The Complete SQL Course 2024 Learn by Doing SQL Server

The Complete SQL Course 2024 – Learn by Doing – SQL Server, available at $99.99, has an average rating of 4.63, with 114 lectures, 1 quizzes, based on 2587 reviews, and has 9006 subscribers.

You will learn about How to write accurate SQL queries against a database Use SQL to perform data analysis Learn to perform GROUP BY Statements Learn how to join multiple tables – including complex joins Learn how to use window functions, correlated subqueries, set operators, CTEs and much more Best practices in SQL Replicate real-world situations and query reports How to create tables, views and stored procedures How to make your queries run faster by making them sargable Be comfortable putting SQL and SQL Server on your resume This course is ideal for individuals who are Anyone interested in learning SQL or data analysis! or Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. or If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data or Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career It is particularly useful for Anyone interested in learning SQL or data analysis! or Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. or If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data or Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career.

Enroll now: The Complete SQL Course 2024 – Learn by Doing – SQL Server

Summary

Title: The Complete SQL Course 2024 – Learn by Doing – SQL Server

Price: $99.99

Average Rating: 4.63

Number of Lectures: 114

Number of Quizzes: 1

Number of Published Lectures: 114

Number of Published Quizzes: 1

Number of Curriculum Items: 115

Number of Published Curriculum Objects: 115

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

How to write accurate SQL queries against a database

Use SQL to perform data analysis

Learn to perform GROUP BY Statements

Learn how to join multiple tables – including complex joins

Learn how to use window functions, correlated subqueries, set operators, CTEs and much more

Best practices in SQL

Replicate real-world situations and query reports

How to create tables, views and stored procedures

How to make your queries run faster by making them sargable

Be comfortable putting SQL and SQL Server on your resume

Who Should Attend

Anyone interested in learning SQL or data analysis!

Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language.

If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data

Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career

Target Audiences

Anyone interested in learning SQL or data analysis!

Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language.

If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data

Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career

Learn how to write effective and accurate SQL with this course!

You will learn how to read and write complex SQL queries in a relational database (SQL Server). The skills you will learn are also largely applicable to any other major database system, such as MySQL, PostgreSQL, Oracle Database, and much more.

Knowing how to write SQL is one of the fastest ways to reach your career goals. This is because SQL is consistently the most in-demand skills in the tech sector. SQL can seem simple at first but it can quickly become complicated. It is common for people to a write SQL query without realizing they are getting an incorrect result returned. This course is designed with a focus on accuracy and understanding. You will learn how to avoid the common mistakes people make when writing SQL. Not only that.. but you will get a visual guide to the SQL language by seeing how queries work step-by-step. This is a complete course which covers all the core skills you need to master the SQL language.

I believe that the best way to learn SQL is by writing lots of SQL. For that reason, this course includes over 80 coding challenges where you get to write SQL queries and create database objects. These challenges are based on real-world scenarios and are designed for optimal understanding.

In this course you will learn everything you need to master SQL! Including:

Get started with SQL Server and SSMS, two of the world’s most popular SQL tools

How to install SQL Server on Windows and Mac-OS computers

Note: that Mac users will need to use Azure Data Studio rather than SSMS

Learn how to do data analysis and data analytics using SQL. Including advanced query techniques

Start by learning the fundamentals of the relational model and SQL language

Analyzing data using aggregate functions with the GROUP BY command

Writing advanced queries with string and date functions

Learn to use logical operators to add logic flow to your SQL queries

Learn how to write both self-contained and correlated sub queries

Learn how to join data by using the different types of JOIN commands

Learn how to do more advanced joins such as joining more than two tables and joining on multiple columns

Learn to create tables and integrity constraints

How to update, insert and delete data

How to create indexes

How to make your queries run faster by making them SARGable

Learn to write advanced SQL such as stored procedures, window functions, and common table expressions

Bonus section on Database Design – includes data normalization up to and including Boyce-Codd Normal Form.

and much, much more!

This course is one that puts you in control. Where you get to write SQL throughout the course, instead of watching someone else code. Every section comes with fresh challenges, modeled after real-world tasks and situations.

This comprehensive course allows you to learn at your own pace through an interactive environment.  You will start with the basics and soon find yourself writing advanced SQL queries.

Course Curriculum

Chapter 1: SQL Statement Fundamentals and Software Setup

Lecture 1: Introduction

Lecture 2: Understanding the Foundations of SQL

Lecture 3: SELECT Statement

Lecture 4: Overview of SQL Server

Lecture 5: Windows – How to Setup SQL Server and SSMS on a Windows Computer

Lecture 6: Windows – How to Setup the SAMPLEDB Database on Windows Computer

Lecture 7: MacOS – How to set up SQL Server Database on a Mac Computer using Docker

