Description
In this course, you will :
- Create your own database or interact with existing databases.
- Write complex SQL queries across multiple tables.
- Build a web app using NodeJS and MySQL.
- Model real-world data and generate reports using SQL.
- Answer company performance or sales questions using data.
Syllabus :
- Getting Started: Overview and Installation
- Creating Databases and Tables
- Inserting Data (and a couple other things)
- CRUD commmands
- CRUD Challenge Section
- The World Of String Functions
- Refining Our Selections
- The Magic of Aggregate Functions
- Revisiting Data Types
- The Power of Logical Operators
- Section 12: One To Many
- Section 13: Many To Many
- Instagram Database Clone
- Working With Lots Of Instagram Data
- Section 16 - Introducing Node
- Section 17 - Building Our Web App
- Section 18 - Database Triggers