SQL: A Practical Introduction for Querying Databases

Instructor: Rav Ahuja

Beginner Level • 2 weeks at 10 hours a week • Flexible Schedule

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

Database Systems
Transaction Processing
SQL
IBM DB2
Data Manipulation
Relational Databases
MySQL
Databases
Stored Procedure
Database Management
Data analysis
Query Languages
Microsoft SQL Servers

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate from IBM

There are 5 modules in this course

In this module, you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.

In this module, you will explore the fundamental concepts behind databases, tables, and the relationships between them. You will then create an instance of a database, discover SQL statements that allow you to create and manipulate tables, and then practice them on your own live database.

In this module, you will learn how to use string patterns and ranges to search data and how to sort and group data in result sets. You will also practice composing nested queries and execute select statements to access data from multiple tables.

In this assignment, you will be working with multiple real world datasets for the city of Chicago. You will be asked questions that will help you understand the data just as you would in the real wold. You will be assessed on the correctness of your SQL queries and results.

This module covers some advanced SQL techniques that will be useful for Data Engineers. If you are following the Data Engineering track, you must complete this module. In this module, you will learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.