- Slack Details for Communication
Online
₹ 479 3,499
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
For business analysts, data scientists, and anybody else who works with data, SQL is among the most demanded talents. SQL is one of the most sought IT skills today, and learning it is one of the simplest ways to increase one's professional opportunities. The Data Warehousing and SQL End to End certification course has been created by Rahul Tiwari, a Professional Data Scientist, Consultant, and Trainer, and is available through Udemy which is aimed at candidates who want to learn the fundamentals of data warehousing and SQL to become successful SQL specialists.
Data Warehousing and SQL End to End online course aim to teach students how to read and write complicated queries to a database employing Oracle SQL, which can also be applied to other major SQL databases including Amazon Redshift, MySQL, Microsoft SQL Server, PostgreSQL, and others. By the end of the Data Warehousing and SQL End to End online classes, candidates will have obtained the ability to use SQL to query a database and use SQL to analyze data.
The highlights
- Certificate of completion
- Self-paced course
- 30 hours of pre-recorded video content
- 1 article
- 31 downloadable resources
- 30-day money-back guarantee
Program offerings
- Online course
- 30-day money-back guarantee
- Learning resources
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
certificate availability
certificate providing authority
What you will learn
After completing the Data Warehousing and SQL End to End online certification, candidates will be introduced to the fundamentals of data warehousing as well as SQL functionality. Candidates will explore the basics of normalization and denormalization. Candidates will learn about the strategies involved with data manipulation and data analysis using SQL. Candidates will also acquire deep knowledge about regular expressions, operators, queries, and clauses.
Who it is for
The syllabus
Slack Channel
Introduction to Data warehousing and SQL
- How this course helped a fresher
- About Instructor and the Feedback
- 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 141
- 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
Regular Expressions in SQL
- Regular Expressions in SQL
Analytics Functions in SQL
- Analytics Functions in SQL - Part 1
- Analytics Functions in SQL - Part 2
Materialized Views
- Materialized Views
SQL Interview Prep
- SQL Interview Prep (Advanced Select) - Part 1
- SQL Interview Prep (Advanced Select) - Part 2
- SQL Interview Prep (Advanced Select) - Part 3
- SQL Interview Prep (Joins) - Part 4
- SQL Interview Prep (Joins) - Part 5
- SQL Interview Prep (Joins) - Part 6
- SQL Interview Prep (Joins) - Part 7
Instructors
Mr Rahul Tiwari
Instructor
Freelancer