Top 9 Recommended SQL Self-Study Materials! [December 2023]

This course was just completely redone and rebuilt from the ground up, with over 325 brand new videos recorded. The course now uses MySQL 8.x and covers new topics including: Window Functions, Views, and SQL modes.

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.  

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases.  

In this course, you will:

• Learn the ins and outs of SQL syntax

• Generate reports using sales and user data

• Analyze data using Aggregate Functions

• Run complex queries using MySQL logical operators and string functions

• Write all the common SQL joins

• Work with large datasets containing thousands of entries

• Design and implement complex database schemas

• Learn to navigate the treacherous world of storing dates and times

• Clone the database structure of a photo sharing social network

• Work with MySQL 8.x Window Functions: RANK, LEAD, LAG, NTILE, etc.

• Create MySQL database views and virtual tables

This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning. Apply what you’re learning to real-world challenges such as finding a website’s power users, calculating your top students, identifying bots on a site, or determining which hashtags generate the most traction on a site. Along the way, you’ll also get to meet my pet cat, Blue! (She’s really cute.)

Why Learn MySQL

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.

Why This Course Is Different  

This isn’t going to be a course where you watch me code for 20 hours; it’s a course with ample opportunity for you to get your hands dirty writing code (even within the first 7 minutes of the course).

My teaching experience is rooted in the classroom. I’ve spent years teaching programming, web development, and databases to my in-person bootcamp students. This course combines the best of my offline courses with the convenience of learning online, in a setting that’s best for you.   

Upon completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.

So let’s do this! Enroll today and start learning SQL!

