Blog

Sum Aggregate Function Min and Max Aggregate Functions Grouping Data Average Aggregate Functions Having Clauses

Section Summary (section 5) Section Introduction(SECTION 6) Count Aggregate Functions VIDEO KEEMPAT

Null Values Setting a Column Name Alias Concatenation

Order By   Limiting the Number of Results Fetch Distinct Values

Where Clauses Logical Operators In, Not In Like Between 

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

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

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

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