Course Description
This five-day instructor-led Querying SQL Server with Transact-SQL training is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers.
In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.
16 Module Course Outline Below
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
Course Modules
- Introduction to Transact-SQL
- Joining tables with Transact-SQL
- Filtering and sorting results
- SQL Server data types
- Inserting, updating and deleting data
- Using SQL Server functions with Transact-SQL
- Aggregating data with Transact-SQL
- Implement subqueries with Transact-SQL
- Create queries that use table expressions
- Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data
- Implement window functions in queries
- Use PIVOT and grouping sets in queries
- Use stored procedures in queries
- Implement programming features in Transact-SQL
- Add error handling to queries
- Use transactions in queries
Testimonials
“The content was great for an introduction to Tableau. I truly appreciate the way Michael was able to explain everything, and would recommend this class to anyone needing to get their feet wet with Tableau.”
- Shianne DeGeorge, Business Intelligence Group, Kaiser Permanente
“Your private Tableau Desktop Bootcamp I for Beginners training was excellent, our 15 staff members thoroughly enjoyed it!”
- David Sonntag, US Airforce
“It was a very enjoyable and informative course and we’re all looking forward to using the skills we learnt. We all agreed that the instructor was very good and was able to break down pretty complex issues to make them more understandable”
- Grahame Welch, Head of BI, UK Home Office