1. Introduction & 5 Minutes of SQL
2. This Course Was Just Updated!
3. Join The Community!
4. Course Intro
5. About Me
6. Getting The Course Code
7. First 5 Minutes of SQL
8. Getting Started & Installation
9. Section Introduction
10. What Is A Database?
11. SQL vs. MySQL
12. Installation: START HERE!
13. IMPORTANT NOTE: Windows Installation Instructions
14. Installation: Windows Instructions
15. VERY IMPORTANT: Mac Installation Notes
16. Installation: Mac Instructions
17. Creating Databases & Tables
18. Section Introduction
19. Showing Databases
20. CODE: Showing Databases
21. Creating Databases
22. CODE: Creating Databases
23. Dropping and Using Databases
24. CODE: Dropping and Using Databases
25. Introducing Tables
26. Data Types: The Basics
27. Basic Datatypes Challenge
28. CODE: Basic Datatypes Challenge
29. Creating Tables
30. CODE: Creating Tables
31. How Do We Know It Worked?
32. CODE: How Do We Know It Worked?
33. Dropping Tables
34. CODE: Dropping Tables
35. Tables Basics Activity
36. SOLUTION: Tables Basics Activity
37. MySQL Comments
38. Inserting Data
39. Section Introduction
40. INSERT: The Basics
41. CODE: INSERT: The Basics
42. A Quick Preview of SELECT
43. CODE: A Quick Preview of SELECT
44. Multi-inserts
45. CODE: Multi-inserts
46. INSERT Exercise
47. SOLUTION: INSERT Exercise
48. Working With NOT NULL
49. CODE: Working With NOT NULL
50. Sidenote: Quotes In MySQL
51. Adding DEFAULT Values
52. CODE: Adding DEFAULT Values
53. Introducing Primary Keys
54. CODE: Introducing Primary Keys
55. Working With AUTO_INCREMENT
56. CODE: Working With AUTO_INCREMENT
57. Create Table/ Insert Exercise
58. SOLUTION: Insert Exercise
59. CRUD Basics
60. Section Introduction
61. Introducing CRUD
62. Getting Our New "Dataset"
63. CODE
64. Officially Introducing SELECT
65. CODE
66. The WHERE clause
67. CODE
68. Rapid Fire Exercises
69. Rapid Fire Exercises SOLUTION
70. SOLUTION CODE
71. Aliases
72. CODE
73. Using UPDATE
74. CODE
75. A Quick Rule Of Thumb
76. UPDATE Exercise
77. UPDATE Exercise SOLUTION
78. SOLUTION CODE
79. Introducing DELETE
80. CODE
81. DELETE Exercise
82. DELETE Exercise SOLUTION
83. SOLUTION CODE
84. CRUD Challenge
85. Section Introduction
86. Introducing the CRUD Challenge
87. CRUD Challenge Solution: Creating
88. SOLUTION CODE
89. CRUD Challenge Solution: Reading
90. SOLUTION CODE
91. CRUD Challenge Solution: Updating
92. SOLUTION CODE
93. CRUD Challenge Solution: Deleting
94. SOLUTION CODE
95. String Functions
96. Section Introduction
97. The World Of String Functions
98. Loading Our Books Data
99. CODE
100. CONCAT
101. CODE
102. SUBSTRING
103. CODE
104. Combining String Functions
105. CODE
106. Sidenote: SQL Formatting
107. REPLACE
108. CODE
109. REVERSE
110. CODE
111. CHAR_LENGTH
112. CODE
113. UPPER & LOWER
114. CODE
115. Other String Functions
116. CODE
117. String Functions Exercise
118. String Functions Exerise SOLUTION
119. SOLUTION CODE
120. Refining Selections
121. Section Introduction
122. Adding Some New Books
123. CODE
124. DISTINCT
125. CODE
126. ORDER BY
127. CODE
128. More On ORDER BY
129. CODE
130. LIMIT
131. CODE
132. LIKE
133. CODE
134. Escaping Wildcards
135. CODE
136. Refining Selections Exercise
137. Refining Selections Exercise SOLUTION
138. SOLUTION CODE
139. Aggregate Functions
140. Section Introduction
141. Count Basics
142. CODE
143. GROUP BY
144. CODE
145. MIN and MAX Basics
146. CODE
147. Subqueries
148. CODE
149. Grouping By Multiple Columns
150. CODE
151. MIN and MAX With GROUP BY
152. CODE
153. SUM
154. CODE
155. AVG
156. CODE
157. Aggregate Functions Docs
158. Agg Functions Exercise
159. Agg Functions Exercise SOLUTION
160. SOLUTION CODE
161. Revisiting Data Types
162. Section Introduction
163. Surveying Other Data Types
164. CHAR vs. VARCHAR
165. INT, TINYINT, BIGINT, etc.
166. DECIMAL
167. FLOAT & DOUBLE
168. DATE and TIME
169. Working With Dates
170. CODE
171. CURDATE, CURTIME, & NOW
172. CODE
173. Date Functions
174. CODE
175. Time Functions
176. CODE
177. Formatting Dates
178. CODE
179. Date Math
180. TIMESTAMPS
181. DEFAULT & ON UPDATE TIMESTAMPS
182. CODE
183. Data Types Exercise
184. Data Types Exercise SOLUTION
185. SOLUTION CODE
186. Comparison & Logical Operators
187. Section Introduction
188. Not Equal
189. CODE
190. NOT LIKE
191. CODE
192. Greater Than
193. CODE
194. Less Than Or Equal To
195. CODE
196. Logical AND
197. CODE
198. Logical OR
199. CODE
200. Between

Learn how to use SQL quickly and effectively with this course!

You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!

In this course you will learn everything you need to become a SQL Pro! Including:

• Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools

• Learn he basics of SQL syntax

• Analyzing data using aggregate functions with GROUP BY commands

• Running advanced queries with string operations and comparison operations

• Learn to use logical operators to add logic flow to your SQL queries

• Learn common SQL JOIN commands

• Learn to create tables and databases with constraints on data entries

• Learn to use Python to further advanced your SQL skills

• and much, much more!

This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.

I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.

SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!

I'll see you inside the course!

Check out the free preview videos for more information!

