MCSE: Data Management and Analytics Solutions Expert

MCSE: Data Management and Analytics Solutions Expert

MCSE Data Management and Analytics

The globally recognized standard for IT professionals

Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data—both on-premises and in cloud environments.
Earning an MCSE: Data Management and Analytics certification qualifies you for such jobs as database analyst, database designer, and business intelligence analyst.
This MCSE certification does not expire or require recertification. However, each calendar year, you have the opportunity to earn the certification and to receive an additional entry on your transcript. You do this by passing a unique exam from the list of electives, which demonstrates your continued investment to broaden or deepen your skills in a specific technology area.
For 2017, this MCSE certification can be earned as follows:
Step 1. Earn one of the following Microsoft Certified Solutions Associate (MCSA) certifications:

Step 2. Pass one of the following elective exams during the 2016 calendar year.

Course 20464D: Developing Microsoft SQL Server 2014 Databases

Course 20464D: Developing Microsoft SQL Server 2014 Databases
About this course
This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.
Audience profile
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2014 product features and technologies for implementing a database.
The secondary audiences for this course are individuals who are developers from other product platforms or previous versions of SQL Server looking to become skilled in the implementation of a SQL Server 2014 database.
At course completion
After completing this course, students will be able to:
Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.
Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types.
Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered).
Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.
Determine appropriate single column and composite indexes strategies.
Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure.
Read and interpret details of common elements from execution plans.
Design effective non-clustered indexes.
Design and implement views
Design and implement stored procedures.
Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses.
Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).
Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.
Use both traditional T-SQL error handling code and structured exception handling.
Design and implement DML triggers
Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
Store XML data and schemas in SQL Server.
Perform basic queries on XML data in SQL Server.
Course Outline
Module 1: Introduction to Database Development
Module 2: Designing and Implementing Tables
Module 3: Ensuring Data Integrity through Constraints
Module 4: Introduction to Indexing
Module 5: Designing Optimized Index Strategies
Module 6: Columnstore Indexes
Module 7: Designing and Implementing Views
Module 9: Designing and Implementing User-Defined Functions
Module 10: Responding to Data Manipulation via Triggers
Module 11: Using In-Memory Tables
Module 12: Implementing Managed Code in SQL Server 2014
Module 13: Storing and Querying XML Data in SQL Server
Module 14: Working with SQL Server 2014 Spatial Data
Module 15: Incorporating Data Files into Databases

Course 20465D: Designing Solutions for Microsoft SQL Server 2014

About this course
The focus of this three-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Audience profile
This course is intended for database professionals who need who plan, implement, and manage database solutions. Primary responsibilities include:
Planning and implementing database infrastructure.
Planning and implementing consolidation strategies.
Planning and implementing high availability solutions.
Planning and implementing disaster recovery solutions.
At course completion
After completing this course, students will be able to:
Assess an existing enterprise environment.
Plan and implement Policy-Based Management.
Describe the considerations for consolidating workloads with SQL Server 2014.
Describe considerations for including SQL Server 2014 in a private cloud.
Course Outline
Module 1: Introduction to Enterprise Data Architecture
Module 2: Multi-Server Configuration Management
Module 3: Monitoring SQL Server 2014 Health
Module 4: Consolidating Database Workloads with SQL Server 2014
Module 5: Introduction to Cloud Data Solutions
Module 6: Introduction to High Availability in SQL Server 2014
Module 7: Clustering with Windows Server and SQL Server 2014
Module 8: AlwaysOn Availability Groups
Module 9: Planning High Availability and Disaster Recovery
Module 10: Replicating Data

Course 20466D: Implementing Data Models and Reports with SQL Server 2014

