FlexStack: SQL Fundamentals 3 - Winding a Web with Python and SQL

  • Overview
  • Course Content
  • Requirements & Materials
Overview

FlexStack: SQL Fundamentals 3 - Winding a Web with Python and SQL

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 Django framework. The final lessons focus on object-relational mapping tools, how and when to use them, and 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 at every class session 
  • No homework
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.

 

Prerequisites

Completion of FlexStack: SQL Fundamentals 1 - Pulling Up to the Database Table and FlexStack: SQL Fundamentals 2 - Perking Up Your Lagging Database.

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

  • Store, retrieve and manipulate data, and create and modify database schemas within a database management system (DBMS) with SQL. 
  • Use aggregation, filters, and sorting to provide additional insights on data beyond basic data retrieval.
  • Implement keys, constraints, indices, and normalization for improving database performance and ensuring data integrity.
  • Create stored procedures, triggers, and use transactions to facilitate easier database usage for applications.
  • Build basic database-driven web applications for humans as well as structured data interfaces for machines using the Python programming language and associated frameworks.
  • Recognize applications of the object-relational model and its usage for rapid application development. 
  • Assess AI-generated code for accuracy and effectiveness.
  • 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?