1.1 Introduction - Biir Academy

Course Content

Section 1: Introduction

0/3

1.1 Introduction

1.2 SQL Server Edition And SQL Type

1.3 SQL server installation and Backup Adventurework2019

Section 2: Database Design

0/5

2.1 Primary and Foreign Key

2.2 Database Normalization

2.3 Data Relationship

Section 3: Data Definition Language

0/7

3.1 Create Database and Table

3.2 Select into And Temporary table

3.4 Table Modification (Alter)

Section 4: Data Manipulation Language

0/4

4.2 Delete and Update

Section 5: Selecting Data from a Database

0/12

5.1 Select statment

5.2 SQL functions (String Functions)

5.3 SQL functions (Date Functions)

5.4 SQL functions (Advanced Functions)

5.5 Where Clause

5.6 Where Clause continuation

5.7 Information Schema

5.10 Data Merging

Section 6: Data Aggregation

0/4

6.1 Aggregate Functions

Section 7: Advanced SQL

0/9

7.2 IF, IF-ELSE

7.3 While Loops

7.4 SQL Windows functions

7.6 Functions Continuations

7.7 Store Procedure

Introduction to SQL

0% Complete