Course Description
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.
What you'll learn
- Introduction
- What is a Database?
- Tables & Keys
- SQL Basics
- MySQL Windows Installation
- MySQL Mac Installation
- Creating Tables
- Inserting Data
- Constraints
- Update & Delete
- Basic Queries
- Company Database Intro
- Creating Company Database
- More Basic Queries
- Functions
- Wildcards
- Union
- Joins
- Nested Queries
- On Delete
- Triggers
- ER Diagrams Intro
- Designing an ER Diagram
- Converting ER Diagrams to Schemas
