Transact-SQL is how you communicate with a Microsoft SQL Server to add and retrieve data in their SQL Server databases, a key concept for IT professionals in many roles as the database lies at a crucial stage of operations for businesses in multiple industries.

This course is designed to give you a level of understanding of the Transact-SQL language that is good enough for you to not only pass the official 70-761 exam, but also practically implement the skills you learn when querying and managing data in a corporate environment to help efficiently run business IT and operations. People in job roles ranging from SQL Developer, DevOps, Database Administrator and Development will find the 70-761 beneficial to their career as it will teach you the core skills needed to manage a database, talk to the database server and store data for applications in a database.

The course is delivered to you through our convenient but effective online training platform where you will have unlimited access to the 18 hours of in-depth content which will guide you through how to query data with Transact-SQL in a Microsoft SQL Server using both basic and advanced protocols.

KEY LEARNING POINTS

• Describe key capabilities and components of SQL Server
• Describe T-SQL, sets, and predicate logic
• Write a single table SELECT statement
• Write a multi-table SELECT statement
• Write SELECT statements with filtering and sorting
• Describe how SQL Server uses data types
• Write DML statements
• Write queries that use built-in functions
• Write queries that aggregate data
• Write subqueries
• Create and implement views and table-valued functions
• Use set operators to combine query results
• Write queries that use window ranking, offset, and aggregate functions
• Transform data by implementing pivot, unpivot, rollup and cube
• Create and implement stored procedures
• Add programming constructs such as variables, conditions, and loops to T-SQL code

ADVANTAGES OF THE COURSE

• Learn how to talk to the SQL Server to retrieve and input data
• Talk to any version of the Microsoft database (including 2016, 2014 2012, even all the way back to 2000) with the skills you learn in this course
• Learn how to master T-SQL and SQL Server with the help of subject matter experts with over 10 years’ experience in technical IT
• 24-hour access to the course content, seven days a week for an entire year
• This course includes a practice exam where you can become accustomed to the criteria needed for the official 70-761 exam