LIVEINAR - Querying Data with Transact-SQL

Kurs

Online

2.490 € inkl. MwSt.

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.

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

Meinungen

Themen

  • Server
  • SQL
  • SQL Server

Inhalte

- Introduction to Microsoft SQL Server 2016
- 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

*+ Working knowledge of relational databases.
*+ Basic knowledge of the Microsoft Windows operating system and its core functionality.

LIVEINAR - Querying Data with Transact-SQL

2.490 € inkl. MwSt.