LIVEINAR - Querying Data with Transact-SQL
Kurs
Online
Beschreibung
-
Kursart
Kurs
-
Methodik
Online
-
Dauer
5 Tage
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.
Meinungen
Themen
- Server
- SQL
- SQL Server
Inhalte
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server 2016 Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Windows Ranking, Offset, and Aggregate Functions
- Pivoting and Grouping Sets
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
Zusätzliche Informationen
*+ Basic knowledge of the Microsoft Windows operating system and its core functionality.
LIVEINAR - Querying Data with Transact-SQL