Lecture 8: Overview of the Course Challenges

Lecture 9: SELECT Challenges

Lecture 10: Solutions to the SELECT Challenges

Lecture 11: SELECT DISTINCT Statement

Lecture 12: SELECT DISTINCT Challenges

Lecture 13: Solutions to the SELECT DISTINCT Challenges

Lecture 14: Row Ordering – ORDER BY

Lecture 15: Filtering Data with TOP

Lecture 16: ORDER BY Challenges

Lecture 17: Solutions to the ORDER BY Challenges

Lecture 18: WHERE Clause – Three-valued Logic

Lecture 19: Replacing Nulls in Queries

Lecture 20: WHERE Clause – Comparison Operators

Lecture 21: WHERE Clause Challenges

Lecture 22: Solutions to the WHERE Clause Challenges

Lecture 23: Introduction to Collations and Pattern Matching

Lecture 24: Pattern Matching – Part 2

Lecture 25: Introduction to Character Data Types

Lecture 26: Pattern Matching Challenges

Lecture 27: Solutions to the Pattern Matching Challenges

Lecture 28: Introduction to Aggregate Functions

Lecture 29: GROUP BY and Aggregate Functions

Lecture 30: HAVING Clause

Lecture 31: Logical Query Processing Order

Lecture 32: GROUP BY Challenges

Lecture 33: Solutions to the GROUP BY Challenges

Lecture 34: AND operator

Lecture 35: OR operator

Lecture 36: Operator Precedence

Lecture 37: IN Operator

Lecture 38: Logical Operator Challenges

Lecture 39: Solutions to the Logical Operator Challenges

Chapter 2: Joins and Integrity Constraints

Lecture 1: Inner Joins

Lecture 2: Outer Joins – LEFT OUTER JOIN and RIGHT OUTER JOIN

Lecture 3: FULL OUTER JOIN

Lecture 4: Integrity Constraints

Lecture 5: Many-to-many Relationships

Lecture 6: Join Challenges

Lecture 7: Solutions to the Join Challenges

Lecture 8: Composite Joins – Joining on multiple columns

Lecture 9: Joining more than two tables

Lecture 10: Predicate placement – ON clause vs WHERE clause

Lecture 11: Self-referencing Joins

Lecture 12: Cross Joins

Lecture 13: Advanced Join Challenges

Lecture 14: Solutions to the Advanced Join Challenges

Chapter 3: Set Operators

Lecture 1: UNION and UNION ALL

Lecture 2: INTERSECT

Lecture 3: EXCEPT

Lecture 4: Set Operator Precedence

Lecture 5: SET Operator Challenges

Lecture 6: Solutions to the Set Operator Challenges

Chapter 4: Subqueries

Lecture 1: Self-contained Subqueries

Lecture 2: Correlated Subqueries

Lecture 3: EXISTS

Lecture 4: Introduction to Window Functions

Lecture 5: Common Table Expressions

Lecture 6: Avoiding the NOT IN trap

Lecture 7: Subquery Challenges

Lecture 8: Solutions to the Subquery Challenges

Chapter 5: Scalar Functions

Lecture 1: Concatenation in SQL Server

Lecture 2: String Manipulation Functions

Lecture 3: Date and Time Functions

Lecture 4: Function Challenges

Lecture 5: Solutions to the Function Challenges

Lecture 6: CASE Expression

Lecture 7: CASE Expression Challenges

Lecture 8: Solutions to the CASE Expression Challenges

Chapter 6: Data Definition Language (DDL) and Data Manipulation Language (DML)

Lecture 1: Overview of Data Types

Lecture 2: Integer Data Types

Lecture 3: DECIMAL Data Type

Lecture 4: FLOAT Data Type

Lecture 5: CREATE TABLE Statement

Lecture 6: INSERT Statement

Lecture 7: CREATE TABLE Challenges

Lecture 8: Solutions to the CREATE TABLE Challenges

Lecture 9: UNIQUEIDENTIFIER (GUID) Data Type

Lecture 10: UPDATE Statement

Lecture 11: DELETE Statement

Lecture 12: TRUNCATE TABLE statement

Lecture 13: DROP TABLE Statement

Lecture 14: Transactions

Lecture 15: Stored Procedures

Lecture 16: Stored Procedures Demo

Lecture 17: Stored Procedure Challenges

Lecture 18: Solutions to the Stored Procedure Challenges

Lecture 19: ALTER TABLE Statement and sp_rename

Instructors

Daniel Tait
Database Instructor

Rating Distribution

1 stars: 10 votes

2 stars: 19 votes

3 stars: 177 votes

4 stars: 865 votes

5 stars: 1523 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!