1. Course Introduction
2. Welcome Message
3. Introduction
4. Course Curriculum Overview
5. Overview of Databases
6. Course FAQs
7. Windows Installation - PostGreSQL and PgAdmin with Database Setup
8. MacOS Installation - PostgreSQL and PgAdmin with First Query
9. pgAdmin Overview
10. SQL Statement Fundamentals
11. Overview of Challenges!
12. SQL Cheat Sheet
13. SQL Statement Fundamentals
14. SELECT Statement
15. Challenge: SELECT
16. SELECT DISTINCT
17. Challenge: SELECT DISTINCT
18. COUNT
19. SELECT WHERE - Part One
20. SELECT WHERE - Part Two
21. Challenge: SELECT WHERE
22. ORDER BY
23. LIMIT
24. Challenge: ORDER BY
25. BETWEEN
26. IN
27. LIKE and ILIKE
28. General Challenge 1
29. GROUP BY Statements
30. Introduction to GROUP BY
31. Aggregation Functions
32. GROUP BY - Part One
33. GROUP BY - Part Two
34. GROUP BY - Challenge
35. HAVING
36. HAVING - Challenge Tasks
37. Assessment Test 1
38. Overview of Assessment Test 1
39. Assessment Test 1
40. Solutions to Assessment Test 1
41. JOINS
42. Overview of JOINS
43. Introduction to JOINs
44. AS Statement
45. Inner Joins
46. Full Outer Joins
47. Left Outer Join
48. Right Joins
49. UNION
50. JOIN Challenge Tasks
51. Advanced SQL Commands
52. Overview of Advanced SQL Commands
53. Timestamps and Extract - Part One
54. Timestamps and Extract - Part Two
55. Quick Note on TO_CHAR
56. Timestamps and Extract - Challenge Tasks
57. Mathematical Functions and Operators
58. String Functions and Operators
59. SubQuery
60. Self-Join
61. Assessment Test 2
62. READ ME FIRST PLEASE
63. Setting up New Database for Assessment Exercises
64. Assessment Test 2
65. Solutions to Assessment Test 2
66. Creating Databases and Tables
67. Introduction to Section
68. Data Types
69. Primary Keys and Foreign Keys
70. Constraints
71. CREATE Table
72. INSERT
73. UPDATE
74. DELETE
75. ALTER Table
76. DROP Table
77. CHECK Constraint
78. Assessment Test 3
79. Assessment Test 3
80. Solutions to Assessment Test 3
81. Conditional Expressions and Procedures
82. Conditional Expressions and Procedures Introduction
83. CASE
84. CASE - Challenge Task
85. COALESCE
86. CAST
87. NULLIF
88. Views
89. Import and Export
90. Extra: PostGreSQL with Python
91. Overview of Python and PostgreSQL
92. Psycopg2 Example Usage
93. Psycopg2 Resources
94. BONUS SECTION: THANK YOU!
95. Bonus Lecture

Learn SQL with the world’s best SQL course in just 15 days!

1 hour per day, for just 15 days and you will be fluent in SQL!

That’s the only course you need to completely master SQL.

You will be guided step-by-step from beginner to absolute expert in SQL.

Why is this the best course you can take?

1. The most comprehensive course that teaches you everthing from beginner to expert

2. Much more challenges & hands-on coding exercises than other courses

3. Much more real-life advanced topics that other courses don’t cover

By the end of this guided experience you will be so fluent in SQL to get a job and work professionally and with a lot of confidence with SQL!

This is the most comprehensive & most modern course you can find on SQL.

Here is why:

• Most comprehenisve course with 14 hours video lectures and most topics

• Master SQL by working on real-life challenges

• Learn PostgreSQL – the most modern SQL system & easy to transfer to all other SQL dialects

• We will set up two modern databases and learn everything with realistic data, so you can do everything hands-on!

• Learn from a real expert - crystal clear & straight-forward

• Understand everything step by step from the absolute basics to the advanced topics

• Learn the practical to upskill your career or find a job with SQL

We cover every single important topic you will need including the advanced topics other courses do not cover!

Including...

• GROUP BY

• JOINs

• Functions

• UNIONs

• Data manipulation & Data Definition

• Views

• Window functions

• Grouping sets

• Rollups

• Transactions

• Subqueries

• Query optimization

• Indexes and much more!

Plus, tons of practical challenges and 2 complete course projects and much more challenges than you can find anywhere else!

