Database Programming with Python

Database Programming with Python, available at $49.99, has an average rating of 4.1, with 74 lectures, based on 301 reviews, and has 1510 subscribers.

You will learn about Install and configure the tools required for working with Python and databases including development tools, drivers, and modules Design a database within SQLite, MySQL, and SQL Server Normalize a database including establishing keys and relationships Use an RDBMS to manually add data to a database Use the Structured Query Language (SQL) to write create, retrieve, update, and delete (CRUD) statements Use Eclipse and Python to connect to a database and perform CRUD operations Build out a full-functioning Help Desk application using Python and SQLite This course is ideal for individuals who are Beginner to intermediate Python developers curious about integrating databases into their workflows. or This course is not intended for experienced Python developers already familiar with relational and object-oriented database development with Python. It is particularly useful for Beginner to intermediate Python developers curious about integrating databases into their workflows. or This course is not intended for experienced Python developers already familiar with relational and object-oriented database development with Python.

Enroll now: Database Programming with Python

Summary

Title: Database Programming with Python

Price: $49.99

Average Rating: 4.1

Number of Lectures: 74

Number of Published Lectures: 74

Number of Curriculum Items: 74

Number of Published Curriculum Objects: 74

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Install and configure the tools required for working with Python and databases including development tools, drivers, and modules

Design a database within SQLite, MySQL, and SQL Server

Normalize a database including establishing keys and relationships

Use an RDBMS to manually add data to a database

Use the Structured Query Language (SQL) to write create, retrieve, update, and delete (CRUD) statements

Use Eclipse and Python to connect to a database and perform CRUD operations

Build out a full-functioning Help Desk application using Python and SQLite

Who Should Attend

Beginner to intermediate Python developers curious about integrating databases into their workflows.

This course is not intended for experienced Python developers already familiar with relational and object-oriented database development with Python.

Target Audiences

Beginner to intermediate Python developers curious about integrating databases into their workflows.

This course is not intended for experienced Python developers already familiar with relational and object-oriented database development with Python.

It’s not often that you get to use a language as powerful and as versatile as Python. Python is a great language for writing web applications, cross-platform desktop applications, Artificial Intelligence software, shell scripts, perform scientific computation, games, and even connect to and work with a myriad of relational and document-oriented database solutions. This course gets you up and running with using Python to program against relational and document-oriented databases such as SQLite, MySQL, SQL?Server, and MongoDB. It teaches you the basic concepts of relational data, databases, tables, SQL, and walks you through the code required to connect to these databases and perform CRUD?(create, retrieve, update, and delete)?operations within them using Python. When you’re finished with this course, you’ll have a solid foundation to go out and start building your own database applications using Python.

Course Curriculum

Chapter 1: Introduction to Python, Databases, and Tools

Lecture 1: Introduction

Lecture 2: The Importance of Data

Lecture 3: Introduction to Python

Lecture 4: What can I do with Python?

Lecture 5: Introduction to Databases

Lecture 6: Database and RDBMS Options

Lecture 7: SQLite and SQLite Studio

Lecture 8: MySQL and PhpMyAdmin

Lecture 9: SQL Server and Management Studio

Lecture 10: ODBC, DB API, and pyodbc

Lecture 11: Installing the Tools for this Course

Lecture 12: Installing Python

Lecture 13: Installing Eclipse

Lecture 14: Installing PyDev

Lecture 15: Installing the pyodbc Module

Lecture 16: Installing the MySQL Driver

Lecture 17: Installing the Microsoft ODBC Driver

Chapter 2: Creating Databases and Tables

Lecture 1: Introduction

Lecture 2: Introduction to Relational Data

Lecture 3: Planning and Designing a Database

Lecture 4: Tables, Records, and Columns

Lecture 5: Assigning Data Types

Lecture 6: Normalization

Lecture 7: Keys and Relationships

Lecture 8: An Overview of the Vecta Corp. Help Desk Database Structure

Lecture 9: The Employees Table

Lecture 10: The Roles Table

Lecture 11: The Tickets Table

Lecture 12: The Solutions Table

Lecture 13: The Status Table

Lecture 14: Lab 1a: Creating the Database and Tables in SQLite

Lecture 15: Lab 1b: Creating the Database and Tables in SQL Server

Lecture 16: Lab 1c: Creating the Database and Tables in MySQL

Lecture 17: Lab 2a: Establishing the Relationships in SQLite

Lecture 18: Lab 2b: Establishing the Relationships in SQL Server

Lecture 19: Lab 2c: Establishing the Relationships in MySQL

Lecture 20: Lab 3a: Manually Adding Data to the Tables in SQLite

Lecture 21: Lab 3b: Manually Adding Data to the Tables in SQL Server

Lecture 22: Lab 3c: Manually Adding Data to the Tables in MySQL

Chapter 3: Introduction to SQL

Lecture 1: Introduction

Lecture 2: Introduction to the Structured Query Language (SQL)

Lecture 3: The SELECT Command

Lecture 4: Filtering and Ordering Data with Clauses

Lecture 5: Operators for Advanced Querying

Lecture 6: The INSERT INTO Command

Lecture 7: The UPDATE Command

Lecture 8: The DELETE Command

Lecture 9: SQL Expressions and Aliases

Lecture 10: Common SQL Functions

Lecture 11: Joining Related Tables

Chapter 4: Python and Relational Databases

Lecture 1: Lecture Introduction

Lecture 2: Setting Up and Importing the Required Modules

Lecture 3: Connecting to a SQLite Database

Lecture 4: Connecting to a MySQL Database

Lecture 5: Connecting to a SQL Server Database

Lecture 6: How to Execute SELECT Statements

Lecture 7: How to Get the Rows in a Result Set

Lecture 8: How to Get Data from a Database View

Lecture 9: How to Insert Data into a Database

Lecture 10: How to Update Data in a Database

Lecture 11: How to Delete Data from a Database

Lecture 12: How to Handle Database Exceptions

Chapter 5: Project

Lecture 1: Lecture Introduction

Lecture 2: Setting Up the Administrative Dashboard

Lecture 3: Creating the Database Layer

Lecture 4: Creating the Object Layer

Lecture 5: Creating the User Interface (UI) Layer

Lecture 6: Lab 1: On Your Own! Displaying the User Role

Lecture 7: Lab 2: On Your Own! Logging In the Admin

Lecture 8: Setting Up the Help Desk Dashboard

Lecture 9: Creating the Object Layer

Lecture 10: Creating the Database Layer

Lecture 11: Creating the User Interface (UI) Layer

Lecture 12: Lab 3: On Your Own! Getting Employees When Adding Tickets

Instructors

Zak Ruvalcaba
Web App Developer, Programmer, Professor, Author, Athlete

Rating Distribution

1 stars: 7 votes

2 stars: 10 votes

3 stars: 52 votes

4 stars: 107 votes

5 stars: 125 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!