Developing Applications with SQL, Databases, and Django

BY
IBM via Coursera

Become an expert in managing databases and designing applications with the Developing Applications with SQL, Databases, and Django programme by Coursera.

Lavel

Intermediate

Mode

Online

Duration

14 Hours

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Accessing, processing, and presenting data are the essentials of application development. Data is usually stored in databases, either on the cloud or on-premise. Developers need to learn how to access this data via programming languages. The Developing Applications course by edX will help you get comfortable with these programming languages and introduce you to various fundamental database concepts.

The Developing Applications course starts with SQL, a powerful yet simple programming language for managing and querying data. You will also engage in hands-on cloud database experiments. Besides SQL, the course also covers other software like Django, using which you will create a full-blown web app that can persist, present, and process data.

With the Developing Applications programme, you will also learn how to work with databases using object-oriented programming through Object-Relational Mapping (ORM). All the information will be provided through video lectures, assignments, and readings. There’s also a certificate option available if you wish to showcase your skills and advance your career.

The highlights

  • Flexible assignment deadlines
  • Intermediate-level training
  • Delivered in English
  • 100% online programme
  • Shareable certificate
  • Free audit available
  • Takes 14 hours to complete

Program offerings

  • Graded assignments
  • Flexible deadlines
  • Intermediate-level
  • Delivered in english
  • 100% online
  • Reading material
  • Video lectures
  • English transcripts
  • 14-hour course

Course and certificate fees

certificate availability

Yes

certificate providing authority

Coursera

Eligibility criteria

It’s essential that you be familiar with Python, HTML, GitHub, and CSS to get the most out of the Developing Applications online training.

What you will learn

Sql knowledge Web application development skills

By the end of the Developing Applications training course, you will proficient in:

  • Describing what a database is and how to model data
  • Deploying your Django app on the cloud
  • Understanding Object Relational Model (ORM)
  • Composing SQL queries to insert, update, select, and delete data in a database
  • Employing Django to develop database-powered applications

The syllabus

Module 1: Getting Started with SQL and Relational Databases

Videos
  • 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
Readings
  • Helpful Tips for Course Completion
  • Syllabus and Prerequisites
  • Module 1 Lesson 1 Summary
  • Module 1 Lesson 2 Summary
  • Module 1 Cheat Sheet: Getting Started with SQL & Relational Databases
  • Bonus Lesson Overview
  • Module 1 Bonus Lesson 3 Summary
  • Module 1 Summary: Getting Started with SQL & Relational Databases 
Quizzes
  • Practice Quiz: Introduction to Databases
  • Practice Quiz: Basic SQL Statements
  • Practice Quiz: Creating Tables, Sorting Results, and Join
  • Graded Quiz: Introduction to Databases
Assignment
  • Graded Quiz: Basic SQL Statements
App Items
  • Hands-on Lab: Simple SELECT Statements
  • Hands-on Lab: INSERT, UPDATE, and DELETE
Plugin
  • Hands-on Lab: Relational Data Concepts

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

Videos
  • Introduction to Django
  • Object-Oriented Analysis and Design
  • Object-Relational Mapping (ORM)
  • Django Model
  • Django Models CRUD
  • Related Objects
Reading
  • 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
Quiz
  • Module 2 Practice Quiz: ORM - Bridging the Gap Between the Real World and Relational Model
Assignment
  • Module 2 Graded Quiz: ORM - Bridging the Gap Between the Real World and Relational Model
App Items
  • 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
Plugin
  • Reading: ORM Tools

Module 3: Full-stack Django Development

Videos
  • Django Model-View-Template Pattern
  • Create a Django App
  • Django Admin Site
  • Django Views
  • Django Templates
Reading
  • Module 3 Summary: Full-stack Django Development
  • Module 3 Cheat Sheet: Full-stack Django Development
Quiz
  • Graded Quiz: Full-stack Django Development
Assignment
  • Practice Quiz: Full-stack Django Development
App Items
  • Hands-on Lab: Create Your First Django App and Deploy using Docker
  • Hands-on Lab: Django Admin
  • Hands-on Lab: Views and Templates
Plugin
  • Advanced Features of the Django Template

Module 4: Consolidate and Deploy Your Django App

Videos
  • Class-based and Generic Class Views
  • Django Authentication System
  • Bootstrap Integration
  • Manage Static Files 
  • Deploy Your Django App on IBM Cloud
Reading
  • Module 4 Summary: Consolidate and Deploy Your Django App
  • Module 4 Cheat Sheet: Consolidate and Deploy Your Django App
Quiz
  • Graded Quiz: Consolidate and Deploy Your Django App
Assignment
  • Practice Quiz: Consolidate and Deploy Your Django App
Plugin
  • Hands-on Lab: Class-based and Generic Views
  • Hands-on Lab: Django Authentication
  • Hands-on Lab: Bootstrap Integration

Module 5: Final Project: Enhance Online Course App with New Features

Admission details

If you want to register for the Developing Applications training programme, follow the steps listed below:

Step 1. Head to the official Coursera website: https://www.coursera.org/   

Step 2. Sign in using your Coursera credentials or through your Google ID, Facebook account, or Apple ID.

Step 3. In Coursera’s search bar, type in the name of the course, “Developing Applications with SQL, Databases, and Django.”

Step 4. Select the “Enroll for Free” button on the top-right. 

Step 5. Select whichever option you want– audit or certificate - from the pop-up window.


Filling the form