This course will take you all the way from beginner to being able to upskill your career and make you ready to get a job with SQL!

Check out the free video previews and enroll now!

See you inside the course!

1. Day 1 - Getting started with SQL!
2. How to get the most out of the course
3. Why learning SQL?
4. Let the Joruney Begin!
5. What is a database?
6. Databases
7. Different dialects of SQL
8. Dialects of SQL
9. Installing PostgreSQL & pgAdmin (Windows)
10. Installing PostgreSQL & pgAdmin (MacOS)
11. Setting up the database
12. Common problems: Set binary paths
13. Common problems: Slow performance
14. The Project
15. SELECT
16. Challenge: SELECT
17. Solution: SELECT
18. ORDER BY
19. Challenge: ORDER BY
20. Solution: ORDER BY
21. SELECT DISTINCT
22. Challenge: SELECT DISTINCT
23. Solution: SELECT DISTINCT
24. LIMIT
25. COUNT()
26. Today's challenges
27. Today's summary
28. Day 2 - Basics: Filtering
29. WHERE
30. Challenge: WHERE
31. Solution: WHERE
32. WHERE operators
33. Challenge: WHERE operators
34. Solution: WHERE operators
35. WHERE with AND/OR
36. Challenge: WHERE with AND/OR
37. Solution: WHERE with AND/OR
38. Quick note on time zones
39. BETWEEN
40. Challenge: BETWEEN
41. Solution: BETWEEN
42. IN
43. Challenge: IN
44. Solution: IN
45. LIKE
46. Challenge: LIKE
47. Solution: LIKE
48. Comments & Aliases
49. Today's summary
50. Today's challenges
51. Day 3 - Basics: Grouping
52. Today's plan
53. Aggregate functions
54. Challenge: Aggregate function
55. GROUP BY
56. Challenge: GROUP BY
57. Solution: GROUP BY
58. GROUP BY multiple columns
59. Challenge: GROUP BY multiple columns
60. Solution: GROUP BY multiple columns
61. HAVING
62. Challenge: HAVING
63. Solution: HAVING
64. Introducing the second project
65. Note for Mac users
66. Important: Problems & solutions of setting up the database
67. Today's summary
68. Day 4 - Intermediate: Functions
69. Today's plan
70. LENGTH, LOWER & UPPER
71. Challenge: LENGTH, LOWER & UPPER
72. Solution: LENGTH, LOWER & UPPER
73. LEFT & RIGHT
74. Challenge: LEFT & RIGHT
75. Solution: LEFT & RIGHT
76. Concatenate
77. Challenge: Concatenate
78. Solution: Concatenate
79. POSITION
80. Challenge: POSITION
81. Solution: POSITION
82. SUBSTRING
83. Challenge: SUBSTRING
84. Solution: SUBSTRING
85. EXTRACT
86. Challenge: EXTRACT
87. Solution: EXTRACT
88. TO_CHAR
89. Challenge: TO_CHAR
90. Solution: TO_CHAR
91. Intervals & Timestamps
92. Challenge: Intervals & Timestamps
93. Solution: Intervals & Timestamps
94. Today's slides
95. Day 5 - Intermediate: Conditional Expressions
96. Mathematical functions and operators
97. Challenge: Mathematical functions and operators
98. Solution: Mathematical functions and operators
99. CASE WHEN - Theory
100. CASE WHEN - Hands-on
101. 3 Challenge: CASE WHEN
102. Solutions
103. Solution: CASE WHEN
104. CASE WHEN & SUM
105. COALESCE
106. CAST
107. Challenge: CAST & COALESCE
108. Solution: CAST & COALESCE
109. REPLACE
110. Today's slides
111. Day 6 - Intermediate: Joins
112. What are joins?
113. INNER JOIN - Theory
114. INNER JOIN - Practice
115. Challenge: INNER JOIN
116. Solution: INNER JOIN
117. FULL OUTER JOIN
118. JOIN & WHERE
119. LEFT OUTER JOIN
120. Challenge: LEFT OUTER JOIN
121. Solution: LEFT OUTER JOIN
122. RIGHT OUTER JOIN
123. Challenge: Joins
124. Solution: Joins
125. Joins on multiple conditions
126. Solution: Joins on multiple conditions
127. Joining multiple tables
128. Joining multiple tables - Practice
129. Challenge: Joining multiple tables
130. Solution: Joining multiple tables
131. More challenges
132. Solutions
133. Today's slides
134. Day 7 - Advanced: UNION & Subqueries
135. UNION
136. UNION - Practice
137. Subqueries in WHERE
138. Challenge: Subqueries in WHERE
139. Solution: Subqueries in WHERE
140. More challenges: Subqueries in WHERE
141. Solution: More challenges
142. Subqueries in FROM
143. Challenge: Subqueries in FROM
144. Solution: Subqueries in FROM
145. Subqueries in SELECT
146. Challenge: Subqueries in SELECT
147. Solution: Subqueries in SELECT
148. Correlated Subqueries in WHERE
149. Challenge: Correlated subqueries in WHERE
150. Solution: Correlated subqueries in WHERE
151. Correlated Subquery in SELECT
152. More challenges: Correlated subqueres
153. Solution: More challenges
154. Today's slides
155. Day 8 - Advanced: Course project
156. Project Introduction
157. Challenges
158. Solutions
159. Solution 1
160. Solution 2
161. Solution 3
162. Solution 4
163. Solution 5
164. Solution 6
165. Solution 7
166. Solution 8
167. Solution 9
168. Solution 10
169. Solution 11
170. Solution 12
171. Solution 13
172. Solution 14
173. Day 9 - Advanced: Managing tables & databases
174. Managing databases & tables
175. CREATE DATABASE
176. CREATE & DROP DATABASE
177. Data Types
178. Data Types
179. Constraints
180. Constraints
181. Primary Key & Foreign Key
182. Primary & Foreign Key
183. CREATE TABLE
184. CREATE TABLE
185. INSERT
186. INSERT
187. ALTER TABLE
188. Challenge: ALTER TABLE
189. Solution: ALTER TABLE
190. TRUNCATE & DROP TABLE
191. CHECK
192. Challenge: CHECK
193. Solution: CHECK
194. Today's slides
195. Day 10 - Advanced: Views & Data Manipulation
196. UPDATE
197. Challenge: UPDATE
198. Solution: UPDATE
199. DELETE
200. Challenge: DELETE

