20761C: Querying Data with Transact-SQL/ on-line obuka

Opšte informacije

Organizator:
Adresa:
Kralja Aleksandra 12, II sprat- TC Pariski magazin, Novi Sad, prikaži na mapi
Sajt organizatora:
Datum početka kursa:
Trajanje kursa:
40 školskih časova
Vreme održavanja:
Gradovi u kojima se kurs održava:
Novi Sad

CENA: 57600 din

Opis kursa

20761C: Querying Data with Transact-SQL/ on-line obuka

 

This course is designed to introduce students to Transact-SQL. This self-paced course will give you 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. 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.

Who should attend

Database Administrators
Database Developers
BI professionals

Prerequisites

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

After completing this course, students will be able to:

Describe the basic architecture and concepts of Microsoft SQL Server 2016
Understand the similarities and differences between Transact-SQL and other computer languages
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in SQL Server
Modify data using Transact-SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with T-SQL
Implement error handling
Implement transactions

Length

5 days/40 school class

Outline

Module 1: Introduction to Microsoft SQL Server 2016

The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio

Module 2: Introduction to T-SQL

Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements

Module 3: Writing SELECT Queries

Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions

Module 4: Querying Multiple Tables

Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins

Module 5: Sorting and Filtering Data

Sorting Data
Filtering Data with Predicates
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown Values

Module 6: Working with SQL Server 2016 Data Types

Introducing SQL Server 2016 Data Types
Working with Character Data
Working with Date and Time Data

Module 7: Using DML to Modify Data

Inserting Data
Modifying and Deleting Data

Module 8: Using Built-In Functions

Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL

Module 9: Grouping and Aggregating Data

Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING

Module 10: Using Subqueries

Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries

Module 11: Using Set Operators

Writing Queries with the UNION Operator
Using EXCEPT and INTERSECT
Using APPLY

Labs

Working with SQL Server 2016 Tools
Introduction to Transact-SQL Querying
Writing Basic SELECT Statements
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 SET Operators

Special Offer

Za sve polaznike prijavljene u ovom terminu, odobrava se 10% popusta.
Ova obuka se može realizovati i kroz SA trening vaučere koji se dobijaju uz kupovinu Microsoft licenci. Više informacija na telefon:
065 4728 223

Iskustva polaznika

Prilikom informisanja i/ili prijavljivanja na kurs pozovite se na Kursevi.com