MCSA SQL Server 2014 Administrator CLS Learn
Price: EGP 4,800

    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

    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
    Courses you can instantly connect with... Do an online course on MCSA starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or