How important is database management in the age of big data and analytics?

It is really important.   

How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.  

How many people have these skills?

Not enough.  

This is why now is the time to learn SQL and gain a competitive advantage in the job market. Remember, the average salary of a SQL developer is $103,400! That’s a lucrative career.   

How come?   

Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making.   

Worried that you have no previous experience? 

Not an issue. We will start from the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.   

Why take this course in particular? Isn’t it like the rest of the SQL courses out there?  

We would like to think it isn’t. Our team worked hard to create a course that is:

 

• Easy to understand
  
   

• Time efficient and concise
  
   

• Shows how SQL can be crucial for data analytics and business intelligence   

• Comprehensive – it covers several topics not shown in other SQL courses   

• Practical – it teaches you how to work with a real-life database   

• Corresponds to professional best practices
  
   

• Taught in MySQL – The most popular SQL database management system
  
   

• Contains plenty of downloadable exercises, course notes, and quiz questions   

Some of these aspects have been covered in other courses. Others haven’t. However, no one provides such a variety of topics in one place.    

We firmly believe this course is the best training material out there. It is a truly interactive experience preparing you for a real-life working environment.   

We love teaching   

So far, over 1,750,000 students have taken our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the most engaging content for you, our students. Our mission is to help you bridge the gap between theoretical knowledge taught at school and in universities and the practical application required at the workplace.   

So, why do you need to enroll in this course and learn SQL?

 

1. Salary/Income. As we pointed out earlier, learning SQL is a great opportunity. There is a significant surge in demand for skills revolving around database management, database administration, and business analysis relying on data. Companies will pay top dollars for specialists who have such know-how
   
    

