MCSE Data Platform Certification Exam Prep

$49.00$1,299.00

You save 96%

MCSE: Data Platform Certification Bundle: Solutions Expert

Querying Microsoft SQL Server 2012
Lesson 01 - Introduction to SQL Server 201231:00
Lesson 02 - Working with T-SQL 1:02:45
Lesson 03 - Understanding SQL Data Types42:36
Lesson 04 - Sorting and Filtering38:09
Lesson 05 - Query Multiple Tables using JOINs31:45
Lesson 06 - Modifying Table Data46:43
Lesson 07 - Programming in SQL Server 1:00:34
Lesson 08 - Writing Advanced Queries in T-SQL37:48
Lesson 09 - Data Manipulation24:56
Lesson 10 - Advanced Querying30:38
Administering MS SQL Server 2012 Databases
Lesson 00 - Course Overview06:19
Lesson 01 - SQL Server Tools and Installation35:18
Lesson 02 - Managing the Database Server26:40
Lesson 03 - Managing Databases34:10
Lesson 04 - SQL Server Security35:40
Lesson 05 - Advanced Security in SQL Server42:52
Lesson 06 - Working with Indexes and Files39:43
Lesson 07 - Maintaining Reliability of SQL Server Installations25:53
Lesson 08 - Optimizing Servers20:02
Lesson 09 - Troubleshooting Errors in SQL Server21:02
Lesson 10 - Advanced Server Management
Implementing Data Warehouse MS SQL 2012
Lesson 00 - Course Overview05:42
Lesson 1 - Introduction to Data Warehouses30:19
Lesson 2 - Dimension Tables39:54
Lesson 3 - Fact Tables24:09
Lesson 4 - Concepts Involved in Implementing a Data Warehouse with SQL Server 201219:37
Lesson 5 - SSIS Overview for ETL27:20
Lesson 6 - Understanding SSIS Control Flow41:41
Lesson 7 - Working with Variables34:12
Lesson 8 - Introduction to ETL53:07
Lesson 9 - Deploying and Managing Packages19:37
Lesson 10 - Debugging and Securing Packages
Developing MS SQL Server 2012 Database
Module 01 - Introduction29:06
Module 02 - SQL Server 2012 Essentials10:28
Module 03 - Installing SQL Server24:30
Module 04 - SQL Server Basics 1:22:30
Module 05 - Working with Tables 1:48:37
Module 06 - Indexes53:14
Module 07 - Programming Objects 1:21:20
Module 08 - Concurrency and Locking22:53
Module 09 - Optimization44:55
Module 10 - Working with XML Data13:06
Module 11 - Conclusion03:58
Module 12 - Credits
Designing Database Solutions For MS SQL Server 2012
Module 01 - Welcome32:54
Module 02 - SQL Server 2012 Essentials11:45
Module 03 - Installing SQL Server 201238:10
Module 04 - Designing Database Structure49:57
Module 05 - Database Object Design53:28
Module 06 - Designing Tables 1:00:23
Module 07 - Indexing44:19
Module 08 - Programming Objects22:33
Module 09 - Database Server Maintenance 1:05:42
Module 10 - Monitoring Performance30:33
Module 11 - Designing Backup Recovery32:29
Module 12 - Conclusion03:58
Module 13 - Credits

DescriptionInstructorImportant DetailsRelated Products

Build Enterprise-Scale Data Solutions Like an Expert & Study to Earn an Industry-Leading Certification

SimplilearnSimplilearn is the world’s largest professional certifications company. We work with companies and working professionals to address their unique learning needs. For more details on this course and instructor, click here.

Description

MCSE-certified professionals earn an average of $16k more than their peers and 60% of IT professionals say MCSE certification helped them get a new job. Pretty convincing numbers, right? If you've ever considered, or are considering, a career in SQL Server Administration, this bundle of courses will assess your ability to build enterprise-scale data solutions both on-premises and in cloud environments, and prepare you for the MCSE SQL Server Certification exam. Server administrators are well paid, and always in demand, so the time to start studying is now!

Access 5 courses w/ study materials for MCSE SQL Server Certification
Learn how to build effective enterprise-scale data solutions
Gain expertise on administering various SQL server databases
Understand data warehousing & designing database solutions for SQL servers
Develop the skills you need to earn an industry-leading certification

Specs

Details & Requirements

Length of time users can access this course: 1 year
Access options: web streaming, mobile streaming
Certification of completion included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels

Compatibility

Internet required

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...