Useful resources for Database

Databsae related courses: CPS: 3351, 3500, 3740, 4721, 4745, 5740, 5721, 5745; TECH: 3500, 3740

The database is one of the most important components in the modern software system (including games) because it stores and manages the data. The positions required database skills are usually high demand and high paying jobs: Software Engineer with salary range $80K ~ $200+K, Database Deverloper and Database Administrator with salary range $60K ~ $150K, (DBA $83 ~ $107K), Data Analyst with salary range: $69K ~ $87K, and other jobs that need to interact with database such as CPS 4271 data mining and CPS 4271 advanced data mining).
Topic: MySQL Workbench installation & Tutorial
How to Install and Connect in MySQL Workbench on Windows 10	MySQL WorkBench macOS Installation	MySQL Workbench Tutorial
Topic: Basic SQL - SELECT
Reading and practice SQL at W3Schools
MySQL Querying Data - Lesson 1, Part 1 - How To Write a Basic SQL Select Statement	MySQL Querying Data - Lesson 1, Part 2 - How To Write a Basic SQL Select Statement	SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join
Topic: Basic SQL - aggregations
SQL: Group By, Having, Min, Max Sum	Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)	HAVING clause and difference with GROUP BY & WHERE clause in SQL statement
Topic: Basic SQL - Create tables, constraints, insert, update, delete
Learn SQL in 1 Hour - SQL Basics for Beginners (select, create table, insert)	Constraints - SQL - Tutorial 8	Update & Delete | SQL | Tutorial 9
Topic: Database Anomalies, Normalization, Decomposition
Anomalies and Normalization	Database Normalization in SQL - 1NF, 2NF, 3NF, 4NF - SQL Training Online	Lecture 17 Part 6 Lossless Join Decompositions
Topic: PHP MySQL
Reading and practice PHP MySQL at W3Schools, TutorialsPoint, MySQL Tutorial
PHP MySQL Tutorial	How to Create a Login Page in PHP	Insert data from a website into a database using MySQLi