The Complete Python PostgreSQL Developer Course
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
No pre-knowledge is required: I’ll teach you absolutely everything you need to know!
A computer is required, but any will do. A desktop or a laptop running Mac, Windows, or Linux
All the software used in the course is free, and I’ll personally walk you through setting it all up
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 used by many technology companies, small and large. That’s because they are powerful, yet extremely flexible.
Python is used in the industry for things like embedded software, web development, desktop applications, and even mobile apps!
PostgreSQL allows your applications to become even more powerful by storing, retrieving, and filtering through large data sets easily.
This course is your one-stop shop for everything Python and PostgreSQL, and the instructor is constantly available to support your learning and answer questions.
Gallop through — or go at your own speed
You’ll gain immediate access over 160 lectures and more than 20 hours of content, each developed with ease of learning in mind.
Using my previous teaching experience I’ve created crystal-clear and original content which you’ll find easy to understand – and more importantly – to absorb.
You’ll find learning both quick and fun. And, I’ve used techniques proven to effortlessly lock that knowledge in, as you breeze through each comprehensive chapter.
Fun, fast, and effective
This course will get you from being an absolute Python and PostgreSQL beginner to an experienced software developer.
Don’t believe me? I offer a full money back guarantee, so long as you request it within 30 days of your purchase of the course.
Are you ready to transform your world and become an uber-confident app developer?
I’ll see you on the inside!
Section 1: Installing Python
Lecture 1 IMPORTANT: New Version of This Course Available!
Lecture 2 Introduction
Lecture 3 Installing Python on Windows
Lecture 4 Installing Python on Mac
Section 2: Python 101
Lecture 5 My private letter to you as you start learning programming
Lecture 6 Two tools to take the most from this course
Lecture 7 The Python interactive shell (IDLE)
Lecture 8 Numbers and Strings in Python
Lecture 9 Variables in Python
Lecture 10 The str() method to convert to Strings
Lecture 11 Running a Python file from the IDLE
Lecture 12 Getting user input in Python
Lecture 13 The int() method to convert to Integers
Lecture 14 The format() method to simplify String formatting
Lecture 15 Age Program Code
Section 3: Magic Numbers in Python
Lecture 16 Lists in Python
Lecture 17 The for loop in Python
Lecture 18 Boolean expressions, True and False
Lecture 19 If statements in Python
Lecture 20 The ‘in’ keyword to check whether a list contains an element
Lecture 21 Giving the user multiple chances in our program
Lecture 22 Generating random integers in Python
Lecture 23 Defining our own methods in Python
Lecture 24 Returning values from our methods in Python
Lecture 25 Magic Numbers Code
Section 4: A Lottery app
Lecture 26 The String split() method
Lecture 27 List comprehension in Python
Lecture 28 Python Sets — what is a Set?
Lecture 29 Set comprehension in Python
Lecture 30 Creating our lottery numbers
Lecture 31 Calculating the lottery winnings
Lecture 32 Lottery App Code
Section 5: More complex applications: a student registration system
Lecture 33 Installing PyCharm, a professional Python tool
Lecture 34 Setting up PyCharm on Mac
Lecture 35 Setting up PyCharm on Windows
Lecture 36 Dictionaries in Python
Lecture 37 Advanced Dictionary usage in Python
Lecture 38 Methods returning dictionaries
Lecture 39 Appending to a list in Python
Lecture 40 Adding marks to our student data structure
Lecture 41 The sum() method in Python
Lecture 42 Iterating over a list and using the dictionaries inside it
Lecture 43 Creating the application menu
Lecture 44 Student Registration System Code
Section 6: Object-Oriented Programming: a movie rental system
Lecture 45 What are classes? Classes in Python
Lecture 46 The Movie Class
Lecture 47 The User Class (and the __repr__ method)
Lecture 48 The filter() method in Python
Lecture 49 More Movie operations and methods
Lecture 50 Writing to a file in Python
Lecture 51 Saving CSV files with our data
Lecture 52 Loading our data from CSV files
Lecture 53 How to use the csv module to read and write CSV files more easily
Lecture 54 Saving JSON files with our data
Lecture 55 Loading our data from JSON files
Lecture 56 Argument unpacking in Python (the two asterisks)
Lecture 57 Creating the menu for our application
Lecture 58 Movie Rental System Code
Section 7: Introduction to PostgreSQL
Lecture 59 Introduction to databases
Lecture 60 Installing PostgreSQL on Windows
Lecture 61 Using PostgreSQL on Windows
Lecture 62 Executing SQL queries on Windows
Lecture 63 Installing PostgreSQL on Mac
Lecture 64 Using PostgreSQL on Mac
Lecture 65 Executing SQL commands on Mac
Lecture 66 Using the sample data provided
Lecture 67 SQL: The SELECT command
Lecture 68 SQL: filtering with WHERE
Lecture 69 SQL: LIMIT for limiting the number of results
Lecture 70 SQL: UPDATE data in a table
Lecture 71 SQL: DELETE data from a table
Lecture 72 SQL Wildcards for filtering unknowns
Lecture 73 What is a JOIN?
Lecture 74 SQL: JOINs and JOIN examples
Lecture 75 SQL: GROUP BY for aggregation of data
Lecture 76 SQL: ORDER BY for sorting data
Lecture 77 SQL: CREATE TABLE
Lecture 78 SQL: INSERT INTO for adding data to a table
Lecture 79 SQL: SEQUENCE for auto-incrementing fields
Lecture 80 SQL: CREATE INDEX and advanced information about indexes
Lecture 81 SQL: DROP TABLE for deleting tables and data
Section 8: Advanced PostgreSQL
Lecture 82 SQL: VIEWs and what they are used for
Lecture 83 SQL: built-in functions and the HAVING construct
Lecture 84 Dates in SQL: an old problem
Lecture 85 Other data types in SQL (including JSON in PostgreSQL)
Lecture 86 Nested SELECT statements for complex queries
Lecture 87 The PostgreSQL SERIAL type
Section 9: Python and PostgreSQL
Lecture 88 Installing Microsoft Visual C++ on Windows
Lecture 89 Installing psycopg2 on Windows (2018 update)
Lecture 90 Installing psycopg2 on Windows (older versions)
Lecture 91 Installing psycopg2 on Mac
Lecture 92 Verifying everything works—don’t proceed if it doesn’t!
Lecture 93 Mac OS X: Fixing psycopg2 ‘library not loaded’ error
Lecture 94 What is a virtual environment?
Lecture 95 psycopg2 on a virtualenv on Windows (2018 update)
Lecture 96 Psycopg2 on a virtualenv on Windows (older versions)
Lecture 97 Setting up the app structure, pip, and requirements.txt
Lecture 98 Recap on classes and object-oriented programming
Lecture 99 Saving to database from Python
Lecture 100 Loading from the database from Python
Lecture 101 Removing some duplicate code from our app
Lecture 102 Connection pooling and why it is important
Lecture 103 Creating the ConnectionPool class
Lecture 104 Creating the ConnectionFromPool class
Lecture 105 Obtaining a cursor from the ConnectionFromPool class
Lecture 106 The Database class and selective initialisation
Lecture 107 Cleaning up the Database class
Lecture 108 End of section review
Lecture 109 Keep thinking: Section 9
Lecture 110 Download the code for this section here
Section 10: Python Web and APIs
Lecture 111 What is an API?
Lecture 112 Making requests in Python
Lecture 113 What is OAuth?
Lecture 114 Creating a Twitter app
Lecture 115 Setting up Twitter login
Lecture 116 Getting the OAuth request token
Lecture 117 More on the Python debugger—an essential tool
Lecture 118 Getting authorization by the user
Lecture 119 Getting the OAuth access token
Lecture 120 Performing Twitter requests: getting images
Lecture 121 Reusing code from the last section to save users
Lecture 122 Creating users in our app
Lecture 123 Retrieving users in our app
Lecture 124 Cleaning up the code—extremely important!
Lecture 125 Introduction to Flask and Python Web Development
Lecture 126 Adding a Twitter login endpoint
Lecture 127 Adding Twitter authorization
Lecture 128 Creating the user profile
Lecture 129 The Flask before_request decorator
Lecture 130 Checking if a user is already logged in
Lecture 131 Searching tweets and displaying them
Lecture 132 Searching for different things
Lecture 133 What is Bootstrap?
Lecture 134 Writing our own CSS
Lecture 135 Allowing users to perform custom searches
Lecture 136 Adding sentiment analysis with another API
Lecture 137 Section 10: Twitter Login code
Section 11: Introduction to Git and GitHub
Lecture 138 What is Git?
Lecture 139 Installing Git on Mac and Windows
Lecture 140 Introduction to the UNIX terminal
Lecture 141 The VIM text editor, a powerful terminal editor
Lecture 142 Dealing with files in the UNIX terminal
Lecture 143 What is a Git repository?
Lecture 144 git init — create a Git repository
Lecture 145 git add and git commit — staging and committing
Lecture 146 git log — viewing past commits
Lecture 147 Creating a repository on GitHub
Lecture 148 git remote — managing remote repositories
Lecture 149 Adding your SSH key to GitHub
Lecture 150 What is a README file? Introduction to Markdown
Lecture 151 git pull — pulling other’s changes
Lecture 152 Keep thinking: Section 11
Section 12: Advanced Python
Lecture 153 OOP: Inheritance
Lecture 154 OOP: Multiple Inheritance in Python
Lecture 155 OOP: What is composition?
Lecture 156 OOP: What is encapsulation?
Lecture 157 Introduction to Exceptions in Python
Lecture 158 Creating our own Exceptions
Lecture 159 Some of the available built-in Exceptions
Lecture 160 Python built-in methods
Lecture 161 Assertions in Python
Lecture 162 Lambda expressions in Python
Lecture 163 More uses of lambda expressions
Lecture 164 Lambda expressions in the wild
Lecture 165 Introduction to unit testing with unittest
Lecture 166 Section 12: Advanced Python code
Lecture 167 Keep thinking: Section 12
Section 13: Data Structures and Algorithms
Lecture 168 What are data structures?
Lecture 169 What is a Linked List?
Lecture 170 Introduction to Linked List Assignment
Lecture 171 Assignment: Linked List
Lecture 172 Programming our own Linked List in Python
Lecture 173 Creating a Queue
Lecture 174 Introduction to Queue Assignment
Lecture 175 Assignment: Queue
Lecture 176 Programming our own Queue in Python
Lecture 177 Creating a Stack
Lecture 178 Introduction to Stack Assignment
Lecture 179 Assignment: Stack
Lecture 180 Programming our own Stack in Python
Lecture 181 Creating a Binary Tree
Lecture 182 Introduction to Binary Tree Assignment
Lecture 183 Assignment: Binary Tree
Lecture 184 Programming our own Binary Tree in Python
Section 14: Conclusion
Lecture 185 Next steps
Lecture 186 Bonus lecture: other courses and next steps
Complete beginners to programming and Python. The course follows concise explanations with hands-on projects, and has been created with the beginner in mind.,Intermediate programmers can 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 and can serve well as a reference!
Udemy | English | 21h 52m | 10.60 GB
Created by: Rob Percival