Developing Applications with SQL, Databases, and Django

所在平台: Coursera

课程主页: https://www.coursera.org/learn/developing-applications-with-sql-databases-and-django

课程评论：没有评论

第一个写评论        关注课程

课程简介

课程名称：使用 SQL、数据库和 Django 开发应用程序 课程概述：应用程序开发的核心是访问、处理和展示数据。数据存储在本地或云端的多种数据库中，开发者需要学习如何通过编程语言与这些数据库进行交互。本课程将介绍一些基本的数据库概念，学习 SQL 这门简单而强大的数据查询和管理编程语言，并了解云数据库的基本概念，获得实际的云数据库体验。 此外，您将发现对象关系映射（ORM）如何使您能够使用面向对象编程（OOP）语言来处理数据库。通过创建一个 Django 网页应用，您将掌握全栈 Django 技能，以持久化、处理和展示数据。您还将学习云应用平台的基本原理，并获得在云上部署 Django 网页应用的实践经验。 课程学习目标： - 描述数据库及其数据建模的概念 - 编写 SQL 查询以插入、选择、更新和删除数据库中的数据 - 理解对象关系模型（ORM） - 使用 Django 开发基于数据库的应用程序 - 在云上部署您的 Django 应用程序 先决条件： - GitHub - HTML 和 CSS - Python 课程大纲： 1. **SQL 与关系数据库入门** - 介绍数据、数据库和数据库管理系统的基本概念，学习一些基本的 SQL 语句，探索关系数据库的结构、用例和局限性，以及了解云数据库基础知识并创建云数据库实例。 2. **ORM：连接现实和关系模型之间的桥梁** - 探讨如何通过对象关系映射（ORM）在现代应用开发中使用面向对象编程语言与数据库交互，而无需编写 SQL 代码，掌握 Django ORM 的使用。 3. **全栈 Django 开发** - 创建一个 Django 网页应用，了解 Django 模型-视图-模板设计模式及其如何协同工作，学习 Django 项目的构建流程和网页内容管理。 4. **整合与部署您的 Django 应用** - 增强 Django 技能，通过类视图和认证、授权模块的学习，探索如何使用 Bootstrap 快速构建互动的网页，并了解 Django 在开发和部署中的静态文件管理。 5. **最终项目：为在线课程应用程序增强新功能** - 在这一模块中，将应用所学知识和技能，在实践项目中改进应用，并完成同行评审的最终项目。 通过本课程的学习，您将为开发基于数据库的应用程序奠定坚实的基础，并掌握将其部署至云端的技能。

课程大纲

Name:Getting Started with SQL & Relational Databases

Description:What is data? As you start this course, you will be introduced to concepts fundamental to understanding data, databases, and database management systems. You will learn some basic SQL statements. Explore the structure, use cases, and limitations of relational databases. Learn key relational database concepts, including entities, attributes, entity-relationship data modeling, common data types, and primary key. You will learn about cloud database fundamentals and get hands-on experience creating a database instance on the cloud. At the end of the module, an optional lesson with more advanced SQL techniques will help you get the most out of your data.

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

Description:You’re aware that SQL is a powerful tool for working with databases. But in the modern application development environment, object-oriented programming is the most popular paradigm, and it is quite different from SQL. Is there a way to use Object-oriented programming to work with databases? Discover how Object-Relational Mapping (ORM) bridges the gap between object-oriented programming (OOP) and SQL and allows application developers to use OOP languages to work with databases without writing SQL code. Gain skills in using Django ORM, a popular ORM library for Python, to define models and fields so they can be mapped to database tables. Learn the steps for using Django ORM to convert your entity-relationship diagrams into Django models. Gain knowledge about using Django Model APIs to manipulate objects in databases without writing SQL queries. Explore the many useful methods Django Model provides to handle related objects.

Name:Full-stack Django Development

Description:It’s time to build your skills by creating a Django web app. In this module, you’ll explore the Django Model- View- Template design pattern and learn how Django models, views, and templates work together to present data on a website. You’ll look at a typical Django development process, starting with building a Django project and creating and adding an app. Gain knowledge about the Django web app structure. Learn the steps to create Django models and views, add an HTML template, map the request URLs to your views, and design and build the UI. Next, use Django’s powerful admin site functionality to manage your site content. You’ll build an admin site and create an admin user. You’ll specify the model fields on the admin site and add UI features such as Search and Filter. Create a Django view to receive an HTTP request and send an HTTP response. Discover how to combine Django views and templates to present your data as dynamic web pages.

Name:Consolidate and Deploy Your Django App

Description:Add to your Django skills by building a class-based view. Then, learn how to speed up development using Django’s generic-based views. Next, you’ll learn about authentication and authorization in Django. Create a User model to handle authentication and work with other models to handle authorization. Create web login, log out, and registration forms. Assign permissions to models and user groups. You’ll then move on to Bootstrap, a free and open-source web front-end framework. Learn how to quickly add Bootstrap to your Django template to build stylized and interactive web pages. Next, explore how to add static files to your apps. Learn how Django manages static files in development and deployment environments. Learn about the webserver interfaces supported by Django. And discover how Infrastructure as a Service and Platform as a Service offerings can streamline app deployment. Explore the benefits of deploying Django apps on IBM Cloud.

Name:Final Project: Enhance Online Course App with New Features

Description:Welcome to the culmination of your learning journey in this Django course. In this module, you will apply your new skills and knowledge to improve applications in a practice project and a peer-reviewed final project.

课程评论(0条)