Loading...

Terminy kursów:

06.08.2018 - 10.08.2018
03.09.2018 - 07.09.2018
24.09.2018 - 28.09.2018
15.10.2018 - 19.10.2018
12.11.2018 - 16.11.2018
03.12.2018 - 07.12.2018

Oficjalny konspekt Microsoft Pozostałe szkolenia

MS-20761 Querying Data with Transact-SQL

Czas trwania kursu: 5 dni
Cena: 2299zł

Opis kursu

Kluczowe zagadnienia szkolenia wg trenera CBSG Polska:

  • podstawy T-SQL – zapytania proste i złączenia zbiorów
  • grupowanie i filtrowanie
  • podzapytania i operacje na zbiorach
  • modyfikacje w danych – dodaj, zamień, usuń

Bartosz Ratajczyk, Microsoft Certified Trainer

Certyfikacje zawodowe

Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce:

  • MCSA: SQL Server 2016
MTA   MCS  MCSA  MCSE
MCSD

Dowiedz się więcej o certyfikacjach Microsoft


Poziom szkolenia wg standardów Microsoft

podstawowy średniozaawansowany zaawansowany ekspercki
100 200 300 400

Czas trwania

  • 40 godziny lekcyjne (5 dni)

Tematyka zajęć

  • 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
    Lab : Working with SQL Server 2016 Tools

 

  • Module 2: Introduction to T-SQL Querying
    Introducing T-SQL
    Understanding Sets
    Understanding Predicate Logic
    Understanding the Logical Order of Operations in SELECT statements
    Lab : Introduction to T-SQL Querying

 

  • Module 3: Writing SELECT Queries
    Writing Simple SELECT Statements
    Eliminating Duplicates with DISTINCT
    Using Column and Table Aliases
    Writing Simple CASE Expressions
    Lab : Writing Basic SELECT Statements

 

  • Module 4: Querying Multiple Tables
    Understanding Joins
    Querying with Inner Joins
    Querying with Outer Joins
    Querying with Cross Joins and Self Joins
    Lab : Querying Multiple Tables

 

  • Module 5: Sorting and Filtering Data
    Sorting Data
    Filtering Data with Predicates
    Filtering Data with TOP and OFFSET-FETCH
    Working with Unknown Values
    Lab : Sorting and Filtering Data

 

  • 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
    Lab : Working with SQL Server 2016 Data Types

 

  • Module 7: Using DML to Modify Data
    Inserting Data
    Modifying and Deleting Data
    Lab : Using DML to Modify 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
    Lab : Using Built-In Functions

 

  • Module 9: Grouping and Aggregating Data
    Using Aggregate Functions
    Using the GROUP BY Clause
    Filtering Groups with HAVING
    Lab : Grouping and Aggregating Data

 

  • Module 10: Using Subqueries
    Writing Self-Contained Subqueries
    Writing Correlated Subqueries
    Using the EXISTS Predicate with Subqueries
    Lab : Using Subqueries

 

  • Module 11: Using Table Expressions
    Using Views
    Using Inline Table-Valued Functions
    Using Derived Tables
    Using Common Table Expressions
    Lab : Using Table Expressions

 

  • Module 12: Using Set Operators
    Writing Queries with the UNION operator
    Using EXCEPT and INTERSECT
    Using APPLY
    Lab : Using Set Operators

 

  • Module 13: Using Windows Ranking, Offset, and Aggregate Functions
    Creating Windows with OVER
    Exploring Window Functions
    Lab : Using Windows Ranking, Offset, and Aggregate Functions

 

  • Module 14: Pivoting and Grouping Sets
    Writing Queries with PIVOT and UNPIVOT
    Working with Grouping Sets
    Lab : Pivoting and Grouping Sets

 

  • Module 15: Executing Stored Procedures
    Querying Data with Stored Procedures
    Passing Parameters to Stored procedures
    Creating Simple Stored Procedures
    Working with Dynamic SQL
    Lab : Executing Stored Procedures

 

  • Module 16: Programming with T-SQL
    T-SQL Programming Elements
    Controlling Program Flow
    Lab : Programming with T-SQL

 

  • Module 17: Implementing Error Handling
    Implementing T-SQL error handling
    Implementing structured exception handling
    Lab : Implementing Error Handling

 

  • Module 18: Implementing Transactions
    Transactions and the database engines
    Controlling transactions
    Lab : Implementing Transactions

