DP-080T00 – Querying Data with Microsoft Transact-SQL

ThakralGL > Courses > Microsoft > DP-080T00 – Querying Data with Microsoft Transact-SQL
  • Duration: 10 weeks
Categories:

1. Introduction to Transact-SQL

This module provides an introduction to relational databases, the SQL language and Transact-SQL. You will learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.

Click here to know more

2. Sort and filter results in T-SQL

Learn how to sort and filter query results

Click here to know more

3. Combine multiple tables with JOINs in T-SQL

Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.

Click here to know more

4. Write Subqueries in T-SQL

Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.

Click here to know more

5. Use built-in functions and GROUP BY in Transact-SQL

Learn how to use functions in Transact-SQL, and how to group aggregated results.

Click here to know more

6. Modify data with T-SQL

Learn how to use Transact-SQL to insert, update, and delete data in a database.

Click here to know more

Leave feedback about this

Related Courses

Free

AZ-1002 – Configure secure access to your workloads using Azure networking

1. Configure virtual networks Learn to configure virtual networks and subnets, including IP addressing. Click here to know more 2. Configure Azure Virtual Network peering Learn to configure an Azure Virtual Network peering connection and address transit and connectivity concerns. Click here to know more 3. Manage and control traffic…
0
Free

AZ-1003 – Secure storage for Azure Files and Azure Blob Storage

1. Create an Azure Storage account Create an Azure Storage account with the correct options for your business needs. Click here to know more 2. Configure Azure Blob Storage Learn how to configure Configure Azure Blob Storage, including tiers and object replication. Click here to know more 3. Configure Azure…
0
Free

AZ-2001 – Implement security through a pipeline using Azure DevOps

1. Configure a project and repository structure to support secure pipelines This module is designed to help learners understand the importance of configuring a secure project and repository structure to support pipelines in Azure DevOps. The module covers fundamental concepts and best practices for organizing the project and repository structure…
0
Free

DP-605T00 – Develop dynamic reports with Microsoft Power BI

1. Get data in Power BI You’ll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You’ll also learn how to improve performance while retrieving data. Click here to know more 2. Clean, transform, and load data in Power…
0
Free

DP-3014 – Implement a Machine Learning solution with Azure Databricks

1. Explore Azure Databricks Azure Databricks is a cloud service that provides a scalable platform for data analytics using Apache Spark. Click here to know more 2. Use Apache Spark in Azure Databricks Azure Databricks is built on Apache Spark and enables data engineers and analysts to run Spark jobs…
0