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
Data Warehousing and SQL End to End
File Size :
15.09 GB
Total length :
29h 59m

Category

Instructor

Rahul Tiwari

Language

Last update

Last updated 7/2021

Ratings

4.4/5

Data Warehousing and SQL End to End

What you’ll 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

Data Warehousing and SQL End to End

Requirements

Passion to learn SQL

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 syntaxAnalyzing data using aggregate functions with GROUP BY commandsRunning advanced queries with string operations and comparison operationsSet Operators Subqueries, correlated subqueriesLearn to use logical operators to add logic flow to your SQL queriesLearn common SQL JOIN commandsLearn to create tables and databases with constraints on data entriesand 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 transactionsSQL 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!!!

Overview

Section 1: Slack Channel

Lecture 1 Slack Details for Communication

Section 2: Introduction to Data warehousing and SQL

Lecture 2 How this course helped a fresher

Lecture 3 About Instructor and the Feedback

Lecture 4 Introduction to Data warehousing and SQL

Section 3: Facts and Dimensions

Lecture 5 Facts and Dimension – Understanding

Section 4: Normalization and Denormalization

Lecture 6 Normalization and Denormalization – Understanding

Section 5: Constraints in SQL

Lecture 7 Constraints Part 1 – Primary Key and Foreign Key

Lecture 8 Constraint Part 2 – Unique Key, Check and Not Null constraints

Section 6: Inserts in the tables

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

Section 7: Operators and Clauses in SQL

Lecture 10 Operators and Clauses in SQL

Section 8: Functions in SQL

Lecture 11 Single Row functions – Part 1

Lecture 12 Single Row functions – Part 2

Lecture 13 Multiple Row Functions – Group by Clause

Section 9: Joins in SQL

Lecture 14 Joins in SQL – Part 1

Lecture 15 Joins in SQL – Part 2

Lecture 16 Joins in SQL – Part 3

Section 10: Sub queries in SQL

Lecture 17 Single Row Sub Queries

Lecture 18 Multiple Rows Sub Queries

Lecture 19 Multiple Column, Scalar and Correlated Subqueries

Lecture 20 Exists and With Clause

Section 11: Set Operators in SQL

Lecture 21 Set Operators in SQL

Section 12: Data Manipulation in SQL

Lecture 22 Data Manipulation in SQL

Section 13: Other Schema Objects

Lecture 23 Views

Lecture 24 Sequence, Synonym and Index

Section 14: Managing Schema Objects

Lecture 25 Alter Statement

Section 15: Manipulating Large Datasets

Lecture 26 Multitable Inserts

Lecture 27 Merge Statement

Section 16: Hierarchical Queries – Connect with Prior

Lecture 28 Hierarchical Queries – Connect with Prior

Section 17: Regular Expressions in SQL

Lecture 29 Regular Expressions in SQL

Section 18: Analytics Functions in SQL

Lecture 30 Analytics Functions in SQL – Part 1

Lecture 31 Analytics Functions in SQL – Part 2

Section 19: Materialized Views

Lecture 32 Materialized Views

Section 20: SQL Interview Prep

Lecture 33 SQL Interview Prep (Advanced Select) – Part 1

Lecture 34 SQL Interview Prep (Advanced Select) – Part 2

Lecture 35 SQL Interview Prep (Advanced Select) – Part 3

Lecture 36 SQL Interview Prep (Joins) – Part 4

Lecture 37 SQL Interview Prep (Joins) – Part 5

Lecture 38 SQL Interview Prep (Joins) – Part 6

Lecture 39 SQL Interview Prep (Joins) – Part 7

Beginner who has passion to learn SQL,Who wants to learn SQL End to End

Course Information:

Udemy | English | 29h 59m | 15.09 GB
Created by: Rahul Tiwari

You Can See More Courses in the IT & Software >> Greetings from CourseDown.com

New Courses

Scroll to Top