Advanced technology and business courses from world-class education providers collaboration

MCSA: SQL Server Administration

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

Querying Microsoft SQL Server 2012 (461)

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

Administering Microsoft SQL Server 2012 Databases (462)

  • Planning and Installing SQL Server 2012
  • Configuring SQL Server 2012 Components
  • SQL Server Logins, Roles, and Users
  • Mirroring and Replication
  • Troubleshooting SQL Server 2012
  • SQL Server Agent, Backup, and Restore
  • Configuring and Managing SQL Server Instances
  • Migrating, Importing, and Exporting
  • Securing SQL Server 2012
  • Clustering and AlwaysOn
  • Indexes and Concurrency
  • 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 RestartablePackage
  • 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