Top 9 Recommended SQL Self-Study Materials! [November 2024]

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

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. VERY IMPORTANT, PLEASE READ! — New MySQL Windows Installation Instructions
14. Installation: Windows Instructions (FIRST FOLLOW THE PREVIOUS WRITTEN LECTURE)
15. VERY IMPORTANT, PLEASE READ! — New MySQL Mac Installation Instructions
16. Installation: Mac Instructions (FIRST FOLLOW THE PREVIOUS WRITTEN LECTURE)
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

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 $123,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 3,000,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. CODING EXERCISES - Browser-based coding
68. Creating a Table - Exercise #1
69. Creating a Table - Exercise #2
70. Creating a Table - Exercise #3
71. Creating a Table - Exercise #4
72. Using databases and tables
73. Using databases and tables - exercise
74. Using databases and tables - solution
75. Using Databases and Tables - Exercise #1
76. Additional notes on using tables
77. Additional notes on using tables
78. Additional notes on using tables - exercise
79. Additional Notes on Using Tables - Exercise #9
80. MySQL constraints
81. PRIMARY KEY constraint
82. PRIMARY KEY Constraint
83. PRIMARY KEY constraint - exercise
84. PRIMARY KEY constraint - solution
85. PRIMARY KEY constraint - Exercise #1
86. PRIMARY KEY constraint - Exercise #2
87. FOREIGN KEY constraint - Part I
88. FOREIGN KEY constraint - Part II
89. FOREIGN KEY constraint - Part II - exercise
90. FOREIGN KEY constraint - Part II - solution
91. FOREIGN KEY constraint - Exercise #1
92. FOREIGN KEY constraint - Exercise #2
93. FOREIGN KEY constraint - Exercise #3
94. UNIQUE Constraint
95. UNIQUE Constraint - exercise
96. UNIQUE constraint - Exercise #1
97. DEFAULT Constraint
98. DEFAULT Constraint - exercise
99. DEFAULT Constraint - solution
100. DEFAULT constraint - Exercise #1
101. NOT NULL Constraint - Part I
102. NOT NULL Constraint - Part I - exercise
103. NOT NULL Constraint - Part I - solution
104. NOT NULL constraint - Exercise #1
105. NOT NULL Constraint - Part II
106. SQL best practices
107. Coding techniques and best practices - Part I
108. Coding techniques and best practices – Part I
109. Coding techniques and best practices - Part II
110. Coding techniques and best practices – Part II
111. Loading the 'employees' database
112. Loading the 'employees' database
113. Loading the 'employees' database
114. SQL SELECT statement
115. SELECT - FROM
116. SELECT - FROM - exercise
117. SELECT - FROM - solution
118. CODING EXERCISES - the 'employees_10' Database
119. SELECT - FROM - Exercise #1
120. SELECT - FROM - Exercise #2
121. SELECT - FROM - Exercise #3
122. SELECT - FROM - Exercise #4
123. WHERE
124. WHERE - exercise
125. WHERE - solution
126. SELECT - WHERE - Exercise #1
127. AND
128. AND - exercise
129. AND - solution
130. SELECT - AND - Exercise #1
131. OR
132. OR - exercise
133. OR - solution
134. SELECT - OR - Exercise #1
135. Operator precedence
136. Operator precedence - exercise
137. Operator precedence - solution
138. SELECT - Operator Precedence - Exercise #1
139. IN - NOT IN
140. IN - NOT IN - exercise 1
141. IN - NOT IN - solution 1
142. IN - NOT IN - exercise 2
143. IN - NOT IN - solution 2
144. SELECT - IN - NOT IN - Exercise #1
145. SELECT - IN - NOT IN - Exercise #2
146. LIKE - NOT LIKE
147. LIKE - NOT LIKE - exercise
148. LIKE - NOT LIKE - solution
149. SELECT - LIKE - NOT LIKE - Exercise #1
150. SELECT - LIKE - NOT LIKE - Exercise #2
151. SELECT - LIKE - NOT LIKE - Exercise #3
152. Wildcard characters
153. Wildcard characters - exercise
154. Wildcard characters - solution
155. Wildcard characters - Exercise #1
156. Wildcard characters - Exercise #2
157. BETWEEN - AND
158. BETWEEN - AND - exercise
159. BETWEEN - AND- solution
160. SELECT - BETWEEN - AND - Exercise #1
161. SELECT - BETWEEN - AND - Exercise #2
162. SELECT - BETWEEN - AND - Exercise #3
163. IS NOT NULL - IS NULL
164. IS NOT NULL - IS NULL - exercise
165. IS NOT NULL - IS NULL - solution
166. SELECT - IS NOT NULL - IS NULL - Exercise #1
167. Other comparison operators
168. Other comparison operators - exercise
169. Other comparison operators - solution
170. SELECT - Other comparison operators - Exercise #1
171. SELECT - Other comparison operators - Exercise #2
172. SELECT DISTINCT
173. SELECT DISTINCT - exercise
174. SELECT DISTINCT - solution
175. SELECT DISTINCT - Exercise #1
176. Introduction to aggregate functions
177. Introduction to aggregate functions - exercise
178. Introduction to aggregate functions - solution
179. Introduction to aggregate functions - Exercise #1
180. Introduction to aggregate functions - Exercise #2
181. ORDER BY
182. ORDER BY - exercise
183. ORDER BY - solution
184. SELECT - ORDER BY - Exercise #1
185. GROUP BY
186. Using Aliases (AS)
187. Using Aliases (AS) - exercise
188. Using Aliases (AS) - solution
189. SELECT - Using Aliases (AS) - Exercise #1
190. HAVING
191. HAVING - exercise
192. HAVING - solution
193. SELECT - HAVING - Exercise #1
194. WHERE vs HAVING- Part I
195. WHERE vs HAVING- Part II
196. WHERE vs HAVING - Part II - exercise
197. WHERE vs HAVING - Part II - solution
198. SELECT - WHERE vs HAVING - Exercise #1
199. LIMIT
200. LIMIT - exercise

