Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL Made Simple: SQL Server Queries for Non-Programmers

Name: SQL Made Simple: SQL Server Queries for Non-Programmers
Rating: 4.5 (522 reviews)

Master SQL Queries, and Data Manipulation Without Any Programming Experience

Created byIsáBel .

Last updated 1/2026

English

What you'll learn

Course SQL Script Included!
SQL queries broken down into ACTIONABLE STEPS.
Before you know it, you'll be scripting SQL queries on your own!
WRITE SQL Queries in Your SQL Server Databases
CREATE Select Queries
FILTER with the WHERE Clause
SORT Your Database Records
GROUP Your Records
USE Aggregate Functions
LEARN Different Date Functions
GET Familiar with Functions You Can Use with Strings
LEARN How to Join Tables
CREATE Subqueries
CREATE Tables Using SQL
INSERT Records Into Your Tables
CREATE Views
... and more!

Course content

16 sections • 120 lectures • 3h 42m total length

Introduction0:53
Learn to build queries, create tables, and perform aggregate calculations. Join tables for robust reporting and create views and stored procedures to save and reuse queries.
What is SQL?1:57
Explore structured query language, sql, as the global standard for querying and manipulating data. Learn sql's data manipulation and data definition languages, including select, insert, update, delete, and where.
Getting Familiar with SQL Server Management Studio11:39
Installing the Exercise Databases0:54
Steps for a Successful Course

The SELECT Syntax2:08
Learn the structure of the SELECT statement, used to retrieve data from your database.
SELECT Statements5:21
Multiple examples will walk you through the core of scripting SQL - the SELECT statement.
Aliasing Columns2:55
Learn to use aliases to temporarily rename a column heading
DISTINCT1:42
DISTINCT is used when you have duplicate values in your query, and you only want to return unique values.
Section SQL: SELECT0:33
The SQL used in this section.
Exercise: Lesson Lab Questions0:23
Exercises to reinforce the SQL you learned in this section of the course - SELECT
Exercise: Lesson Lab Answers0:08
Answers to the SELECT section Lesson Lab questions.

The WHERE Syntax1:31
The WHERE clause is in SQL used to filter records
Understanding LIKE, %2:54
In SQL, wildcard characters are used with the LIKE operator, and can be used to substitute any character(s) in a string.
Understanding [ ]2:33
Learn additional ways to filter records in SQL
Understanding NOT, ^2:02
Learn additional ways to filter records in SQL
Understanding BETWEEN... AND3:20
Learn additional ways to filter records in SQL
Understanding IN1:09
Learn additional ways to filter records in SQL
Understanding NULL, NOT NULL2:11
Learn additional ways to filter records in SQL
WHERE (1)5:30
Examples of how you can use WHERE to filter records in SQL
WHERE (2)10:43
More examples of how you can use WHERE to filter records in SQL
Section SQL: WHERE0:37
The SQL used in this section.
Exercise: Lesson Lab Questions0:24
Exercises to reinforce the SQL you learned in this section of the course - WHERE
Exercise: Lesson Lab Answers0:14
Answers to the WHERE section Lesson Lab questions.

The ORDER BY Syntax1:43
In SQL, ORDER BY is used to sort the result set
ORDER BY3:40
Examples of how you can use ORDER BY in SQL to sort records in your databases
Section SQL: ORDER BY0:32
The SQL used in this section.
Exercise: Lesson Lab Questions0:23
Exercises to reinforce the SQL you learned in this section of the course - ORDER BY
Exercise: Lesson Lab Answers0:13
Answers to the ORDER BY section Lesson Lab questions.

Aggregate Functions1:32
In SQL, use aggregate functions to return one value, calculated from multiple values in a column
SUM3:48
Examples of the SQL SUM function
COUNT2:50
Examples of the SQL COUNT function
MIN, MAX and AVG (Average)2:14
Examples of the SQL MIN and MAX functions
Section SQL: Aggregate Functions0:32
The SQL used in this section.
Exercise: Lesson Lab Questions0:23
Exercises to reinforce the SQL you learned in this section of the course - Aggregate functions
Exercise: Lesson Lab Answers0:16
Answers to the Aggregate Function section Lesson Lab questions.

Displaying the Current System Date and Time1:38
Examples of the SQL DATE and TIME functions
Formatting Dates and Times Using CONVERT4:42
Learn how to format dates using SQL in your databases
DAY, MONTH, YEAR Functions2:47
Example of the SQL DAY function
DATEPART1:59
Examples of the SQL DatePart function
DATEADD3:17
Examples of the SQL DateAdd function
DATEDIFF1:55
Examples of the SQL DateDiff function
Section SQL: Date and Time Function0:38
The SQL used in this section.
Exercise: Lesson Lab Questions0:27
Exercises to reinforce the SQL you learned in this section of the course - Date Functions
Exercise: Lesson Lab Answers0:13
Answers to the Date and Time section Lesson Lab questions.

