Course description
Django Application Development with SQL and Databases
The essential building blocks of application development include accessing, processing, and presenting data. With vast amounts of data stored in various databases, on the cloud or on-premises, developers will use a language like SQL.
This course introduces you to the basics of SQL, a simple and powerful programming language for querying and managing data, and the fundamentals of cloud databases. You will discover Object-Relational Mapping (ORM), and how to use Object-Oriented Programming (OOP) languages to work with databases.
You will be introduced to Django, a fast and simple open source web framework used by developers to simplify their work. You will learn how Django models, views and templates work together to present data on a website and will use Django’s powerful admin site functionality to manage site content. And you will 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.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
- Knowledge of:
- GitHub
- HTML & CSS
- Python
Outcome / Qualification etc.
What you'll learn
- Learn and apply foundational knowledge of the SQL language
- How to create a database in the cloud
- How to use string patterns and ranges to query data
- How to sort and group data in result sets and by data type
- How to analyze data using Python
Training Course Content
Module 1: Introduction to Databases
- Introduction to Databases and Database Management Systems
- Relational Databases
- Relational Data Concepts
- Hands-on Lab: Entity-Relationship Data Modeling
- SELECT Statement
- Hands-on Lab: Simple SELECT Statements
- COUNT, DISTINCT, LIMIT
- INSERT Statement
- UPDATE and DELETE Statements
- Hands-on Lab: INSERT, UPDATE, and DELETE
- Basic SQL Statements Summary
Module 2: ORM: Bridging the Gap between the Real World and Relational Model
- Object-Relational Mapping (ORM)
- Django Model
- Hands-on Lab: Create a Django project in Theia
- Optional Lab: Create a Standalone Django ORM Project Template
- Django CRUD
- Hands-on Lab:CRUD on Django Model Objects
- Related Objects
- Hands-on Lab: Query Spanning Relationships
Module 3: Full-stack Django Development
- Django Model-View-Template pattern
- Quiz: MVC and Django MVT pattern
- Create a Django app
- Hands-on Lab: Create your first Django App
- Django Admin Site
- Hands-on Lab: Django Admin
- Django Views
- Django Templates
- 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: User Signup and Signin
- Bootstrap integration
- Hands-on Lab: Bootstrap Integration
- Manage Static Files
- Deploy your Django App on IBM Cloud
- Hands-on Lab: Deploy your Django app on IBM Cloud Foundry
Course delivery details
This course is offered through IBM, a partner institute of EdX.
6–8 hours per week
Expenses
- Verified Track -$49
- Audit Track - Free