Udemy - The Complete Python & PostgreSQL Developer Course

Category: Technical

Tag: Database/SQL


Posted on 2019-05-16, by phaelx.

Description



Date: March 2019
Author: Rob Percival

Size: 3.1 GB
Format: MP4
Download     >>    https://dropapk.com/roqfxomxxuw6
What you'll learn
   *Understand software and programming with Python from beginning to end
   *Create Python applications ranging from beginner, basic applications to advanced, useful and engaging applications
   *Learn how to extend Python applications by using a professional data storage which is PostgreSQL
   *Understand advanced concepts extremely useful in jobs and interviews, such as data structures and algorithms


Course content

Installing Python
   Introduction
   Installing Python on Windows
   Installing Python on Mac

Python 101
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz

Magic Numbers in Python
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz

A Lottery app
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz

More complex applications: a student registration system
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz

Object-Oriented Programming: a movie rental system
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz

Introduction to PostgreSQL
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz
   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
   Section 7 Final Quiz

Advanced PostgreSQL
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz
   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
   Section 7 Final Quiz
   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
   Section 8 Final Quiz

Python and PostgreSQL
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz
   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
   Section 7 Final Quiz
   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
   Section 8 Final Quiz
   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
   Section 9 Final Quiz
   Keep thinking: Section 9
   Download the code for this section here

Python Web and APIs
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz
   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
   Section 7 Final Quiz
   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
   Section 8 Final Quiz
   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
   Section 9 Final Quiz
   Keep thinking: Section 9
   Download the code for this section here
   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
   Section 10 Final Quiz
   Section 10: Twitter Login code

Introduction to Git and GitHub
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz
   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
   Section 7 Final Quiz
   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
   Section 8 Final Quiz
   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
   Section 9 Final Quiz
   Keep thinking: Section 9
   Download the code for this section here
   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
   Section 10 Final Quiz
   Section 10: Twitter Login code
   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
   Section 11 Final Quiz
   Keep thinking: Section 11

Advanced Python
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz
   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
   Section 7 Final Quiz
   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
   Section 8 Final Quiz
   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
   Section 9 Final Quiz
   Keep thinking: Section 9
   Download the code for this section here
   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
   Section 10 Final Quiz
   Section 10: Twitter Login code
   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
   Section 11 Final Quiz
   Keep thinking: Section 11
   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
   Section 12 Final Quiz
   Section 12: Advanced Python code
   Keep thinking: Section 12

Data Structures and Algorithms
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz
   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
   Section 7 Final Quiz
   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
   Section 8 Final Quiz
   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
   Section 9 Final Quiz
   Keep thinking: Section 9
   Download the code for this section here
   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
   Section 10 Final Quiz
   Section 10: Twitter Login code
   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
   Section 11 Final Quiz
   Keep thinking: Section 11
   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
   Section 12 Final Quiz
   Section 12: Advanced Python code
   Keep thinking: Section 12
   What are data structures?
   What is a Linked List?
   Introduction to Linked List Assignment
   Assignment: Linked List
   Programming our own Linked List in Python
   Creating a Queue
   Introduction to Queue Assignment
   Assignment: Queue
   Programming our own Queue in Python
   Creating a Stack
   Introduction to Stack Assignment
   Assignment: Stack
   Programming our own Stack in Python
   Creating a Binary Tree
   Introduction to Binary Tree Assignment
   Assignment: Binary Tree
   Programming our own Binary Tree in Python
   Section 13 Final Quiz

Conclusion
   Introduction
   Installing Python on Windows
   Installing Python on Mac
   My private letter to you as you start learning programming
   Two tools to take the most from this course
   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
   Age Program Code
   Section 2 Final Quiz
   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
   Magic Numbers Code
   Section 3 Final Quiz
   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
   Lottery App Code
   Section 4 Final Quiz
   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 list and using the dictionaries inside it
   Creating the application menu
   Student Registration System Code
   Section 5 Final Quiz
   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
   How to use the csv module to read and write CSV files more easily
   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
   Movie Rental System Code
   Section 6 Final Quiz
   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
   Section 7 Final Quiz
   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
   Section 8 Final Quiz
   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
   Section 9 Final Quiz
   Keep thinking: Section 9
   Download the code for this section here
   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
   Section 10 Final Quiz
   Section 10: Twitter Login code
   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
   Section 11 Final Quiz
   Keep thinking: Section 11
   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
   Section 12 Final Quiz
   Section 12: Advanced Python code
   Keep thinking: Section 12
   What are data structures?
   What is a Linked List?
   Introduction to Linked List Assignment
   Assignment: Linked List
   Programming our own Linked List in Python
   Creating a Queue
   Introduction to Queue Assignment
   Assignment: Queue
   Programming our own Queue in Python
   Creating a Stack
   Introduction to Stack Assignment
   Assignment: Stack
   Programming our own Stack in Python
   Creating a Binary Tree
   Introduction to Binary Tree Assignment
   Assignment: Binary Tree
   Programming our own Binary Tree in Python
   Section 13 Final Quiz
   Next steps
   Bonus lecture: web development with Python


Sponsored High Speed Downloads
8184 dl's @ 2624 KB/s
Download Now [Full Version]
5768 dl's @ 2603 KB/s
Download Link 1 - Fast Download
7404 dl's @ 2161 KB/s
Download Mirror - Direct Download



Search More...
Udemy - The Complete Python & PostgreSQL Developer Course

Search free ebooks in ebookee.com!


Related Archive Books

Archive Books related to "Udemy - The Complete Python & PostgreSQL Developer Course":



Links
Download this book

No active download links here?
Please check the description for download links if any or do a search to find alternative books.


Related Books


Comments

No comments for "Udemy - The Complete Python & PostgreSQL Developer Course".


    Add Your Comments
    1. Download links and password may be in the description section, read description carefully!
    2. Do a search to find mirrors if no download links or dead links.
    Back to Top