T-SQL/MSBI Knowledge Share

Resume Format

Fresher Resume : Fresher_Resume.docx

No comments:

Subscribe to: Comments (Atom)

Author

Sreehari Katageri

View my complete profile

Data Warehouse Topics

Understanding Data Warehouse
Basic Data Warehouse Concepts
Types of Dimensions

T-SQL Topics

Database Overview
Key Constraints
Normalization
Joins & SELECT Sequence
Examples on T-SQL Joins
Tricky Join Examples
Truncate and Delete
Group By/Distinct/Count
Incremental loads and updates
Delete duplicate records
Temp table,Table variable,CTE
Sub Query
Basic Ranking function
Indexed Views
Clustered/Non-Clustered Index (Key Lookup/ Book Mark Lookup and RID Lookup)
T-SQL Miscellaneous 1
T-SQL Miscellaneous 2
T- SQL Miscellaneous 3
T-SQL Miscellaneous 4
T-SQL Miscellaneous 5
Maximum value from the multiple columns
Table Valued Parameter (TVP)
Row level security implementation
TSQL/MSBI Youtube Links
Resume Format
SQL Reference link

Some important SQL/MSBI links and articles

MSBI Knowledge Share
Important SQL/MSBI links

Total Blog views

Followers

Google Search

Powered by Blogger.