❗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