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.46 (737 reviews)
Udemy
platform
English
language
IT Certification
category
Rahul Tiwari
instructor
Data Warehousing and SQL End to End
4,135
students
30 hours
content
Jul 2021
last update
$74.99
regular price

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

Why take this course?

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?

  • 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!!!


Content

Introduction to Data warehousing and SQL

Introduction to Data warehousing and SQL

Facts and Dimensions

Facts and Dimension - Understanding

Normalization and Denormalization

Normalization and Denormalization - Understanding

Constraints in SQL

Constraints Part 1 - Primary Key and Foreign Key
Constraint Part 2 - Unique Key, Check and Not Null constraints

Inserts in the tables

Inserting the records , understand DDL, DML, DQL, DCL and TCL

Operators and Clauses in SQL

Operators and Clauses in SQL

Functions in SQL

Single Row functions - Part 1
Single Row functions - Part 2
Multiple Row Functions - Group by Clause

Joins in SQL

Joins in SQL - Part 1
Joins in SQL - Part 2
Joins in SQL - Part 3

Sub queries in SQL

Single Row Sub Queries
Multiple Rows Sub Queries
Multiple Column, Scalar and Correlated Subqueries
Exists and With Clause

Set Operators in SQL

Set Operators in SQL

Data Manipulation in SQL

Data Manipulation in SQL

Other Schema Objects

Views
Sequence, Synonym and Index

Managing Schema Objects

Alter Statement

Manipulating Large Datasets

Multitable Inserts
Merge Statement

Hierarchical Queries - Connect with Prior

Hierarchical Queries - Connect with Prior

Screenshots

Data Warehousing and SQL End to End - Screenshot_01Data Warehousing and SQL End to End - Screenshot_02Data Warehousing and SQL End to End - Screenshot_03Data Warehousing and SQL End to End - Screenshot_04

Reviews

Mastan
September 6, 2023
Explained all the topics in detail with examples. Once who completed this course can easily write any queries.
Omar
June 2, 2023
Some words are not very well undestandable and the content can be summarized in a shorter time. I do not have any support from teacher.
Sidharth
April 21, 2023
The course content is good. The instructor explains every concept in detail. But the transcript was wrong several times.
Venkatesh
January 28, 2023
I clearly understood the Data warehouse concepts which was discussed in the intro section . Sir , i would like to tell about your teaching , it was amazing . Thanks for your effort to understanding the concepts to people
Jay
December 27, 2022
I don't need those intro taking up 14 minutes. I was not impressed. Not sure what to make of all this sql examples. It is not necessary to go on an on forever as you do. The point is gotten.
Sherif
October 19, 2022
Repeating same words over and over again like hi is in the front of full class of students and trying to interact with them. Wasting a lot of time doing that. Not well organized
Rahul
October 16, 2022
This is a great course. Mr. Rahul is having very depth knowledge of the topics. Since this is recorded session, and we come across with doubt. It is difficult to get it clear on the spot, but we query our doubt and get it cleared.
Tharun
August 21, 2022
This course has deep dive experience with some concepts like sub queries,Hierarchial queries, Regex and Analytical functions which really helped me to refresh my skills. Most importantly the interview preparation section has very good questions if anyone can solve this questions then any interview can be cracked easily. Guidance is important for any course and this course is a perfect guide to learn SQL. Though you have some experience in SQL still it helps in your approach towards writing queries. My experience on 30 hour duration for the course is worth if we spend 30 hours and extra 60 hours for practice (apart from interview questions in the last) then this will help in reaching extra heights in SQL. From now on if at all I feel anytime to refresh again I will definitely use this course. Thank you for teaching and your guidance. Thanks to concentrix catalyst for the course.
Jay
April 26, 2022
A great instructor, explains your doubts even before you think about them. Every time a query rises in your head, he's there to solve it in the lecture itself. I don't know how you do it, but enjoying learning a lot.
Manish
March 24, 2022
The way Mr Rahul sir has taught in the video was very easy to understand,it was commendable effort from sir the way they teach ,thank u sir
Roli
March 24, 2022
Amazing course. Here trainer is explaining with very simple examples. Anyone who are looking to learn from scratch they can go for this course. Very nicely explained and lot of interesting concepts covered in this. Highly recommended for freshers and who are new to SQL and Data warehouse world.
Mohammed
March 24, 2022
Classes are very engaging and Instructor is giving a very detailed and In Depth explanation of important concepts of SQL, With industry level examples and business scenarios this is I think a goto Course who is looking to learn SQL with no prerequisite. Great course I highly recommend!
Vijay
March 22, 2022
This is some other training which trainer had already recorded with students, and have put it in Udemy. He is talking to students in the training as if this is live training. Even content and presentation is immature and very basic.
Edwin
February 8, 2022
very poor explanation of degenerate dimension. Instructor get confused explaining "IN" and "IS" operators Instructor confuses audience using "WITH"
Vijayalaxmi
August 16, 2021
Classes are engaging and with many examples. Comprehensive yet detailed. On the go practical analysis and validation of the logic of the queries. Multilevel uderstanding of the behavior of the code. I enjoy this course

Charts

Price

Data Warehousing and SQL End to End - Price chart

Rating

Data Warehousing and SQL End to End - Ratings chart

Enrollment distribution

Data Warehousing and SQL End to End - Distribution chart

Related Topics

SQL
3269868
udemy ID
6/25/2020
course created date
8/2/2020
course indexed date
Bot
course submited by