Querying Microsoft SQL Server with Transact-SQL
This five-day instructor-led course 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.
About This Course
This five-day instructor-led course 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.
Audience Profile
This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and basic Windows navigation skills.
At Course Completion
- Create single table SELECT queries
- Create multiple table SELECT queries
- Filter and sort data
- Insert, update, and delete data
- Query data using built-in functions
- Create queries that aggregate data
- Create subqueries
- Create queries that use table expressions
- Use UNION, INTERSECT, and EXCEPT on multiple sets of data
- Implement window functions in queries
- Use PIVOT and GROUPING SETS in queries
- Use stored procedures in queries
- Add error handling to queries
- Use transactions in queries
Who Should Attend
Schedule Dates
Course Content
- What is Transact-SQL
- The SELECT statement
- The WHERE clause
- Sorting results
- Calculations
- CASE expressions
FAQs
The duration of the course is typically 5 days. This includes intensive hands-on training and practical exercises to ensure comprehensive understanding and application of T-SQL
Flexible Training Options to Meet Your Needs
We know the importance of flexibility in the success of learning and professional development. This is the reason CounselTrain provides a variety of delivery options for all IT training offered in the UAE to ensure access and convenience for each learner.
Online Instructor-Led Training
Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.