Monthly Subscription Starting at AED 99 + VAT

SQL: A Practical Introduction for Querying Databases
  • Level Foundation
  • المدة 21 ساعات hours
  • الطبع بواسطة IBM
  • Offered by

عن

Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is a must for anyone who wants to start a career in Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence. The purpose of this course is to help you learn and apply foundational and intermediate knowledge of the SQL language, and become familiar with many relational database (RDBMS) concepts along the way. 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.

الوحدات

Basic SQL

    • 6 Videos
    • 3 ExternalTool
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz

3 External Tool

  • Hands-on Lab: Simple SELECT Statements
  • Hands-on Lab: COUNT, DISTINCT, LIMIT
  • Hands-on Lab: INSERT, UPDATE, and DELETE

6 Videos

  • Course Introduction
  • Introduction to Databases
  • SELECT Statement
  • COUNT, DISTINCT, LIMIT
  • INSERT Statement
  • UPDATE and DELETE Statements

Summary and Module Assessment

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Graded Quiz: Basic SQL

1 Readings

  • Summary & Highlights

Introduction to Relational Databases and Tables

    • 4 Videos
    • 2 ExternalTool
    • 2 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz

2 External Tool

  • Hands-on Lab : CREATE, ALTER, TRUNCATE, DROP
  • Hands-on Lab: Create and Load Tables using SQL Scripts

4 Videos

  • Relational Database Concepts
  • Types of SQL statements (DDL vs. DML)
  • CREATE TABLE Statement
  • ALTER, DROP, and Truncate tables

Optional: Hands-on Labs with Db2

    • 1 Videos
    • 1 Readings
    • 1 ExternalTool
    • 3 Plugin
Show info about module content

1 External Tool

  • Obtain IBM Cloud Feature Code and Activate Trial Account

1 Videos

  • How to create a Database instance on Cloud

1 Readings

  • Optional Db2 Labs

Summary and Module Assessment

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Graded Quiz: Relational DB Concepts and Tables

1 Readings

  • Summary & Highlights

Refining your Results

    • 3 Videos
    • 1 Readings
    • 1 ExternalTool
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz
  • Graded Quiz: Refining Your Results

1 External Tool

  • Hands-on Lab: String Patterns, Sorting and Grouping

3 Videos

  • Using String Patterns and Ranges
  • Sorting Result Sets
  • Grouping Result Sets

1 Readings

  • Summary & Highlights

Functions, Multiple Tables, and Sub-queries

    • 4 Videos
    • 1 Readings
    • 3 ExternalTool
    • 3 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz
  • Graded Quiz: Functions, Sub-Queries, Multiple Tables

3 External Tool

  • Hands-on Lab: Built-in functions
  • Hands-on Lab : Sub-queries and Nested SELECTS
  • Hands-on Lab: Working with Multiple Tables

4 Videos

  • Built-in Database Functions
  • Date and Time Built-in Functions
  • Sub-Queries and Nested Selects
  • Working with Multiple Tables

1 Readings

  • Summary & Highlights

Assignment Preparation: Working with real-world data sets and built-in SQL functions

    • 2 Videos
    • 1 ExternalTool
    • 2 Plugin
Show info about module content

1 External Tool

  • Hands-on Lab: Working with a real world data-set

2 Videos

  • Working with Real World Datasets
  • Getting Table and Column Details

Final Project

    • 1 ExternalTool
    • 2 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Project Evaluation (Quiz)

1 External Tool

  • Hands-on Lab: Final Project

Final Exam

    • 1 Assignment
Show info about module content

1 Assignment

  • Final Exam

Course Wrap-up

    • 2 Readings
Show info about module content

2 Readings

  • Congratulations & Next Steps
  • Course Team

About this Honors module

    • 1 Readings
Show info about module content

1 Readings

  • About this Honors Module

Views, Stored Procedures, and Transactions (Honors)

    • 3 Videos
    • 1 Readings
    • 3 ExternalTool
    • 3 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz

3 External Tool

  • Hands-on Lab: Using Views
  • Hands-on Lab: Stored Procedures
  • Hands-on Lab: Committing and Rolling back a Transaction

3 Videos

  • Views
  • Stored Procedures
  • ACID Transactions

1 Readings

  • Summary & Highlights

JOIN Statements (Honors)

    • 3 Videos
    • 1 Readings
    • 1 ExternalTool
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz

1 External Tool

  • Hands-on Lab: Joins

3 Videos

  • Join Overview
  • Inner Join
  • Outer Joins

1 Readings

  • Summary & Highlights

Quiz and Assignment for Advanced SQL

    • 1 PeerReview
    • 2 ExternalTool
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Graded Quiz: Views, Stored Procedures and Transactions
  • Graded Quiz: JOIN operations

2 External Tool

  • Practice Lab: Joins
  • Hands-on Lab:Final Project: Advanced SQL Techniques

1 Peer Review

  • Advanced SQL for Data Engineers

Auto Summary

Dive into the world of databases with Coursera's "SQL: A Practical Introduction for Querying Databases." Perfect for aspiring Data Engineers, Data Analysts, and Business Intelligence professionals, this foundational course, led by expert instructors, covers essential SQL skills. You'll perform CRUD operations, filter, sort, and aggregate data, and work with real database systems through hands-on labs. The 1260-minute course concludes with a final project to showcase your skills. Available with Starter and Professional subscriptions, no prior SQL or programming experience is needed. Ideal for anyone with basic data literacy aiming to enhance their data handling capabilities.

Rav Ahuja
Instructor

Rav Ahuja