Back to Courses

MCSA SQL Server 2014 Administrator

ENDED

Training by CLS Learning

Inquire Now

On-Site / Training

Inquire for Price

Inquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Inquire

Details

Earning an MCSA: SQL Server certification qualifies you for a position as a software as a database developer or database analyst.

Outline

Diploma courses :

Querying SQL Server (40 Hours)
Administering SQL Databases (40 Hours)
Implementing Data Warehouse (40 Hours)

Querying SQL Server:

Module 1: Introduction to Microsoft SQL Server 2014
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Module 6: Working with SQL Server 2014 Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying data with Stored Procedures
Module 16: Programming with T-SQL
Module 17: Implementing Error Handling
Module 18: Implementing Transactions
Module 19: Appendix 1: Improving Query Performance
Module 20: Appendix 2: Querying SQL Server Metadata

Administering SQL Databases:

Module 1: Introduction to SQL Server 2014 Database Administration
Module 2: Installing and Configuring SQL Server 2014
Module 3: Working with Databases and Storage
Module 4: Planning and Implementing a Backup Strategy
Module 5: Restoring SQL Server 2014 Databases
Module 6: Importing and Exporting Data
Module 7: Monitoring SQL Server 2014
Module 8: Tracing SQL Server Activity
Module 9: Managing SQL Server Security
Module 10: Auditing Data Access and Encrypting Data
Module 11: Performing Ongoing Database Maintenance
Module 12: Automating SQL Server 2014 Management
Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications

Implementing Data Warehouse:

Module 1: Introduction to Data Warehousing
Module 2: Data Warehouse Hardware Considerations
Module 3: Designing and Implementing a Data Warehouse
Module 4: Creating an ETL Solution with SSIS
Module 5: Implementing Control Flow in an SSIS Package
Module 6: Debugging and Troubleshooting SSIS Packages
Module 7: Implementing a Data Extraction Solution
Module 8: Loading Data into a Data Warehouse
Module 9: Enforcing Data Quality
Module 10: Master Data Services
Module 11: Extending SQL Server Integration Services
Module 12: Deploying and Configuring SSIS Packages
Module 13: Consuming Data in a Data Warehouse

Reviews

Be the first to write a review about this course.

Write a Review

Since 1995, CLS Learning solutions is leading the technology learning market in Egypt, the Middle East, and Africa. With our wide network of international partners, trainers, instructors, and technology leaders; we are able to deliver top notch training programs to our students and technology professionals.

25 Years in the market.

We delivered over 4,200 courses to 63,500 professionals in our centers.

We delivered 1,200 courses to 18,240 corporate employees on Site.

View Complete Profile

Database & Information Systems