Loading...

Terminy kursów:

08.11.2021 - 09.11.2021

Oficjalny konspekt Microsoft Pozostałe szkolenia

DP-080 Querying Data with Microsoft Transact-SQL

Czas trwania kursu: 2 dni
Cena: 1599 zł netto

CERTYFIKACJE ZAWODOWE

Certyfikacja podstawowa CertyfIkacja specjalistyczna Certyfikacja ekspercka
FUNDAMENTALS ASSOCIATE EXPERT

 

POZIOM SZKOLENIA

podstawowy średniozaawansowany zaawansowany ekspercki
100 200 300 400

 

TEMATYKA ZAJĘĆ

  • Module 1: Getting Started with Transact-SQL
    Introduction to Transact-SQL
    Using the SELECT statement
    Lab: Get started with SQL Server query tools and writing queries in T-SQL

 

  • Module 2: Sorting and Filtering Query Results
    Sorting query results
    Filtering the data
    Lab: Sort and filter data returned by SELECT queries

 

  • Module 3: Using Joins and Subqueries
    Using JOIN operations
    Using subqueries
    Lab : Write queries with JOIN operations
    Lab : Write SELECT statements using subqueries

 

  • Module 4: Using Built-in Functions
    Getting started with scalar functions
    Grouping aggregated results
    Lab : Built-in functions

 

  • Module 5: Modifying Data
    Inserting data into tables
    Modifying and deleting data
    Lab : Modify data

