Get an understanding on how easily and securely you can move databases onto cloud, understand how the AWS Schema Conversion tool works and learn how the AWS Database Migration service supports both homogenous and heterogeneous migrations
This tutorial will provide a good foundation of Oracle performance tuning along with handy tips for issue resolution.
Learn how to identify your current servers and processors, evaluate different servers for performance, choose the most appropriate new server for your budget, and maintain server hardware; applicable to anyone who uses servers or is responsible for evaluating and choosing new servers
Are you trying to force SQL Server Standard Edition to do something that may only be capable in enterprise edition? In this course, you'll learn how to experience standard edition technologies as closely to the enterprise edition as possible.
Learn how to correctly choose server hardware for SQL Server 2012, including workload evaluation, SQL Server 2012 Edition hardware limits and licensing costs, processor and storage choice, and redundancy components and effects. This course is applicable to anyone who is purchasing hardware for SQL Server for the first time and wants to avoid the common mistakes and pitfalls that are made so often.
A practical approach to understanding the benefits and requirements of implementing in-memory OLTP tables, indexes, natively compiled stored procedures, and UDFs. This course also treats support, monitoring, and troubleshooting IMOLTP.
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. This course takes a tour of the basic new features that were introduced, including backup, security, column store enhancements, Resource Governor, General Administration, Azure integration, extensions with SQL Server 2014 and more.
Explore the newest features and performance improvements of SQL Server 2016, quickly after its release on the market. This course will teach you about some amazing new functionality that will help enhance the performance of your solution.
This course teaches how to recognize and diagnose numerous types of SQL Server query performance problems.
This course focuses on the database developers and architects engaged in the increasingly difficult task of achieving the best performance of database applications. SQL Server 2014 addresses these needs, optimizing for both OLTP and Data Warehousing workloads using In-Memory OLTP and Clustered Columnstore Indexes, allowing you to realize the fullest potential of your database systems and underlying hardware.
