FlexStack: SQL Fundamentals 3 - Database Web Apps

  • Overview
  • Course Content
  • Requirements & Materials
Overview

FlexStack: SQL Fundamentals 3 - Database Web Apps

Course Description

After learning how to manage and use databases, students will learn how to connect databases to applications using the Python programming language. The third course in the FlexStack: SQL Fundamentals Certificate series begins with an emphasis on loading data into various data structures, followed by steps for creating basic data-driven web applications and data feeds using the Flask framework. The final lessons focus on object-relational mapping tools, how and when to use them, as well as their benefits and drawbacks. 

Course Content
  • Individual modules to help students learn Python one step at a time
  • Interactive sessions for gaining knowledge and asking questions in real-time
  • Immersive exercises to practice using Python right away
  • Hands-on guidance available during every class session
Requirements & Materials

Requirements

A Windows or Mac computer with a webcam is required to participate in the course. Tablets or other devices are not supported. Familiarity with using a computer and adequate typing ability. Recommended: Additional monitor.

Familiarity with using a computer and adequate typing ability. 

Participants are expected to have their cameras on during the interactive sessions and must attend 80% of the sessions to pass the course.

 

Prerequisites

Materials

Supplemental materials provided.

Session Details

Who Should Attend

This course is perfect for those wanting more control over the data collected and stored through their work. Everyone, including managers, programmers, engineers, teachers, accountants, and more, are surrounded by data and access databases every day. This certificate teaches participants how to use SQL databases to appropriately store and manage data, query and update the data within them, and gain essential skills for implementing database-centric programs.  

A person sitting at a desk with a computer

What You Will Learn

  • NumPy and Pandas Python frameworks and how they are used to manipulate and store data within Python programs
  • Processing and loading of data from files and SQL databases into Python data structures
  • Using Pandas with Python code to modify, query, and iterate over data
  • Explanation of process for updating SQL databases from Python programs
  • Web APIs and Python frameworks for accessing data stored in a SQL database
  • CRUD and REST data models for building a web API using Django
  • Implementation of object-relational mapping to accelerate development of a web API
  • Basic methods to secure web APIs
A person looking at a screen

How You Will Benefit

  • Describe how NumPy and Pandas are used to manipulate and store data within Python programs.
  • Illustrate how to process and load data from files and SQL databases into Python data structures.
  • Assemble Python code using Pandas to modify, query, and iterate over data.
  • Explain how to perform updates to SQL databases from Python programs.
  • Discuss how to access data stored in SQL databases using web APIs and Python frameworks.
  • Employ CRUD and REST data models to build a web API using Django.
  • Implement object-relational mapping to accelerate the development of web APIs 
  • Grow Your Professional Network icon
    Grow Your Professional Network
  • Taught by Experts in the Field icon
    Taught by Experts in the Field

Want to learn more about this course?