2. Profession of the future. In the years to come, data will only grow in importance and size. Therefore, it is great to pick up a skill that will likely increase in demand over the years to come
   
    

3. Analytical reasoning. Programming languages are a great way to train your mind. Furthermore, understanding a business task and looking for its solution through writing code can be really interesting and stimulating once you become familiar with the basics  

What about certificates? Do you provide a certificate?

Upon completion of the course, you will be able to download a certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.  

Sounds awesome, right?   

So, what are you waiting for? Click the “Buy now” button, and let’s begin this journey together!

 

1. Introduction to databases, SQL, and MySQL
2. What does the course cover?
3. Why SQL?
4. Why SQL?
5. Why MySQL?
6. Why MySQL?
7. Introduction to databases
8. Introduction to databases
9. SQL theory
10. SQL as a declarative language
11. SQL as a declarative language
12. Data definition language (DDL)
13. Data definition language (DDL)
14. SQL keywords
15. SQL keywords
16. Data manipulation language (DML)
17. Data manipulation language (DML)
18. Data control language (DCL)
19. Data control language (DCL)
20. Transaction control language (TCL)
21. Transaction control language (TCL)
22. Basic database terminology
23. Relational database essentials
24. Relational database essentials
25. Databases vs spreadsheets
26. Databases vs spreadsheets
27. Database terminology
28. Database terminology
29. Relational schemas - Primary key
30. Relational schemas - Primary key
31. Relational schemas - Foreign key
32. Relational schemas - Foreign key
33. Relational schemas - Unique key and null values
34. Relational Schemas - Unique key
35. Relationships
36. Relational Schemas – Relationships
37. Installing MySQL and getting acquainted with the interface
38. Installing MySQL
39. Additional note – Installing – Visual C
40. Installing MySQL on macOS and Unix systems
41. The Client-Server Model
42. Setting up a connection
43. Read me!!!
44. New Authentication Plugin - Creating a New User
45. Introduction to the MySQL interface
46. First steps in SQL
47. Creating a Database - Part I
48. SQL files
49. Creating a Database - Part I - exercise
50. Creating a Database - Part I - solution
51. Creating a Database - Part II
52. Creating a Database - Part II - exercise
53. Creating a Database - Part II - solution
54. Introduction to data types
55. Introduction to data types
56. String data types
57. String data types
58. Integers
59. Integers
60. Fixed and floating-point data types
61. Fixed and floating-point data types
62. Other useful data types
63. Other useful data types
64. Creating a table
65. Creating a table - exercise
66. Creating a table - solution
67. Using databases and tables
68. Using databases and tables - exercise
69. Using databases and tables - solution
70. Additional notes on using tables
71. Additional notes on using tables
72. Additional notes on using tables - exercise
73. MySQL constraints
74. PRIMARY KEY constraint
75. PRIMARY KEY Constraint
76. PRIMARY KEY constraint - exercise
77. PRIMARY KEY constraint - solution
78. FOREIGN KEY constraint - Part I
79. FOREIGN KEY constraint - Part II
80. FOREIGN KEY constraint - Part II - exercise
81. FOREIGN KEY constraint - Part II - solution
82. UNIQUE Constraint
83. UNIQUE Constraint - exercise
84. DEFAULT Constraint
85. DEFAULT Constraint - exercise
86. DEFAULT Constraint - solution
87. NOT NULL Constraint - Part I
88. NOT NULL Constraint - Part I - exercise
89. NOT NULL Constraint - Part I - solution
90. NOT NULL Constraint - Part II
91. SQL best practices
92. Coding techniques and best practices - Part I
93. Coding techniques and best practices – Part I
94. Coding techniques and best practices - Part II
95. Coding techniques and best practices – Part II
96. Loading the 'employees' database
97. Loading the 'employees' database
98. Loading the 'employees' database
99. SQL SELECT statement
100. SELECT - FROM
101. SELECT - FROM - exercise
102. SELECT - FROM - solution
103. WHERE
104. WHERE - exercise
105. WHERE - solution
106. AND
107. AND - exercise
108. AND - solution
109. OR
110. OR - exercise
111. OR - solution
112. Operator precedence
113. Operator precedence - exercise
114. Operator precedence - solution
115. IN - NOT IN
116. IN - NOT IN - exercise 1
117. IN - NOT IN - solution 1
118. IN - NOT IN - exercise 2
119. IN - NOT IN - solution 2
120. LIKE - NOT LIKE
121. LIKE - NOT LIKE - exercise
122. LIKE - NOT LIKE - solution
123. Wildcard characters
124. Wildcard characters - exercise
125. Wildcard characters - solution
126. BETWEEN - AND
127. BETWEEN - AND - exercise
128. BETWEEN - AND- solution
129. IS NOT NULL - IS NULL
130. IS NOT NULL - IS NULL - exercise
131. IS NOT NULL - IS NULL - solution
132. Other comparison operators
133. Other comparison operators - exercise
134. Other comparison operators - solution
135. SELECT DISTINCT
136. SELECT DISTINCT - exercise
137. SELECT DISTINCT - solution
138. Introduction to aggregate functions
139. Introduction to aggregate functions - exercise
140. Introduction to aggregate functions - solution
141. ORDER BY
142. ORDER BY - exercise
143. ORDER BY - solution
144. GROUP BY
145. Using Aliases (AS)
146. Using Aliases (AS) - exercise
147. Using Aliases (AS) - solution
148. HAVING
149. HAVING - exercise
150. HAVING - solution
151. WHERE vs HAVING- Part I
152. WHERE vs HAVING- Part II
153. WHERE vs HAVING - Part II - exercise
154. WHERE vs HAVING - Part II - solution
155. LIMIT
156. LIMIT - exercise
157. LIMIT - solution
158. SQL INSERT statement
159. The INSERT statement - Part I
160. The INSERT statement - Part II
161. The INSERT statement - exercise 1
162. The INSERT statement - solution 1
163. The INSERT statement - exercise 2
164. The INSERT statement - solution 2
165. Inserting data INTO a new table
166. Inserting Data INTO a New Table - exercise
167. Inserting Data INTO a New Table - solution
168. SQL UPDATE Statement
169. TCL's COMMIT and ROLLBACK
170. The UPDATE Statement - Part I
171. ROLLBACK; ARTICLE
172. The UPDATE Statement - Part II
173. The UPDATE Statement – Part II - exercise
174. The UPDATE Statement – Part II - solution
175. SQL DELETE Statement
176. The DELETE Statement - Part I
177. The DELETE Statement - Part II
178. The DELETE Statement – Part II - exercise
179. The DELETE Statement – Part II - solution
180. DROP vs TRUNCATE vs DELETE
181. DROP vs TRUNCATE vs DELETE
182. MySQL - Aggregate functions
183. COUNT()
184. COUNT() - exercise
185. COUNT() - solution
186. SUM()
187. SUM() - exercise
188. SUM() - solution
189. MIN() and MAX()
190. MIN() and MAX() - exercise
191. MIN() and MAX() - solution
192. AVG()
193. AVG() - exercise
194. AVG() - solution
195. ROUND()
196. ROUND() - exercise
197. ROUND() - solution
198. COALESCE() - Preamble
199. IFNULL() and COALESCE()
200. Another Example of Using COALESCE()

SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations.

 In this course you'll learn the core concepts of the SQL programming language. You'll learn how to use SQL to store, query, and manipulate data. 
Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. 

We'll then show you the basics of creating tables and selecting data in various different ways.  
You'll learn important concepts associated with relational databases. You will run SQL commands to create database tables and define data element types..

 By the end of this course you should have a good understanding of the SQL programming language. 

1. Introduction
2. Welcome
3. Introduction
4. Course files
5. DB Browser
6. Database and SQL
7. Data From Database
8. Ask for data with SELECT
9. Narrow down a query with WHERE
10. Add more criteria to a statement and limit responses
11. Organize responses with ORDER BY
12. JOIN types
13. Combine results
14. Data Types, Math, and Useful Functions
15. Data types and math in SQL
16. Compound Select
17. Transform data
18. Adding Data & Modify
19. Conclusion
20. Conclusion