❗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, you will acquire the skills and knowledge necessary to interact with and query any SQL database, generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications. You will also learn the ins and outs of SQL syntax, generate reports using sales and user data, analyze data using Aggregate Functions, run complex queries using MySQL logical operators and string functions, write all the common SQL joins, work with large datasets containing thousands of entries, design and implement complex database schemas, learn to navigate the treacherous world of storing dates and times, clone the database structure of a photo sharing social network, and work with MySQL 8.x Window Functions such as RANK, LEAD, LAG, NTILE, etc. Additionally, you will create MySQL database views and virtual tables.


Contribution to Professional Growth:
This course provides a comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today. By mastering MySQL, professionals can gain the ability to answer complex business problems and questions using insights from data. Through this course, professionals can learn the ins and outs of SQL syntax, generate reports using sales and user data, analyze data using aggregate functions, and design and implement complex database schemas. By completing this course, professionals will be able to interact with and query any SQL database, generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications. This course is an invaluable tool for professional growth and development.


Suitability for Further Education:
This course is suitable for preparing further education. It covers a wide range of topics related to MySQL, including Window Functions, Views, and SQLmodes, and provides ample opportunity for students to practice their skills. Additionally, the course provides a comprehensive introduction to MySQL, which is a highly in-demand skill in the business sector. By the end of the course, students will be able to interact with and query any SQL database, generate reports, answer company performance questions using data, and integrate MySQL into complete applications.

Course Syllabus

Introduction & 5 Minutes of SQL

Getting Started & Installation

Creating Databases & Tables

Inserting Data

CRUD Basics

CRUD Challenge

String Functions

Refining Selections

Aggregate Functions

Revisiting Data Types

Comparison & Logical Operators

Constraints & ALTER TABLE

One to Many & Joins

Many to Many

Views, Modes, & More!

Window Functions

Instagram Database Clone

Working With Lots of IG Data

What Next?

LEGACY: Introduction and 5 Minutes of SQL

LEGACY: Getting Started: Overview and Installation

LEGACY: Creating Databases and Tables

LEGACY: Inserting Data (and a couple other things)

LEGACY: CRUD commmands

LEGACY: CRUD Challenge Section

LEGACY: The World Of String Functions

LEGACY: Refining Our Selections

LEGACY: The Magic of Aggregate Functions

LEGACY: Revisiting Data Types

LEGACY: The Power of Logical Operators

LEGACY: Section 12: One To Many

LEGACY: Many To Many

LEGACY: Instagram Database Clone

LEGACY: Working With Lots Of Instagram Data

LEGACY: Introducing Node

LEGACY: Building Our Web App

LEGACY: Database Triggers

Additional Resources