Blog

Let's Join Us

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

Values

Null Values Setting a Column Name Alias Concatenation