Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.
If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Welcome this course! We revisit some concepts from the previous course (Introduction to Databases and Querying) and walk you through the agenda for this course
|Section 2: SQL Views|
A brief walkthrough of the concept of SQL views.
SQL Views - Deep Dive into Querying
|Section 3: SQL Triggers|
SQL Triggers - An Introduction
SQL Triggers - Deep dive into Querying
|Section 4: SQL Computed Columns|
SQL Computed Columns - An Introduction
SQL Computed Columns - Deep dive into Querying
|Section 5: SQL Stored Procedures|
SQL Stored Procedures - An Introduction
SQL Stored Procedures - Deep dive into Querying
|Section 6: SQL User Defined Functions (UDF)|
SQL User Defined Functions - An Introduction
SQL User Defined Functions - Deep dive into Querying
|Section 7: SQL Transactions and Error Handling|
SQL Transactions and Error Handling - An Introduction
SQL Transactions and Error Handling - An Introduction (Continued)
SQL Transactions and Error Handling - Deep Dive into Querying
|Section 8: SQL grouping functions and Ranking functions|
SQL Grouping Sets and Common Table Expressions
SQL Ranking Functions - An Introduction
SQL Ranking Functions - Deep Dive into Querying
|Section 9: SQL XML data-types|
SQL XML Datatype - An Introduction
SQL XML Datatype - Deep Dive into Querying
|Section 10: SQL Partitions|
SQL Partitions - An Introduction
SQL Partitions - Deep Dive into Querying
|Section 11: SQL Dynamic Queries|
SQL Dynamic Queries and Pivots - An Introduction
SQL Dynamic Queries and Pivots - Deep dive into QUerying
|Section 12: SQL Filestream and Free-Text Search|
SQL Free-Text Search
|Section 13: SQL Geography and Geometry datatype|
Geometry and Geography Data Types
|Section 14: Conclusion and Next steps|
Conclusion and Next Steps
I am a coder, manager, educator and a gamer. I love data and analytics. In my day job, I work with database technologies including SQL , Big Data and Tableau. I am passionate about technologies and love coding and managing teams. In my spare time I like to teach Big Data analytics, Databases, Programming etc. I am currently working on certain machine learning and Data Science projects and love to explore more in the Statistics field.