Monthly Subscription Starting at AED 99 + VAT

Developing Applications with SQL, Databases, and Django

About

Working with databases is a key skill for developers, especially those in Back-End, Full Stack, and DevOps roles. This course will teach you the fundamentals of relational databases and how to access them from your applications. Some of the essential application development tasks include accessing, processing, and presenting data. Data is stored in various databases, either on-premise or on the cloud, and developers will need to learn how to talk to them via programming languages. In this course, you’ll learn about foundational database concepts, and basics of SQL, a simple and powerful programming language used for managing data. In addition to SQL, you will discover how Object-Relational Mapping (ORM) allows you to use Object-Oriented Programming (OOP) languages like Python to work with databases. You will gain full-stack Django skills by creating a Django web app to persist, process, and present data. And you will get hands-on experience deploying your Django web app on the cloud. Throughout this course you will practice with hands-on labs. You will also complete a final project at the end of the course to demonstrate what you have learnt and have a great addition to your portfolio!

Modules

Welcome

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Course Introduction

2 Readings

  • Helpful Tips for Course Completion
  • Syllabus and Prerequisites

Introduction to Databases

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

2 Assignment

  • Practice Quiz: Introduction to Databases
  • Graded Quiz: Introduction to Databases

4 Videos

  • Introduction to Data and Databases
  • Relational Databases
  • Non-relational Databases
  • Relational Data Concepts

1 Readings

  • Module 1 Lesson 1 Summary

Basic SQL Statements

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

2 Assignment

  • Practice Quiz: Basic SQL Statements
  • Graded Quiz: Basic SQL Statements

2 External Tool

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

4 Videos

  • SELECT Statement
  • COUNT, DISTINCT, LIMIT
  • INSERT Statement
  • UPDATE and DELETE Statements

2 Readings

  • Module 1 Lesson 2 Summary
  • Module 1 Cheat Sheet: Getting Started with SQL & Relational Databases

(Optional) Creating Tables, Sorting Results, and Join

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

1 Assignment

  • Practice Quiz: Creating Tables, Sorting Results, and Join

4 Videos

  • CREATE Table Statement
  • ALTER, DROP, and Truncate Tables
  • Sorting Result Sets
  • Join Overview

2 Readings

  • Bonus Lesson Overview
  • Module 1 Bonus Lesson 3 Summary

Module 1 Summary

    • 1 Readings
Show info about module content

1 Readings

  • Module 1 Summary: Getting Started with SQL & Relational Databases

ORM: Bridging the Gap Between the Real World and Relational Model

    • 6 Videos
    • 4 ExternalTool
    • 1 Plugin
Show info about module content

4 External Tool

  • Hands-on Lab: Create Your First Django Model
  • Optional Hands-on Lab: Create a Standalone Django ORM Project Template
  • Hands-on Lab: CRUD on Django Model Objects
  • Query Spanning Relationships

6 Videos

  • Introduction to Django
  • Object-Oriented Analysis and Design
  • Object-Relational Mapping (ORM)
  • Django Model
  • Django Models CRUD
  • Related Objects

Module 2 Summary and Graded Quiz

    • 2 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Module 2 Practice Quiz: ORM - Bridging the Gap Between the Real World and Relational Model
  • Module 2 Graded Quiz: ORM - Bridging the Gap Between the Real World and Relational Model

2 Readings

  • Module 2 Summary: ORM: Bridging the Gap Between the Real World and Relational Model
  • Module 2 Cheat Sheet: ORM: Bridging the Gap Between the Real World and Relational Model

Full-stack Django Development

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

3 External Tool

  • Hands-on Lab: Create Your First Django App and Deploy using Docker
  • Hands-on Lab: Django Admin
  • Hands-on Lab: Views and Templates

5 Videos

  • Django Model-View-Template (MVT) Pattern
  • Create a Django App
  • Django Admin
  • Django Views
  • Django Template

Module 3 Summary and Graded Quiz

    • 2 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Full-stack Django Development
  • Graded Quiz: Full-stack Django Development

2 Readings

  • Module 3 Summary: Full-stack Django Development
  • Module 3 Cheat Sheet: Full-stack Django Development

Consolidate and Deploy Your Django App

    • 5 Videos
    • 3 ExternalTool
Show info about module content

3 External Tool

  • Hands-on Lab: Class-based and Generic Views
  • Hands-on Lab: Django Authentication
  • Hands-on Lab: Bootstrap Integration

5 Videos

  • Class-based and Generic Class Views
  • Django Authentication System
  • Bootstrap
  • Django Static Files
  • Deploy Your Django Apps

Module 4 Summary and Graded Quiz

    • 2 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Consolidate and Deploy Your Django App
  • Graded Quiz: Consolidate and Deploy Your Django App

2 Readings

  • Module 4 Summary: Consolidate and Deploy Your Django App
  • Module 4 Cheat Sheet: Consolidate and Deploy Your Django App

Practice Project: Customer360

    • 1 ExternalTool
    • 1 Plugin
Show info about module content

1 External Tool

  • Practice Project

Final Project: Add a New Assessment Feature to an Online Course App

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

1 External Tool

  • Final Project: Add a New Assessment Feature to an Online Course App

1 Peer Review

  • Peer Review

Course Wrap Up

    • 2 Readings
Show info about module content

2 Readings

  • Congratulations and Next Steps
  • Thanks from the Course Team

Auto Summary

"Developing Applications with SQL, Databases, and Django" is an essential course for IT and Computer Science enthusiasts, specifically tailored for those pursuing careers in Back-End, Full Stack, and DevOps development. Offered by Coursera, this professional-level course delves into the core aspects of relational databases and their integration with applications. Guided by an expert instructor, learners will master the use of SQL for database management and learn to leverage Django, a powerful web framework, to build robust applications. The course content is rich and comprehensive, ensuring that participants gain a deep understanding of database fundamentals and practical skills for real-world application development. While the course duration is flexible to accommodate varying schedules, it is available through two subscription plans: Starter and Professional, catering to different learning needs and professional aspirations. This course is ideal for developers and tech professionals looking to enhance their database management capabilities and application development expertise. Join now to elevate your technical skills and stay ahead in the ever-evolving field of technology.