We store vast amounts of data in relational databases. Understanding and manipulating this data using SQL is an essential skill for application developers. This course provides you with instruction and hands-on experiences accessing, processing, and presenting data.

Learn the basics of SQL, a simple and powerful programming language for querying and managing data, and the fundamentals of cloud databases. You will explore fundamental database concepts such as object-relational mapping (ORM), and object-oriented programming (OOP) languages to work with databases.

You will use Django, a fast and simple open-source web framework, to simplify your applications. using Django models, views, and templates, which work together to provide and present your web application with the data in your database. You will also use Django’s powerful admin site functionality to manage site content. Finally, you discover Bootstrap, a free and open-source web front-end framework.

As a final project, you will gain hands-on practical experience developing and deploying a full-stack Django web application on the cloud.

Learning Objectives:

Explain what it means to model data
Perform database operations such as insert, select, update, and delete using SQL
Design a data model using the Object Relational Model (ORM)
Use Bootstrap to build interactive web pages
Develop a Django powered applications using models, views, and templates
Deploy your Django app on the cloud

Prerequisites:

GitHub
HTML & CSS
Python

Course Syllabus:

Module 1: Getting Started with SQL and Relational Databases

Relational Databases
Non-relational Databases
Relational Data Concepts
Hands-on Lab: Relational Data Concepts
SELECT Statement
Hands-on Lab: Simple SELECT Statements
COUNT, DISTINCT, LIMIT
INSERT Statement
UPDATE and DELETE Statements
Hands-on Lab: INSERT, UPDATE, and DELETE

Module 2: ORM: Bridging the Gap Between the Real World and Relational Models

Object-Relational Mapping (ORM)
Django Model
Hands-on Lab: Create Your First Django Model
Optional Hands-on Lab: Create a Standalone Django ORM Project Template
Django Models CRUD
Hands-on Lab: CRUD on Django Model Objects
Related Objects
Query Spanning Relationships

Module 3: Full-stack Django Development

Django Model-View-Template (MVT) Pattern
Create a Django App
Hands-on Lab: Create Your First Django App and Deploy using Docker
Django Admin
Hands-on Lab: Django Admin
Django Views
Django Template
Hands-on Lab: Views and Templates

Module 4: Consolidate and Deploy Your Django App

Class-based and Generic Class Views
Hands-on Lab: Class-based and Generic Views
Django Authentication System
Hands-on Lab: Django Authentication
Bootstrap
Hands-on Lab: Bootstrap Integration
Django Static Files
Deploy Your Django Apps

Module 5: Final Project

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

Building Django Applications with Databases

Language

Topic

Industries

Skills You Will Learn

Offered By

Estimated Effort

Platform

Last Update