Gain the skills and knowledge needed to succeed in an MIS-dominated corporate world.

Synthesize your knowledge of algorithms and biology to build your own software for solving a biological challenge.

Build a foundation of the four NoSQL (non-relational) databases: Document-oriented, Key-Value Pair, Column-oriented, and Graph.

Learn how to design relational databases, including many popular relational database models. Relational database normal form will also be covered, so your design will conform to industry best practices.

Learn how to create and interact with a relational database. The course includes Data Definition Language (DDL) used for database creation and Data Manipulation Language (DML) used for inserting, updating and deleting data in the database.

Learn about connection handling in MySQL, back up and restore, and the client interface options available for MySQL.

PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module, you learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools.

Learn about concurrency in MySQL, including how to limit the number of connections, and when to use thread pools.

Azure Database for PostgreSQL is a multi-user relational database solution. The increase in users brings a risk of conflicts and so it is important to understand the concurrency systems that are in place.

Learn about the language capabilities that are available to create data warehouses in Azure Synapse Analytics.

The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible.

Learn about and use the Intelligent Query Processing feature enhancements in SQL Server 2022.