Digicomp Academy AG

Querying Data with Transact-SQL 2017

Anbieter

Digicomp Academy AG

Start

04.11.2020, 07:30 Uhr

Dauer

5 Tage

Code

M20761-0420BS

Ort

4051 Basel

Preis

CHF 4000.-

Abschluss

Bestätigung/Zertifikat

Durchführungsgarantie

Ja


Hinweis zum Datenschutz

Dieser Kurs bietet Ihnen eine optimale Grundlage für alle weiterführenden SQL-Server-2017-Kurse. In diesem Kurs lernen Sie, wie Sie Basic Transact SQL Queries erstellen und anwenden.

Introduction to Microsoft SQL Server 2017
  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
Introduction to T-SQL Querying
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
Writing SELECT Queries
  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
Querying Multiple Tables
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
Sorting and Filtering Data
  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown Values
Working with SQL Server 2017 Data Types
  • Introducing SQL Server 2017 Data Types
  • Working with Character Data
  • Working with Date and Time Data
Using DML to Modify Data
  • Inserting Data
  • Modifying and Deleting Data
Using Built-In Functions
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
Grouping and Aggregating Data
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
Using Subqueries
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
Using Set Operators
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
Using Table Expressions
  • Using Derived Tables
  • Using Common Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions
Using Window Ranking, Offset, and Aggregate Functions
  • Creating Windows with OVER
  • Exploring Window Functions
Pivoting and Grouping Sets
  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
Executing Stored Procedures
  • Querying Data with Stored Procedures
  • Passing Parameters to Stored procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
Programming with T-SQL
  • T-SQL Programming Elements
  • Controlling Program Flow
Implementing Error Handling
  • Using TRY / CATCH Blocks
  • Working with Error Information
Implementing Transactions
  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels
zum Anbieter

Verantwortliche Person

Kundenberatung
Tel... anzeigen
E-Mail Anfrage