Data Management and Analysis Using SQL Server

0(0 Ratings)

Level

All Levels
Total Enrolled

5
Duration

2 hours 5 minutes
Last Updated

December 17, 2024
Certificate

Certificate of completion

Level

All Levels
Total Enrolled

5
Duration

2 hours 5 minutes
Last Updated

December 17, 2024
Certificate

Certificate of completion

Course content:

Data Management and Analysis Using SQL Server

Database

02:19
Table

01:09
A schema

00:41
Relational Database

01:05
A primary key and A foreign key

02:47
Relationships between Tables

01:04
One-to-One

00:27
One-to-Many

00:28
Many-to-Many

00:22
A relational database management system (RDBMS)

00:55
SQL (Structured Query Language)

00:52
Type of sql commands

01:56
DDL – Data Definition Language

00:50
DQL – Data Query Language

00:47
DML – Data Manipulation Language

00:42
DCL – Data Control Language

00:38
TCL – Transaction Control Language

00:40
SQL Server Management Studio (SSMS)

01:06
Install SQL Server Developer and SQL Server Management Studio (SSMS)

10:38
SSMS Overview

03:38
Transportation database and Install transportation database

06:40
SQL Resources Files

00:09
SQL Server Data Types

02:28
SELECT

01:49
AND – OR conditions

04:01
ORDER BY

02:07
DISTINCT

00:42
Between

00:36
IN

01:41
like

02:00
Introduction to Joins

02:17
Inner JOIN

04:05
Left JOIN

02:57
Right JOIN

01:21
Full JOIN

01:51
Aggregation functions and Groupby

03:15
SUM

00:59
AVERAGE

00:28
COUNT

00:47
MIN

00:17
MAX

00:25
Groupby

01:18
Having

01:08
String Functions

03:04
Date Functions

05:32
Conversion Functions

01:49
Introduction to SQL subquery

00:40
Noncorrelated Subqueries

01:44
Correlated Subqueries

01:13
Window functions

00:50
ROW_NUMBER()

02:02
RANK()

01:56
DENSE_RANK()

01:39
CASE statement

02:09
Qualify vs Having

01:10
CTE Tables

01:22
Transportation Analysis Project

23:53
SQL quiz

Master SQL fundamentals, including tables, schemas, keys, and relationships between data.
Use essential commands like SELECT, JOINs, GROUP BY, and aggregation functions for data querying and analysis.
Explore advanced features such as subqueries, window functions, and Common Table Expressions (CTEs).
Gain practical experience with SQL Server Management Studio (SSMS) and work on a real-world Transportation Database.

No Review Yet

Instructor:

Eng Mohammed

Big Data Engineer and Data Consultant @ ISD Company

Data Management and Analysis Using SQL Server

Course content:

Data Management and Analysis Using SQL Server

Database

Table

A schema

Relational Database

A primary key and A foreign key

Relationships between Tables

One-to-One

One-to-Many

Many-to-Many

A relational database management system (RDBMS)

SQL (Structured Query Language)

Type of sql commands

DDL – Data Definition Language

DQL – Data Query Language

DML – Data Manipulation Language

DCL – Data Control Language

TCL – Transaction Control Language

SQL Server Management Studio (SSMS)

Install SQL Server Developer and SQL Server Management Studio (SSMS)

SSMS Overview

Transportation database and Install transportation database

SQL Resources Files

SQL Server Data Types

SELECT

AND – OR conditions

ORDER BY

DISTINCT

Between

IN

like

Introduction to Joins

Inner JOIN

Left JOIN

Right JOIN

Full JOIN

Aggregation functions and Groupby

SUM

AVERAGE

COUNT

MIN

MAX

Groupby

Having

String Functions

Date Functions

Conversion Functions

Introduction to SQL subquery

Noncorrelated Subqueries

Correlated Subqueries

Window functions

ROW_NUMBER()

RANK()

DENSE_RANK()

CASE statement

Qualify vs Having

CTE Tables

Transportation Analysis Project

SQL quiz

What you will learn:

Course requirements:

This course includes:

Reviews

Instructor:

All rights reserved © 2024

Privacy Policy

Privacy Policy

Privacy Policy

Privacy Policy