Praktik peningkatan performa SQL Server untuk mengelola data yang jumlahnya besar. Dilengkapi dengan pembahasan studi kasus terkait pembuatan query SQL yang efisien, pembuatan desain database, pembuatan store procedure, triggers, event & view serta penerapan beberapa teknik konfigurasi untuk mengoptimasi performa SQL Server
CONTENT
1. Review of SQL Basics
1.1. Recap of Fundamental SQL Concepts and Syntax
1.2. Refreshing Knowledge of Querying and Manipulating Data
1.3. Normalization of Your Data
2. Advanced Querying Techniques
2.1. Complex Joins and Subqueries
2.2. Common Table Expressions (CTEs)
2.3. Window Functions for Ranking and Aggregation
2.4. Pivoting and Unpivoting Data
3. Indexing and Query Optimization
3.1. Understanding Indexes and Their Types
3.2. Indexing Strategies and Best Practices
3.3. Query Execution Plans and Performance Tuning
3.4. Analyzing and Optimizing Query Performance
4. Stored Procedures, Functions, and Triggers
4.1. Creating and Managing Stored Procedures
4.2. Scalar and Table-valued Functions
4.3. Using Triggers for Enforcing Business Rules
4.4. Error Handling and Transactions in Stored Procedures
5. Advanced Data Manipulation
5.1. Bulk Data Operations (BULK INSERT, BCP, OPENROWSET)
5.2. Dynamic SQL and Parameterized Queries
5.3. Working with XML and JSON Data
5.4. Manipulating Data using MERGE Statement
6. Views and Indexed Views
6.1. Creating and Managing Views
6.2. Materialized (Indexed) Views
6.3. Performance Considerations for Views
6.4. Updating Data Through Views
7. Working with Large Data Sets
7.1. Partitioning Tables and Indexes
7.2. Table Compression Techniques
7.3. Data Archiving and Purging Strategies
Course Features
- Lectures 9
- Quizzes 2
- Duration 40 hours
- Skill level All levels
- Language English
- Students 18
- Certificate Yes
- Assessments Yes
