Trang chủ

IT & Software

IT Certifications

SQL

Data Warehousing and SQL End to End

Loại khoá học: IT Certifications

Become an expert at SQL and learn SQL end to end, clear all your concepts of SQL in depth and become SQL expert

50.000 VND

399.000 VND

Đầy Đủ Bài Giảng

Học Online Tiện Lợi

Kích Hoạt Nhanh 2-5 Phút

Thanh toán tự động

Được phép tải xuống

Mô tả

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

Bạn sẽ học được gì

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

Yêu cầu

Passion to learn SQL

Nội dung khoá học

19 sections

Introduction to Data warehousing and SQL

1 lectures

Introduction to Data warehousing and SQL

53:51

Facts and Dimensions

1 lectures

Facts and Dimension - Understanding

01:00:59

Normalization and Denormalization

1 lectures

Normalization and Denormalization - Understanding

43:55

Constraints in SQL

2 lectures

Constraints Part 1 - Primary Key and Foreign Key

54:40

Constraint Part 2 - Unique Key, Check and Not Null constraints

46:37

Inserts in the tables

1 lectures

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

42:50

Operators and Clauses in SQL

1 lectures

Operators and Clauses in SQL

01:15:12

Functions in SQL

3 lectures

Single Row functions - Part 1

01:18:34

Single Row functions - Part 2

01:04:33

Multiple Row Functions - Group by Clause

01:06:03

Joins in SQL

3 lectures

Joins in SQL - Part 1

55:17

Joins in SQL - Part 2

53:17

Joins in SQL - Part 3

27:10

Sub queries in SQL

4 lectures

Single Row Sub Queries

40:36

Multiple Rows Sub Queries

31:15

Multiple Column, Scalar and Correlated Subqueries

57:28

Exists and With Clause

54:41

Set Operators in SQL

1 lectures

Set Operators in SQL

46:56

Data Manipulation in SQL

1 lectures

Data Manipulation in SQL

56:44

Other Schema Objects

2 lectures

Views

49:45

Sequence, Synonym and Index

01:07:58

Managing Schema Objects

1 lectures

Alter Statement

54:39

Manipulating Large Datasets

2 lectures

Multitable Inserts

54:42

Merge Statement

26:07

Hierarchical Queries - Connect with Prior

1 lectures

Hierarchical Queries - Connect with Prior

24:26

Regular Expressions in SQL

1 lectures

Regular Expressions in SQL

01:13:03

Analytics Functions in SQL

2 lectures

Analytics Functions in SQL - Part 1

47:17

Analytics Functions in SQL - Part 2

44:49

Materialized Views

1 lectures

Materialized Views

47:37

SQL Interview Prep

7 lectures

SQL Interview Prep (Advanced Select) - Part 1