Skip to main content
DP-080T00: Query and modify data with Transact-SQL
0%
Previous
Course data
Introduction
Audio Book: Introduction
Lesson - 1 Query and modify data with Transact-SQL
Lesson - 1 Query and modify data with Transact-SQL
Audio Lesson - 1 Query and modify data with Transact-SQL
Podcast Lesson - 1 Query and modify data with Transact-SQL
1.1.1 Introduction
1.1.2 Work with schemas
1.1.3 Explore the structure of SQL statements
1.1.4 Examine the SELECT statement
1.1.5 Work with data types
1.1.6 Handle NULLs
1.1.7 Summary
Lab 1 - Get Started with Transact-SQL
Activity: Tab
Activity: Knowledge Check
1.2.1 Introduction
1.2.2 Sort your results
1.2.3 Limit the sorted results
1.2.4 Page results
1.2.5 Remove duplicates
1.2.6 Filter data with predicates
1.2.7 Summary
Lab 2 - Sort and Filter Query Results
Activity: Multiple Response
Activity: Knowledge Check
1.3.1 Introduction
1.3.2 Understand joins concepts and syntax
1.3.3 Use inner joins
1.3.4 Use outer joins
1.3.5 Use cross joins
1.3.6 Use self joins
1.3.7 Summary
Lab 3 - Query Multiple Tables with Joins
Activity: Carousel/Slideshow
Activity: Knowledge Check
1.4.1 Introduction
1.4.2 Understand subqueries
1.4.3 Use scalar or multi-valued subqueries
1.4.4 Use self-contained or correlated subqueries
1.4.5 Summary
Lab 4 - Use Subqueries
Activity: Accordion
Activity: Knowledge Check
1.5.1 Introduction
1.5.2 Categorize built-in functions
1.5.3 Use scalar functions
1.5.4 Use ranking and rowset functions
1.5.5 Use aggregate functions
1.5.6 Summarize data with GROUP BY
1.5.7 Filter groups with HAVING
1.5.8 Summary
Lab 5 - Use Built-in Functions
Activity: True/False
Activity: Knowledge Check
1.6.1 Introduction
1.6.2 Insert data
1.6.3 Generate automatic value
1.6.4 Update data
1.6.5 Delete data
1.6.6 Merge data based on multiple tables
1.6.7 Summary
Lab 6 - Modify Data
Activity: Multiple choice with image
Activity: Knowledge Check
Resources
DP-080T00 Blueprint
DP-080T00 Detailed Curiiculum
Quiz
Quiz
Next
Side panel
Categories
All categories
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
NetCom+
NetCom+ v1
AI CERTs Free Courses
NetCom+ Bengali
Netcom+ Free Courses
AI Tools
Soft Skills
Internal Training
Microsoft Spanish
Home
Search
Search
Search
Search
Close
Toggle search input
Log in
Categories
Collapse
Expand
All categories
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
NetCom+
NetCom+ v1
AI CERTs Free Courses
NetCom+ Bengali
Netcom+ Free Courses
AI Tools
Soft Skills
Internal Training
Microsoft Spanish
Home
Open Chat Bot
Course info
DP-080T00: Query and modify data with Transact-SQL
Grade
Certificate
Certificate Download
Certificate Sharing
