MCSA SQL Server 2012/2014 Training

caroline121 · January 6, 2017, 2:21pm

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

Introduction to Microsoft SQL Server 2014
```
Introduction to SQL Querying
```
```
Writing SELECT Queries
```
```
Querying Multiple Tables
```
```
Sorting and Filtering Data
```

Working with SQL Server 2014 Data Types

Using DML to Modify Data and Using Built-In Functions

```
Grouping and Aggregating Data
```

Using Subqueries and Using Table Expressions

Using Set Operators and Using Window Ranking, Offset, and Aggregate Functions

```
Pivoting and Grouping Sets
```
```
Querying data with Stored Procedures
```

Implementing Transactions and Implementing Error Handling

Introduction to SQL Server 2014 Database Administration

Installing and Configuring SQL Server 2014

```
Working with Databases and Storage
```

Planning and Implementing a Backup Strategy

```
Restoring SQL Server 2014 Databases
```
```
Importing and Exporting Data
```
```
Monitoring SQL Server 2014
```
```
Tracing SQL Server Activity
```
```
Managing SQL Server Security
```

Auditing Data Access and Encrypting Data

Performing Ongoing Database Maintenance

```
Automating SQL Server 2014 Management
```

Monitoring SQL Server 2014 by Using Alerts and Notifications

```
Introduction to Data Warehousing
```
```
Data Warehouse Hardware Considerations
```

Designing and Implementing a Data Warehouse

```
Creating an ETL Solution with SSIS
```

Implementing Control Flow in an SSIS Package

Debugging and Troubleshooting SSIS Packages

Implementing an Incremental ETL Process

```
Enforcing Data Quality
```
```
Using Master Data Services
```

Extending SQL Server Integration Services

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:caroline.mutembei@clclearningcentre.com
skype:caroline.mutembei or 0718018948