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