SQL – MySQL for Data Analytics and Business Intelligence
-
Introduction to databases SQL and MySQL
-
SQL theory
-
Basic database terminology
-
Installing MySQL and getting acquainted with the interface
-
First steps in SQLCreating a Database – Part I0sSQL filesCreating a Database – Part I – exerciseCreating a Database – Part I – solutionCreating a Database – Part II0sCreating a Database – Part II – exerciseCreating a Database – Part II – solutionIntroduction to data types0sString data types0sIntegers0sFixed and floating-point data types0sOther useful data types0sCreating a table0sCreating a table – exerciseCreating a table – solutionCODING EXERCISES – Browser-based codingUsing databases and tables0sUsing databases and tables – exerciseUsing databases and tables – solutionAdditional notes on using tables0sAdditional notes on using tables – exercise
-
MySQL constraintsPRIMARY KEY Constraint0sPRIMARY KEY constraint – exercisePRIMARY KEY constraint – solutionFOREIGN KEY constraint – Part I0sFOREIGN KEY constraint – Part II0sFOREIGN KEY constraint – Part II – exerciseFOREIGN KEY constraint – Part II – solutionUNIQUE Constraint0sUNIQUE Constraint – exerciseDEFAULT Constraint0sDEFAULT Constraint – exerciseDEFAULT Constraint – solutionNOT NULL Constraint – Part I0sNOT NULL Constraint – Part I – exerciseNOT NULL Constraint – Part I – solutionNOT NULL Constraint – Part II0s
-
SQL best practices
-
Loading the ’employees’ database
-
SQL SELECT statementSELECT – FROM0sSELECT – FROM – exerciseSELECT – FROM – solutionCODING EXERCISES – the ’employees_10′ DatabaseWHERE0sWHERE – exerciseWHERE – solutionAND0sAND – exerciseAND – solutionOR0sOR – exerciseOR – solutionOperator precedence0sOperator precedence – exerciseOperator precedence – solutionIN – NOT IN0sIN – NOT IN – exercise 1IN – NOT IN – solution 1IN – NOT IN – exercise 2IN – NOT IN – solution 2LIKE – NOT LIKE0sLIKE – NOT LIKE – exerciseLIKE – NOT LIKE – solutionWildcard characters0sWildcard characters – exerciseWildcard characters – solutionBETWEEN – AND0sBETWEEN – AND – exerciseBETWEEN – AND- solutionIS NOT NULL – IS NULL0sIS NOT NULL – IS NULL – exerciseIS NOT NULL – IS NULL – solutionOther comparison operators0sOther comparison operators – exerciseOther comparison operators – solutionSELECT DISTINCT0sSELECT DISTINCT – exerciseSELECT DISTINCT – solutionIntroduction to aggregate functions0sIntroduction to aggregate functions – exerciseIntroduction to aggregate functions – solutionORDER BY0sORDER BY – exerciseORDER BY – solutionGROUP BY0sUsing Aliases (AS)0sUsing Aliases (AS) – exerciseUsing Aliases (AS) – solutionHAVING0sHAVING – exerciseHAVING – solutionWHERE vs HAVING- Part I0sWHERE vs HAVING- Part II0sWHERE vs HAVING – Part II – exerciseWHERE vs HAVING – Part II – solutionLIMIT0sLIMIT – exerciseLIMIT – solution
-
SQL INSERT statementThe INSERT statement – Part I0sThe INSERT statement – Part II0sThe INSERT statement – exercise 1The INSERT statement – solution 1The INSERT statement – exercise 2The INSERT statement – solution 2Inserting data INTO a new table0sInserting Data INTO a New Table – exerciseInserting Data INTO a New Table – solution
-
SQL UPDATE Statement
-
SQL DELETE Statement
-
MySQL Aggregate functionsCOUNT()0sCOUNT() – exerciseCOUNT() – solutionSUM()0sSUM() – exerciseSUM() – solutionMIN() and MAX()0sMIN() and MAX() – exerciseMIN() and MAX() – solutionAVG()0sAVG() – exerciseAVG() – solutionROUND()0sROUND() – exerciseROUND() – solutionCOALESCE() – PreambleIFNULL() and COALESCE()0sAnother Example of Using COALESCE()0sAnother example of using COALESCE() – exercise 1Another example of using COALESCE() – solution 1Another example of using COALESCE() – exercise 2Another example of using COALESCE() – solution 2
-
SQL JoinsIntroduction to JOINs0sIntro to JOINs – exercise 1Intro to JOINs – solution 1Intro to JOINs – exercise 2INNER JOIN – Part I0sINNER JOIN – Part II0sINNER JOIN – Part II – exerciseINNER JOIN – Part II – solutionA Note on Using Joins0sDuplicate Records0sLEFT JOIN – Part I0sLEFT JOIN – Part II0sLEFT JOIN – Part II – exerciseLEFT JOIN – Part II – solutionRIGHT JOIN0sThe new and the old join syntax0sThe new and the old join syntax – exerciseThe new and the old join syntax – solutionJOIN and WHERE Used Together0sImportant – Prevent Error Code: 1055!JOIN and WHERE Used Together – exerciseJOIN and WHERE Used Together – solutionCROSS JOIN0sCROSS JOIN – exercise 1CROSS JOIN – solution 1CROSS JOIN – exercise 2CROSS JOIN – solution 2Using Aggregate Functions with Joins0sJOIN more than two tables in SQL0sJoin more than two tables in SQL – exerciseJoin more than two tables in SQL – solutionTips and tricks for joins0sTips and tricks for joins – exerciseTips and tricks for joins – solutionUNION vs UNION ALL0sUNION vs UNION ALL – exerciseUNION vs UNION ALL – solution
-
SQL SubqueriesSQL Subqueries with IN nested inside WHERE0sSQL Subqueries with IN nested inside WHERE – exerciseSQL Subqueries with IN nested inside WHERE – solutionSQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE0sSQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE – exerciseSQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE – solutionSQL Subqueries nested in SELECT and FROM0sSQL Subqueries nested in SELECT and FROM – exercise 1SQL Subqueries nested in SELECT and FROM – solution 1SQL Subqueries nested in SELECT and FROM – exercise 2SQL Subqueries nested in SELECT and FROM – solution 2
-
SQL Self Join
-
SQL Views
-
Stored routinesIntroduction to stored routines0sThe MySQL syntax for stored procedures0sStored procedures – Example – Part I0sStored procedures – Example – Part II0sStored procedures – Example – Part II – exerciseStored procedures – Example – Part II – solutionAnother way to create a procedure0sStored procedures with an input parameter0sStored procedures with an output parameter0sStored procedures with an output parameter – exerciseStored procedures with an output parameter – solutionVariables0sVariables – exerciseVariables – solutionUser-defined functions in MySQL0sError Code: 1418.User-defined functions in MySQL – exerciseUser-defined functions in MySQL – solutionStored routines – conclusion0s
-
Advanced SQL TopicsTypes of MySQL Variables – Local Variables0sSession Variables0sGlobal Variables0sUser-Defined vs System Variables0sMySQL TriggersMySQL Triggers0sMySQL Triggers – exerciseMySQL Triggers – solutionMySQL Indexes0sMySQL Indexes – exercise 1MySQL Indexes – solution 1MySQL Indexes – exercise 2MySQL Indexes – solution 2The CASE Statement0sThe CASE Statement – exercise 1The CASE Statement – solution 1The CASE Statement – exercise 2The CASE Statement – solution 2The CASE Statement – exercise 3The CASE Statement – solution 3
-
SQL Window FunctionsIntroduction to MySQL Window Functions0sThe ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax0sThe ROW_NUMBER() Ranking Window Function – ExercisesThe ROW_NUMBER() Ranking Window Function – SolutionA Note on Using Several Window Functions in a Query0sA Note on Using Several Window Functions – ExerciseA Note on Using Several Window Functions – SolutionMySQL Window Functions Syntax0sMySQL Window Functions Syntax – ExerciseMySQL Window Functions Syntax – SolutionThe PARTITION BY Clause VS the GROUP BY Clause0sThe PARTITION BY Clause VS the GROUP BY Clause – ExerciseThe PARTITION BY Clause VS the GROUP BY Clause – SolutionThe MySQL RANK() and DENSE_RANK() Window Functions0sThe MySQL RANK() and DENSE_RANK() Window Functions – ExerciseThe MySQL RANK() and DENSE_RANK() Window Functions – SolutionWorking with MySQL Ranking Window Functions and Joins Together0sWorking with MySQL Ranking Window Functions and Joins Together – ExerciseWorking with MySQL Ranking Window Functions and Joins Together – SolutionThe LAG() and LEAD() Value Window Functions0sThe LAG() and LEAD() Value Window Functions – ExerciseThe LAG() and LEAD() Value Window Functions – SolutionMySQL Aggregate Functions in the Context of Window Functions – Part I0sMySQL Aggregate Functions in the Context of Window Functions – Part I-ExerciseMySQL Aggregate Functions in the Context of Window Functions – Part I-SolutionMySQL Aggregate Functions in the Context of Window Functions – Part II0sMySQL Aggregate Functions in the Context of Window Functions – Part II-ExerciseMySQL Aggregate Functions in the Context of Window Functions – Part II-Solution
-
SQL Common Table Expressions (CTEs)MySQL Common Table Expressions – Introduction0sAn Alternative Solution to the Same Task0sAn Alternative Solution to the Same Task-ExerciseAn Alternative Solution to the Same Task-SolutionUsing Multiple Subclauses in a WITH Clause – Part I0sUsing Multiple Subclauses in a WITH Clause – Part II0sUsing Multiple Subclauses in a WITH Clause-ExerciseUsing Multiple Subclauses in a WITH Clause-SolutionReferring to Common Table Expressions in a WITH Clause0s
-
SQL Temporary TablesMySQL Temporary Tables – Introduction0sMySQL Temporary Tables in Action0sMySQL Temporary Tables in Action-ExerciseMySQL Temporary Tables in Action-SolutionOther Features of MySQL Temporary Tables0sOther Features of MySQL Temporary Tables-ExerciseOther Features of MySQL Temporary Tables-Solution
-
Combining SQL and Tableau Introduction
-
Combining SQL and Tableau Task 1
-
Combining SQL and Tableau Task 2
-
Combining SQL and Tableau Task 3
-
Combining SQL and Tableau Task 4
-
Combining SQL and Tableau Task 5
-
Practice SQL 10 Final Query Questions
-
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?
-
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 “Buy now” button, and let’s begin this journey together!
What's included
- 11.5 hours on-demand video
- 182 articles
- 99 downloadable resources
- Access on mobile and TV
- Certificate of completion