SQL - MySQL for Data Analytics and Business Intelligence
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.
More
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.
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!
- No prior experience is required. We will start from the very basics
- People interested in SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
- Beginners to programming
- Everyone who wants to learn how to code and apply their skills in practice
What you'll learn:
- 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
Watch Online SQL - MySQL for Data Analytics and Business Intelligence
| # | Title | Duration |
|---|---|---|
| 1 | What does the course cover? | 04:15 |
| 2 | Why SQL? | 03:18 |
| 3 | Why MySQL? | 01:58 |
| 4 | Introduction to databases | 04:45 |
| 5 | SQL as a declarative language | 02:12 |
| 6 | Data definition language (DDL) | 04:14 |
| 7 | SQL keywords | 01:13 |
| 8 | Data manipulation language (DML) | 04:56 |
| 9 | Data control language (DCL) | 05:04 |
| 10 | Transaction control language (TCL) | 03:03 |
| 11 | Relational database essentials | 04:52 |
| 12 | Databases vs spreadsheets | 08:07 |
| 13 | Database terminology | 04:18 |
| 14 | Relational schemas - Primary key | 04:56 |
| 15 | Relational schemas - Foreign key | 05:00 |
| 16 | Relational schemas - Unique key and null values | 03:08 |
| 17 | Relationships | 04:40 |
| 18 | Installing MySQL | 10:49 |
| 19 | Setting up a connection | 02:35 |
| 20 | New Authentication Plugin - Creating a New User | 06:19 |
| 21 | Introduction to the MySQL interface | 05:10 |
| 22 | Creating a Database - Part I | 05:13 |
| 23 | Creating a Database - Part II | 02:23 |
| 24 | Introduction to data types | 02:17 |
| 25 | String data types | 05:02 |
| 26 | Integers | 04:11 |
| 27 | Fixed and floating-point data types | 05:45 |
| 28 | Other useful data types | 06:13 |
| 29 | Creating a table | 05:18 |
| 30 | Using databases and tables | 03:04 |
| 31 | Additional notes on using tables | 02:13 |
| 32 | PRIMARY KEY constraint | 05:24 |
| 33 | FOREIGN KEY constraint - Part I | 05:26 |
| 34 | FOREIGN KEY constraint - Part II | 05:27 |
| 35 | UNIQUE Constraint | 05:01 |
| 36 | DEFAULT Constraint | 05:25 |
| 37 | NOT NULL Constraint - Part I | 05:54 |
| 38 | NOT NULL Constraint - Part II | 02:00 |
| 39 | Coding techniques and best practices - Part I | 05:35 |
| 40 | Coding techniques and best practices - Part II | 04:12 |
| 41 | Loading the 'employees' database | 02:20 |
| 42 | SELECT - FROM | 04:58 |
| 43 | WHERE | 02:31 |
| 44 | AND | 02:15 |
| 45 | OR | 03:36 |
| 46 | Operator precedence | 03:35 |
| 47 | IN - NOT IN | 03:13 |
| 48 | LIKE - NOT LIKE | 03:37 |
| 49 | Wildcard characters | 01:46 |
| 50 | BETWEEN - AND | 02:21 |
| 51 | IS NOT NULL - IS NULL | 01:38 |
| 52 | Other comparison operators | 04:31 |
| 53 | SELECT DISTINCT | 02:07 |
| 54 | Introduction to aggregate functions | 05:25 |
| 55 | ORDER BY | 03:47 |
| 56 | GROUP BY | 06:01 |
| 57 | Using Aliases (AS) | 02:09 |
| 58 | HAVING | 03:27 |
| 59 | WHERE vs HAVING- Part I | 04:05 |
| 60 | WHERE vs HAVING- Part II | 03:09 |
| 61 | LIMIT | 04:53 |
| 62 | The INSERT statement - Part I | 06:06 |
| 63 | The INSERT statement - Part II | 02:20 |
| 64 | Inserting data INTO a new table | 03:57 |
| 65 | TCL's COMMIT and ROLLBACK | 02:43 |
| 66 | The UPDATE Statement - Part I | 03:19 |
| 67 | The UPDATE Statement - Part II | 02:56 |
| 68 | The DELETE Statement - Part I | 04:15 |
| 69 | The DELETE Statement - Part II | 01:31 |
| 70 | DROP vs TRUNCATE vs DELETE | 03:24 |
| 71 | COUNT() | 04:15 |
| 72 | SUM() | 01:32 |
| 73 | MIN() and MAX() | 01:16 |
| 74 | AVG() | 01:59 |
| 75 | ROUND() | 02:07 |
| 76 | IFNULL() and COALESCE() | 06:26 |
| 77 | Another Example of Using COALESCE() | 01:37 |
| 78 | Introduction to JOINs | 04:24 |
| 79 | INNER JOIN - Part I | 06:04 |
| 80 | INNER JOIN - Part II | 05:34 |
| 81 | A Note on Using Joins | 04:10 |
| 82 | Duplicate Records | 04:22 |
| 83 | LEFT JOIN - Part I | 04:32 |
| 84 | LEFT JOIN - Part II | 05:47 |
| 85 | RIGHT JOIN | 04:31 |
| 86 | The new and the old join syntax | 04:18 |
| 87 | JOIN and WHERE Used Together | 02:54 |
| 88 | CROSS JOIN | 07:43 |
| 89 | Using Aggregate Functions with Joins | 02:18 |
| 90 | JOIN more than two tables in SQL | 04:28 |
| 91 | Tips and tricks for joins | 05:40 |
| 92 | UNION vs UNION ALL | 05:45 |
| 93 | SQL Subqueries with IN nested inside WHERE | 04:32 |
| 94 | SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE | 03:43 |
| 95 | SQL Subqueries nested in SELECT and FROM | 07:58 |
| 96 | Self Join | 07:46 |
| 97 | Views | 07:13 |
| 98 | Introduction to stored routines | 03:27 |
| 99 | The MySQL syntax for stored procedures | 04:33 |
| 100 | Stored procedures - Example - Part I | 02:46 |
| 101 | Stored procedures - Example - Part II | 04:50 |
| 102 | Another way to create a procedure | 03:20 |
| 103 | Stored procedures with an input parameter | 06:30 |
| 104 | Stored procedures with an output parameter | 03:21 |
| 105 | Variables | 06:51 |
| 106 | User-defined functions in MySQL | 06:15 |
| 107 | Stored routines - conclusion | 03:56 |
| 108 | Types of MySQL Variables - Local Variables | 04:57 |
| 109 | Session Variables | 05:22 |
| 110 | Global Variables | 02:19 |
| 111 | User-Defined vs System Variables | 04:13 |
| 112 | MySQL Indexes | 07:28 |
| 113 | The CASE Statement | 05:58 |
| 114 | The Advantages of Software Integration | 05:21 |
| 115 | Why Combining SQL and Tableau is useful | 04:55 |
| 116 | Installing Tableau Public | 01:52 |
| 117 | Loading the 'employees_mod' Database | 03:23 |
| 118 | Task 1 | 05:34 |
| 119 | Task 1: SQL Solution | 04:42 |
| 120 | Transferring a Dataset from SQL to Tableau | 04:14 |
| 121 | Chart 1: Visualizing and Analyzing the Solution in Tableau - Part I | 06:18 |
| 122 | Chart 1: Visualizing and Analyzing the Solution in Tableau - Part II | 05:26 |
| 123 | Task 2 | 03:51 |
| 124 | Task 2: SQL Solution | 03:44 |
| 125 | Chart 2: Visualizing and Analyzing the Solution in Tableau | 06:09 |
| 126 | Task 3 | 02:22 |
| 127 | Task 3: SQL Solution | 03:15 |
| 128 | Chart 3: Visualizing and Analyzing the Solution in Tableau | 04:57 |
| 129 | Task 4 | 02:46 |
| 130 | Task 4: Solution in SQL | 02:48 |
| 131 | Chart 4: Visualizing and Analyzing the Solution in Tableau | 03:23 |
| 132 | Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau | 06:05 |
Similar courses to SQL - MySQL for Data Analytics and Business Intelligence
Complete SQL + Databases Bootcamp: Zero to Mastery
The Complete SQL Bootcamp: Go from Zero to Hero
Mastery with SQL
Database DevOps from Start to Finish
MySQL High Performance Tuning Guide
SQL and PostgreSQL: The Complete Developer's Guide
PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
