This course will help you acquire certification for the exam 1Z0-149: Oracle Database Program with PL/SQL. It will cover the exam objectives of writing control structures in Oracle PL/SQL.

Companies rely on the backend developers in meeting the SLAs with the customer. This course will teach you how to write efficient nested blocks and expressions using the built-in function provided by PL/SQL.

Companies rely on the backend developers when meeting SLAs with customers. This course will teach you how to proficiently write PL/SQL executable blocks using DML and the INTO clause to hold values returned by PL/SQL for the Oracle database.

This course introduces developers to the fundamental principles of performance tuning when using Oracle as their backend database.

In this course, we will talk in detail about transaction management in Oracle. We will take an in-depth look at dynamic SQL and debugging options in PL/SQL, and explore in detail the SQL Developer Debugger.

Master performing database operations within the IBM Cloudant Dashboard. Learn to interact with your NoSQL database, manage data, and run queries directly from the dashboard for cloud-based applications.

Discover how to perform CRUD operations and work with tables in Cassandra, a NoSQL database designed for scalability. Learn to handle large datasets, query efficiently, and use the Cassandra Query Language (CQL).

phpMyAdmin is a free and open source tool for the administration of MySQL.

This course looks at the components in Microsoft Azure that can be used as part of a data warehouse solution, as well as common architectures for a data warehouse implementation.

Data modifications are a critical aspect of application design. In this course, you will learn about challenges associated with multi-user data access and the tools that PostgreSQL provides to tackle them, so you can avoid data consistency issues.

Most programming languages come with built-in functions and SQL is no exception. In this course, you'll learn about the ANSI SQL functions and operators implemented by PostgreSQL and a good portion of the of those unique to this popular system.

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.