❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 13th, 2023]

Skills and Knowledge Acquired:
By taking this course, students will acquire the skills and knowledge necessary to work with SQL and MySQL for data analytics and business intelligence. This includes understanding the fundamentals of database management, learning how to write SQL queries, and gaining an understanding of how to use SQL for data analysis and decision making. Additionally, students will learn how to work with a real-life database, as well as best practices for working with SQL and MySQL. Upon completion of the course, students will be able to download a certificate of completion with their name on it.


Contribution to Professional Growth:
This course provides an opportunity for professional growth by teaching the fundamentals of SQL and MySQL, which are essential for data analytics and business intelligence. It covers a variety of topics, from the basics to more advanced concepts, and provides practical exercises and quizzes to help students gain a better understanding of the material. Additionally, the course provides a certificate of completion, which can be used to demonstrate the student's knowledge and skills to potential employers. With the knowledge gained from this course, students can gain a competitive advantage in the job market and potentially increase their salary.


Suitability for Further Education:
This course is suitable for preparing further education as it provides comprehensive coverage of topics related to database management, data analysis, and business intelligence. It is taught in MySQL, the most popular SQL database management system, and contains plenty of downloadable exercises, course notes, and quiz questions. Additionally, upon completion of the course, students will be able to download a certificate of completion with their name on it, which can be used to demonstrate their knowledge and skills to potential employers.

Course Syllabus

Introduction to databases, SQL, and MySQL

SQL theory

Basic database terminology

Installing MySQL and getting acquainted with the interface

First steps in SQL

MySQL constraints

SQL best practices

Loading the 'employees' database

SQL SELECT statement

SQL INSERT statement

SQL UPDATE Statement

SQL DELETE Statement

MySQL - Aggregate functions

SQL Joins

SQL Subqueries

SQL Self Join

SQL Views

Stored routines

Advanced SQL Topics

SQL Window Functions

SQL Common Table Expressions (CTEs)

SQL Temporary Tables

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