Scribd
Upload
9 views

Data Warehouse SQL Syllabus

Uploaded by

gaura nitai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views

Data Warehouse SQL Syllabus

Uploaded by

gaura nitai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Data Ware House AND SQL Syllabus

Session 1:

• Syllabus Explanation

• Faculty Introduction

Session 2:

• Data and Understanding

• What is the difference between database and Cloud

• What are the different technologies along with Data Analytics Demo

DATA WAREHOUSE

 SDLC
 DATABASE VS WAREHOUSE
 ACID property
 ETL
 ODS
 Data MART
 OLAP vs OLTP
 ER MODEL
 DIM MODEL
 STAR & SNOWFLAKE SCHEMA
 SK
 Type of FACTS
 SCD Type1,2,3,hybrid
 Degenerated dim
 Junk dim
 Confirmed or bridge dim
 Data Lineage

SQL

• Installation of MySQL and oracle 11g

Course subjeCts starts SQL (Structured Query Language) Introduction to SQL

➢ What is SQL?

➢ What is Database?
➢ Difference between SQL and Database

➢ Types of SQL Commands

➢ Relationships in SQL ✓ One to One, One to Many, Many to One, Many to Many

➢ Comments in SQL ✓ Single Line Comment ✓ Multiple Line Comment

➢ Alias in SQL

➢ Database Commands ✓ Create Database ✓ Create Schema ✓ Drop Database ✓ Show Database

➢ Datatypes in SQL

➢ Table Commands ✓ CREATE TABLE ✓ DROP TABLE ✓ ALTER TABLE - MODIFY COLUMN - ADD
COLUMN - DROP COLUMN - RENAME COLUMN ✓ INSERT INTO ✓ UPDATE ✓ DELETE ✓ DROP
✓TRUNCATE

➢ Constraints in SQL ✓ NOT NULL ✓ UNIQUE ✓ DEFAULT ✓ CHECK ✓ PRIMARY KEY ✓ FOREIGN KEY

➢ Operators in SQL ✓ Arithmetic Operators ✓ Comparison Operators ✓ Logical Operators ✓ Range


Operators ✓ String and Wildcard Operators ✓ Regular Expressions Foreign Key,>
<
=
is null
is not null
like
&&
OR
EXISt
In
BETWEEN
LIKE %, _

➢ Clauses in SQL ✓ SELECT ✓ FROM ✓ WHERE ✓ GROUP BY ✓ ORDER BY ✓ HAVING ✓ TOP/LIMIT


Literals || order by

 GROUP BY MAX,MIN,AVG,COUNT… HAVING clause… diff bet having n where… diff bet count(10,
count(*), and count(distinct id)

➢ Functions in SQL ✓ Text/String Functions ✓ Numeric Functions ✓ Date and Time Functions ✓ Null
Functions ✓ Aggregate Functions TO CHAR TONUMBER TODATE
ADD HOURS MINS SEC
Character functions 4 concat, trim,replace,regex_replace, nvl, collease, …………….
Number functions 1 MOD, AVG, SUM, COUNT, MIN, DISTINCT, UNIQUE
Date functions 1 EXTRACt,TO_CHAR, SYSDATE,CURRENT_DATE,ADD_MONTH

➢ JOINS ✓ Cross Join ✓ Inner Join ✓ Outer Join - LEFT (Inclusive, Exclusive) - RIGHT (Inclusive,
Exclusive) - FULL (Inclusive, Exclusive) ✓ Self-join

➢ Set operators.

➢ Sub Queries

➢ Views

➢ Synonyms

➢ Indexing

➢ Case Statements

➢ Window Functions ✓ Over, Partition By, Order by ✓ Row Number, First Value, Last Value, Nth Value,
Rank, Dense Rank, Lead, Lag

You might also like