Querying Data with Transact-SQL - Course 20761-C Course in Izola
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.
Acknowledged by Deloitte as a pioneer in education, AcademyTech provides the official Querying Data with Transact-SQL - Course 20761-C Course in Izola and one-on-one online formats; both finalized with the certification exam.
Training schedule for "Querying Data with Transact-SQL - Course 20761-C Course"
Querying Data with Transact-SQL - Course 20761-C Course
Querying Data with Transact-SQL - Course 20761-C Course
Querying Data with Transact-SQL - Course 20761-C Course
Querying Data with Transact-SQL - Course 20761-C Course
Querying Data with Transact-SQL - Course 20761-C Course
Querying Data with Transact-SQL - Course 20761-C Course
Querying Data with Transact-SQL - Course 20761-C Course
Querying Data with Transact-SQL - Course 20761-C Course
Schedule Specific Date"
Are you looking for a SPECIFIC DATE for your "Querying Data with Transact-SQL - Course 20761-C Course" Training?
Who Should Attend
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
Course Content
-
Module 1: Introduction to Microsoft SQL Server
-
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 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 Aggregate Functions
-
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
Frequently Asked Questions
Exam & Certification
Participation Certificate
All trainees who participate in training will have an AcademyTech participation certificate.
AcademyTech Training and Consulting Center
Jason Bradford