Build 9 projects and master two essential and modern technologies: Python and PostgreSQL
About This Video
In Detail
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 …
Build 9 projects and master two essential and modern technologies: Python and PostgreSQL
About This Video
In Detail
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!
Who this book is for
If you’re a complete beginner to programming and Python, this course will provides concise explanations with hands-on projects. Intermediate programmers will be able to fly through the first couple of sections and quickly learn about PostgreSQL and advanced Python concepts. This course is likely not for advanced programmers, although it has a lot of useful information that will serve as a reference!
Chapter 1 : Installing Python
Introduction
Installing Python on Windows
Installing Python on Mac
Chapter 2 : 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
Chapter 3 : 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
Chapter 4 : 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
Chapter 5 : 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
Chapter 6 : 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
Chapter 7 : 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
Chapter 8 : 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
Chapter 9 : 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
Chapter 10 : 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
Chapter 11 : 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
Chapter 12 : 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
Chapter 13 : 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