This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.
- Describe key capabilities and components of SQL Server 2016.
- 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, un-pivot, rollup and cube.
- Create and implement stored procedures.
- Add programming constructs such as variables, conditions, and loops to T-SQL code.
Introduction to Microsoft SQL Server 2016
Module 2:Introduction to T-SQL Querying
Module 3:Writing SELECT Queries
Module 4:Querying Multiple Tables
Module 5:Sorting and Filtering Data
Module 6:Working with SQL Server 2016 Data Types
Module 7:Using DML to Modify Data
Module 8:Using Built-In Functions
Module 9:Grouping and Aggregating Data
Module 10:Using Subqueries
Module 11:Using Table Expressions
Module 12:Using Set Operators
Module 13:Using Windows Ranking, Offset, and Aggre
Module 14:Pivoting and Grouping Sets
Module 15:Executing Stored Procedures
Module 16:Programming with T-SQL
Module 17:Implementing Error Handling
Module 18:Implementing Transactions
All Microsoft On-demand content is designed and created by Microsoft Certified Trainers and Microsoft Subject Matter Experts. The trainers teaching the content in videos are the officials who have been working on the same technology that is being taught in the course.
After completing the course sucessfully you will be able to download and save the certificate or print it.
Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases.
Why should I choose MOC on-demand?
To ensure that learners have the adequate skills to use Microsoft technologies MOC on-demand Courses have been introduced by Microsoft. These courses have been made available to serve the needs of learners who prefer to study at their own pace, at their convinient time and from their preferred location globally.
What do MOC On-demand courses include?
- MOC On-demand Courses are organised in Modules which include:
- Demos: A video walk-through of a process or task discussed in that lesson.
- Practices: A self-paced practice where they can apply what was covered in the lesson, with supporting prompts to guide them as needed.
- Labs: These detailed exercises use practice files and offer a more hands-on experience with the lesson material. Note: Not all courses include labs.
- Knowledge Checks: A brief quiz testing what was learned in the lesson.
- Assessments: To test knowledge attained from the course.
How do I get the product?
After purchasing a MOC on-demand course on training.com, you will receive a mail with an access code, link to the Microsoft training site and detailed instructions to login, redeem the Access Code and start with your course.
What is important for students to know before redeeming a voucher code?
- You need to create a Microsoft account if you have not already, for example, Live.com, Hotmail.com and Outlook.com.
- An access code can only be redeemed once.
- A code must be redeemed by the expiration date provided by their Microsoft Learning Partner.
- Once activated, course materials are available for a period of 90 days
- All the details are included in the Microsoft Official Course On-Demand Terms and Conditions: http://go.microsoft.com.
Who should join this course?
The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
How are the MOC courses structured?
Microsoft official courses on-demand are arranged in modules that include few minutes videos. At the end of each module one or two questions will be posed to test your comprehension. There will be an assessment of at least 25 questions at the end of the course.
What is the instructors' profile who teach the course?
All Microsoft On-demand content is designed and created by Microsoft Certified Trainers and Microsoft Subject Matter Experts. The trainers teaching the content in videos are the officials who have been working on the same technology that is being taught in the course.
What are the course packages available to purchase?
There are 2 sets of courses - Basic Set and Package Set
Basic Set:- 90-day access to the official Microsoft On-Demand Training Videos
- 90-day access to Live Microsoft Labs Online (MLO) for hands-on practice
- 90-day access to Course Exercises
- Reading and Knowledge checks throughout the course Package Set:
- Basic Set features
- Digital edition of the Microsoft Official Curriculum (dMOC) kit for reference.