1.1 Introduction - Biir Academy

Introduction to SQL 1.1 Introduction

Introduction to SQL

0% Completed

Section 1: Introduction

1.1 Introduction

Video - 10:55 mins

1.2 SQL Server Edition And SQL Type

Video - 6:59 mins

1.3 SQL server installation and Backup Adventurework2019

Video - 15:03 mins

Section 2: Database Design

2.1 Primary and Foreign Key

Video - 9:49 mins

2.2 Database Normalization

Video - 12:39 mins

2.3 Data Relationship

Video - 6:13 mins

Section 3: Data Definition Language

3.1 Create Database and Table

Video - 19:34 mins

3.2 Select into And Temporary table

Video - 9:57 mins

Video - 9:57 mins

3.4 Table Modification (Alter)

Video - 7:39 mins

Video - 8:35 mins

Section 4: Data Manipulation Language

Video - 8:14 mins

4.2 Delete and Update

Video - 7:51 mins

Section 5: Selecting Data from a Database

5.1 Select statment

Video - 8:35 mins

5.2 SQL functions (String Functions)

Video - 16:52 mins

5.3 SQL functions (Date Functions)

Video - 13:49 mins

5.4 SQL functions (Advanced Functions)

Video - 6:36 mins

5.5 Where Clause

Video - 11:31 mins

5.6 Where Clause continuation

Video - 10:22 mins

5.7 Information Schema

Video - 8:02 mins

Video - 7:35 mins

Video - 18:38 mins

5.10 Data Merging

Video - 5:02 mins

Section 6: Data Aggregation

6.1 Aggregate Functions

Video - 5:31 mins

Video - 12:48 mins

Section 7: Advanced SQL

Video - 6:22 mins

7.2 IF, IF-ELSE

Video - 7:03 mins

7.3 While Loops

Video - 9:04 mins

7.4 SQL Windows functions

Video - 12:03 mins

Video - 11:53 mins

7.6 Functions Continuations

Video - 8:06 mins

7.7 Store Procedure

Video - 11:44 mins

Announcements Reviews Course Info