The Complete MS SQL Course

Frontier Education

• The Complete MS SQL Course Content 8:45:18

  • 1: 1a. Introduction 03:55
  • 2: 1b. Course Curriculum overview 04:23
  • 3: 1c. Overview of Databases 08:56
  • 4: 2a. MSSQL Installation 27:19
  • 5: 2b. MSSQL SSMS Installation 07:51
  • 6: 2c. Connecting to MS-SQL (Windows Authentication) 04:41
  • 7: 2d. Connecting to MS-SQL (SQL Server Authentication) 05:35
  • 8: 3a Overview of Challenges 02:38
  • 9: 3b SQL statement basic 12:54
  • 10: 3c. SELECT Statement 16:29
  • 11: 3d. SELECT DISTINCT 16:54
  • 12: 3e. Column AS Statement 09:12
  • 13: 3f. COUNT 09:42
  • 14: 3g. SELECT WHERE Clause – One 04:58
  • 15: 3g. SELECT WHERE Clause – Two 11:38
  • 16: 3i. ORDER BY 09:34
  • 17: 3j. TOP in MSSQL 05:39
  • 18: 3k. BETWEEN 13:13
  • 19: 3l. IN Operator - Condition 08:12
  • 20: 3m. LIKE 12:54
  • 21: 4a. Overview of GROUP BY 08:12
  • 22: 4b. Aggregation Function – SUM() 11:52
  • 23: 4c. Aggregation Function – MIN()-MAX() 08:21
  • 24: 4d. GROUP BY – One(theory) 10:55
  • 25: 4e. GROUP BY – Two(practical) 13:55
  • 26: 4f Task on HAVING 01:00
  • 27: 4f. HAVING 14:46
  • 28: 4fa Sol of Task on HAVING 01:00
  • 29: 5a. Overview Assessment Test 1 02:43
  • 30: 6a. Overview of JOINS 06:39
  • 31: 6b. Introduction to JOINS 07:08
  • 32: 6c. AS Statement 03:44
  • 33: 6d. INNER Join 12:21
  • 34: 6e. Full Outer Join 07:24
  • 35: 6f. Left Outer Join 05:59
  • 36: 6g. Right Outer Join 07:51
  • 37: 6h. Union 07:24
  • 38: 6i JOIN Assignment 01:00
  • 39: 6ia Solution for Joins Assignment 01:00
  • 40: 7a. Basic of Advanced SQL Commands 04:20
  • 41: 7b. Timestamp 11:40
  • 42: 7c. Extract from Timestamp 06:22
  • 43: 7d. Mathematical Scalar Functions 11:08
  • 44: 7e. String Functions 16:40
  • 45: 7f. SubQuery 07:09
  • 46: 9a. Basic of Database and Tables 09:41
  • 47: 9b. Data Types 10:54
  • 48: 9c. Select Datatype on SSMS 05:06
  • 49: 9ei. How to set Primary Key 05:37
  • 50: 9eii. How to set Foreign Key 12:11
  • 51: 9f. Create Table using SQL Script 07:12
  • 52: 9g. Insert 06:29
  • 53: 9h. Update 08:02
  • 54: 9i. Delete 06:35
  • 55: 9j. Alter Table 04:20
  • 56: 9k. Drop Table 02:55
  • 57: 9l. Check Constraint 14:07
  • 58: 9m. NOT NULL Constraint 11:46
  • 59: 9n. UNIQUE Constraint 11:15
  • 60: 10a. Overview of Database and Tables 03:32
  • 61: 10b. Creating a Database backup using SSMS 10:51
  • 62: 10c. Restoring a Database from backup using SSMS 07:35

With expert guidance and a combination of videos, PDFs, and worksheets, this course will enable you to develop your Database Design, become a Business Analyst and unlock your full potential.

This The Complete MS SQL Course course covers:

1. What you need to know
2. Tailoring your approach to maximise impact
3. Mastering SQL Environment Setup
4. SQL Statement Basics
5. SQL Query Operators

You’ll also be able to access a number of exclusive bonus resources to help you along your The Complete MS SQL Course journey, including:

• Subqueries
• Data Definition Language (DDL) & Data Manipulation Language (DML)

Course Curriculum :

Course Introduction

• Introduction
• Course Curriculum overview
• Overview of Databases

SQL Environment Setup

• MSSQL Installation
• MSSQL Management Studio Installation
• Connecting to MS-SQL (Windows Authentication)
• Connecting to MS-SQL (SQL Server Authentication)

SQL Statement Basics

• Overview of Challenges
• SQL Statement Basic
• SELECT Statement
• SELECT DISTINCT
• Column AS Statement
• COUNT

Filtering Data Rows

• SELECT WHERE Clause – One
• SELECT WHERE Clause – Two

SQL Query Operators

• ORDER BY
• TOP in MSSQL
• BETWEEN
• IN
• LIKE

Overview of GROUP BY

• Aggregation Function – SUM()
• Aggregation Function – MIN()-MAX()
• GROUP BY – One(theory)
• GROUP BY – Two(practical)
• HAVING

JOINS

• Overview of JOINS
• Introduction to JOINS
• AS Statement
• INNER Join
• Full Outer Join
• Left Outer Join
• Right Outer Join
• Union

Advanced SQL Commands

• Basic of Advanced SQL Commands
• Timestamp
• Extract from Timestamp
• Mathematical Scalar Functions
• String Functions
• Sub Query

Creating Database and Tables

• Basic of Database and Tables
• Data Types
• Select Data type on SSMS
• Create Table on SSMS
• How to set Primary Key
• How to set Foreign Key
• Create Table using SQL Script

SQL CRUD Operations

• Insert
• Update
• Delete
• Alter Table
• Drop Table
• Check Constraint
• NOT NULL Constraint
• UNIQUE Constraint

Backup and Restore Functions

• Overview of Database and Tables
• Creating a Database backup using SSMS
• Restoring a Database from backup using SSMS

Top reasons to Study Online at Frontier Education

• Tailor made: Course adapted to market needs and interests

• Flexible programs: study and work at your own pace on easy-to-use web platforms

• Online education: progressive teaching methods with video or easy to understand medium

• Multicultural: connect with classmates from all corners of the globe

This Complete MS SQL Course is ideal for people looking to progress their career into a Data Analyst, for those who want to become Financial Analyst, as well as looking to further develop their skills and knowledge.

• Positive attitude and desire to learn

• Passion to become SQL database administrator

There are currently no Q&As for this course. Be the first to ask a question.