Duration : 2 Days
4323 Partipants
Looking for Corporate TrainingExpert-led Comprehensive Learnings Microsoft Certified Trainers [MCTs]
Querying Data with Microsoft Transact-SQL (DP-080T00) Certification
<p>The beginner-level Azure course focuses on the database administrator role. <br /> Instructor-led customizable upskilling teaches the foundational aspects of <br /> Microsoft's dialect of the standard SQL language: <strong>Transact-SQL.</strong><br /> </p>
Querying Data with Microsoft Transact-SQL (DP-080T00) Certification
Official Microsoft Content Authorized Course Material
ILVT, Online & In-house Interactive Face-to-face Solutions
Schedule-flexible eLearning Self-paced Offerings
Course Overview
Database Administrators are involved in installing/maintaining the performance of database servers, developing processes for optimizing database security, setting/maintaining database standards, managing database access, performance tuning of database systems, installing, upgrading, and managing database applications.
The Querying Data with Microsoft Transact-SQL training covers multiple aspects, including querying/modifying data in relational databases hosted in Microsoft SQL Server-based database systems like Microsoft SQL Server, Azure SQL Database and Azure Synapse Analytics.
Loading...
Course Objectives
- To Get Started with Transact-SQL.
- Explore Sort & Filter Results in T-SQL.
- Combine Multiple Tables with JOINs in T-SQL.
- Write Subqueries in T-SQL.
- Use Built-in Functions & GROUP BY in Transact-SQL.
- Modify Data with T-SQL.
Audience
- Individuals interested in writing basic SQL or Transact-SQL queries.
- Those peripherally involved with data or willing to learn more about working with data.
- Students, Data Analysts, Data Engineers, Data Scientists, Database Administrators, Database Developers, Solution Architects & Technology Managers.
Course Outline
Transact-SQL Introduction
- Understanding what SQL is for.
- Identifying database objects in schemas.
- Identifying SQL statement types.
- Using the SELECT statement.
- Working with data types.
- Handling NULLs.
Sorting & Filtering Results in T-SQL
- Sorting your results.
- Limiting the sorted results.
- Returning paged results.
- Removing duplicates.
- Filtering data with predicates.
Combining Multiple Tables with JOINs in T-SQL
- Describing join concepts and syntax.
- Writing queries that use inner and outer joins.
- Writing queries that use cross joins.
- Writing queries that use self joins.
Writing Subqueries in T-SQL
- Understanding what subqueries are.
- Using scalar or multi-valued subqueries.
- Using self-contained or correlated subqueries.
Using Built-in Functions & GROUP BY in Transact-SQL
- Categorizing built-in functions.
- Using scalar functions.
- Using ranking and rowset functions.
- Using aggregate functions.
- Summarizing data with GROUP BY.
- Filtering groups with HAVING.
Modifying Data with T-SQL
- Inserting data into a table.
- Generating automatic values.
- Updating data in a table.
- Deleting data from a table.
- Merging data based on multiple tables
Choose Your Preferred Mode
FAQ’s
What's the primary function of any efficient DBA?
DBAs or Database Administrators are responsible for maintaining, securing and operating databases while ensuring data is appropriately stored/retrieved.
Is Querying Data with Microsoft Transact-SQL training an intermediate-level offering?
Please note that DP-080T00 is an entry-level course meant for beginners.
May I attend the training without completing my Microsoft Azure Fundamentals course?
You can; there are no mandatory prerequisites.
May I attend the training without completing my Microsoft Azure Fundamentals course?
You can; there are no mandatory prerequisites.
Does this course prepare for more than one MS Azure accreditation?
It does not directly prepare you for any certification exam.
Will I get training in sync with all the recent changes in the course content?
Yes, Vinsys, an authorized Microsoft Partner, always brings you the up-to-date learning curriculum.
Does DP-080T00 training provide approved courseware?
Yes, you will get access to the Microsoft Official Courseware (MOC).
Is there an option to customize the DP-080T00 training and choose my desired learning time slots?
You may opt for any of our highly customizable, blended and time-flexible ILVT, online, in-house, interactive face-to-face, eLearning or self-paced solutions
Why Vinsys
Seasoned Instructors
Official Vendor Partnerships
Authorized Courseware
3,000+ Courses & 2,000+ Modules
In Synch with Tech-advancements
Customizable Blended Learning Options
Reviews
Always preferred Vinsys for Microsoft courses. They stick to the official content and bring real-world expertise
Ravi TejaData Scientist
Data Analysts like me look for in-depth learning features, and surprisingly, we got more than we expected. No complaints
Kusum ManeDate Analysts
Search