Retail Sales

All modern IT Peripherals and Mobile with latest technologies available at KMD

Distribution

KMD is authorized distribution partner for world's leading IT and Mobile brands

Enterprise Solutions

Quality and efficient software solutions for SMEs to increase business productivity

Education

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

OEM

High-quality technology products directly at your doorstep from world class OEMs

System Integration

Customizing technologies to create innovative solutions for your business

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