Advanced Databases and SQL Querying
This advanced TSQL Querying course is perfect for those looking to take their database knowledge to the next level. It is expected that students have already taken the Introduction to Databases and Querying course and are comfortable writing basic TSQL queries. The course covers advanced concepts such as Views, Triggers, and Dynamic Queries, and includes TSQL Scripts for all demos. With over two hours of content and assignments at the end of each concept, this course is ideal for those looking to get their next database job or improve their existing database knowledge and apply it to their projects. ▼
ADVERTISEMENT
Course Feature
Cost:
Free
Provider:
Udemy
Certificate:
No Information
Language:
English
Start Date:
2017-12-12
Course Overview
❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [August 13th, 2023]
Skills and Knowledge Acquired:
This Advanced Databases and SQL Querying course will provide students with the skills and knowledge necessary to write advanced TSQL queries, such as SELECT JOINS, Views, Triggers, and Dynamic Queries. Students will also gain an understanding of how to use TSQL Scripts for demos, as well as how to apply their knowledge to their projects. Upon completion of the course, students will have a better understanding of how to use databases and querying in their job or projects.
Contribution to Professional Growth:
Advanced Databases and SQL Querying provides an opportunity for professional growth by teaching students advanced concepts in TSQL Querying. The course covers topics such as Views, Triggers, and Dynamic Queries, and provides TSQL Scripts for all demos. With assignments at the end of each concept, this course is ideal for those looking to improve their existing database knowledge and apply it to their projects. By taking this course, students can gain the skills necessary to pursue their next database job.
Suitability for Further Education:
This Advanced Databases and SQL Querying course is suitable for preparing further education as it covers advanced concepts such as Views, Triggers, Dynamic Queries, and more. The course expects that students are already aware of basic database concepts and are comfortable writing basic TSQL queries. It also provides TSQL scripts for all demos and assignments at the end of each concept. This course is ideal for those looking to improve their existing database knowledge and apply it to their projects, or those looking for their next database job.
Course Syllabus
Introduction
SQL Views
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 Partitions
SQL Dynamic Queries
SQL Filestream and Free-Text Search
SQL Geography and Geometry datatype
Conclusion and Next steps
Course Provider
Provider Udemy's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of Advanced Databases and SQL Querying