Skip to content

Latest commit

 

History

History
82 lines (42 loc) · 1.11 KB

File metadata and controls

82 lines (42 loc) · 1.11 KB

15. Databases and SQL

[toc]


15.1. What is SQL?

15.1.1. MySQL

15.1.1.1. Numbers

15.1.1.2. Strings

15.1.1.3. Boolean

15.1.2. Check Your Understanding ✅

15.2. SQL Queries

15.2.1. Create

15.2.1.1. Creating a Table

15.2.1.2. Adding a Row

15.2.1.3. Adding a column

15.2.2. Read

15.2.3. Update

15.2.4. Delete

15.2.5. Check Your Understanding ✅

15.3. Joins

15.3.1. Inner Join

15.3.2. Left Outer Join

15.3.3. Right Outer Join

15.3.4. Full Outer Join

15.3.5. Check Your Understanding ✅

15.4. Exercises: SQL, Part 1 🏃

15.4.1. Table Setup

15.4.2. Create

15.4.3. Read

15.4.4. Update

15.4.5. Delete

15.4.6. Bonus Exercises 🚀

15.5. Studio: Movie SQLs 🎙️

15.5.1. Walkthrough

15.5.1.1. Movies Table

15.5.1.2. Directors Table

15.5.1.3. Relating the Tables

15.5.1.4. INSERT Data From File

15.5.2. Your Assignment

15.5.2.1. Task List

15.5.3. Bonus Missions 🚀


#Java