The Ultimate SQL Querying Package
4.4 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10 students enrolled

The Ultimate SQL Querying Package

Get Ready for that SQL Interview
4.4 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10 students enrolled
Created by Taylor Chiu
Last updated 2/2018
English
English [Auto]
Price: $99.99
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 105 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Confidently approach SQL queries
  • Schedule a SQL interview
Requirements
  • A desire to learn SQL
Description

The last course you will need for mastering SQL query-writing, whether you are starting a new career or looking to improve your existing skills. We go through the basics of writing your first query all the way through complex joins and subqueries. This course has hours of video and over 100 practice challenges.

Who this course is for:
  • SQL Beginners
  • Experienced SQL users who need a better querying foundation
  • SQL users who struggle in interviews
Course content
Expand all 161 lectures 04:01:08
+ My First Query
8 lectures 06:18
The Query Editor
00:42
Table Explanation
01:04
My First Query - Part II
00:22
Challenge Explanation
01:01
Simple Ethnicity Report
00:09
Simple Total Appointments Report
00:10
Why are you learning SQL
00:12
+ Selecting Multiple Columns
4 lectures 02:57
Selecting Multiple Columns - Part II
00:13
Simple Birthday Report
00:11
Birthdate vs Registration Date Report
00:11
+ Grab All Columns From a Table
2 lectures 02:11
Selecting All Columns
01:57
Full Patient Report
00:14
+ Column Aliases
6 lectures 07:22
Formatted Birthday Report
06:00
Making a Column Alias - Part II
00:23
Formatted Birthday Report
00:17
Formatted Total Appointments Report
00:14
Formatted Birthday Report #2
00:16
Formatted Total Appointments Report #2
00:11
+ DISTINCT Keyword
4 lectures 03:54
DISTINCT Keyword
03:18
Distinct Keyword - Part II
00:06
Sex (Gender) Report
00:13
Unique Total Appointments Report
00:16
+ WHERE - Conditional Statements (Integers)
6 lectures 07:58
WHERE Clause Introduction
06:29
WHERE Clause Introduction - Part II
00:26
Filtered Appointment Report #1
00:16
Filtered Status Report
00:11
Filtered Balance Report
00:19
Filtered Balance Report #2
00:16
+ WHERE - Conditional Statements (Dates)
4 lectures 02:44
WHERE (Filtering with Dates)
02:08
WHERE (Filtering with Dates) - Part II
00:06
Filtered Birthday Report
00:13
Filtered Registration Report
00:16
+ WHERE - Conditional Statements (Strings)
4 lectures 04:06
WHERE (Filtering with Strings)
03:40
WHERE (Filtering with Strings) - Part II
00:07
Moon Report
00:11
Native American Report
00:07
+ WHERE - AND
3 lectures 04:25
WHERE (AND Keyword)
03:55
Recent Registration + Appointments Report
00:17
Active + Low Balance Report
00:13