Author: Ninda Lutfiani

Let's Join Us

Aggregate Functions

Section Summary (section 5) Section Introduction(SECTION 6) Count Aggregate Functions VIDEO KEEMPAT Ninda Lutfianinindalutfiani.ilearning.me/

Values

Null Values Setting a Column Name Alias Concatenation Ninda Lutfianinindalutfiani.ilearning.me/

SQL And PostgreSQL for Beginners

Order By   Limiting the Number of Results Fetch Distinct Values Ninda Lutfianinindalutfiani.ilearning.me/

IN, NOT IN, LIKE, AND BETWEEN

Where Clauses Logical Operators In, Not In Like Between  Ninda Lutfianinindalutfiani.ilearning.me/

INSERTING DATA INTO DATABASE

Updating Data in a Table Deleting Data from a Table Inserting Data into Our Movie Data Database Section Summary Section Introduction  Select Queries – Ninda Lutfianinindalutfiani.ilearning.me/

MODIFYING TABLES PART 2

Modifying Tables Part 2: Changing a Columns Data Type  Deleting Tables from a Database Section Summary Section Introduction Inserting Data into a Table  Ninda Lutfianinindalutfiani.ilearning.me/

MODIFYING TABLES PART 1

Creating the Movie Revenues Table – Creating a Junction Table Modifying Tables Part 1: Adding Columns Ninda Lutfianinindalutfiani.ilearning.me/

CREATING TABLE

Unique, Not Null and Check Constraints  Creating Our First Table Creating the Actors Table Creating a Table with a Foreign Key Ninda Lutfianinindalutfiani.ilearning.me/

DATABASE TABLES AND DATA TYPE

Section Introduction  Database Tables  Data Types Explained  Primary Keys and Foreign Keys  Ninda Lutfianinindalutfiani.ilearning.me/

INTRODUCING DATABASE & SQL

Course Introduction What is a Database? Relational Databases and SQL Ninda Lutfianinindalutfiani.ilearning.me/