Explore

Developing Applications with SQL, Databases, and Django

Approx. 15 hours to complete

Save Course

Go to Course

Course Summary

This course focuses on developing web applications using Django, a Python-based framework, with SQL databases. Students will learn how to build scalable and secure applications that can handle large amounts of data.

Key Learning Points

Use Django to build web applications with SQL databases
Create scalable and secure applications that can handle large amounts of data
Deploy applications to production servers using best practices

Job Positions & Salaries of people who have taken this course might have

- USA: $75,000 - $120,000
- India: ₹400,000 - ₹1,200,000
- Spain: €25,000 - €40,000
- USA: $75,000 - $120,000
- India: ₹400,000 - ₹1,200,000
- Spain: €25,000 - €40,000
- USA: $80,000 - $135,000
- India: ₹500,000 - ₹1,500,000
- Spain: €30,000 - €45,000
- USA: $75,000 - $120,000
- India: ₹400,000 - ₹1,200,000
- Spain: €25,000 - €40,000
- USA: $80,000 - $135,000
- India: ₹500,000 - ₹1,500,000
- Spain: €30,000 - €45,000
- USA: $75,000 - $120,000
- India: ₹400,000 - ₹1,200,000
- Spain: €25,000 - €40,000

Learning Outcomes

Build web applications using Django and SQL databases
Deploy applications to production servers
Apply best practices for scalability and security

Prerequisites or good to have knowledge before taking this course

Basic knowledge of Python programming
Familiarity with web development concepts

Course Difficulty Level

Intermediate

Course Format

Online self-paced
Video lectures
Hands-on projects

Similar Courses

Web Applications for Everybody
Python for Data Science

Related Education Paths

Notable People in This Field

Creator of Python
Co-creator of Django

Related Books

Description

The essentials of application development are 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 will be introduced to some fundamental database concepts. You will learn the basics of SQL, a simple and powerful programming language for querying and managing data. And you will learn about cloud database fundamentals and get hands-on cloud database experiences. In addition to SQL, you will discover how Object-Relational Mapping (ORM) allows you to use Object-Oriented Programming (OOP) languages 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 learn about cloud app platform fundamentals and get hands-on experience deploying your Django web app on the cloud. Course Learning Objectives: - Describe what is a database and how to model data - Compose SQL queries to insert, select, update, delete data in a database - Understand Object Relational Model (ORM) - Employ Django to develop database-powered applications - Deploy your Django app on the cloud Prerequisites: - GitHub - HTML & CSS - Python

Outline

Getting Started with SQL & Relational Databases
Course Introduction
Introduction to Databases and Database Management Systems
Relational Databases
Relational Data Concepts
SELECT Statement
COUNT, DISTINCT, LIMIT
INSERT Statement
UPDATE and DELETE Statements
CREATE Table Statement
ALTER, DROP, and Truncate Tables
Sorting Result Sets
Join Overview
Lesson Summary
Lesson Summary
Bonus Lesson Overview
Bonus Lesson Summary
Practice Quiz: Introduction to Databases
Graded Quiz: Introduction to Databases
Practice Quiz: Basic SQL Statements
Graded Quiz: Basic SQL Statements
Practice Quiz: Creating Tables, Sorting Results, and Join

ORM: Bridging the Gap Between the Real World and Relational Model
Object-Relational Mapping (ORM)
Django Model
Django CRUD
Related Objects
Module Summary
Practice Quiz: ORM and Django Model
Practice Quiz: Django Model API
Practice Quiz: ORM - Bridging the Gap Between the Real World and Relational Model
Graded Quiz: ORM - Bridging the Gap Between the Real World and Relational Model

Full-stack Django Development
Django Model-View-Template Pattern
Create a Django App
Django Admin Site
Django Views
Django Templates
Module Summary
Practice Quiz: MVC and Django MVT Pattern
Practice Quiz: Full-stack Django Development
Graded Quiz: Full-stack Django Development

Consolidate and Deploy Your Django App
Class-based and Generic Class Views
Django Authentication System
Bootstrap Integration
Manage Static Files
Deploy Your Django App on IBM Cloud
Module Summary
Practice Quiz: Class-based and Generic Views
Practice Quiz: Consolidate and Deploy Your Django App
Graded Quiz: Consolidate and Deploy Your Django App

Final Project: Enhance Online Course App with New Features
Final Project Overview and Scenario
Credits and Acknowledgments

Recommended for you

Learning Path: Akka: Building Applications and Microservices

Embrace yourself to learn the art of creating applications and microservices with Akka You will then create stateful actors, work with a cluster system, and work with remote actors....

Save Course

Learning Path: Django: Modern Web Development with Django

Complete featured guide to help you build real-world scalable, and secure web applications using the finest tools of Dja The highlights of this Learning Path are:...

Save Course

Web Application Technologies and Django

In this course, you'll explore the basic structure of a web application, and how a web browser interacts with a web server....

Save Course

IBM Full Stack Cloud Developer Professional Certificate

Kickstart your career in application development. Master Cloud Native and Full Stack Development using hands-on projects involving HTML, JavaScript, Node. js, Python, Django, Containers, Microservices and more....

Save Course