SQL Beginner to Advanced Level - Data Analytics

Name: SQL Beginner to Advanced Level - Data Analytics
Rating: 4.7 (379 reviews)

Learn SQL using Microsoft SQL Server Environment

Created byAlexander Shafe

Last updated 12/2025

English

What you'll learn

Learn how to code in SQL from the beginning to advance level - Write, Read and Analyze with SQL.
Learn to work with databases in SQL Server.
Query SQL within a Server.

Course content

18 sections • 137 lectures • 13h 48m total length

SQL Course Introduction1:44
Instructor Introduction0:36
Course Requirement & Prerequisite2:19
Course Curriculum3:11
Course Structure2:19
Udemy Review System1:25
Application Downloads & Installation0:39
Windows Applications Download & Installation4:52
Learn to install Microsoft SQL Server 2019 developer edition on Windows, manage multiple instances, and set up SQL Server Management Studio for a graphical user interface or command line interface.
Mac book Applications Download & Installation21:19
Learn to run SQL Server on Mac by installing a VirtualBox VM with Windows 10, SQL Server 2019 Developer Edition, and SSMS, plus setup tips.
Microsoft SQL Server Environment Review10:05

Section Introduction0:31
What is Data?1:25
What are Databases?1:06
Introduction to Database Management System (DBMS)1:06
Relational Database Management System (RDBMS)3:40
How to Create a database3:44
Saving Queries in SQL Server2:07
Selecting a Database3:02
Use the use database syntax to switch between databases in SQL Server, such as computers, basketball, and restaurant, while viewing system databases like master, model, msdb, and tempdb.
Delete a Database2:39

Section Introduction0:29
Explore data definition language (ddl) commands used to define table schemas, apply constraints, and include non-intrusive comments in sql queries.
CREATE, DROP, ALTER10:43
Adding comments to query4:56
Null & Not Null – SQL Constraint17:45
Add a Default Constraint6:11
Add a Unique Constraint6:30
Enforce email uniqueness in an employees table by applying a unique constraint on the email column in SQL Server, preventing duplicate records and ensuring clear, distinct staff emails.
Primary Key Constraint8:18
Using IDENTITY in SQL5:50

Section Introduction0:18
Explore string functions essential for querying and analyzing records within SQL, and practice with the commonly used string functions. Build foundational skills for SQL data analytics.
String Functions3:35
Discover how SQL string functions work, including the concat function to join strings, and follow a hands-on setup to create a bookstore database and a books table.
CONCAT Function15:26
CONCAT_WS Function4:41
LEFT Function10:45
RIGHT Function7:16
LEN Function6:27
UPPER Function4:25
LOWER Function3:39
LTRIM, RTRIM, TRIM Functions13:10
REVERSE Function4:28
REPLACE Function5:50
Explore the replace function in sql to search and replace substrings within a string, using replace(string, old_substring, new_substring), with examples like happy to yellow and spaces to plus signs.
SUBSTRING Function6:53

Requirements

No course requirement or prerequisites

Description

Learn SQL from the beginning to becoming an expert analyzing data in SQL. This course takes you from having little or no knowledge of SQL to becoming highly proficient querying with SQL.

Knowing SQL is highly important if you intend working with data and the demand for SQL skills is ever growing.

You will learn SQL in a server environment which is most likely how you would use SQL in the real world. This course is designed to cut through the chase and teach you what you need to become successful.

This course is hands on with lots of practice tasks which allows you get comfortable and familiar with querying in SQL.

My goal is to make your learning efficient, smooth and equip you with the skill set you need to start or transition into any data related field.

Course Requirement or Prerequisites

This course does not require any prior knowledge or specific academic background. The only requirement is having a laptop or desktop computer. All applications necessary for learning the course would be downloaded free from the internet.

Who is this course for?

Anyone looking to work with data personally or professionally.

Starting or transitioning into a career as Data Scientist, Data Analyst, Business Analyst, Database Administrator, Report Analyst, ETL Specialist, BI Consultant, Data Engineer or any Data related field.

Who this course is for:

Anyone who wants to learn SQL from Beginner level to becoming proficient in SQL

SQL Beginner to Advanced Level - Data Analytics

What you'll learn

Explore related topics

Course content

Introduction10 lectures • 48min

Data, Databases & Database Management system9 lectures • 19min

Introduction to SQL (Structured Query Language)4 lectures • 11min

Data Types in SQL5 lectures • 11min

Tables in SQL6 lectures • 28min

Data Definition Language (DDL)8 lectures • 1hr 1min

Data Query Language (DQL)3 lectures • 15min

Data Manipulation Language (DML)5 lectures • 40min

String Functions13 lectures • 1hr 27min

Sorting Records8 lectures • 1hr 1min

Requirements

Description

Who this course is for: