Blog

Let's Join Us

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 

MODIFYING TABLES PART 1

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

CREATING TABLE

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

DATABASE TABLES AND DATA TYPE

Section Introduction  Database Tables  Data Types Explained  Primary Keys and Foreign Keys 

INTRODUCING DATABASE & SQL

Course Introduction What is a Database? Relational Databases and SQL

SQL Joins Explained

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

Database Relationship 2

One to Many Relationships One to One Relationships Many to Many Relationships Section Summary

Database Relationship

Mathematical Operators Section Summary(section 6) What Are Database Relationships VIDEO KEEMPAT

Aggregate Functions 2

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

Aggregate Functions

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