1. day 5
1.1. revision
1.2. hands on
1.3. objective test
2. day 2
2.1. level constraint
2.1.1. table level
2.1.2. column level
2.2. Normalization
2.2.1. 1nf
2.2.1.1. atomic
2.2.2. 2nf
2.2.2.1. partial
2.2.2.2. functional dependency
2.2.3. 3nf
2.2.3.1. in 2nf
2.2.3.2. not tranisitive
2.3. distinct
2.4. operators
2.4.1. like
2.4.2. exists
2.4.3. commit
2.5. DCL
2.5.1. rollback
2.5.2. savepoint
2.5.3. commit
2.5.4. insert
2.5.5. select
2.5.6. delete
2.5.7. %_%
2.5.8. order by
3. day 4
3.1. built in function
3.1.1. string function
3.1.2. numeric function
3.1.3. datetime function
3.1.4. special function
3.1.5. conversion function
3.2. set opertors
3.2.1. union
3.2.2. union all
3.2.3. intersect
3.2.4. except
3.3. common table expression
3.4. views
3.4.1. with
3.4.2. advanced analysis/windows function
3.4.2.1. ranking
3.4.2.2. row_number
3.4.2.3. percentage_rank
3.4.2.4. first_value
3.4.2.5. lag
3.4.3. aggregration
3.4.3.1. avg
3.4.3.2. min
3.4.3.3. max
3.4.3.4. sum
3.4.4. joins
3.4.4.1. left
3.4.4.2. right
3.4.4.3. inner
3.4.4.4. outer
3.4.5. where exists
3.4.6. loops
3.4.6.1. repeat
3.4.6.2. for loop
3.4.7. stored procedure
3.4.7.1. object in db
3.4.7.2. simple stored procedure
3.4.7.3. stored procedure with cursor
3.4.7.4. user defined function
3.4.7.5. stored procedure with conditional logic
4. day 3
4.1. migration
4.2. sub query
4.3. co-realted query
4.4. where
4.5. having
4.6. group by
4.7. normalization
5. day1
5.1. data
5.1.1. what is data
5.2. Dbms
5.2.1. database
5.2.2. dbms
5.2.3. crud
5.3. relational DBMS
5.4. SQL Server
5.4.1. database engine
5.4.1.1. OLTP
5.4.1.2. OLAP
5.4.2. integration services
5.4.2.1. Flat files
5.4.3. Reporting services
5.4.4. Analysis services
5.4.5. Replication Services
5.5. Entity relationship diagram
5.5.1. entity
5.5.2. record
5.5.3. degree
5.5.4. cardinality
5.5.5. primary key
5.5.6. composite pk
5.5.7. default
5.5.8. candidate key
5.5.9. alternate key
5.5.10. cardinality
5.5.10.1. 1-M
5.5.10.2. 1-1
5.5.10.3. m-n
5.6. SQL
5.6.1. DDL
5.6.1.1. create
5.6.1.2. alter
5.6.1.3. drop
5.6.1.4. rename
5.6.2. DML
5.6.2.1. insert
5.6.2.2. update
5.6.2.3. delete
5.6.2.4. select
5.6.3. TCL
5.6.3.1. commit
5.6.3.2. rollback
5.6.3.3. savepoint
5.6.4. DCL
5.6.4.1. grant
5.6.4.2. revoke
5.6.4.3. deny
5.7. datatypes
5.7.1. numerics
5.7.1.1. decimal
5.7.1.2. numeric
5.7.1.3. int
5.7.1.4. float
5.7.1.5. real
5.7.2. strings
5.7.2.1. string
5.7.2.2. varchar
5.7.2.3. text
5.7.2.4. nvarchar
5.7.3. date and time
5.7.3.1. date
5.7.3.2. time
5.7.4. binary