MS-10995 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack
MCSE
03.09.2018 - 07.09.2018
MS-55178 Introduction to Microsoft Outlook 2016 & MS-55179 Advanced Microsoft Outlook 2016
04.04.2018 - 05.04.2018
MS-20537 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack
Windows
14.05.2018 - 18.05.2018
MS-20535 Architecting Microsoft Azure Solutions
Windows
23.04.2018 - 27.04.2018
MS-55224-2 Operationalize Cloud Analytics Solutions with Microsoft Azure
SQL Server 2016
23.05.2018 - 24.05.2018
MS-55224-1 Microsoft Azure Big Data Analytics Solutions
SQL Server 2016
21.05.2018 - 22.05.2018
MS-20776 Engineering Data with Microsoft Cloud Services
SQL Server 2016
14.05.2018 - 18.05.2018
MS-20773 Analyzing Big Data with Microsoft R
SQL Server 2016
16.04.2018 - 18.04.2018
MS-20775 Performing Data Engineering on Microsoft HD Insight
SQL Server 2016
07.05.2018 - 11.05.2018
MS-20778 Analyzing Data with Power BI
SQL Server 2016
14.05.2018 - 16.05.2018
MS-20779 Analyzing Data with Excel
SQL Server 2016
21.05.2018 - 23.05.2018
MS-20417 Upgrading Your Skills to MCSA Windows Server 2012
Windows Server 2012/2012R2
21.05.2018 - 25.05.2018
MS-20414 Implementing an Advanced Server Infrastructure
Windows Server 2012/2012R2
14.05.2018 - 18.05.2018
MS-20413 Designing and Implementing a Server Infrastructure
Windows Server 2012/2012R2
24.09.2018 - 28.09.2018
MS-20409 Server Virtualization with Windows Server Hyper-V and System Center
Windows Server 2012/2012R2
17.09.2018 - 21.09.2018
MS-10974 Deploying and Migrating Windows Servers
Windows Server 2012/2012R2
16.04.2018 - 18.04.2018
MS-10970 Networking with Windows Server
Windows Server 2012/2012R2
11.06.2018 - 15.06.2018
MS-20697-2 Deploying and Managing Windows 10 using Enterprise Services
Windows 10
11.06.2018 - 15.06.2018
MS-20697-1 Implementing and Managing Windows 10
Windows 10
02.07.2018 - 06.07.2018
MS-10982 Supporting and troubleshooting Windows 10
Windows 10
15.10.2018 - 19.10.2018
MS-20412 Configuring Advanced Windows Server 2012 Services
Windows Server 2012/2012R2
23.04.2018 - 27.04.2018
MS-20411 Administering Windows Server 2012
Windows Server 2012/2012R2
14.05.2018 - 18.05.2018
MS-20410 Installing and Configuring Windows Server 2012
Windows Server 2012/2012R2
09.04.2018 - 13.04.2018
MS-20774 Perform Cloud Data Science with Azure Machine Learning
SQL Server 2016
23.04.2018 - 27.04.2018
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
17.05.2018 - 18.05.2018
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
14.05.2018 - 16.05.2018
MS-20745 Implementing a Software-Defined DataCenter
System Center
07.05.2018 - 11.05.2018
MS-10997 Office 365 Administration and Troubleshooting
Office 365
14.05.2018 - 16.05.2018
MS-20703-2 Integrating MDM and Cloud Services with System Center Configuration Manager
System Center
21.05.2018 - 25.05.2018
MS-20703-1 Administering System Center Configuration Manager
System Center
14.05.2018 - 18.05.2018
MS-10996 Hybrid Cloud and Datacenter Monitoring with Operations Management Suite (OMS)
04.06.2018 - 08.06.2018
MS-20489 Developing Microsoft SharePoint Server 2013 Advanced Solutions
SharePoint 2013
21.05.2018 - 25.05.2018
MS-20532 Developing Microsoft Azure Solutions
MCSA
11.06.2018 - 15.06.2018
MS-40441 Designing and Implementing Cloud Data Platform Solutions
23.04.2018 - 25.04.2018
MS-20487 Developing Windows Azure and Web Services
Programowanie
17.09.2018 - 21.09.2018
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
14.05.2018 - 18.05.2018
MS-20483 Programming in C#
Programowanie
07.05.2018 - 11.05.2018
MS-20480 Programming in HTML5 with JavaScript and CSS3
Programowanie
23.04.2018 - 27.04.2018
MS-10962 Advanced Automated Administration with Windows PowerShell
Windows PowerShell
29.10.2018 - 31.10.2018
MS-55164 Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
Power BI
18.04.2018 - 19.04.2018
MS-55163 Preparing Your Data for Power BI
Power BI
16.04.2018 - 17.04.2018
MS-55205 Mastering Microsoft Project 2016
Project 2016
11.04.2018 - 13.04.2018
MS-55180 Introduction to Microsoft Project 2016: Getting Started
Project 2016
09.04.2018 - 10.04.2018
MS-55181 Microsoft Project 2016: Digging Deeper
Project 2016
09.04.2018 - 10.04.2018
MS-55154 Office 365 for the End-User
Office 365
14.05.2018 - 14.05.2018
MS-55179 Advanced Microsoft Outlook 2016
18.05.2018 - 18.05.2018
MS-55178 Introduction to Microsoft Outlook 2016
17.05.2018 - 17.05.2018
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
11.05.2018 - 11.05.2018
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
10.05.2018 - 10.05.2018
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
16.05.2018 - 16.05.2018
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
15.05.2018 - 15.05.2018
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
14.05.2018 - 14.05.2018
MS-55175 Advanced Microsoft Word 2016
Word 2016
09.05.2018 - 09.05.2018
MS-55174 Intermediate Microsoft Word 2016
Word 2016
08.05.2018 - 08.05.2018
MS-55173 Introduction to Microsoft Word 2016
Word 2016
14.12.2018 - 07.05.2018
MS-20698 Installing and Configuring Windows 10
Windows 10
16.04.2018 - 20.04.2018
MS-10993 Integrating On-Premises Identity Infrastructure with Microsoft Azure
29.05.2018 - 30.05.2018
MS-10992 Integrating On-Premises Core Infrastructure with Microsoft Azure
14.05.2018 - 16.05.2018
MS-20768 Developing SQL Data Models
SQL Server 2016
07.05.2018 - 09.05.2018
MS-20767 Implementing a SQL Data Warehouse
SQL Server 2016
27.08.2018 - 31.08.2019
MS-20334 Core Solutions of Skype for Business 2015
Skype for Business 2015
06.08.2018 - 10.08.2018
MS-20744 Securing Windows Server 2016
Windows Server 2016
03.09.2018 - 07.09.2018
MS-20337 Enterprise Voice and Online Services with Microsoft Lync Server 2013
Lync Server 2013
11.06.2018 - 15.06.2018
MS-20336 Core Solutions of Microsoft Lync Server 2013
Lync Server 2013
09.04.2018 - 13.04.2018
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
25.06.2018 - 29.06.2018
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
14.05.2018 - 18.05.2018
MS-20765 Provisioning SQL Databases
SQL Server 2016
11.06.2018 - 15.06.2018
MS-20764 Administering a SQL Database Infrastructure
SQL Server 2016
08.10.2018 - 12.10.2018
MS-20762 Developing SQL Databases
SQL Server 2016
01.10.2018 - 05.10.2018
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
07.05.2018 - 11.05.2018
MS-50255 Managing Windows Environments with Group Policy
Windows Server 2012/2012R2
04.06.2018 - 08.04.2018
MS-20339-2 Advanced Technologies of SharePoint 2016
SharePoint 2016
07.05.2018 - 11.05.2018
MS-20339-1 Planning and Administering SharePoint 2016
SharePoint 2016
23.04.2018 - 27.04.2018
MS-20741 Networking with Windows Server 2016
Windows Server 2016
10.09.2018 - 14.09.2018
MS-20740 Installation, Storage, and Compute with Windows Server 2016
Windows Server 2016
20.08.2018 - 24.08.2018
MS-20742 Identity with Windows Server 2016
Windows Server 2016
17.09.2018 - 21.09.2018
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016
Exchange Server 2016
16.04.2018 - 20.04.2018
MS-20345-1 Administering Microsoft Exchange Server 2016
Exchange Server 2016
04.06.2018 - 08.06.2018
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
25.06.2018 - 29.06.2018
MS-20398 Planning for and Managing Devices in the Enterprise: Enterprise Management Suite (EMS) & On-Premises Tools
Windows 10
24.09.2018 - 28.09.2018
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
04.06.2018 - 08.06.2018
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
16.04.2018 - 20.04.2018
MS-10971 Storage and High Availability with Windows Server
Windows Server 2012/2012R2
18.06.2018 - 21.06.2018
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
23.04.2018 - 27.04.2018
MS-20488 Developing Microsoft SharePoint Server 2013 Core Solutions
SharePoint 2013
14.05.2018 - 18.05.2018
MS-20332 Advanced Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
07.05.2018 - 11.05.2018
MS-20331 Core Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
23.04.2018 - 27.04.2018
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
07.05.2018 - 09.05.2018
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
23.04.2018 - 25.04.2018
Bezpieczeństwo w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
09.04.2018 - 11.04.2018
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
09.04.2018 - 11.04.2018
MS-20696 Administering System Center Configuration Manager and Intune
System Center
09.04.2018 - 13.04.2018
MS-10961 Automating Administration with Windows PowerShell
Windows PowerShell
08.10.2018 - 12.10.2018
MS-20342 Advanced Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
11.06.2018 - 15.06.2018
MS-20341 Core Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
09.04.2018 - 13.04.2018
MS-20533 Implementing Microsoft Azure Infrastructure Solutions
21.05.2018 - 25.05.2018
MS-10979 Microsoft Azure Fundamentals
07.05.2018 - 08.05.2018
MS-20247 Configuring and Deploying a Private Cloud
System Center
17.09.2018 - 21.09.2018
MS-10748 Planning and Deploying System Center 2012 Configuration Manager
System Center
18.06.2018 - 20.06.2018
MS-20347 Enabling and Managing Office 365
Office 365
23.04.2018 - 27.04.2018
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
26.03.2018 - 30.03.2018
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
16.04.2018 - 20.04.2018
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
09.04.2018 - 13.04.2018