Author: Oktika Gita Amrikhasanah

Where Clauses Logical Operators In, Not In Like Between  Oktika Gita Amrikhasanah

Modifying Tables Part 2: Changing a Columns Data Type  Deleting Tables from a Database Section Summary Section Introduction Inserting Data into a Table  Oktika Gita Amrikhasanah

Creating the Movie Revenues Table – Creating a Junction Table Modifying Tables Part 1: Adding Columns Oktika Gita Amrikhasanah

Updating Data in a Table Deleting Data from a Table Inserting Data into Our Movie Data Database Section Summary Section Introduction  Select Queries – Oktika Gita Amrikhasanah

Unique, Not Null and Check Constraints  Creating Our First Table Creating the Actors Table Creating a Table with a Foreign Key Oktika Gita Amrikhasanah

Section Introduction  Database Tables  Data Types Explained  Primary Keys and Foreign Keys  Oktika Gita Amrikhasanah

Course Introduction What is a Database? Relational Databases and SQL Introduction to MySQL Databases  Introduction to MySQL Databases    Oktika Gita Amrikhasanah

Section Introduction(SECTION 8) Inner Joins Part 1 SQL Joins Explained Inner Joins Part 2 Oktika Gita Amrikhasanah

One to Many Relationships One to One Relationships Many to Many Relationships Section Summary Oktika Gita Amrikhasanah