Ementorhub

What you'll learn

Analyze data within a database using SQL.

Create a relational database on Cloud and work with tables.

Write SQL statements including SELECT, INSERT, UPDATE, and DELETE.

Build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.

Skills you'll gain

IBM DB2

Stored Procedure

MySQL

Data Manipulation

Database Systems

SQL

Database Management

Query Languages

Transaction Processing

Databases

Microsoft SQL Servers

Data Analysis

Relational Databases

There are 5 modules in this course

You will start with performing basic Create, Read, Update and Delete (CRUD) operations using CREATE, SELECT, INSERT, UPDATE and DELETE statements. You will then learn to filter, order, sort, and aggregate data. You will work with functions, perform sub-selects and nested queries, as well as JOIN data in multiple tables. You will also work with VIEWS, transactions and create stored procedures. The emphasis in this course is on hands-on, practical learning. As such, you will work with real database systems, use real tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs, you will practice building and running SQL queries. At the end of the course you will apply and demonstrate your skills with a final project. The SQL skills you learn in this course will be applicable to a variety of RDBMSes such as MySQL, PostgreSQL, IBM Db2, Oracle, SQL Server and others. No prior knowledge of databases, SQL or programming is required, however some basic data literacy is beneficial.

Introduction to Relational Databases and Tables

Intermediate SQL

Working with real-world data sets, Final Project & Exam

Advanced SQL for Data Engineers