(Added a Comprehensive Assignment on Analyzing Sales data)

(Source Code Included for ALL Lectures)

Get ready to acquire some seriously marketable programming skills! You can't consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company's biggest asset is their data. All databases require the language SQL to store and retrieve data. Salaries for junior level SQL Developers are upwards of $70,000 - $90,000 dollars a year! The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we're going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you've completed the course (in 2 months), you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world! This course will prepare you to be job-ready in just 1 month of study and practice.

All exercises and solutions are in the lectures. In several lectures I ask students to pause the video and complete the assignment before resuming to watch my solution. MAKE SURE YOU WORK OUT THE PROBLEMS ON YOUR OWN BEFORE MOVING ON TO MY SOLUTION!!

With over 62,000 enrolled students and a 4.5 star-rating, this is a Udemy best-selling course.

Do you have no prior experience in SQL development? This course is perfect for you. Don't take it from me, take it from actual students that took this course:

"I am a beginner and the way this course starts is perfect for the person who has no introduction of SQL or Oracle."

Do you have prior experience, but need a refresher or to fine-tune your skills? This is the course for you. Again, I'll let my students do the talking:

"I had a good base of knowledge from my last employment. This course is constantly proving useful to supercharge my actual knowledge base. Very good one!"

Have you taken a SQL course before, but felt confused on certain topics or not completely satisfied in your abilities? A lot of my students had shared similar concerns:

"I had previously taken a college course about databases and SQL, but these ten hours of content were more clear and useful than the course and textbook."

Topics covered in this course :

• Basics of Tables

• SELECT and WHERE Clause

• WHERE, AND & OR with Operators

• BETWEEN, IN and NULL

• Single Table Queries

• Single Row Functions

• Grouping Functions

• GROUP BY and HAVING Clause

• Joins

• Inner and Outer Joins

• EXISTS & NOT EXIST Operators

• Creating Your Own Tables

• Using ALTER

• Creating Tables with SELECT & UPDATE Data