Submitting a separate application form to participate in the Developing Applications training course isn’t required. Simply join for free by signing up with your Google, Facebook, or Apple ID and begin learning.

Scholarship Details

Coursera offers financial aid to those who can’t afford the Developing Applications certification fee. To apply for one, you must fill out a dedicated application form. You can access the form by selecting the ‘Financial aid available’ beside the ‘Enroll for Free’ button. You’ll be notified of the approval through an email within 15 days of form submission.

How it helps

When you register for the Developing Applications certification programme, you not only get in-depth video lectures and insightful reading material but also engage in hands-on, practical training exercises that are aligned with real-life industry problems. Moreover, you also get to test your knowledge with an abundant amount of practice exercises, quizzes, and assignments.

Lastly, if you pay for the certificate experience, you can get access to additional graded assignments and features, along with a course completion certificate. Earning this certificate will enable you to display your skills to top industry recruiters and get lucrative employment offers.

Instructors

Mr Yan Luo

Mr Yan Luo
Data Scientist
IBM

Ph.D

Mr Rav Ahuja

Mr Rav Ahuja
Global Program Director
IBM

B.E /B.Tech, MBA

FAQs

Do I get university credits for clearing the course?

No, the programme doesn’t carry university credits. However, you can check with your institution to convert the course into credits, as many universities do accept course credentials for credit.

Who will teach the course?

The Developing Applications course will be taught by Rav Ahuja and Yan Luo. Learn more about Yan Luo https://www.coursera.org/instructor/yanluo. Click https://www.coursera.org/instructor/ravahuja  to find information about Rav Ahuja

Which organisation has Coursera collaborated with to make this course available?

IBM has partnered with Coursera to bring you the Developing Applications programme.

Do I have to follow strict deadlines?

No, the assignment deadlines are flexible.

Is this an advanced-level programme?

No, the Developing Applications course is an intermediate-level training programme.

Similar Courses

Building No-Code Apps with AppSheet Implementation

Google via Coursera

3 Weeks Online
Intermediate

Application Development using Microservices and Se...

IBM via Coursera

6 Weeks Online
Intermediate

Full Stack Application Development Project

IBM via Edx

2 Weeks Online
Intermediate
Free

Software Development Fundamentals

Penn via Edx

4 Weeks Online
Intermediate
Free
STM32 Drone Programming A to Z Sensor I F to Fligh...

STM32 Drone Programming A to Z Sensor I F to Fligh...

Udemy

Online
Intermediate
₹479 ₹3,499

Getting Started With Application Development

Google via Coursera

7 Weeks Online
Intermediate

Mobile Virtual Reality App Development with Unity

Unity Technologies via Coursera

4 Weeks Online
Intermediate

Handheld Augmented Reality App Development with Un...

Unity Technologies via Coursera

4 Weeks Online
Intermediate

Developing Cloud Apps with Node.js and React

IBM via Coursera

5 Weeks Online
Intermediate
Free

Hyperledger Sawtooth for Application Developers

The Linux Foundation via Edx

14 Weeks Online
Intermediate
Free

Courses of your Interest

Build AI Apps with ChatGPT Dall E and GPT 4

Build AI Apps with ChatGPT Dall E and GPT 4

Scrimba via Coursera

3 Weeks Online
Intermediate
Free

Artificial Intelligence Ethics in Action

LearnQuest via Coursera

Online
Intermediate

Artificial Creativity

Parsons School of Design, The New Sch... via Coursera

Online
Intermediate
Data Science on Microsoft Azure Using Python Progr...

Data Science on Microsoft Azure Using Python Progr...

CloudSwyft Global Systems, Inc via Futurelearn

15 Weeks Online
Intermediate

Angular7 for Intermediate Level

Great Learning

2 Hours Online
Intermediate
Free

Hashing in Java

Great Learning

Online
Intermediate
Free

Binary Trees

Great Learning

1 Hour Online
Intermediate
Free
Fullstack Enterprise Mongo Express Vue And Node

Fullstack Enterprise Mongo Express Vue And Node

Simpliv Learning

Online
Intermediate
$199 $999
Visual Design for Web Designers UI Designers and D...

Visual Design for Web Designers UI Designers and D...

Simpliv Learning

Online
Intermediate
$199 $999
Learning Algorithms in JavaScript from Scratch

Learning Algorithms in JavaScript from Scratch

Simpliv Learning

Online
Intermediate
$199 $999

More Courses by IBM

AI Applications With Watson

IBM via Edx

3 Weeks Online
Intermediate
Free

Site Reliability Engineers Infrastructure Resilien...

IBM via Edx

6 Weeks Online
Intermediate
Free

Python for Data Science Project

IBM via Edx

1 Week Online
Intermediate
Free

Site Reliability Engineering Fundamentals and Secu...

IBM via Edx

5 Weeks Online
Intermediate
Free

Site Reliability Engineering Capstone

IBM via Edx

4 Weeks Online
Intermediate
Free

Blockchain Framework and Platforms

IBM via Edx

2 Weeks Online
Intermediate
Free

Introduction to System Programming on IBM Z

IBM via Edx

3 Weeks Online
Intermediate
Free

Smarter Chatbots with Node RED and Watson AI

IBM via Edx

3 Weeks Online
Intermediate
Free

Relational Database Administration

IBM via Coursera

5 Weeks Online
Intermediate

Data Topology

IBM via Coursera

3 Weeks Online
Intermediate
Free

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books