SQL: A Practical Introduction for Querying Databases
- Offered byCoursera
SQL: A Practical Introduction for Querying Databases at Coursera Overview
Duration | 21 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
SQL: A Practical Introduction for Querying Databases at Coursera Highlights
- Earn a Certificate upon completion
SQL: A Practical Introduction for Querying Databases at Coursera Course details
- 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 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
- You will create a database instance in the cloud
- 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
SQL: A Practical Introduction for Querying Databases at Coursera Curriculum
Getting Started with SQL
Course Introduction
Introduction to Databases
SELECT Statement
COUNT, DISTINCT, LIMIT
INSERT Statement
UPDATE and DELETE Statements
Summary & Highlights
Practice Quiz
Graded Quiz: Basic SQL
Introduction to Relational Databases and Tables
Relational Database Concepts
Types of SQL statements (DDL vs. DML)
CREATE TABLE Statement
ALTER, DROP, and Truncate tables
How to create a Database instance on Cloud
Optional Db2 Labs
Summary & Highlights
Practice Quiz
Graded Quiz: Relational DB Concepts and Tables
Intermediate SQL
Using String Patterns and Ranges
Sorting Result Sets
Grouping Result Sets
Built-in Database Functions
Date and Time Built-in Functions
Sub-Queries and Nested Selects
Working with Multiple Tables
Summary & Highlights
Summary & Highlights
Practice Quiz
Graded Quiz: Refining Your Results
Practice Quiz
Graded Quiz: Functions, Sub-Queries, Multiple Tables
Working with real-world data sets, Final Project & Exam
Working with Real World Datasets
Getting Table and Column Details
Congratulations & Next Steps
Course Team
Project Evaluation (Quiz)
Final Exam
Advanced SQL (Honors)
Views
Stored Procedures
ACID Transactions
Join Overview
Inner Join
Outer Joins
About this Honors Module
Summary & Highlights
Summary & Highlights
Practice Quiz
Practice Quiz
Graded Quiz: Views, Stored Procedures and Transactions
Graded Quiz: JOIN operations
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?