CONCAT2:11
Learn how to bring fields together using SQL
LOWER and UPPER0:57
Use SQL to convert the value of a field to lowercase or uppercase
LEFT and RIGHT2:46
Extract characters from the left or right side of a character string in SQL
SUBSTRING2:03
Extract characters from a character string in SQL
LEN0:10
In SQL, find the length of a value in a string
LTRIM, and RTRIM0:09
Remove blank characters from the ends of a character string in SQL
REPLACE1:48
Replace characters with other characters
Section SQL: String Functions0:35
The SQL used in this section.
Exercise: Lesson Lab Questions0:20
Exercises to reinforce the SQL you learned in this section of the course - String Functions
Exercise: Lesson Lab Answers0:08
Answers to the String Functions section Lesson Lab questions.

Subqueries6:04
In SQL, a subquery is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside of another subquery
Using EXISTS with Subqueries0:36
Learn to use EXISTS
Section SQL: Subqueries0:33
The SQL used in this section.
Exercise: Lesson Lab Questions0:24
Exercises to reinforce the SQL you learned in this section of the course - Subqueries
Exercise: Lesson Lab Answers0:15
Answers to the Subqueries section Lesson Lab questions.

Introduction to Joins1:20
Common Types of Joins1:35
Learn about INNER JOINS and OUTER JOINS
The JOIN Syntax1:51
Learn the SQL syntax for creating Joins
Inner Joins8:01
Examples of how to Join tables in your database using SQL
Outer Joins3:03
Examples of the SQL DateValue function
Examples of Three or More Table Joins - UPDATED1:00
Examples of joining 3 or more tables in the Northwind database.
Aliasing Tables in Joins2:34
Learn to use aliases to temporarily rename tables
Union Joins3:14
Examples of the SQL AVERAGE function
Self Joins4:06
The PRIMARY KEY uniquely identifies each record in a table. A FOREIGN KEY in one table is the PRIMARY KEY in another table.
FAQ: Subqueries v. Joins0:49
Now that you know how to create a Subquery, and how to create a Join, which one should you use?
Section SQL: Joining Tables with SQL0:31
The SQL used in this section.
Exercise: Lesson Lab Questions0:39
Exercises to reinforce the SQL you learned in this section of the course - Joins
Exercise: Lesson Lab Answers0:33
Answers to the Joining Tables section Lesson Lab questions.
How are you enjoying the course?

Introduction to Views1:21
Creating Views4:18
Create two views from the orders and products tables: last ten orders by date in descending order and discontinued products list.
Schemabinding3:02
Schemabinding protects from the modification of a view's source table.
Altering Views1:24
Dropping Views0:04
Section SQL: Views0:30
The SQL used in this section.
Exercise: Lesson Lab Questions0:16
Exercises to reinforce the SQL you learned in this section of the course - Views
Exercise: Lesson Lab Answers0:15
Answers to the Views section Lesson Lab questions.

Requirements

Download the databases to follow along. This is covered in the lecture, "Installing the Exercise Databases"
Access to one of the following versions of SQL Server & SQL Server Management Studio
---------------------
SQL Sever 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
SQL Server 2008

Description

Are you ready to unlock the power of SQL?

Whether you're brand new to SQL or just need a refresher, SQL Made Simple is the perfect course to get you started with querying SQL Server. SQL is a vital skill for anyone aspiring to work with databases, and by the end of this course, you'll be equipped with the knowledge to confidently build queries, create tables, and perform aggregate calculations.

In this course, you'll learn how to:

Build queries to retrieve exactly the data you need
Join tables together for more advanced reporting
Create tables, views, and stored procedures that will save you time and make your work more efficient
Perform aggregate calculations to summarize your data with ease

Designed for non-programmers, this course makes SQL accessible and easy to learn. Step by step, you’ll gain practical experience that will help you become proficient in SQL Server.

Course Features:

SQL Scripts & Resources: At the end of each section, you’ll find the SQL scripts used in the lessons, plus practice questions and answers to reinforce what you've learned.
Test Your Skills: Challenge yourself with a final set of questions to make sure you’ve mastered the material.
Glossary of Terms: Build your SQL vocabulary with a handy glossary of terms used throughout the course.

With hands-on practice and real-world examples, you'll be ready to dive into SQL Server and start applying your skills right away. So, let’s get started—your journey to mastering SQL begins here!

Who this course is for:

This SQL course is for new SQL Server users who are not yet familiar with SQL syntax. This course is for those who will be gathering and mining for data, not for database administrators looking to learn about implementation, or security. No prior programming knowledge is needed. This course is probably not for you is you are looking to learn super advanced queries.
This SQL course is not for you if you are already 100% comfortable with SQL.
This SQL course is for SQL Server user who are looking to query databases.
This SQL course is not for SQL user who are looking for information about database administration, or security policies.

SQL Made Simple: SQL Server Queries for Non-Programmers

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 15min

SQL: SELECT7 lectures • 13min

SQL: WHERE12 lectures • 33min

SQL: ORDER BY5 lectures • 7min

Introduction to Aggregate Functions in SQL7 lectures • 12min

SQL: Date and Time Functions9 lectures • 18min

SQL: String Functions10 lectures • 11min

SQL: Subqueries5 lectures • 8min

Joining Tables Using SQL14 lectures • 29min

SQL: Views8 lectures • 11min

Requirements

Description

Who this course is for: