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
IT & Software,IT Certification,SQL
Lectures -29
Duration -24.5 hours
30-days Money-Back Guarantee
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.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now