Advanced Python | The Complete Python and PostgreSQL Developer Course

Book Overview & Buying
Table Of Contents

The Complete Python and PostgreSQL Developer Course

By : Codestars By Rob Percival, Jose Salvatierra Fuentes

3 (1)

Buy this Video

The Complete Python and PostgreSQL Developer Course

3 (1)

By: Codestars By Rob Percival, Jose Salvatierra Fuentes

Buy this Video

Overview of this book

Ever wanted to learn one of the most popular programming languages on the planet? Why not learn two of the most popular at the same time? Python and SQL are widely used by small to large technology companies thanks to their powerful, yet extremely flexible features. While Python is used in the industry for embedded software, web development, desktop applications, and mobile apps, PostgreSQL allows your applications to become even more powerful by storing, retrieving, and filtering through large datasets easily. This course is your one-stop-shop for everything Python and PostgreSQL. You’ll advance from an absolute Python and PostgreSQL beginner to an experienced software developer. Get ready to transform your world and become a super-confident app developer! All the code files are placed at https://github.com/PacktPublishing/The-Complete-Python-and-PostgreSQL-Developer-Course

Installing Python

Introduction

Installing Python on Windows

Installing Python on Mac

Python 101

The Python interactive shell (IDLE)

Numbers and Strings in Python

Variables in Python

The str() method to convert to Strings

Running a Python file from the IDLE

Getting user input in Python

The int() method to convert to Integers

The format() method to simplify String formatting

Magic Numbers in Python

Lists in Python

The for loop in Python

Boolean expressions, True and False

If statements in Python

The 'in' keyword to check whether a list contains an element

Giving the user multiple chances in our program

Generating random integers in Python

Defining our own methods in Python

Returning values from our methods in Python

A Lottery app

The String split() method

List comprehension in Python

Python Sets — what is a Set?

Set comprehension in Python

Creating our lottery numbers

Calculating the lottery winnings

More complex applications: a student registration system

Installing PyCharm, a professional Python tool

Setting up PyCharm on Mac

Setting up PyCharm on Windows

Dictionaries in Python

Advanced Dictionary usage in Python

Methods returning dictionaries

Appending to a list in Python

Adding marks to our student data structure

The sum() method in Python

Iterating over a dictionary's keys and values

Creating the application menu

Object-Oriented Programming: a movie rental system

What are classes? Classes in Python

The Movie Class

The User Class (and the __repr__ method)

The filter() method in Python

More Movie operations and methods

Writing to a file in Python

Saving CSV files with our data

Loading our data from CSV files

Saving JSON files with our data

Loading our data from JSON files

Argument unpacking in Python (the two asterisks)

Creating the menu for our application

Introduction to PostgreSQL

Introduction to databases

Installing PostgreSQL on Windows

Using PostgreSQL on Windows

Executing SQL queries on Windows

Installing PostgreSQL on Mac

Using PostgreSQL on Mac

Executing SQL commands on Mac

Using the sample data provided

SQL: The SELECT command

SQL: filtering with WHERE

SQL: LIMIT for limiting the number of results

SQL: UPDATE data in a table

SQL: DELETE data from a table

SQL Wildcards for filtering unknowns

What is a JOIN?

SQL: JOINs and JOIN examples

SQL: GROUP BY for aggregation of data

SQL: ORDER BY for sorting data

SQL: CREATE TABLE

SQL: INSERT INTO for adding data to a table

SQL: SEQUENCE for auto-incrementing fields

SQL: CREATE INDEX and advanced information about indexes

SQL: DROP TABLE for deleting tables and data

Advanced PostgreSQL

SQL: VIEWs and what they are used for

SQL: built-in functions and the HAVING construct

Dates in SQL: an old problem

Other data types in SQL (including JSON in PostgreSQL)

Nested SELECT statements for complex queries

The PostgreSQL SERIAL type

Python and PostgreSQL

Installing psycopg2 on Windows (2018 update)

Installing psycopg2 on Windows (older versions)

Installing psycopg2 on Mac

Verifying everything works—don't proceed if it doesn't!

Mac OS X: Fixing psycopg2 'library not loaded' error

What is a virtual environment?

psycopg2 on a virtualenv on Windows (2018 update)

Psycopg2 on a virtualenv on Windows (older versions)

Setting up the app structure, pip, and requirements.txt

Recap on classes and object-oriented programming

Saving to database from Python

Loading from the database from Python

Removing some duplicate code from our app

Connection pooling and why it is important

Creating the ConnectionPool class

Creating the ConnectionFromPool class

Obtaining a cursor from the ConnectionFromPool class

The Database class and selective initialisation

Cleaning up the Database class

End of section review

Python Web and APIs

What is an API?

Making requests in Python

What is OAuth?

Creating a Twitter app

Setting up Twitter login

Getting the OAuth request token

More on the Python debugger—an essential tool

Getting authorization by the user

Getting the OAuth access token

Performing Twitter requests: getting images

Reusing code from the last section to save users

Creating users in our app

Retrieving users in our app

Cleaning up the code—extremely important!

Introduction to Flask and Python Web Development

Adding a Twitter login endpoint

Adding Twitter authorization

Creating the user profile

The Flask before_request decorator

Checking if a user is already logged in

Searching tweets and displaying them

Searching for different things

What is Bootstrap?

Writing our own CSS

Allowing users to perform custom searches

Adding sentiment analysis with another API

Introduction to Git and GitHub

What is Git?

Installing Git on Mac and Windows

Introduction to the UNIX terminal

The VIM text editor, a powerful terminal editor

Dealing with files in the UNIX terminal

What is a Git repository?

git init — create a Git repository

git add and git commit — staging and committing

git log — viewing past commits

Creating a repository on GitHub

git remote — managing remote repositories

Adding your SSH key to GitHub

What is a README file? Introduction to Markdown

git pull — pulling other's changes

Advanced Python

OOP: Inheritance

OOP: Multiple Inheritance in Python

OOP: What is composition?

OOP: What is encapsulation?

Introduction to Exceptions in Python

Creating our own Exceptions

Some of the available built-in Exceptions

Python built-in methods

Assertions in Python

Lambda expressions in Python

More uses of lambda expressions

Lambda expressions in the wild

Introduction to unit testing with unittest

Data Structures and Algorithms

What are data structures?

What is a Linked List?

Introduction to Linked List Assignment

Programming our own Linked List in Python

Creating a Queue

Introduction to Queue Assignment

Programming our own Queue in Python

Creating a Stack

Introduction to Stack Assignment

Programming our own Stack in Python

Creating a Binary Tree

Introduction to Binary Tree Assignment

Programming our own Binary Tree in Python

The Complete Python and PostgreSQL Developer Course

By : Codestars By Rob Percival, Jose Salvatierra Fuentes

The Complete Python and PostgreSQL Developer Course

By: Codestars By Rob Percival, Jose Salvatierra Fuentes

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