課程名稱：Microsoft Certified Azure Database Administrator Associate (1科 Azure SQL Database, 採用 SQL Server 2019 技術) 國際認可證書課程
- 簡稱：Azure Database Training Course |
1. Plan and Implement Data Platform
1.1 An Overview to Azure SQL
1.2 Deploying Resources by using Manual Methods
1.3 Basic Concept of Azure SQL Database
1.4 Fully Qualified Names
1.5 Transaction Log
1.6 Create a single database in Azure SQL Database using an ARM template
1.7 About Azure SQL Patching process
1.8 Recommend an Appropriate Database Offering Based on Specific Requirements
1.9 Protecting Sensitive Data with Always Encrypted
2. Azure SQL Identity and Access Control
2.1 Principals
2.2 SQL Server-level principal
2.3 Database Level Principals
2.4 Roles
2.5 Fixed Server Roles
2.6 Database Roles
2.7 Choosing an Authentication Mode
2.8 Securables
2.9 Permission Hierarchy
2.10 Reporting Permission
2.11 Assigning Permissions on database and within database securables
2.12 The DENY Permission
2.13 The GRANT OPTION
2.14 Granting Permission on Server Level Securables
2.15 Relationship between Database User, Fixed Database Role, Database Role and Schema
2.16 General Steps of Permission Check Algorithm
2.17 Row level permission
2.18 Dynamic Data Masking
3. Row Store Index
3.1 Creating an Row Store Index
3.2 Nonclustered and Clustered Index
3.3 Page and Extent
3.4 Non-Clustered Index with Included Columns
3.5 Using Included Columns to Avoid Size Limits
3.6 Summary of using Included Columns of a Non-clustered Index
3.7 Index Usage
3.8 Fill Factor
3.9 Filtered Index
3.10 Reorganizing Index
3.11 Using Database Maintenance Task for Index Reorganization of Entire Database
4. Standard Views and Indexed Views
4.1 Understanding Standard View
4.2 Using View to provide Backward Compatibility
4.3 CHECK OPTION
4.4 Designing and Implementing Indexed View
4.5 Using Hints with Indexed View
4.6 Detecting Discrepancy between Table and Indexed View
5. Statistics
5.1 Concept of Statistics
5.2 About Index Statistics
5.3 Optimizing Statistics Update process
6. Columnstore Index
6.1 Understanding data in Row and Columnar format
6.2 Introduction to Azure SQL Columnstore Index
6.3 Creating and Using a Non-Clustered Columnstore Index (NCCI)
6.4 Clustered Columnstore Index (CCI) for Real-time Operational Analytics
6.5 Comparing Non-Clustered Rowstore to Non Clustered Columnstore Index (NCCI) for DML Operations in a Real Time Analytics environment
6.6 About Filtered Non-Clustered Columnstore Index (NCCI)
6.7 Compression Delay option for Nonclustered Columnstore Index (NCCI)
6.8 Columnstore Index Defragmentation and Automation
7. Query Store
7.1 Monitoring performance by using the Query Store
7.2 Information in the Query Store
7.3 Regressed Queries
8. Cloud Migration
8.1 Introduction to Data Migration Assistant
8.2 Creating an Assessment
8.3 Migrate on-premises SQL Server to Azure SQL Database using the Data Migration Assistant
9. Disaster Recovery
9.1 Three Recovery Models
9.2 Types of Backup supported in Full Recovery Model
9.3 Performing Backup to Azure Storage Account
9.4 Performing Restore from Azure Storage account
10. Azure SQL Elastic Pool
10.1 Introduction to SQL Elastic Pool
10.2 Creating SQL Database Elastic Pool
10.3 Monitoring and Scaling Elastic Pool
|
繳付學費，過程簡便！
