________________________________________________________________
Do you want to take this course remotely or in person?
Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78, WhatsApp: +34 685 60 05 91 , or contact Our Offices
________________________________________________________________
This course is aimed at database administrators, database developers, and business intelligence professionals.
The course is most likely to be well served by advanced SQL users who are not necessarily database users; such as report writers, business analysts, and client application developers. This course is aimed at database administrators, database developers, and business intelligence professionals.
The course is most likely to be well served by advanced SQL users who are not necessarily database users; as report writers, business analysts and client application developers.
Course details
Aim:
The main purpose of this Course 20761 Querying Data with Transact-SQL is to give students a good understanding of the Transact-SQL language that is used by all disciplines related to SQL Server; 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.
Prerequisites:
Before attending this course, students must have:
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
Modules
- Module 1: 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 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
Telepresence Modality
- Duration: 35 hours. (8 days)
-
Date, days and time: consult
