Data Warehousing and SQL End to End

person icon Rahul Tiwari

4.2 ★★★★ ★

Buy Now

Data Warehousing and SQL End to End

Name: Data Warehousing and SQL End to End
Rating: 4.2 (148 reviews)
Author: Rahul Tiwari

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Rahul Tiwari

category icon IT & Software,IT Certification,SQL

Lectures -29

Duration -24.5 hours

4.2 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

You'll learn how to read and write complex queries to a database using one of the most in-demand skills - Oracle SQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, PostgreSQL, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in-demand tech skills! In this course, you'll learn quickly and receive challenges and tests along the way to improve your understanding!

In this course, you will learn everything you need to become a SQL expert! Including:

Get started with SQL
Learn the basics of SQL syntax
Analyzing data using aggregate functions with GROUP BY commands
Running advanced queries with string operations and comparison operations
Set Operators
Subqueries, correlated subqueries
Learn to use logical operators to add logic flow to your SQL queries
Learn common SQL JOIN commands
Learn to create tables and databases with constraints on data entries
and much, much more!
What is a data warehouse?
What is the need for a data warehouse?
What is the difference between a data warehouse and a data lake?
The bottom-up and top-down approach of data warehousing project.
OLTP and OLAP transactions

SQL is one of the most in-demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skillset quickly and add SQL to your resume by joining today!

All the very best!!!

Who this course is for:

A beginner who has a passion to learn SQL
Who wants to learn SQL End to End

Goals

What will you learn in this course:

How to use SQL to query a database
Use SQL for 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

Prerequisites

What are the prerequisites for this course?

Basic knowledge of computers
Passion to learn SQL

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction to Data Warehouse
1 Lectures

Introduction to Data Warehouse 53:48 53:48

Introduction to Facts and Dimensions
1 Lectures

Introduction to Normalization
1 Lectures

Constraints in Oracle
2 Lectures

Commands
1 Lectures

Operators and Clauses
1 Lectures

Single Row Functions
2 Lectures

Multi Row Functions
1 Lectures

Joins
3 Lectures

Single Row Sub Query
1 Lectures

Multiple Row SubQuery
1 Lectures

Correlated Sub Queries
1 Lectures

Exists and With Clause
1 Lectures

Set Operators
1 Lectures

Data Manipulation
1 Lectures

Views
1 Lectures

Other Objects
1 Lectures

Alter Statements
1 Lectures

Multi Table Inserts
1 Lectures

Merge
1 Lectures

Connect by Prior
1 Lectures

Regular Expressions
1 Lectures

Analytics Functions
2 Lectures

Materialized Views
1 Lectures

Instructor Details

Rahul Tiwari

I train and give consultation to organizations and individuals on Business Analytics, Data Science, and Machine Learning. For 14 years I have been helping Professionals and organizations in various domains like retail, telecom, life sciences, finance, etc. in solving their business problems using Data Science, Business Analytics, and Machine Learning.

After starting my career 14 years back in Data Warehousing I moved onto the Data Science domain and held various roles. Mostly working with CTOs, Key IT decision-makers, and Professionals, I have always been focusing on building capacity, knowledge and solutions in Data Science, Business Analytics, and Machine Learning.

Course Certificate

Use your certificate to make a career change or to advance in your current career.