About this course
The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Audience profile
This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:
Implementing analytical data models, such as OLAP cubes.
Implementing reports, and managing report delivery.
Creating business performance dashboards.
Supporting data mining and predictive analysis.
At course completion
After completing this course, students will be able to:
Describe the components, architecture, and nature of a BI solution.
Create a multidimensional database with Analysis Services.
Implement dimensions in a cube.
Implement measures and measure groups in a cube.
Use MDX Syntax.
Customize a cube.
Implement a Tabular Data Model in SQL Server Analysis Services.
Use DAX to enhance a tabular model.
Create reports with Reporting Services.
Enhance reports with charts and parameters.
Manage report execution and delivery.
Implement a dashboard in SharePoint Server with PerformancePoint Services.
Use Data Mining for Predictive Analysis.
Course Outline
Module 1: Introduction to Business Intelligence and Data Modeling
Module 2: Creating Multidimensional Databases
Module 3: Working with Cubes and Dimensions
Module 4: Working with Measures and Measure Groups
Module 5: Introduction to MDX
Module 6: Customizing Cube Functionality
Module 7: Implementing an Analysis Services Tabular Data Model
Module 8: Introduction to Data Analysis Expression (DAX)
Module 9: Implementing Reports with SQL Server Reporting Services
Module 10: Automating Report Execution and Delivery
Module 11: Delivering BI with SharePoint PerformancePoint Services
Module 12: Performing Predictive Analysis with Data Mining

Course 20467D: Designing Business Intelligence Solutions with SQL 2014

About this course
This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Audience profile
The primary audience for this course is database and business intelligence (BI) professionals who are familiar with data warehouses and enterprise BI solutions built with SQL Server technologies. Experienced data analysts who want to learn how to use Microsoft technologies for self-service analysis and reporting will also benefit from attending this course.
At course completion
After completing this course, students will be able to:
Describe key features and benefits of self-service BI.
Use SQL Server Reporting Services to implement a self-service reporting solution.
Use PowerPivot in Microsoft Excel to create analytical data models.
Use Power Query in Microsoft Excel to import data into a data model.
Use Power View in Microsoft Excel to create interactive data visualizations.
Use Power Map in Microsoft Excel to create geographic data visualizations.
Use Microsoft SharePoint Server to implement collaborative self-service BI solutions.
Provision and use a Windows Azure HDInsight cluster for Big Data analysis.
Use Pig and Hive to analyze big data in Windows Azure HDInsight.
Design and implement Big Data processes to support self-service BI.
Course Outline
Module 1: Planning a BI Solution
Module 2: Planning BI Infrastructure
Module 3: Designing a Data Warehouse
Module 4: Designing an ETL solution
Module 5: Designing Analytical Data Models
Module 6: Planning a BI Delivery Solution
Module 7: Designing a Reporting Services Solution
Module 8: Designing an Excel Based reporting Solution
Module 9: Planning a SharePoint Server BI Solution
Module 10: Monitoring and Optimizing a BI Solution
Module 11: Operating a BI Solution



We are committed to providing our customers with the

best service and products available

100% satisfaction guarantee

why students prefer computek as the best training center in egypt new

 1.Computek Training Center has trained over 1,000,000 trainees in Egypt and over 100,000 trainees in Middle East and africa.

2.Our programs are designed to meet our clients' training necessities including budget and time limitation.

3.We will cooperate with you to bring out effective programs fitting your organization.

4.Computek Training Center provides customer-focus training in mutable deliverymethods offering top quality training and high qualified instructor to meet individual learning styles and organization profession training.

5.Computek instructors are selected from the best of training professional instructors in Egypt who awarded the trust worthy certified international companies, Computek instructors not only provide superior education but also reliable work experience in the field of giving courses

6.Trainees prefer Computek Training Center not only due to our high quality training but also for our reasonable and cost-effective price list.

7.Computek Classroom is designed with cutting edge facilities strong from hardware and software technologies to the most sophisticated educational aids.

8.The information desk with our friendly and professional customers support representative is highly qualified to answer any questions and also deliver your unique requirements.

9.Computek Training Center staff is available 7 days in week from 10:00 AM to 10:00 PM to deal with any inquiries and assist student with anything they need.

10.Computek Training Center is partner of world's technology leads such as Microsoft, Cisco, Compatia, EC Council ,Adobe , Autodesk, prometric and Pearson VUE.

All Rights Reseved ©