Advanced Databases and SQL Querying

Mark as Favorite Share
image

What Will You Learn?

Write complex TSQL queries.
Know the different TSQL functionalities that exist
Write more efficient TSQL code

About This Course

Provider: Udemy
Format: Online
Duration: 4 hours to complete [Approx]
Target Audience: Intermediate
Learning Objectives: By the end of this free course, proficient TSQL practitioners will elevate their skills in advanced querying, encompassing Views, Triggers, Dynamic Queries, and practical applications
Course Prerequisites: Basic knowledge of SQL, TSQL code and Basic syntax like SELECT, INSERT, UPDATE etc.
Assessment and Certification: NA
Instructor: Rakesh Gopalakrishnan
Key Topics: Database, Advanced Databases and SQL Querying, TSQL Queries
Topic Covered: 
  1. - Introduction
  2. - SQL Views 
  3. - SQL Triggers 
  4. - SQL Computed Columns 
  5. - SQL Stored Procedures 
  6. - SQL User Defined Functions 
  7. - SQL Transactions and Error Handling 
  8. - SQL Ranking Functions 
  9. - SQL XML Datatype 
  10. - SQL Partitions 
  11. - SQL Dynamic Queries and Pivots 
  12. - SQL Free-Text Search
  13. - Geometry and Geography Data Types
  14. - Conclusion

0 Comments

No reviews yet !!

Please login first