The integrity of the data used for analysis is a major step in any data-related project. This course will teach you how to develop SQL Server Integration Services (SSIS) packages, used for data cleansing activities, to ensure data integrity.

Knowing how to form clear results from hierarchical data is vital for any SQL developer's career. This course will teach you how to create and optimize recursive queries that transform raw data into valuable insights.

Working with SQL Server data is something that every data professional should know. However, crafting efficient and modular code is one of the key requirements for optimal implementation of data solutions.

This second course in Django for Everybody explores data models in Django and how it communicates with a database. This course also explores basic Structured Query Language (SQL) and database modeling and how they work in the Django model.

In this fourth and final course in PostgreSQL for Everybody, learners will explore database architectures, CRUD operations and how ACID requirements are implemented in PostgreSQL. Learners will compare how to scale SQL and NoSQL database services and build NoSQL applications using ElasticSearch.

This first course in PostgreSQL for Everybody explores the use of SQL in the PostgreSQL environment and introduces SQL techniques and commands. This course also explores data modeling and database relationships, while introducing hands-on assignments to work within PostgreSQL.

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions.

From querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL, learn essential skills that employers need.

Boost your SQL Server efficiency. This course will teach you advanced indexing, query tuning, and concurrency control.

Manipulating the data from SQL Server is something that every data professional should know. However, manipulating the SQL Server data by using stored procedures in an efficient and performant way is a mastery on its own!

Learn the fundamentals of Autonomous databases and take your DBA skills knowledge to the next level and learn to deploy and administer Autonomous databases. Explore planning, implementing, and deploying an Oracle Autonomous Database, the first and only autonomous database service in the cloud.In this module you will learn how to create applications on Autonomous Database using SQL, APEX, and Oracle Machine Learning.

Learn to leverage predictive models and methods directly in SQL Server. This course will demonstrate the capabilities of SQL Server related to predictive analytics, including best practices and optimizations.