Coursera
Coursera Logo

Meta - Introduction to Databases 

  • Offered byCoursera

Introduction to Databases
 at 
Coursera 
Overview

Duration

27 hours

Start from

Start Now

Total fee

Free

Mode of learning

Online

Difficulty level

Beginner

Official Website

Explore Free Course External Link Icon

Credential

Certificate

Introduction to Databases
 at 
Coursera 
Highlights

  • Earn a Certificate upon completion
Details Icon

Introduction to Databases
 at 
Coursera 
Course details

What are the course deliverables?
  • Concepts and principles that underpin how databases work .
  • Plan and execute a simple database development project .
More about this course
  • In this course, you will be introduced to databases and explore the modern ways in which they are used
  • Learn to distinguish between different types of database management systems then practice basic creation and data selection with the use of Structured Query Language (SQL) commands
  • Identify and explain the different types of core technology and management systems used in databases

Introduction to Databases
 at 
Coursera 
Curriculum

Introduction to Databases

Introduction to the course

A day in the Life of a Database Engineer

What is a database?

How is data related?

Alternative types of databases

What is Structured Query Language?

SQL usage

Advantages of SQL

SQL syntax introduction

What are tables in databases?

Types of keys in a database table

Module summary: Introduction to Databases

Introduction to the program

Course syllabus

How to be successful in this course

Relational data example charts

Database Evolution

Additional resources

Common SQL Commands

Additional resources

Tables overview

Database structure overview

Additional resources

Knowledge check: Databases and data

Knowledge check: SQL syntax review

Knowledge check: Database structure

Module quiz: Introduction to Databases

Create, Read, Update and Delete (CRUD) Operations

Numeric data types

String data types

Default values

CREATE and DROP database

CREATE TABLE statement

ALTER TABLE statement

INSERT statement

SELECT statement

INSERT INTO SELECT statement

Updating data

Deleting data

Module summary: Create, Read, Update and Delete (CRUD) Operations

Additional resources

Creating tables

Additional resources

Additional resources

Self review: Working with numbers

Self review: Working with strings

Self review: Working with default values

Self review: Choosing the right type for a column

Self-review: Create Database, create table and insert data

Self review: Practicing table creation

Knowledge check: Create, insert, select

Self-review: Record deletion

Knowledge check: Update and Delete

Module quiz: Create, Read, Update and Delete (CRUD) Operations

SQL Operators and sorting and filtering data

SQL Arithmetic Operators

Operators in use

SQL Comparison operators

ORDER BY clause

WHERE clause

SELECT DISTINCT clause

Module summary: Sorting and filtering data

SQL Arithmetic Operator Examples

SQL Comparison operator examples

Additional resources

Types of ordering / sorting

WHERE Clause uses

SELECT DISTINCT clause in use

Additional resources

Knowledge Check: Operators

Self-review: ORDER BY and WHERE

Module quiz: SQL operators and sorting and filtering data

Database design

Database schema

Schema in use

Types of database schema

Table relationships

Primary key

Foreign key

Finding entitites

What is database normalization?

First normal form 1NF

Second normal form 2NF

Third normal form 3NF

Module summary

Exploring database schema

Building a schema

Additional resources

Relational model

Keys in depth

Entity relationship diagrams (ERD)

Additional resources

Data normalization

Additional resources

Knowledge check: Database schema

Knowledge check: Defining keys

Database relations and keys

Knowledge Check: Data normalization

Self-review: Database schema examples

Module quiz: Database design

Graded assessment

Course Recap: Introduction to databases

Congratulations, you have completed Introduction to databases

About the graded assessment

Next steps after Introduction to Databases

Graded Assessment: Intro to databases

Introduction to Databases
 at 
Coursera 
Admission Process

    Important Dates

    May 25, 2024
    Course Commencement Date

    Other courses offered by Coursera

    – / –
    Start Now
    – / –
    – / –
    – / –
    Start Now
    – / –
    Start Now
    View Other 6713 CoursesRight Arrow Icon
    qna

    Introduction to Databases
     at 
    Coursera 

    Student Forum

    chatAnything you would want to ask experts?
    Write here...