Advanced Databases and SQL Querying
Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.
Write complex TSQL queries.
Know the different TSQL functionalities that exist
Write more efficient TSQL code
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.
SQL Triggers
SQL Computed Columns
SQL Stored Procedures
SQL User Defined Functions (UDF)
SQL Transactions and Error Handling
SQL grouping functions and Ranking functions
SQL XML data-types
SQL Dynamic Queries
SQL Filestream and Free-Text Search
SQL Geography and Geometry datatype
Conclusion and Next steps
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Related Courses
IT & Software
A high paced hands on course on AWS. Complete with in depth professional course notes. Subtitles for 24 languages. Learn how to do common tasks: Cr...
Free
IT & Software
This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted wi...
Free
Unlock the Future of Artificial Intelligence Quickly and Easily! Welcome to the future of technology learning – a quick, comprehensive online cours...
Free
