- Write Queries in PostgreSQL, MySQL, SQL Server, Oracle, or SQLite | Crash Course | Beginner | Interview Prepare
- Free tutorial
- Rating: 4.7 out of 54.7 (136 ratings)
- 4,749 students
- 1hr 16min of on-demand video
- Created by Kris Wenzel
- English
What you’ll learn
- Learn how to get started learning SQL
- Learn the basic structure of the SQL SELECT statement
- Understand how to INSERT, UPDATE, and DELETE data from a table
- Learn to write queries to sort, filter, and group data.
- Learn how to combine data from two tables using Joins and Subqueries.
- Learn SQL in easy to understand English.
Requirements
- No programming experience is required. All of the course exercises are conducted online. You don’t need to install anything on your computer!
- Learn SQL in easy to understand English. I promise to make it easy for you to understand.
Description
Welcome to EssentialSQL’s Get Started Learning SQL course! This 7-day course is designed to get you started learning SQL today. I designed it as a seven day course, not because it will take you seven day to complete, but to make it easier for you to digest. To be honest, work it at any pace you find comfortable.
Here is what we are going to do!
On Day 1, you’ll learn the basics of SQL, including SELECT statements and how to write basic queries. You’ll learn how to select columns and use expressions in your queries. You’ll then have the opportunity to practice what you’ve learned with a set of exercises.
On Day 2, you’ll dive deeper into filtering data with the WHERE clause. You’ll learn about comparison and logical operators and how to use the LIKE operator. You’ll get to apply your newfound skills with a set of practice exercises.
Day 3 is all about sorting data with ORDER BY. You’ll learn how to use the ORDER BY clause and how to sort by multiple columns. You’ll then practice sorting data with a set of exercises.
On Day 4, you’ll learn how to manipulate data with INSERT, UPDATE, and DELETE statements. You’ll learn how to add, modify, and remove data from tables, and then you’ll practice these skills with exercises.
Day 5 is all about aggregating data with GROUP BY. You’ll learn how to use the GROUP BY clause and how to use aggregate functions like COUNT, SUM, AVG, MIN, and MAX. You’ll then have the opportunity to practice what you’ve learned with a set of exercises.
On Day 6, you’ll learn about joining tables. You’ll learn about the INNER join, and how to join multiple tables. You’ll then practice what you’ve learned with a set of exercises.
Finally, on Day 7, you’ll learn about subqueries. You’ll learn what they are and how to use them in SELECT statements and WHERE clauses. You’ll then get to practice your skills with a set of exercises.
By the end of this course, you’ll be starting to learn SQL and be able to write basic queries, manipulate data, and use cool techniques like grouping and joining.
Who this course is for:
- Anyone looking to get started learning SQL
- Business Analysts working in Excel and wanting to check out database queries.
- Job candidates that need a crash course on SQL so they can answer some basic interview questions.
- Students that need to quickly learn SQL.
Show less
Course content
9 sections • 13 lectures • 1h 16m total lengthCollapse all sections
Introduction3 lectures • 11min
- Introduction01:32
- Relational Databases and Tables04:08
- What Version of SQL Should I Use?05:03
Day 1 – Write Your First Query1 lecture • 8min
- Learn how to use SELECT08:13
- Using Select #11 question
- Using Select #21 question
- Using Select #31 question
Day 2 – Filter You Query using WHERE1 lecture • 9min
- Filter Data using WHERE09:02
- Using WHERE1 question
- Using Comparison Operators1 question
- Using LIKE1 question
- Using BETWEEN in the WHERE clause1 question
- Using the IN comparison Operator1 question
Day 3 – Ordering Results using ORDER BY1 lecture • 4min
- Sorting Data using ORDER BY04:06
- Using ORDER BY1 question
- Using ORDER BY with multiple fields1 question
- Getting the Top Items in a Query1 question
Day 4 – Manipulating Data with INSERT, UPDATE, and DELETE1 lecture • 6min
- Modifying Data using INSERT, UPDATE, and DELETE05:35
Day 5 – Grouping and Summarizing Query Results1 lecture • 7min
- Using GROUP BY to Summarize Your Results07:17
- Calculate Averages1 question
- Counting Rows1 question
Day 6 – Using INNER JOIN to Combine Data from Multiple Tables1 lecture • 10min
- Using INNER JOIN with Two or More Tables10:24
- Learn to Write a INNER JOIN1 question
- Use a Join and Order the Results1 question
- Joining more than Two Tables1 question
Day 7 – Write Subqueries1 lecture • 7min
- Write A Subquery to Calculate a Value06:45
- Using a Subquery in the SELECT statement1 question
- Using a Subquery in an Expression1 question
Bonus3 lectures • 15min
- Bonus Lecture01:12
- Left and Right Outer Joins – From Join Together Now04:26
- Left and Right Outer Joins – Examples From Join Together Now09:03
