T-SQL/MSBI Knowledge Share

TSQL/MSBI Youtube Links



  1. TSQL/MSBI Knowledge Share Videos: SSRS Nested DrillDown Report
  2. TSQL/MSBI Knowledge Share Videos: SSRS Linked Report
  3. TSQL/MSBI Knowledge Share Videos: SSRS DrillThrough Report
  4. TSQL/MSBI Knowledge Share Videos: SSRS Drill Down Report With Total
  5. TSQL/MSBI Knowledge Share Videos: SSRS Cascading Parameters Report
  6. TSQL/MSBI Knowledge Share Videos: SSRS Sub Report
  7. TSQL/MSBI Knowledge Share Videos: SSIS Transactions With SQL DB
  8. TSQL/MSBI Knowledge Share Videos: SSIS Transaction With files
  9. TSQL/MSBI Knowledge Share Videos :Working of SQL Server Clustered Index,Non Clustered Index,Key Lookup,RID Lookup, INCLUDE
  10. TSQL/MSBI Knowledge Share: Load Multiple Excel Sheet Data to Table
  11. SQL Server : Index Architecture
  12. Microsoft SQL Server Index Architecture
Home
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.