Fast Track: MCSE Data Platform and SQL Server 2014 (SQL14FT)

This intensive boot camp helps to achieve the MCSE Data Platform (MCSE) certification combining contents from the following official courses:

• Developing Microsoft® SQL Server® Databases (MOC 20464)
• Designing a Data Solution with Microsoft SQL Server (MOC 20465)

IT professionals with practical experience in running MS Windows Server and SQL database servers.

• Practical experience in the administration of MS SQL Server 2008 or 2012.
• High level of motivation to attend a workshop that goes beyond the normal course period.

• Optimal preparation for certification in just 5 days
• Efficient summary of the MOC20464 / 20465 courses with a focus on the relative exam topics
• Efficient time-cost learning / certification method

To prepare for the exam 70-464:

• 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.
• Work with the GEOGRAPHY and GEOMETRY data types
• Implement and query a full-text index.

To prepare for the exam 70-465:

• 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.
• Use Microsoft Azure storage with SQL Server 2014.
• Implement and configure databases in Microsoft Azure SQL Database.
• Implement and configure databases in Microsoft Azure virtual machines.
• Describe high availability technologies in SQL Server 2014 and implement log shipping.
• Describe Windows Server Failover Clustering and Implement an AlwaysOn Failover Cluster Instance.
• Implement an Always On Availability Group.
• Plan high availability and disaster recovery solutions.
• Plan and implement database replication.

Oggi gli architetti IT, i decision maker e i network managers si trovano ad affrontare una sempre più crescente varietà di nuove tecnologie, soluzioni e prodotti per l'informazione e le infrastrutture di comunicazione. Sviluppiamo soluzioni enterprise personalizzate ed economicamente efficaci che sfruttano al massimo il potenziale delle nuove tecnologie. Tutte le nostre soluzioni sono focalizzate su standard internazionali.