AZ-030 Microsoft Azure technologies for AWS architects
06.12.2021 - 09.12.2021
AZ-020 Microsoft Azure solutions for AWS developers
02.11.2021 - 04.11.2021
DP-090 Implementing a Machine Learning Solution with Microsoft Azure Databricks
15.11.2021 - 15.11.2021
PL-400 Microsoft Power Platform Developer
29.11.2021 - 03.12.2021
PL-600 Power Platform Solution Architect
15.11.2021 - 18.11.2021
PL-200 Microsoft Power Platform Functional Consultant
22.11.2021 - 26.11.2021
PL-100 Microsoft Power Platform App Maker
29.11.2021 - 01.12.2021
AZ-220 Microsoft Azure IoT Developer
15.11.2021 - 18.11.2021
WS-050 Migrating Application Workloads to Azure
08.11.2021 - 09.11.2021
AZ-600 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub
15.11.2021 - 18.11.2021
AZ-040 Automating Administration with PowerShell
29.11.2021 - 03.12.2021
AZ-700 Designing and Implementing Microsoft Azure Networking Solutions
04.10.2021 - 06.10.2021
MS-55215 SharePoint Online Power User
13.09.2021 - 16.09.2021
DP-080 Querying Data with Microsoft Transact-SQL
13.09.2021 - 14.09.2021
DP-203 Data Engineering on Microsoft Azure
20.09.2021 - 23.09.2021
AZ-140 Configuring and operating Windows Virtual Desktop on Microsoft Azure
10.05.2021 - 13.05.2021
AI-102 Designing and Implementing a Microsoft Azure AI Solution
27.09.2021 - 30.09.2021
SC-900 Security, Compliance, and Identity Fundamentals
06.09.2021 - 06.09.2021
SC-200 Microsoft Security Operations Analyst
10.05.2021 - 13.05.2021
SC-300 Microsoft Identity and Access Administrator
27.09.2021 - 30.09.2021
SC-400 Microsoft Information Protection Administrator
13.09.2021 - 14.09.2021
MS-55281 SharePoint Online Branding
22.03.2021 - 22.03.2021
MS-55300 Microsoft Teams for End Users
05.03.2021 - 05.03.2021
MS-55133 PowerShell for System Center Configuration Manager Administrators
08.03.2021 - 10.03.2021
MS-10984 Deploying and Managing Office 365 Hybrid Deployments
26.10.2020 - 28.10.2020
DP-300 Administering Relational Databases on Microsoft Azure
12.10.2020 - 15.10.2020
MS-203 Microsoft 365 Messaging
19.10.2020 - 23.10.2020
DP-900 Microsoft Azure Data Fundamentals
12.10.2020 - 12.10.2020
WS-012 Windows Server 2019 Hybrid and Azure IaaS
11.01.2021 - 13.01.2021
WS-011 Windows Server 2019 Administration
07.09.2020 - 11.09.2020
AZ-304 Microsoft Azure Architect Design
08.02.2021 - 11.02.2021
AZ-303 Microsoft Azure Architect Technologies
08.02.2021 - 12.02.2021
DA-100 Analyzing Data with Power BI
05.10.2020 - 08.10.2020
MS-050 SharePoint Hybrid Deployment and Migration
26.10.2020 - 30.10.2020
MS-040 Manage SharePoint and OneDrive in Microsoft 365
05.10.2020 - 07.10.2020
AI-900 Microsoft Azure AI Fundamentals
04.09.2020 - 04.09.2020
AZ-400 Designing and Implementing Microsoft DevOps solutions
24.08.2020 - 28.08.2020
MS-500 Microsoft 365 Security Administration
15.06.2020 - 18.06.2020
AZ-104 Microsoft Azure Administrator
06.04.2021 - 09.04.2021
DP-070 Migrate Open Source Data Workloads to Azure
30.06.2020 - 30.06.2020
AZ-204 Developing Solutions for Microsoft Azure
15.06.2020 - 19.06.2020
PL-900 Microsoft Power Platform Fundamentals
24.08.2020 - 25.08.2020
MS-10990 Analyzing Data with SQL Server Reporting Services
22.06.2020 - 26.06.2020
MS-10988 Managing SQL Business Intelligence Operations
01.07.2020 - 03.07.2020
DP-060 Migrate NoSQL workloads to Azure Cosmos DB
31.08.2020 - 31.08.2020
DP-050 Migrate SQL workloads to Azure
27.09.2021 - 28.09.2021
MS-700 Managing Microsoft Teams
15.06.2020 - 19.06.2020
MS-600 Building applications and solutions with Microsoft 365 core services
21.09.2020 - 25.09.2020
AZ-010 Azure Administration for AWS SysOps
07.09.2020 - 08.09.2020
MS-030 Office 365 Administrator
29.06.2020 - 03.07.2020
AZ-500 Microsoft Azure Security Technologies
15.03.2021 - 18.03.2021
DP-100 Designing and Implementing a Data Science Solution on Azure
29.06.2020 - 01.07.2020
MS-55039 Windows PowerShell Scripting and Toolmaking
01.02.2021 - 05.02.2021
MD-101 Managing Modern Desktops
21.09.2020 - 25.09.2020
MD-100 Windows 10
20.07.2020 - 24.07.2020
MS-900 Microsoft 365 Fundamentals
01.10.2021 - 01.10.2021
AZ-900 Microsoft Azure Fundamentals
03.09.2020 - 04.09.2020
MS-10987 Performance Tuning and Optimizing SQL Databases
15.03.2021 - 18.03.2021
MS-101 Microsoft 365 Mobility and Security
11.10.2021 - 15.10.2021
MS-100 Microsoft 365 Identity and Services
27.09.2021 - 01.10.2021
MS-40551 Microsoft Security Workshop: Enterprise Security Fundamentals
MS-40555 Microsoft Security Workshop: Implementing PowerShell Security Best Practices
Microsoft Security Workshop
18.05.2020 - 22.05.2020
MS-20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014
SQL Server 2012/2014
07.09.2020 - 11.09.2020
MS-20466 Implementing Data Models and Reports with SQL Server 2014
SQL Server 2012/2014
24.08.2020 - 28.08.2020
MS-20465 Designing Solutions for Microsoft SQL Server 2014
SQL Server 2012/2014
28.09.2020 - 02.10.2020
MS-20464 Developing Microsoft SQL Server 2014 Databases
SQL Server 2012/2014
30.11.2020 - 04.12.2020
MS-10986 Updating Your Skills to SQL Server 2016
SQL Server 2016
14.09.2020 - 16.09.2020
MS-10985 Introduction to SQL Databases
SQL Server 2012/2014
26.10.2020 - 28.10.2020
MS-10994 Data Analysis Fundamentals using Excel
SQL Server 2016
27.08.2020 - 28.08.2020
MS-20537 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack
MCSA
21.09.2020 - 25.09.2020
MS-55224-2 Operationalize Cloud Analytics Solutions with Microsoft Azure
MCSE
07.09.2020 - 08.09.2020
MS-55224-1 Microsoft Azure Big Data Analytics Solutions
SQL Server 2016
29.10.2020 - 30.10.2020
MS-20779 Analyzing Data with Excel
SQL Server 2016
26.08.2020 - 28.08.2020
MS-20417 Upgrading Your Skills to MCSA Windows Server 2012
Windows Server 2012/2012R2
24.08.2020 - 28.08.2020
MS-20414 Implementing an Advanced Server Infrastructure
Windows Server 2012/2012R2
07.09.2020 - 11.09.2020
MS-20413 Designing and Implementing a Server Infrastructure
Windows Server 2012/2012R2
31.08.2020 - 04.09.2020
MS-10982 Supporting and Troubleshooting Windows 10
Windows 10
22.03.2021 - 26.03.2021
MS-20412 Configuring Advanced Windows Server 2012 Services
Windows Server 2012/2012R2
05.10.2020 - 09.10.2020
MS-20411 Administering Windows Server 2012
Windows Server 2012/2012R2
12.10.2020 - 16.10.2020
MS-20410 Installing and Configuring Windows Server 2012
Windows Server 2012/2012R2
07.09.2020 - 11.09.2020
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
05.10.2020 - 09.10.2020
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
07.09.2020 - 11.09.2020
MS-20745 Implementing a Software-Defined DataCenter
System Center
17.08.2020 - 21.08.2020
MS-10997 Office 365 Administration and Troubleshooting
Office 365
22.02.2021 - 24.02.2021
MS-20703-1 Administering System Center Configuration Manager
System Center
04.10.2021 - 08.10.2021
MS-55247 Designing and Implementing Cloud Data Platform Solutions
14.12.2020 - 18.12.2020
MS-20487 Developing Windows Azure and Web Services
Programowanie
07.12.2020 - 11.12.2020
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
17.08.2020 - 21.08.2020
MS-20483 Programming in C#
Programowanie
31.08.2020 - 04.09.2020
MS-20480 Programming in HTML5 with JavaScript and CSS3
Programowanie
24.08.2020 - 28.08.2020
MS-10962 Advanced Automated Administration with Windows PowerShell
MCSA
24.08.2020 - 26.08.2020
MS-55154 Office 365 for the End-User
Office 365
09.07.2020 - 09.07.2020
MS-55179 Advanced Microsoft Outlook 2016
01.09.2020 - 01.09.2020
MS-55178 Introduction to Microsoft Outlook 2016
02.09.2020 - 02.09.2020
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
03.09.2020 - 03.09.2020
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
04.09.2020 - 04.09.2020
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
07.09.2020 - 07.09.2020
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
08.09.2020 - 08.09.2020
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
09.09.2020 - 09.09.2020
MS-55175 Advanced Microsoft Word 2016
Word 2016
10.09.2020 - 10.09.2020
MS-55174 Intermediate Microsoft Word 2016
Word 2016
14.09.2020 - 14.09.2020
MS-55173 Introduction to Microsoft Word 2016
Word 2016
15.09.2020 - 15.09.2020
MCSA: Windows Server 2016 (wzbogacony o elementy Windows Server 2019) – online
MCSA
14.10.2020 - 20.01.2021
MS-20768 Developing SQL Data Models
SQL Server 2016
02.09.2020 - 04.09.2020
MS-20767 Implementing a SQL Data Warehouse
SQL Server 2016
15.02.2021 - 19.02.2021
MS-20334 Core Solutions of Skype for Business 2015/2019
Skype for Business 2015
28.09.2020 - 02.10.2020
MS-20744 Securing Windows Server 2016
Windows Server 2016
28.09.2020 - 02.10.2020
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
24.08.2020 - 28.08.2020
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
28.09.2020 - 02.10.2020
MS-20765 Provisioning SQL Databases
SQL Server 2016
21.09.2020 - 25.09.2020
MS-20764 Administering a SQL Database Infrastructure
SQL Server 2016
01.03.2021 - 05.03.2021
MS-20762 Developing SQL Databases
SQL Server 2016
05.10.2020 - 09.10.2020
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
12.10.2020 - 16.10.2020
MS-20339-2 Advanced Technologies of SharePoint 2016
SharePoint 2016
28.09.2020 - 02.10.2020
MS-20339-1 Planning and Administering SharePoint 2016
SharePoint 2016
05.10.2020 - 09.10.2020
MS-20741 Networking with Windows Server 2016
Windows Server 2016
04.10.2021 - 08.10.2021
MS-20740 Installation, Storage, and Compute with Windows Server 2016
Windows Server 2016
25.01.2021 - 29.01.2021
MS-20742 Identity with Windows Server 2016
Windows Server 2016
12.10.2020 - 16.10.2020
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
21.09.2020 - 25.09.2020
MS-20345-1 Administering Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
05.10.2020 - 09.10.2020
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
05.10.2020 - 09.10.2020
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
04.10.2021 - 08.10.2021
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
07.09.2020 - 11.09.2020
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
27.07.2020 - 31.07.2020
MS-20488 Developing Microsoft SharePoint Server 2013 Core Solutions
SharePoint 2013
26.10.2020 - 30.10.2020
MS-20332 Advanced Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
31.08.2020 - 04.09.2020
MS-20331 Core Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
28.09.2020 - 02.10.2020
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
28.09.2020 - 30.09.2020
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
19.10.2020 - 23.10.2020
Bezpieczeństwo w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
07.04.2021 - 09.04.2021
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
17.08.2020 - 19.08.2020
MS-10961 Automating Administration with Windows PowerShell
MCSA
12.04.2021 - 16.04.2021
MS-20341 Core Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
07.09.2020 - 11.09.2020
MS-10748 Planning and Deploying System Center 2012 Configuration Manager
System Center
26.10.2020 - 28.10.2020
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
31.08.2020 - 04.09.2020
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
28.09.2020 - 02.10.2020
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
07.09.2020 - 11.09.2020