Microsoft Certified Solutions Expert (MCSE): Data Platform

  • E-COURSE
    E-Learning
    BUNDLE
  • 750
  • 29:22:40
Microsoft Certified Solutions Expert (MCSE): Data Platform
Test scorm
Enquire Now
  • E-Learning
  • 100
  • 04:36:55

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012.

This course is preparation for the 70-463 exam and 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 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. A data warehouse collects needed data and organizes the data in a form that solves the complexities and performance issues that line-of-business applications present.

After completing this course participants will be able to:

  • Design and implement a data warehouse
  • Implement an ETL solution that supports incremental data extraction
  • Describe...read more

  • E-Learning
  • 128
  • 06:57:14

Microsoft 70-462: Administering SQL Server 2012 Databases

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function.

The 70-462: Administering Microsoft SQL Server 2012 online training course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Skills Learned 

  • Installation Planning
  • Installing SQL Server and related services
  • Implementation of a migration strategy
  • How to configure additional SQL Server components
  • Managing the SQL Server Agent
  • Database management and configuration
  • How to configure SQL Server instances
  • Implementing a SQL Server clustered instance
  • SQL Server instances...read more

  • E-COURSE
  • 196
  • 06:54:41

Microsoft 70-461: Querying SQL Server 2012

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

Skills Learned

  • Work with Data
  • Query data by using SELECT statements.
  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and...read more

  • E-COURSE
  • 186
  • 05:55:50

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around designing database solutions for Microsoft SQL Server 2012.

This course will teach students to plan and implement enterprise database infrastructure solutions through the use of SQL Server 2012.  The course teaches students how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. It also teaches the consolidation of SQL Server workloads, working with both on-site and cloud-based solutions and disaster recovery solutions.

Skills Learned 

  • Managing multiple servers
  • Disaster recovery planning
  • Planning high availability
  • Rules of database design
  • Policy-based management
  • Design a database structure
  • Design databases and database objects
  • Design database...read more

  • E-COURSE
  • 140
  • 04:59:00

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around Developing Microsoft SQL Server 2012 Databases.

Developing Microsoft SQL Server 2012 Databases training prepares Database developers to build their skills in developing and implementing databases, while ensuring high level of data availability. This course is in preparation for the 70-464 Developing Microsoft SQL Server 2012 Databases exam. This course covers logical table design, indexing and query plans, and focuses on the creation of database objects including views and 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.

This training course on developing Microsoft SQL Server 2012 Databases prepares participants for the Microsoft Exam 70-464.

Skills...read more