Data Warehousing and SQL End to End

Here we are discussing the detail about different types of facts and dimensions.

Facts:

• Additive facts

• semi-additive facts

• non-additive facts

• factless facts

Dimensions: 

• Slowly changing dimensions

• Conformed dimensions

• Degenerate dimensions

• Junk dimensions

• Role-playing dimensions

Normalization and Denormalization in a data warehouse.

Types of normalization

• 1NF

• 2NF

• 3NF

• 4NF

In this chapter, we are going to talk about constraints in sql

Primarily we are going to talk about primary and foreign keys in sql and why it is needed.

In this chapter, we are going to talk about other constraints

• Unique key constraint

• Check constraint

• Not null constraint

In this chapter, we are going to introduce how to insert the record in the table, and also we will give an understanding of various SQL commands like DDL, DML, DCL, DQL, and TCL.

In this video, we are going to talk about operators and clauses.

• Arithmetic operators

• Concatenation operator

• Comparison operator

• IS [NOT] NULL, LIKE, [NOT] IN

• [NOT] BETWEEN

• Not equal to

• NOT - Logical operator

• AND - Logical operator

• OR - Logical operator

We are going to talk about where clause and order by as well.

In this section, we are going to talk about Single row functions

Single row function -

• Character - It accepts the character as an input and returns both character or number values

• Number - It accepts numeric and gives output also as numeric

• Date - Operates on Date datatype

Character functions

Case manipulation

• Lower

• Upper

• INITCAP

Character manipulation

• Concat

• substr

• length

• instr

• Lpad | Rpad

• Trim

• Replace

Number functions

• Trunc

• Round

• Mod

Date functions

• months_between

• add_months

• next_day

• last_day

• round

• trunc