Interacting with Databases | Complete Python Course with 10 Real-World Projects

Book Overview & Buying
Table Of Contents
Feedback & Rating

Complete Python Course with 10 Real-World Projects

By : PythonHow, Ardit Sulce

4.2 (9)

Buy this Video

Complete Python Course with 10 Real-World Projects

4.2 (9)

By: PythonHow, Ardit Sulce

Buy this Video

Overview of this book

Python is a multi-paradigm programming language with object-oriented and structured programming fully supported, and many features support functional and aspect-oriented programming (metaprogramming and metaobjects). Several other paradigms are supported through extensions, including design by contract and logical programming. This course begins with a brief introduction and covers basic to advanced programming techniques in Python. The first 12 sections of the course cover Python basics. The remaining sections cover intermediate to advanced Python concepts (OOPS, classes, lists, modules, functions, JSON, and so on). Learn to use Matplotlib, NumPy, Flask, and Android APK files. Learn database handling and build geographical apps. The ten buildable apps covered in the course include a volcano web map generator, object detector app, personal website built with Python and Flask, book inventory desktop GUI app with SQL backend, data analysis/visualization dashboard, mobile app on Android and iOS devices, an app that scrapes multiple real estate webpages data, web app to collect user data and sends emails, blog and translator with Django, and web app to process Excel files and download processed files. Upon completion, you can create executable Python programs independently and master coding syntax and Python comprehensively. All codes are available at: https://github.com/PacktPublishing/Complete-Python-Course-with-10-Real-World-Projects

Welcome

Course Introduction

Getting Started with Python

Section Introduction

Installing Python and the IDE

Creating and Running a Python Program

What (Surprisingly) Is Python?

The Basics: Data Types

Section Introduction

Variables -Why and How to Use Variables

Python Interactive Shell

Terminal

Simple Types: Integers, Strings, and Floats

List Types

Ranges

Data Type Attributes

How to Find Out What Code You Need

Dictionary Types

What Makes a Programmer a Programmer?

Tuples

How to Use Datatypes in the Real World

The Basics: Operations with Data Types

Section Introduction

Tip: Better Error Messages in Python 3.10

More Operations with Lists

Accessing List Items

Accessing List Slices

Accessing Items and Slices with Negative Indexes

Accessing Characters and Slices in Strings

Accessing Items in Dictionaries

The Basics: Functions and Conditionals

Section Introduction

Creating Your Own Functions

Print or Return?

Introduction to Conditionals

If Conditional Example

Conditional Explained Line by Line

More on Conditionals

Elif Conditionals

White Space

The Basics: Processing User Input

Section Introduction

User Input

String Formatting

String Formatting with Multiple Variables

The Basics: Loops

Section Introduction

For Loops: How and Why

Looping Through a Dictionary

While Loops: How and Why

While Loop Example with User Input

While Loops with Break and Continue

Putting the Pieces Together: Building a Program

Section Introduction

Problem Statement

Approaching the Problem

Building the Maker Function

Constructing the Loop

Making the Output User-Friendly

List Comprehensions

Section Introduction

Simple List Comprehension

List Comprehension with If Conditional

List Comprehension with If-Else Conditional

More about Functions

Section Introduction

Functions with Multiple Arguments

Default and Non-Default Parameters and Keyword and Non-Keyword Arguments

Functions with an Arbitrary Number of Non-Keyword Arguments

Functions with an Arbitrary Number of Keyword Arguments

File Processing

Section Introduction

Processing Files with Python

Reading Text from a File

File Cursor

Closing a File

Opening Files Using "with"

Different File paths

Writing Text to a File

Appending Text to an Existing File

Modules

Section Introduction

Built-In Modules

Standard Python Modules

Third-Party Modules

Third-Party Module Example

Using Python with CSV, JSON, and Excel Files

Section Introduction

The "pandas" Data Analysis Library

Getting Started with Pandas

Getting Started with Jupyter

Loading CSV Files

Loading Excel Files

Loading Data from Plain Text Files

Set Table Header Row

Set Column Names

Set Index Column

Filtering Data from a Pandas Data Frame

Deleting Columns and Rows

Updating and Adding New Columns and Rows

Data Analysis Example: Converting Addresses to Coordinates

Numerical and Scientific Computing with Python and NumPy

What Is NumPy?

Convert Images to NumPy Arrays

Indexing, Slicing, and Iterating NumPy Arrays

Stacking and Splitting NumPy Arrays

App 1: Web Mapping with Python: Interactive Mapping of Population and Volcanoes

Demo of the Web Map

Creating an HTML Map with Python

Adding a Marker to the Map

Practicing "for-loops" by Adding Multiple Markers

Practicing File Processing by Adding Markers from Files

Practicing String Manipulation by Adding Text to the Map Popup Window

Practicing Functions by Creating a Color Generation Function for Markers

Solution: Add and Stylize Markers

Exploring the Population JSON Data

Practicing JSON Data by Adding a Population Map Layer from the Data

Stylizing the Population Layer

Adding a Layer Control Panel

App 2: Building an English Thesaurus

Demo of the Interactive English Dictionary

Know Your Dataset

Loading JSON Data

Returning the Definition of a Word

Existing Words

Dealing with Case-Sensitive Words

Calculating the Similarity Between Words

Best Matches Out of a List of Words

Finding the Most Similar Word from a Group of Words

Getting Confirmation from the User

Optimizing the Final output

