Master SQL fundamentals and database management using Microsoft SQL Server

About Course

This course provides a thorough introduction to Microsoft SQL Server, guiding learners from basic database concepts to advanced SQL querying. It covers installation, creating and managing databases and tables, performing data manipulation with SELECT, INSERT, UPDATE, and DELETE statements, and executing complex queries including joins and aggregate functions. Additionally, it explores database optimization techniques, security practices, and integration with business intelligence tools. The course includes hands-on exercises to build proficiency in efficient data management and analysis using SQL Server.

Course Content

Introduction

Introduction

00:00
Database Concepts

00:00
Data Types

00:00

Installation and Setup

Structured Query Language – SQL

Intro To SQL

00:00
Select Statements

00:00
Where Clause

00:00
And or Not

00:00
Order By

00:00
Group By

00:00
The Having Clause

00:00
The Top Clause

00:00
Select Distinct

00:00
Union

00:00
Functions

00:00
Insert Statement

00:00
Update Statement

00:00
Delete Statement

00:00
Alter Table

00:00
Null

00:00
Creating A Table

00:00
Drop Table

00:00
Primary Key

00:00
Intro To Joining Tables

00:00
Inner Join

00:00
Left, Right, and Outer Join

00:00
Indexing

00:00

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Master SQL fundamentals and database management using Microsoft SQL Server

About Course

What Will You Learn?

Course Content

Introduction

Introduction

Database Concepts

Data Types

Installation and Setup

Download and Install SQL Serve

Download and Install SSMS

Connect To Server

System Databases

Creating a Database and Table

Adding Data To A Table

Structured Query Language – SQL

Intro To SQL

Select Statements

Where Clause

And or Not

Order By

Group By

The Having Clause

The Top Clause

Select Distinct

Union

Functions

Insert Statement

Update Statement

Delete Statement

Alter Table

Null

Creating A Table

Drop Table

Primary Key

Intro To Joining Tables

Inner Join

Left, Right, and Outer Join

Indexing

Earn a certificate

About Course

What Will You Learn?

Course Content

Introduction

Introduction

Database Concepts

Data Types

Installation and Setup

Download and Install SQL Serve

Download and Install SSMS

Connect To Server

System Databases

Creating a Database and Table

Adding Data To A Table

Structured Query Language – SQL

Intro To SQL

Select Statements

Where Clause

And or Not

Order By

Group By

The Having Clause

The Top Clause

Select Distinct

Union

Functions

Insert Statement

Update Statement

Delete Statement

Alter Table

Null

Creating A Table

Drop Table

Primary Key

Intro To Joining Tables

Inner Join

Left, Right, and Outer Join

Indexing

Earn a certificate

Student Ratings & Reviews