Advertisement
beginner levelDiploma in Advanced SQL Server
6-10hrs
diplomaIT
In this course, we will be taking your basic database skills up a notch and providing you with a refined understanding of coding in SQL 2019. We will be going through essential coding concepts such as carrying out advanced analyses, using subqueries, common table expressions and data optimisation. All these techniques can help you become a more efficient programmer and take your skills and career to the next level. So enrol now to keep learning!
read more
Diploma in Advanced SQL Server
Develop an in-depth understanding of the concepts and functions of an advanced SQL server with this free online course.
In this course, we will be taking your basic database skills up a notch and providing you with a refined understanding of coding in SQL 2019. We will be going through essential coding concepts such as carrying out advanced analyses, using subqueries, common table expressions and data optimisation. All these techniques can help you become a more efficient programmer and take your skills and career to the next level. So enrol now to keep learning!
Course description
Course module
A short ad will play before each lesson.
Module 16 Lessons
Before We Start Coding
In this module, we review some of the essential details regarding programming in SQL. A guide on how to install SQL Server 2019 and SQL server management studio shall be provided. We will also go through the process of downloading the AdventureWorks sample database. A walkthrough of the course environment shall also be provided during the module.
1.Learning Outcomes
Continue Learning
2.Installing SQL Server 2019 Express
Continue Learning
3.Installing SQL Server Management Studio
Continue Learning
4.Downloading the AdventureWorks Sample Database
Continue Learning
5.Course Environment Walkthrough
Continue Learning
6.Lesson Summary
Continue Learning
Module 27 Lessons
Advanced Analysis With Window Functions
Module 38 Lessons
Scalar and Correlated Subqueries
Module 45 Lessons
Common Table Expressions
Module 57 Lessons
Temp Table Functions
Module 66 Lessons
Optimization
Module 77 Lessons
Programming SQL
Module 81 Lessons
Course assessment
INSIGHTS
Latest Post
200K Layoffs, $100B Lost: The Tsunami of China’s Regulation on Education
Analyzing the impact of China’s regulatory crackdown on the nation’s for-profit education industry.
Read More
Duolingo’s Q4 2025: Record Revenue, Record Stock Drop, One Massive Buyback
TL;DR
Duolingo reported Q4 2025 revenue of $282.9 million (+35% YoY), closing its first billion-dollar year, breaking estimates again.
The stock dropped 22.5% anyway. Again.
The company plans to slow down monetization to grow to 100 million DAUs until 2028, by focusing on teaching quality, giving more to free users, and growing non-language courses.
Duolingo’s Q4 2025 results confirmed something we highlighted in its 2025 review: growth is slowing.
The company crossed a billion dollars in r
Read More
Coursera, Udemy, and the $10M+ Video Privacy Battle: Class Action Update
Discover the costly legal fallout and class action developments for these online learning giants as they grapple with alleged video privacy violations.
Read More
FEATURED COLLECTION
Recommended Related Courses
Intermediate Level
Foundations of ITIL 4 for Service Management
3-4hrsdiplomasFREE
Start learning
Intermediate Level
CompTIA A+ 1000 - Part 2
6-10hrsdiplomasFREE
Start learning
Intermediate Level
Fundamentals of NIS2 Directive - EU Cybersecurity Enhancement
1.5-3hrsdiplomasFREE
Start learning
beginner level
Introduction to Electronic Document Management
3-4hrsdiplomasFREE
Start learning
beginner level
Introduction to CCTV Systems & AutoCAD Layouts
1.5-3hrsdiplomasFREE
Start learning
Intermediate Level
Diploma in ISO 27001:2022 - Information Security Management System (ISMS)
10-15hrsdiplomasFREE
Start learning
Advertisement
Build Your Career Toolkit
