Querying SQL Server
Master the skills needed to query and modify data effectively using Transact-SQL.
Plans Become an affiliate
What's Included?
The Querying SQL Server course covers the fundamentals of Transact-SQL, including data querying and modification techniques. This course is divided into twelve topics, each focusing on a specific aspect of SQL Server management. Each module includes video lectures, downloadable resources, and knowledge checks to reinforce learning. Upon completion of all modules, you will receive a certificate of completion.
22
minutes on-demand video
5
Downloadable resources
5
Modules
5
Knowledge Checks
Access on mobile devices
1
Certificate of completion
Course Content
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.
- Module 1: Download and Install SQL Server
- Module 1: Download and Install Databases
- Module 1: Getting Started with Transact-SQL
- Knowledge Check DP-080 Module 1
- Module 2: Sorting and Filtering Query Results
- Knowledge Check DP-080 Module 2
- Module 3: Using Joins and Subqueries
- Knowledge Check DP-080 Module 3
- Module 4: Using Built-In Functions
- Knowledge Check DP-080 Module 4
- Module 5: Modifying Data
- Knowledge Check DP-080 Module 5
Pricing Package
This course is available as part of our subscription plans. Choose the plan that best fits your needs:
Mock Library
Prepare for your exams with our professional mock exams.
$5.99/per month
Get Started- Access to All Existing Practice Exams
- Access to All Future Practice Exams
- Unlimited Access While Subscribed
- Cancel Anytime!
Course Library
Gain access to our expert video training and course resources.
$6.99/per month
Get Started- Access to All Existing Video Training
- Access to All Future Video Training Released While Subscribed
- Unlimited Access While Subscribed
- Progress Tracking Abilities
- Certificate of competition for each course.
- Cancel Anytime!
Full Library
Gain access to everything!
$9.99/per month
Get Started- Access to All Existing Mock & Video Training
- Access to All Future Mock & Video Training Training Released While Subscribed
- Access to all resources
- Unlimited Access While Subscribed
- Progress Tracking Abilities
- Certificate of competition for each course.
- Cancel Anytime!