MCSA SQL Server 2012/2014 Training

Introduction

Querying Microsoft SQL Server, This is an instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Administering Microsoft SQL Server Databases, This is an instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Implementing a Data Warehouse with Microsoft SQL Server, This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services **

Course Outline

  1. Introduction to Microsoft SQL Server 2014
  2. Introduction to SQL Querying
    
  3. Writing SELECT Queries
    
  4. Querying Multiple Tables
    
  5. Sorting and Filtering Data
    
  6. Working with SQL Server 2014 Data Types
    
  7. Using DML to Modify Data and Using Built-In Functions
    
  8. Grouping and Aggregating Data
    
  9. Using Subqueries and Using Table Expressions
    
  10. Using Set Operators and Using Window Ranking, Offset, and Aggregate Functions
    
  11. Pivoting and Grouping Sets
    
  12. Querying data with Stored Procedures
    
  13. Implementing Transactions and Implementing Error Handling
    
  14. Introduction to SQL Server 2014 Database Administration
    
  15. Installing and Configuring SQL Server 2014
    
  16. Working with Databases and Storage
    
  17. Planning and Implementing a Backup Strategy
    
  18. Restoring SQL Server 2014 Databases
    
  19. Importing and Exporting Data
    
  20. Monitoring SQL Server 2014
    
  21. Tracing SQL Server Activity
    
  22. Managing SQL Server Security
    
  23. Auditing Data Access and Encrypting Data
    
  24. Performing Ongoing Database Maintenance
    
  25. Automating SQL Server 2014 Management
    
  26. Monitoring SQL Server 2014 by Using Alerts and Notifications
    
  27. Introduction to Data Warehousing
    
  28. Data Warehouse Hardware Considerations
    
  29. Designing and Implementing a Data Warehouse
    
  30. Creating an ETL Solution with SSIS
    
  31. Implementing Control Flow in an SSIS Package
    
  32. Debugging and Troubleshooting SSIS Packages
    
  33. Implementing an Incremental ETL Process
    
  34. Enforcing Data Quality
    
  35. Using Master Data Services
    
  36. Extending SQL Server Integration Services
    
  37. Deploying and Configuring SSIS Packages Consuming Data in a Data Warehouse
    

Fee information:
The training fee is USD 900 exclusive of V.A.T.Participants attending as a group enjoys a discount. The course fee covers tuition, refreshments and lunch.

DATES:
13 Feb 2017 to 03 Mar 2017

VENUE:
COMPUTER LEARNING CENTRE
**
CONTACT PERSON:**
Caroline Mutembei
email:[email protected]
skype:caroline.mutembei or 0718018948