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
Leave A Reply