Fixing Programming Errors

Syntax Errors

Runtime Errors

How to Fix Difficult Errors

How to Ask a Good Programming Question

Making the Code Handle Errors by Itself

Image and Video Processing with Python

Introduction

Loading, Displaying, Resizing, and Creating Images

Solution Further Explained

Detecting Faces in Images

Capturing Video with Python

App 3: Controlling the Webcam and Detecting Objects

Demo of the Webcam Motion Detector App

Detecting Moving Objects from the Webcam

Storing Object Detection Timestamps in a CSV File

Interactive Data Visualization with Python and Bokeh

Introduction to Bokeh

Your First Bokeh Plot

Using Bokeh with Pandas

Creating a Time-Series Plot

More Visualization Examples with Bokeh

Plotting Time Intervals from the Data Generated by the Webcam App

Implementing a Hover Feature

App 4 (Part 1): Data Analysis and Visualization with Pandas and Matplotlib

Preview of the End Results

Exploring the Dataset with Python and Pandas

Selecting Data

Filtering the Dataset

Time-Based Filtering

Turning Data into Information

Aggregating and Plotting Average Ratings by Day

Down-sampling and Plotting Average Ratings by Week

Down-Sampling and Plotting Average Ratings by Month

Average Ratings by Course by Month

What Day of the Week Are People the Happiest?

Other Types of Plots

App 4 (Part 2): Data Analysis and Visualization - in-Browser Interactive Plots

Introduction to the Interactive Visualization Section

Making a Simple Web App

Making a Data Visualization Web App

Changing Graph Labels in the Web App

Adding a Time-Series Graph to the Web App

Multiple Time-Series Plots

Multiple Time-Series Streamgraph

Adding a Pie Chart to the Web App

App 5: Web Development with Flask - Build a Personal Website

Demo of the Personal Website

Building Your First Website

Preparing HTML Templates

Adding a Website Navigation Menu

Improving the Website Frontend with CSS

Creating a Python Virtual Environment

How to Use the PythonAnywhere Service

Deploying the Flask App on PythonAnywhere

Building Desktop Graphical User Interfaces (GUI) with Python

Introduction to the Tkinter Library

Creating a GUI Window and Adding Widgets

Connecting GUI Widgets with Functions

Interacting with Databases

How Python Interacts with Databases #sql

Connecting to a SQLite Database with Python

(SQLite) Selecting, Inserting, Deleting, and Updating SQL Records

PostgreSQL Database with Python

(PostgreSQL) Selecting, Inserting, Deleting, and Updating SQL Records

App 6: GUI Apps and SQL: Build a Book Inventory Desktop GUI Database App

Demo of the Book Inventory App

Designing the User Interface

Coding the Frontend Interface

Coding the Backend

Connecting the Frontend with the Backend, Part 1

Connecting the Frontend with the Backend, Part 2

Creating .exe and .app Executables from the Python Script

Object-Oriented Programming (OOP)

What Is Object-Oriented Programming (OOP)?

Using OOP in a Program, Part 1

Using OOP in a Program, Part 2

Creating a Bank Account Class

Creating Classes Through Inheritance

OOP Glossary

App 7: Mobile App Development: Build a Feel-Good App

Demo of the Mobile App

Creating a User Login Page

Creating a User Sign-Up Page

Capturing User Input

Processing User Signups

Creating a Sign-Up Success Page

Switching Between Pages

Processing User Login Credentials

Displaying Output to the User

Stylizing the Login Page

Stylizing the Sign-Up Page

Making the Buttons Interactive

Making a Scrollable Area

Making an Android APK File from the Kivy App

Preparing the Environment for Deploying the App to an Android Phone

Creating an APK file for Android

Installing the APK file on Android

Web Scraping with Python and Beautiful Soup

Section Introduction

How Web Scraping Works

Web Scraping Example with Python

App 7: Web Scraping - Scraping Properties for Sale from the Web

Demo of the Web Scraping App

Loading the Webpage in Python

Extracting "div" Elements

Scraping the Addresses of the Properties

Scraping Special Elements

Saving the Extracted Data in CSV Files

Crawling Through Multiple Webpages

App 9: Django and Bootstrap Blog and Translator App

A Comparison of Python Web Frameworks

Setting Up a Virtual Environment

Creating a Django Project

Creating a Superuser for the Project

Setting Up an Empty Django Blog App

Creating a Database Model for the Blog App

Overview of the Web App Architecture

HTML Templates

Django Views

URL Patterns

Creating Admin Interface Views

Creating a Homepage

Creating an "About" Page

Listing Blog Posts on the Homepage

Creating Links

Adding Bootstrap to Django

Django Template Filters

Template Inheritance

Applying Bootstrap Styling to the Navigation Menu

Demo of the Django Translation App

The Steps of Django App Development

Creating an Empty App Structure of the Translator

Creating an HTML Form in Django

Configuring the URLs

Creating a Form

Getting and Processing User Input Through a Form

Completing the Translator App

App 10: Build a Geography Web App with Flask and Pandas

Demo of the Geography Web App

Solution, Part 1

Solution, Part 2

Customer Reviews

4.2 (9)

5 star

44.4%

4 star

33.3%

3 star

22.2%

2 star

1 star

Complete Python Course with 10 Real-World Projects

By : PythonHow, Ardit Sulce

Complete Python Course with 10 Real-World Projects

By: PythonHow, Ardit Sulce

Overview of this book

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access