4.59 (24661 reviews)
☑ Become an expert in SQL
☑ Learn how to code in SQL
☑ Boost your resume by learning an in-demand skill
☑ Create, design, and operate with SQL databases
☑ Start using MySQL – the #1 Database Management System
☑ Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
☑ Adopt professionally tested SQL best practices
☑ Gain theoretical insights about relational databases
☑ Work with a sophisticated real-life database throughout the course
☑ Get maximum preparation for real-life database management
☑ Add data analytical tools to your skillset
☑ Develop business intuition while solving tasks with big data
☑ Study relational database management theory that you will need in your workplace every day
☑ Learn how to create a database from scratch
☑ The ability to take control of your dataset – insert, update, and delete records from your database
☑ Be confident while working with constraints and relating data tables
☑ Become a proficient MySQL Workbench user
☑ Acquire top-notch coding techniques and best practices
☑ Know how to answer specific business questions by using SQL’s aggregate functions
☑ Handle complex SQL joins with ease
☑ Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
☑ Merge coding skills and business acumen to solve complex analytical problems
☑ Become a proficient SQL user by writing flawless and efficient queries
☑ Tons of exercises that will solidify your knowledge
☑ The freedom to query anything you like from a database
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 $92,000! 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 210,000 students have enrolled in our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the best 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?
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
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
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 “Take this course” button, and let’s begin this journey together!
Introduction to databases, SQL, and MySQL
What does the course cover?
Why SQL?
Why SQL?
Why MySQL?
Why MySQL?
Introduction to databases
Introduction to databases
SQL theory
SQL as a declarative language
SQL as a declarative language
Data definition language (DDL)
Data definition language (DDL)
SQL keywords
SQL keywords
Data manipulation language (DML)
Data manipulation language (DML)
Data control language (DCL)
Data control language (DCL)
Transaction control language (TCL)
Transaction control language (TCL)
Basic database terminology
Relational database essentials
Relational database essentials
Databases vs spreadsheets
Databases vs spreadsheets
Database terminology
Database terminology
Relational schemas - Primary key
Relational schemas - Primary key
Relational schemas - Foreign key
Relational schemas - Foreign key
Relational schemas - Unique key and null values
Relational Schemas - Unique key
Relationships
Relational Schemas – Relationships
Installing MySQL and getting acquainted with the interface
Installing MySQL
Additional note – Installing – Visual C
Installing MySQL on macOS and Unix systems
The Client-Server Model
Setting up a connection
Read me!!!
New Authentication Plugin - Creating a New User
Introduction to the MySQL interface
First steps in SQL
Creating a Database - Part I
SQL files
Creating a Database - Part I - exercise
Creating a Database - Part I - solution
Creating a Database - Part II
Creating a Database - Part II - exercise
Creating a Database - Part II - solution
Introduction to data types
Introduction to data types
String data types
String data types
Integers
Integers
Fixed and floating-point data types
Fixed and floating-point data types
Other useful data types
Other useful data types
Creating a table
Creating a table - exercise
Creating a table - solution
Using databases and tables
Using databases and tables - exercise
Using databases and tables - solution
Additional notes on using tables
Additional notes on using tables
Additional notes on using tables - exercise
MySQL constraints
PRIMARY KEY constraint
PRIMARY KEY Constraint
PRIMARY KEY constraint - exercise
PRIMARY KEY constraint - solution
FOREIGN KEY constraint - Part I
FOREIGN KEY constraint - Part II
FOREIGN KEY constraint - Part II - exercise
FOREIGN KEY constraint - Part II - solution
UNIQUE Constraint
UNIQUE Constraint - exercise
DEFAULT Constraint
DEFAULT Constraint - exercise
DEFAULT Constraint - solution
NOT NULL Constraint - Part I
NOT NULL Constraint - Part I - exercise
NOT NULL Constraint - Part I - solution
NOT NULL Constraint - Part II
SQL best practices
Coding techniques and best practices - Part I
Coding techniques and best practices – Part I
Coding techniques and best practices - Part II
Coding techniques and best practices – Part II
Loading the 'employees' database
Loading the 'employees' database
Loading the 'employees' database
SQL SELECT statement
SELECT - FROM
SELECT - FROM - exercise
SELECT - FROM - solution
WHERE
WHERE - exercise
WHERE - solution
AND
AND - exercise
AND - solution
OR
OR - exercise
OR - solution
Operator precedence
Operator precedence - exercise
Operator precedence - solution
IN - NOT IN
IN - NOT IN - exercise 1
IN - NOT IN - solution 1
IN - NOT IN - exercise 2
IN - NOT IN - solution 2
LIKE - NOT LIKE
LIKE - NOT LIKE - exercise
LIKE - NOT LIKE - solution
Wildcard characters
Wildcard characters - exercise
Wildcard characters - solution
BETWEEN - AND
BETWEEN - AND - exercise
BETWEEN - AND- solution
IS NOT NULL - IS NULL
IS NOT NULL - IS NULL - exercise
IS NOT NULL - IS NULL - solution
Other comparison operators
Other comparison operators - exercise
Other comparison operators - solution
SELECT DISTINCT
SELECT DISTINCT - exercise
SELECT DISTINCT - solution
Introduction to aggregate functions
Introduction to aggregate functions - exercise
Introduction to aggregate functions - solution
ORDER BY
ORDER BY - exercise
ORDER BY - solution
GROUP BY
Using Aliases (AS)
Using Aliases (AS) - exercise
Using Aliases (AS) - solution
HAVING
HAVING - exercise
HAVING - solution
WHERE vs HAVING- Part I
WHERE vs HAVING- Part II
WHERE vs HAVING - Part II - exercise
WHERE vs HAVING - Part II - solution
LIMIT
LIMIT - exercise
LIMIT - solution
SQL INSERT statement
The INSERT statement - Part I
The INSERT statement - Part II
The INSERT statement - exercise 1
The INSERT statement - solution 1
The INSERT statement - exercise 2
The INSERT statement - solution 2
Inserting data INTO a new table
Inserting Data INTO a New Table - exercise
Inserting Data INTO a New Table - solution
SQL UPDATE Statement
TCL's COMMIT and ROLLBACK
The UPDATE Statement - Part I
ROLLBACK; ARTICLE
The UPDATE Statement - Part II
The UPDATE Statement – Part II - exercise
The UPDATE Statement – Part II - solution
SQL DELETE Statement
The DELETE Statement - Part I
The DELETE Statement - Part II
The DELETE Statement – Part II - exercise
The DELETE Statement – Part II - solution
DROP vs TRUNCATE vs DELETE
DROP vs TRUNCATE vs DELETE
MySQL - Aggregate functions
COUNT()
COUNT() - exercise
COUNT() - solution
SUM()
SUM() - exercise
SUM() - solution
MIN() and MAX()
MIN() and MAX() - exercise
MIN() and MAX() - solution
AVG()
AVG() - exercise
AVG() - solution
ROUND()
ROUND() - exercise
ROUND() - solution
COALESCE() - Preamble
IFNULL() and COALESCE()
Another Example of Using COALESCE()
Another example of using COALESCE() - exercise 1
Another example of using COALESCE() - solution 1
Another example of using COALESCE() - exercise 2
Another example of using COALESCE() - solution 2
Another example of using COALESCE()
SQL Joins
Introduction to JOINs
Intro to JOINs - exercise 1
Intro to JOINs - solution 1
Intro to JOINs - exercise 2
INNER JOIN - Part I
INNER JOIN - Part II
INNER JOIN - Part II - exercise
INNER JOIN - Part II - solution
A Note on Using Joins
Duplicate Records
LEFT JOIN - Part I
LEFT JOIN - Part II
LEFT JOIN - Part II - exercise
LEFT JOIN - Part II - solution
RIGHT JOIN
The new and the old join syntax
The new and the old join syntax - exercise
The new and the old join syntax - solution
JOIN and WHERE Used Together
Important – Prevent Error Code: 1055!
JOIN and WHERE Used Together - exercise
JOIN and WHERE Used Together - solution
CROSS JOIN
CROSS JOIN - exercise 1
CROSS JOIN - solution 1
CROSS JOIN - exercise 2
CROSS JOIN - solution 2
Using Aggregate Functions with Joins
JOIN more than two tables in SQL
Join more than two tables in SQL - exercise
Join more than two tables in SQL - solution
Tips and tricks for joins
Tips and tricks for joins - exercise
Tips and tricks for joins - solution
UNION vs UNION ALL
UNION vs UNION ALL - exercise
UNION vs UNION ALL - solution
SQL Subqueries
SQL Subqueries with IN nested inside WHERE
SQL Subqueries with IN nested inside WHERE - exercise
SQL Subqueries with IN nested inside WHERE - solution
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution
SQL Subqueries nested in SELECT and FROM
SQL Subqueries nested in SELECT and FROM - exercise 1
SQL Subqueries nested in SELECT and FROM - solution 1
SQL Subqueries nested in SELECT and FROM - exercise 2
SQL Subqueries nested in SELECT and FROM - solution 2
SQL Self Join
Self Join
Self join
SQL Views
Views
Views - exercise
Views - solution
Stored routines
Introduction to stored routines
Introduction to Stored Routines
The MySQL syntax for stored procedures
Stored procedures - Example - Part I
Stored procedures - Example - Part II
Stored procedures - Example - Part II - exercise
Stored procedures - Example - Part II - solution
Another way to create a procedure
Stored procedures with an input parameter
Stored procedures with an output parameter
Stored procedures with an output parameter - exercise
Stored procedures with an output parameter - solution
Variables
Variables - exercise
Variables - solution
User-defined functions in MySQL
Error Code: 1418.
User-defined functions in MySQL - exercise
User-defined functions in MySQL - solution
Stored routines - conclusion
Stored routines - conclusion
Advanced SQL Topics
Types of MySQL Variables - Local Variables
Types of MySQL Variables - Local Variables
Session Variables
Session Variables
Global Variables
Global Variables
User-Defined vs System Variables
User-Defined vs System Variables
MySQL Triggers
MySQL Triggers - exercise
MySQL Triggers - solution
MySQL Indexes
MySQL Indexes - exercise 1
MySQL Indexes - solution 1
MySQL Indexes - exercise 2
MySQL Indexes - solution 2
The CASE Statement
The CASE Statement - exercise 1
The CASE Statement - solution 1
The CASE Statement - exercise 2
The CASE Statement - solution 2
The CASE Statement - exercise 3
The CASE Statement - solution 3
Combining SQL and Tableau - Introduction
The Advantages of Software Integration
Why Combining SQL and Tableau is useful
Installing Tableau Public
Loading the 'employees_mod' Database
Loading the 'employees_mod' Database
Combining SQL and Tableau - Task 1
Task 1
Task 1 - Text
Important clarification!
Task 1: SQL Solution
Task 1: SQL Solution - Code
Transferring a Dataset from SQL to Tableau
Chart 1: Visualizing and Analyzing the Solution in Tableau - Part I
Chart 1: Visualizing and Analyzing the Solution in Tableau - Part II
Combining SQL and Tableau - Task 2
Task 2
Task 2 - Text
Task 2: SQL Solution
Task 2: SQL Solution - Code
Chart 2: Visualizing and Analyzing the Solution in Tableau
Combining SQL and Tableau - Task 3
Task 3
Task 3 - Text
Task 3: SQL Solution
Task 3: SQL Solution - Code
Chart 3: Visualizing and Analyzing the Solution in Tableau
Combining SQL and Tableau - Task 4
Task 4
Task 4 - Text
Task 4: Solution in SQL
Task 4: Solution in SQL - Code
Chart 4: Visualizing and Analyzing the Solution in Tableau
Combining SQL and Tableau - Task 5
Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau
Practice SQL – 10 Final Query Questions
Practice SQL – 10 Final Query Questions
BONUS LECTURE
Bonus Lecture: Next Steps
Yes, it's a good match for me and one of the best courses available online for SQL. Easy to understand and easy to follow even if you are not from an IT or CS background. I will definitely recommend this course for anyone who wants to learn SQL. The instructor did a great job. Thank you.
Thank you for the course. I have really liked it. Being new to SQL, this course has really helped me to understand the basics of SQL. I would definitely like to apply my SQL skills in my professional life and keep learning to advance my SQL skills.
its a good course, first some courses are little boring. But when I have been doing the practical its actually interesting. Thank you for your contribution.
Excellent content and perfect pace!!. Also loved the way the topics are arranged. Only thing that could make this course even better is more practice questions (more sophisticated queries)
Everything is good - easy to follow and understand except for the quiz part. It would have been better if there were explanations for both correct and wrong answers.
It was a great course. However, there is a steep learning curve towards the end and the examples were very advanced. Maybe have more guidance before we look at the solution? It makes sense once you look at the solution but getting there felt impossible. Really enjoyed the sql/tableau section. First 100 lectures mainly for database administrators. The analytics side only came in right at the end.
so far I'm looking forward to seeing advanced queries, and learning how I can set up a relational database for the company I work for
I haven't gotten into the complexities of SQL statement creation yet - but I will say that the first few sections of the course have been very insightful and easy to slip into the concepts.
I appreciate the course is presented in small chunks of information which helps to maintains my attention and not be overwelmed.
Some of the most used functions not explained. Also the course didn't offers the promised other two course
Its like a stupid presentation. Too fast to go into details. It lacks the teacher component. A mechanical voice with some animations going at a certain speed. No human component. At best it's informative. Learning a logical concept this way is not possible. Also, They ask for ratings in between the topics which shows lack of attention. Please don't waste your time.
Engaging speaker. Clear and concise illustrations and transitions. Enjoy the short segments to break down concepts into "bite size" chunks.
Wrapping up the introductory part (about 25% before starting actual data manipulation), I can already say that I recommend the course so far. I'm already familiar with SQL basics and decided to take this course as previous data analytics classes focused a lot more on Python modules used in DS without really touching about SQL or databases in general. The English is flawless and the instructions are very clear. The course starts with a very solid explanation of databases and why to use them, instead of directly jumping into the queries used to manipulate data as many other courses do. Having taken previous courses I never felt confident about working with SQL on my own device, but this course makes it so much easier to understand. I'm not yet sure how deep this course will go eventually, but so far the price I've paid was well worth it! Thanks!
This course is very detailed and provides one with good and enough insights required to understand concepts.
Amazing!!! Absolutely a good match. The instructor knows just how to make this lessons sink. Good Job The quiz is quite short.