Education > MCSA: SQL Server Administration

MCSA: SQL Server Administration



• Database အေျခခံရွိၿပီးေသာသူမ်ားတက္ေရာက္ႏိုင္ပါသည္။
• International အသိအမွတ္ျပဳ SQL Server Database Administration အျဖစ္လုပ္ငန္းခြင္ဝင္ႏိုင္ပါသည္။


Querying Microsoft SQL Server 2012 (461)

• Foundations of Querying • Getting Started with the SELECT Statement
• Filtering and Sorting Data • Combining Sets
• Grouping and Windowing • Querying Full-Text Data
• Querying and Managing XML Data • Creating Tables and Enforcing Data Integrity
• Inserting, Updating, and Deleting Data • Using Tools to Analyze Query Performance
• Other Data Modification Aspects • Designing and Implementing T-SQL Routines
• Implementing Indexes and Statistics • Understanding Cursors, Sets, and Temporary Tables
• Implementing Transactions, Error Handling, and Dynamic SQL • Designing and Creating Views, Inline Functions, and Synonyms
• Understanding Further Optimization Aspects
 

Administering Microsoft SQL Server 2012 Databases (462)

• Planning and Installing SQL Server 2012 • Configuring and Managing SQL Server Instances
• Configuring SQL Server 2012 Components • Migrating, Importing, and Exporting
• SQL Server Logins, Roles, and Users • Securing SQL Server 2012
• Mirroring and Replication • Clustering and AlwaysOn
• Troubleshooting SQL Server 2012 • Indexes and Concurrency
• SQL Server Agent, Backup, and Restore • Code Case Studies
 

Implementing Data Warehouses with Microsoft SQL Server

• Designing and Implementing a Data Warehouse
- Data Warehouse Logical Design - Implementing a Data Warehouse

• Developing SSIS Packages
- Creating SSIS Packages - Designing and Implementing Control Flow - Designing and Implementing Data Flow

• Enhancing SSIS Packages
- Enhancing Control Flow - Enhancing Data Flow - Creating A Robust and Restart able Package
- Implementing Dynamic Packages - Auditing and Logging 381

• Managing and Maintaining SSIS Packages
- Installing SSIS and Deploying Packages - Executing and Securing Packages - Troubleshooting and Performance Tuning

• Building Data Quality Solutions
- Installing and Maintaining Data Quality Services - Implementing Master Data Services - Managing Master Data
- Creating a Data Quality Project to Clean Data

• Advanced SSIS and Data Quality Topics
- SSIS and Data Mining - Implementing Custom Code in SSIS Packages - Identity Mapping and De-Duplicating