MCSA SQL Server 2012/2014 Training

(Caroline Mutembei) #1


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.

13 Feb 2017 to 03 Mar 2017

Caroline Mutembei
email:[email protected]
skype:caroline.mutembei or 0718018948