gameIcon
IT
Diploma in Advanced SQL Server
time6-10hrs
timebeginner level
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!
checked1Course description
checked1Course module
A short ad will play before each lesson.
arrow_top
Module 1
6 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.
course
1.Learning Outcomes
Continue Learningcontinue
course
2.Installing SQL Server 2019 Express
Continue Learningcontinue
course
3.Installing SQL Server Management Studio
Continue Learningcontinue
course
4.Downloading the AdventureWorks Sample Database
Continue Learningcontinue
course
5.Course Environment Walkthrough
Continue Learningcontinue
course
6.Lesson Summary
Continue Learningcontinue
arrow_top
Module 2
7 Lessons
Advanced Analysis With Window Functions
arrow_top
Module 3
8 Lessons
Scalar and Correlated Subqueries
arrow_top
Module 4
5 Lessons
Common Table Expressions
arrow_top
Module 5
7 Lessons
Temp Table Functions
arrow_top
Module 6
6 Lessons
Optimization
arrow_top
Module 7
7 Lessons
Programming SQL
arrow_top
Module 8
1 Lessons
Course assessment
Related Articles
gameIcon
70+ FutureLearn Courses with Free Certificates
Scanning FutureLearn’s catalog, we found more than 70 free certificates on business, teaching, health, and more.
gameIcon
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.
gameIcon
10 Best Guitar Courses for Beginners in 2025
If you’re interested in learning the guitar, there’s a course for you. In this guide to the best guitar courses, there are several beginner courses to choose from, plus some specific styles to explore if you already know the basics. The guitar is a popular and versatile musical instrument. It’s portable (especially the acoustic guitar), and you can play melodies or strumming both solo and in a band. It lends itself beautifully to many musical styles, from flamenco to classical, jazz, blues, fol
gameIcon
Udemy Announces Layoffs Without Saying ‘Layoffs’
Udemy’s latest ‘Strategic Business Update’ uses corporate euphemisms to signal job cuts while pivoting to enterprise clients.
gameIcon
The Business of Online Education: A Deep Dive Into Coursera’s Financials
Discover how Coursera makes money, its different segments, revenue growth, margins, and more.
gameIcon
10 Best Free Rust Courses for 2025: Write Memory-Safe Code
What if I told you that one man’s frustration with an elevator breakdown led to the creation of the fastest-growing and most-beloved programming languages today? Seventeen years ago, Graydon Hoare’s ordinary evening turned pivotal when an out-of-order elevator at his apartment building forced him to trek up 21 stories. A Mozilla software engineer, Hoare’s frustration wasn’t just with the climb, but with the fact that the tools of his trade couldn’t even make an elevator that works without cras
Recommended Related Courses