SQL Made Simple: SQL Server Queries for Non-Programmers
4.7 (111 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,785 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Made Simple: SQL Server Queries for Non-Programmers to your Wishlist.

Add to Wishlist

SQL Made Simple: SQL Server Queries for Non-Programmers

98 of the Fortune 100 trust SQL Server for their data. Now is your time to learn the language top applications run on.
4.7 (111 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,785 students enrolled
Created by IsáBel Harrison
Last updated 7/2017
English
Current price: $12 Original price: $195 Discount: 94% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 42 Articles
  • 26 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • 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!
View Curriculum
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 Server 2016
  • SQL Server 2014
  • SQL Server 2012
  • SQL Server 2008 R2
  • SQL Server 2008
Description

Learn SQL


By the end of this course you will be able to BUILD QUERIES, CREATE TABLES, and PERFORM AGGREGATE CALCULATIONS. You will learn how to JOIN TABLES together for more robust reporting, and how to CREATE VIEWS, and STORED PROCEDURES that let you save and reuse your queries.

So whether you are brand new to SQL, or need a refresher, this is SQL Made Simple, you will find this course highly useful, and easy to learn.


R E S O U R C E S

↳ At the end of each section, you will find the SQL script used in that section, as well as Questions, to help reinforce what you learn... and of course, the Answers.  

↳ At the end of the course, you will find a Test Your Skills with even more questions and answers.

↳ Look for the Glossary of Terms Used In This Course to help you talk the talk.


Your SQL resources are here, so let's get started!

Who is the target audience?
  • 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.
Compare to Other SQL Courses
Curriculum For This Course
119 Lectures
03:41:32
+
Introduction
5 Lectures 15:26



Installing the Exercise Databases
00:54

Steps for a Successful Course
00:03
+
SQL: SELECT
7 Lectures 13:20

Learn the structure of the SELECT statement, used to retrieve data from your database.

Preview 02:08

Multiple examples will walk you through the core of scripting SQL - the SELECT statement.

Preview 05:21

Learn to use aliases to temporarily rename a column heading

Preview 02:55

DISTINCT is used when you have duplicate values in your query, and you only want to return unique values.

Preview 01:42

The SQL used in this section.

Preview 00:33

Exercises to reinforce the SQL you learned in this section of the course - SELECT

Exercise: Lesson Lab Questions
00:27

Answers to the SELECT section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:13
+
SQL: WHERE
12 Lectures 33:13

The WHERE clause is in SQL used to filter records

The WHERE Syntax
01:31

In SQL, wildcard characters are used with the LIKE operator, and can be used to substitute any character(s) in a string. 

Understanding LIKE, %
02:54

Learn additional ways to filter records in SQL

Understanding [ ]
02:33

Learn additional ways to filter records in SQL

Understanding NOT, ^
02:02

Learn additional ways to filter records in SQL

Understanding BETWEEN... AND
03:20

Learn additional ways to filter records in SQL

Understanding IN
01:09

Learn additional ways to filter records in SQL

Understanding NULL, NOT NULL
02:11

Examples of how you can use WHERE to filter records in SQL

WHERE (1)
05:30

More examples of how you can use WHERE to filter records in SQL

WHERE (2)
10:43

The SQL used in this section.

Section SQL: WHERE
00:37

Exercises to reinforce the SQL you learned in this section of the course - WHERE

Exercise: Lesson Lab Questions
00:27

Answers to the WHERE section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:16
+
SQL: ORDER BY
5 Lectures 06:40

In SQL, ORDER BY is used to sort the result set

The ORDER BY Syntax
01:43

Examples of how you can use ORDER BY in SQL to sort records in your databases

ORDER BY
03:40

The SQL used in this section.

Section SQL: ORDER BY
00:32

Exercises to reinforce the SQL you learned in this section of the course - ORDER BY

Exercise: Lesson Lab Questions
00:27

Answers to the ORDER BY section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:17
+
Introduction to Aggregate Functions in SQL
7 Lectures 11:44

In SQL, use aggregate functions to return one value, calculated from multiple values in a column

Aggregate Functions
01:32

Examples of the SQL SUM function

SUM
03:48

Examples of the SQL COUNT function

COUNT
02:50

Examples of the SQL MIN and MAX functions

MIN, MAX and AVG (Average)
02:14

The SQL used in this section.

Section SQL: Aggregate Functions
00:32

Exercises to reinforce the SQL you learned in this section of the course - Aggregate functions

Exercise: Lesson Lab Questions
00:25

Answers to the Aggregate Function section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:22
+
SQL: Date and Time Functions
9 Lectures 17:41

Examples of the SQL DATE and TIME functions

Displaying the Current System Date and Time
01:38

Learn how to format dates using SQL in your databases

Formatting Dates and Times Using CONVERT
04:42

Example of the SQL DAY function

DAY, MONTH, YEAR Functions
02:47

Examples of the SQL DatePart function

DATEPART
01:59

Examples of the SQL DateAdd function

DATEADD
03:17

Examples of the SQL DateDiff function

DATEDIFF
01:55

The SQL used in this section.

Section SQL: Date and Time Function
00:38

Exercises to reinforce the SQL you learned in this section of the course - Date Functions

Exercise: Lesson Lab Questions
00:28

Answers to the Date and Time section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:16
+
SQL: String Functions
10 Lectures 11:20

Learn how to bring fields together using SQL

CONCAT
02:11

Use SQL to convert the value of a field to lowercase or uppercase

LOWER and UPPER
00:57

Extract characters from the left or right side of a character string in SQL

LEFT and RIGHT
02:46

Extract characters from a character string in SQL

SUBSTRING
02:03

In SQL, find the length of a value in a string

LEN
00:14

Remove blank characters from the ends of a character string in SQL

LTRIM, and RTRIM
00:09

Replace characters with other characters

REPLACE
01:48

The SQL used in this section.

Section SQL: String Functions
00:35

Exercises to reinforce the SQL you learned in this section of the course - String Functions

Exercise: Lesson Lab Questions
00:24

Answers to the String Functions section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:12
+
SQL: Subqueries
5 Lectures 08:06

In SQL, a subquery is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside of another subquery

Subqueries
06:04

Learn to use EXISTS

Using EXISTS with Subqueries
00:40

The SQL used in this section.

Section SQL: Subqueries
00:33

Exercises to reinforce the SQL you learned in this section of the course - Subqueries

Exercise: Lesson Lab Questions
00:26

Answers to the Subqueries section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:23
+
Joining Tables Using SQL
14 Lectures 29:49
Introduction to Joins
01:20

Learn about INNER JOINS and OUTER JOINS

Common Types of Joins
01:35

Learn the SQL syntax for creating Joins

The JOIN Syntax
01:51

Examples of how to Join tables in your database using SQL

Inner Joins
08:01

Examples of the SQL DateValue function

Outer Joins
03:03

Examples of joining 3 or more tables in the Northwind database.

Examples of Three or More Table Joins - UPDATED
01:12

Learn to use aliases to temporarily rename tables

Aliasing Tables in Joins
02:34

Examples of the SQL AVERAGE function

Union Joins
03:14

The PRIMARY KEY uniquely identifies each record in a table. A FOREIGN KEY in one table is the PRIMARY KEY in another table.

Self Joins
04:06

Now that you know how to create a Subquery, and how to create a Join, which one should you use?

FAQ: Subqueries v. Joins
00:54

The SQL used in this section.

Section SQL: Joining Tables with SQL
00:31

Exercises to reinforce the SQL you learned in this section of the course - Joins

Exercise: Lesson Lab Questions
00:41

Answers to the Joining Tables section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:45

How are you enjoying the course?
00:00
+
SQL: Views
8 Lectures 11:21
Introduction to Views
01:21

Creating Views
04:18

Schemabinding protects from the modification of a view's source table. 

Schemabinding
03:02

Altering Views
01:24

Dropping Views
00:04

The SQL used in this section.

Section SQL: Views
00:30

Exercises to reinforce the SQL you learned in this section of the course - Views

Exercise: Lesson Lab Questions
00:20

Answers to the Views section Lesson Lab questions.

Exercise: Lesson Lab Answers
00:22
6 More Sections
About the Instructor
IsáBel Harrison
4.5 Average rating
1,063 Reviews
15,748 Students
16 Courses
Results & Convenience | Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.


Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, then ▶Subscribe to My YouTube Channel, because Change Matters, Growth Matters.