• DELETE, TRUNCATE, and DROP Commands

• System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)

• Views and Other Objects and Commands (Newly Added)
  

1. Database Basics
2. Oracle Database Introduction & Basics of Tables
3. Creating the Workspace in Oracle
4. IMPORTANT: Prepare the Sample Data
5. Dedicated TA Support
6. Join our Online Community (Discord)
7. How to Proceed in This Course
8. Single Table Queries (Exercises & Solutions in the Lectures)
9. Oracle Exams and Certification Information
10. Retrieving Data Using the SELECT Clause
11. Using the WHERE Clause in a Query
12. Important Information from Instructor
13. Using Operators in the WHERE Clause
14. Some Inspiration
15. Combining WHERE, AND & OR with Operators
16. Query Filtering Continued BETWEEN, IN and NULL
17. What Will Make you Grow as a Software Developer
18. Query Filtering Conditions & Operator Precedence
19. Ordering, Concatenating And Aliasing Query Results
20. Assignment 1: Practice with Single Table Queries
21. Single Row Functions (Exercises and Solutions In the Lectures)
22. Single Row Functions (SRF) & Using The Dual Table
23. Using Functions in WHERE And Character Based SRFs
24. Numeric and Date Data type SRFs
25. Conversion SRFs and Date Formatting
26. Some More Date Functions
27. Concluding SRFs & NULL / NULLIF Functions
28. Assignment 2: Practice with Single Row Functions
29. Grouping Functions (Exercises and Solutions In the Lectures)
30. Grouping Functions MIN, MAX, AVG, COUNT etc.
31. GROUP BY Clause & HAVING Clause
32. More Practice With The GROUP BY Clause
33. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)
34. SELECT within SELECT (Subqueries)
35. Relating Tables Together Using JOINs
36. Joins Continued INNER & OUTER Joins
37. Career Advice
38. Correlated Subqueries with EXISTS & NOT EXIST operators
39. SELF JOIN
40. CROSS JOIN, NATURAL JOIN and the USING CLAUSE
41. EQUIJOIN and NON-EQUIJOINs
42. CASE Statements
43. Analytical Functions using OVER and PARTITION with ORDER BY
44. OVER Clause with PARTITION BY
45. Compute Running Totals with Ordering and Partitioning
46. Unbounded Preceding Order in Over Clause
47. Slicing Windows and Filtering with Analytic Functions
48. Rank, Dense_rank, Lead, and Lag Functions
49. Assignment: Application of Window Functions and SELF JOIN
50. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)
51. Creating Your Own Tables & Design Considerations
52. Inserting Data Into Our Table
53. Create Table With a Primary Key Constraint
54. INSERT ALL for Multi-table & Conditional Inserts
55. Using ALTER to modify the table structure
56. Create Table with SELECT + UPDATE Data
57. MERGE Statement in Oracle
58. Primary and Foreign Keys
59. Sequence Statements in Oracle
60. DELETE, TRUNCATE, and DROP Commands
61. Working With Database Indexes
62. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)
63. Views and Other Objects and Commands (Newly Added)
64. SQL could be tricky, check this out!
65. Granting and Revoking Privileges
66. ADDITIONAL TOPICS + REVIEW for EXAM 170-071
67. OFFSET and FETCH
68. ERD Diagrams
69. Commit, Rollback, and Savepoint
70. Large Objects and Interval Data Types
71. Using Cascade Constraints and On Delete Cascade
72. UNUSED Columns
73. External Tables
74. SQL Plus and Substitution Variables
75. Exam Question Walkthrough Videos + 2 Exams
76. QA 1- DML, DDL, and Transaction Control
77. QA 2- Fetch and Substitution Variables
78. QA 3 - Conversion Functions, TO_CHAR, NVL, and TO_DATE
79. Practice Test 1
80. Practice Test 2
81. APPENDIX - Installing Oracle on Windows
82. Install Oracle Database 19c in Windows
83. Install Oracle SQL Developer in Windows
84. Course Extras!
85. Bonus Lecture