Overview/Description
Microsoft SQL Server 2014 Microsoft SQL Server 2014 builds from version 2012 to provide optimal performance for applications using In-Memory OLTP, which is a memory-optimized database engine integrated into the SQL Server engine. SQL Server 2014 also provides the ability to create hybrid platform and cloud scenarios by enabling cloud backups and recoveries to decrease on premise costs for storage. This course will discuss and demonstrate the objectives for SQL Server 2014 for the 70-464 Microsoft SQL Server: Developing Databases certification exam, this will include the In-Memory OLTP feature and how to write scripts to automate backups to the cloud. It will also demonstrate other database development tasks, such as designing and creating database objects and programming objects and how to optimize and troubleshoot queries.
Target Audience
Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Prerequisites
None
Expected Duration
2.0 hours
Lesson Objectives
After completing this course, you should be able to accomplish the objectives from the following lessons and topics.
Show Topics Lesson: In-Memory OLTP and Automate Backups
Show Topics Lesson: Managing Tables, Indexes, and Constraints
Show Topics Lesson: Developing and Design Database Objects
Show Topics Lesson: Optimizing Queries and Security
