Business Intelligence
Preview
Open in TheBrain
Business Intelligence
T-SQL Study Guide
Parents
Business Intelligence
Children
Advanced Query Techniques
Aggregate Functions
Basic SELECT Queries
Common Table Expressions (CTEs)
Data Modification with INSERT, UPDATE, DELETE
Filtering with WHERE
Grouping with GROUP BY
Indexes
Introduction to T-SQL
Performance Tuning
Security and Permissions
Sorting with ORDER BY
Stored Procedures
Subqueries and Nested Queries
T-SQL Best Practices
Transactions and Error Handling
Triggers
User-Defined Functions
Using JOINs
Views
Window Functions