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
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
Hands-down the best technical training I have taken! The methods of progressively building reports, adding complexity and features as time goes on, was fantastic.
- Chris, Cirrus Aircraft
The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.
Every one of my employees had tons of positive stuff to say.
- Benjamin G, MXSG Analysis and Integration Chief, US Air Force
