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:
- - Introduction
- - SQL Views
- - SQL Triggers
- - SQL Computed Columns
- - SQL Stored Procedures
- - SQL User Defined Functions
- - SQL Transactions and Error Handling
- - SQL Ranking Functions
- - SQL XML Datatype
- - SQL Partitions
- - SQL Dynamic Queries and Pivots
- - SQL Free-Text Search
- - Geometry and Geography Data Types
- - Conclusion
0 Comments