Monthly Subscription Starting at AED 99 + VAT

Introduction to Databases for Back-End Development
  • Level Foundation
  • Duration 27 hours
  • Course by Meta
  • Offered by

About

Back-end developers write applications that end-users use to interact with databases. Some common tasks that end-users carry out using these applications include storing, searching, extracting and manipulating data. Therefore, it’s essential that all back-end developers possess strong knowledge and experience with how databases work. In this course, you’ll receive an introduction to databases and explore the different ways in which they can be used to store and manage data. You’ll also learn to distinguish between different types of database management systems. You’ll then practice basic creation and data selection tasks with the use of Structured Query Language (SQL) commands. By the end of this course, you’ll be able to: - Demonstrate a working knowledge of the concepts and principles that underpin how databases work - Identify and explain the different types of core technology and management systems used in databases - Identify and interpret basic SQL statements and commands - Manipulate records in a database with the use of SQL statements and commands - Outline alternatives to SQL - and plan and design a simple relational database system You’ll also gain experience with the following: - Fundamental concepts in database - Basic MySQL syntax and commands - Database management systems - Relational databases

Modules

Course Introduction

    • 2 Videos
    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • What do you hope to learn?

2 Videos

  • Introduction to databases
  • A day in the Life of a Database Engineer

2 Readings

  • Course syllabus: Introduction to databases
  • How to be successful in this course

Databases and data

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

1 Assignment

  • Knowledge check: Databases and data

3 Videos

  • What is a database?
  • How is data related?
  • Alternative types of databases

3 Readings

  • Relational data example charts
  • Database Evolution
  • Additional resources

Intro to SQL

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

1 Assignment

  • Knowledge check: SQL syntax review

4 Videos

  • What is Structured Query Language?
  • SQL usage
  • Advantages of SQL
  • SQL syntax introduction

2 Readings

  • Common SQL Commands
  • Additional resources

Basic database structure

    • 3 Videos
    • 3 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check: Database structure
  • Module quiz: Introduction to Databases

3 Videos

  • What are tables in databases?
  • Types of keys in a database table
  • Module summary: Introduction to Databases

3 Readings

  • Tables overview
  • Database structure overview
  • Additional resources

SQL data types

    • 3 Videos
    • 1 Readings
    • 4 Lab
    • 4 Assignment
Show info about module content

4 Assignment

  • Self review: Working with numbers
  • Self review: Working with strings
  • Self review: Working with default values
  • Self review: Choosing the right data type for a column

4 Labs

  • Exercise: Working with numbers
  • Exercise: Working with strings
  • Working with default values 
  • Choosing the right data type for a column 

3 Videos

  • Numeric data types
  • String data types
  • Default values

1 Readings

  • Additional resources

Create and read

    • 6 Videos
    • 2 Readings
    • 2 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Self-review: Create database, create table and insert data
  • Self review: Practicing table creation
  • Knowledge check: Create, insert and select

2 Labs

  • Exercise: Create Database, create table and insert data
  • Exercise: Practicing table creation

6 Videos

  • CREATE and DROP database
  • CREATE TABLE statement
  • ALTER TABLE statement
  • INSERT statement
  • SELECT statement
  • INSERT INTO SELECT statement

2 Readings

  • Creating tables
  • Additional resources

Update and delete

    • 3 Videos
    • 1 Readings
    • 1 Quiz
    • 1 Lab
    • 2 Assignment
Show info about module content

2 Assignment

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

1 Labs

  • Exercise: Record deletion

3 Videos

  • Updating data
  • Deleting data
  • Module summary: Create, Read, Update and Delete (CRUD) Operations

1 Readings

  • Additional resources

1 Quiz

  • Self-review: Record deletion

SQL operators

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

1 Assignment

  • Knowledge Check: Operators

3 Videos

  • SQL Arithmetic Operators
  • Operators in use
  • SQL Comparison operators

3 Readings

  • SQL Arithmetic Operator Examples
  • SQL Comparison operator examples
  • Additional resources

Sorting and filtering data

    • 4 Videos
    • 4 Readings
    • 1 Lab
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: ORDER BY and WHERE
  • Module quiz: SQL operators and sorting and filtering data

1 Labs

  • ORDER BY and WHERE

4 Videos

  • ORDER BY clause
  • WHERE clause
  • SELECT DISTINCT clause
  • Module summary: SQL operators and sorting and filtering data

4 Readings

  • Types of ordering / sorting
  • WHERE Clause uses
  • SELECT DISTINCT clause in use
  • Additional resources

Designing database schema

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

1 Assignment

  • Knowledge check: Database schema

3 Videos

  • Database schema
  • Schema in use
  • Types of database schema

3 Readings

  • Exploring database schema
  • Building a schema
  • Additional resources

Relational database design

    • 4 Videos
    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check: Defining keys
  • Database relations and keys

4 Videos

  • Table relationships
  • Primary key
  • Foreign key
  • Finding entitites

4 Readings

  • Relational model
  • Keys in depth
  • Entity relationship diagrams (ERD)
  • Additional resources

Database normalization

    • 5 Videos
    • 2 Readings
    • 1 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge Check: Database normalization
  • Self-review: Database schema examples
  • Module quiz: Database design

1 Labs

  • Database schema examples

5 Videos

  • What is database normalization?
  • First normal form 1NF
  • Second normal form 2NF
  • Third normal form 3NF
  • Module summary: Database design

2 Readings

  • Data normalization
  • Additional resources

Graded Assessment

    • 1 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Final graded quiz: Intro to databases

1 Videos

  • Course Recap: Introduction to databases for back-end development

1 Readings

  • About the final graded quiz assessment

Course wrap-up

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • What are your thoughts on working with databases?

1 Videos

  • Congratulations, you have completed Intro to databases for back-end development!

1 Readings

  • Next steps after Introduction to Databases

Auto Summary

Unlock the essentials of database management with the "Introduction to Databases for Back-End Development" course, designed for aspiring and current back-end developers. This foundational course, offered by Coursera, delves into the critical role databases play in storing, managing, and manipulating data through applications. Guided by expert instructors, you'll gain a comprehensive understanding of various database management systems and the core technologies that underpin them. The course offers hands-on experience with Structured Query Language (SQL), allowing you to practice essential tasks such as creating databases, selecting data, and manipulating records. Over the duration of the course, you'll master: - Fundamental concepts of databases - Basic MySQL syntax and commands - Key principles of database management systems - Design and planning of simple relational database systems - Alternatives to SQL Ideal for back-end developers at the foundational level, this course empowers you to confidently navigate and utilize database technologies. With a flexible subscription option, you can tailor your learning experience to fit your schedule and career goals. Join now and elevate your database management skills to enhance your development projects.

Taught by Meta Staff
Instructor

Taught by Meta Staff