This course will get you up to speed with the Oracle Database platform in general and the Oracle Database 12c release in particular. You'll also get prepared to pass the Oracle Certified Administrator (OCA) certification exam.
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
This course introduces developers to the fundamental principles of performance tuning when using Oracle as their backend database.
Data is critical to any application, and database performance goes hand-in-hand with it. In this course, you'll get to see some ways to maximize database performance with PostgreSQL, covering indexes, best practices, and more.
This course covers the essentials of creating and managing tables in your Oracle database, including naming tables, defining columns, creating constraints and granting permissions. It also covers the basics of indexes, which are essential for efficiently accessing data in your tables.
Learn how to begin troubleshooting SQL Server performance problems, applicable for developers and DBAs from SQL Server 2005 onwards
MySQL course focusing on Indexing Strategies for High Performance Database
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.
Learn how nonclustered columnstore indexes in SQL Server 2012 can introduce incredible performance benefits when querying very large data sets in relational data warehouses, applicable to developers and DBAs responsible for application data tiers, from SQL Server 2012 onwards
AVL tree, red-black tree, B-tree, binary search tree, array, linked list, stack, queue and splay tree
