MCSA SQL Server 2014 Administrator

CLS Learn

Add to wishlist

Price: AED 1,102

Locations: Dokki Nasr City - Cairo
Duration: 120 Hours
Call: +971 4 4542450

Course details

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

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

Updated on 09 August, 2020

Eligibility / Requirements

Fundamental knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality

Job roles this course is suitable for:

SQL Server DBA , sql server admin , Microsoft SQL Server Administrator

Course Location

Show map Locations Dokki Nasr City - Cairo

About CLS Learn

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.

See all CLS Learn courses

View more Virtual classroom training for SQL Server online courses See all MCSA Courses

See all current MCSA jobs in UAE