Data Warehousing and SQL End to End

Become an expert at SQL and learn SQL end to end, clear all your concepts of SQL in depth and become SQL expert

4.42 (870 reviews)

Udemy

platform

English

language

IT Certification

What you will learn

How to use SQL to query a database

Use SQL to data analysis

Introduction to Data Warehousing

Facts and Dimensions

Normalization and Denormalization

Constraints in SQL

Inserts in the table

Operators and clauses in SQL

Functions in SQL (Single Row functions, Multiple Row functions)

Joins in SQL

Sub Queries in SQL (Start Single Row SubQuery, Start Multiple Row SubQuery, Start Multiple Column, Scalar and Correlated Subqueries, Start Exists and With Clauses)

Set Operators in SQL (Union, Unionall, Intersect, Minus)

Manipulating Data

Using DDL Statements to Create and Manage Tables

Creating Other Schema Objects

Manipulating Large Data Sets

Regular Expression Support

Course Gallery

Data Warehousing and SQL End to End – Screenshot 1 — Screenshot 1 – Data Warehousing and SQL End to End

Data Warehousing and SQL End to End – Screenshot 2 — Screenshot 2 – Data Warehousing and SQL End to End

Data Warehousing and SQL End to End – Screenshot 3 — Screenshot 3 – Data Warehousing and SQL End to End

Data Warehousing and SQL End to End – Screenshot 4 — Screenshot 4 – Data Warehousing and SQL End to End

Charts

Students

Price

Rating & Reviews

Enrollment Distribution