Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag United Kingdom
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Argentina
Country selected
country flag Austria
Country selected
country flag Belgium
Country selected
country flag Bulgaria
Country selected
country flag Chile
Country selected
country flag Colombia
Country selected
country flag Cyprus
Country selected
country flag Czechia
Country selected
country flag Denmark
Country selected
country flag Ecuador
Country selected
country flag Egypt
Country selected
country flag Estonia
Country selected
country flag Finland
Country selected
country flag Greece
Country selected
country flag Hungary
Country selected
country flag Indonesia
Country selected
country flag Ireland
Country selected
country flag Italy
Country selected
country flag Japan
Country selected
country flag Latvia
Country selected
country flag Lithuania
Country selected
country flag Luxembourg
Country selected
country flag Malaysia
Country selected
country flag Malta
Country selected
country flag Mexico
Country selected
country flag Netherlands
Country selected
country flag New Zealand
Country selected
country flag Norway
Country selected
country flag Philippines
Country selected
country flag Poland
Country selected
country flag Portugal
Country selected
country flag Romania
Country selected
country flag Singapore
Country selected
country flag Slovakia
Country selected
country flag Slovenia
Country selected
country flag South Africa
Country selected
country flag South Korea
Country selected
country flag Sweden
Country selected
country flag Switzerland
Country selected
country flag Taiwan
Country selected
country flag Thailand
Country selected
country flag Turkey
Country selected
country flag Ukraine
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Home > Data > Database Programming > The Complete Python and PostgreSQL Developer Course
The Complete Python and PostgreSQL Developer Course
The Complete Python and PostgreSQL Developer Course

The Complete Python and PostgreSQL Developer Course: Build 9 projects to master 2 essential and modern technologies: Python and PostgreSQL

Arrow left icon
Profile Icon Codestars By Rob Percival Profile Icon Jose Salvatierra Fuentes
Arrow right icon
€29.99
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3 (1 Ratings)
Video Jul 2019 21hrs 50mins 1st Edition
Video
€29.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Codestars By Rob Percival Profile Icon Jose Salvatierra Fuentes
Arrow right icon
€29.99
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3 (1 Ratings)
Video Jul 2019 21hrs 50mins 1st Edition
Video
€29.99
Subscription
Free Trial
Renews at €18.99p/m
Video
€29.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Table of content icon View table of contents Download code icon Download Code

Key benefits

  • Gain comprehensive understanding of software and programming with Python
  • Create basic beginner-level applications to advanced engaging applications using Python

Description

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

Who is this book 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!

What you will learn

  • Extend Python applications by using professional data storage — PostgreSQL
  • Understand advanced concepts, such as data structures and algorithms, that are extremely useful in jobs and interviews

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jul 10, 2019
Length: 21hrs 50mins
Edition : 1st
Language : English
ISBN-13 : 9781789957488
Category :
Data
Languages :
Python
Concepts :
Database Programming
Tools :
PostgreSQL

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : Jul 10, 2019
Length: 21hrs 50mins
Edition : 1st
Language : English
ISBN-13 : 9781789957488
Category :
Data
Languages :
Python
Concepts :
Database Programming
Tools :
PostgreSQL

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

The Complete Python and PostgreSQL Developer Course
The Complete Python and PostgreSQL Developer Course
Read more
Jul 2019 21hrs 50mins
Full star icon 3 (1)
Video
Video
  • Video Video €29.99
€29.99
Mastering PostgreSQL 12
Mastering PostgreSQL 12
Read more
Nov 2019 470 pages
Full star icon 4 (5)
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €32.99
€17.99 €26.99
€32.99
PostgreSQL 11 Administration Cookbook
PostgreSQL 11 Administration Cookbook
Read more
May 2019 600 pages
Full star icon 5 (1)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €36.99
€20.98 €29.99
€36.99
Stars icon
Total € 99.97
The Complete Python and PostgreSQL Developer Course
€29.99
Mastering PostgreSQL 12
€32.99
PostgreSQL 11 Administration Cookbook
€36.99
Total € 99.97 Stars icon

Table of Contents

13 Chapters
Installing Python Chevron down icon Chevron up icon
Introduction
Installing Python on Windows
Installing Python on Mac
Python 101 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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 Chevron down icon Chevron up icon
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

Recommendations for you

Left arrow icon
Python Machine Learning By Example
Python Machine Learning By Example
Read more
Jul 2024 518 pages
Full star icon 4.9 (8)
eBook
eBook
  • eBook eBook €18.99
  • Paperback Paperback €34.99
€18.99 €27.99
€34.99
Building AI Applications with OpenAI APIs
Building AI Applications with OpenAI APIs
Read more
Oct 2024 252 pages
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €29.99
€15.99 €23.99
€29.99
Unlocking Data with Generative AI and RAG
Unlocking Data with Generative AI and RAG
Read more
Sep 2024 346 pages
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €29.99
€15.99 €23.99
€29.99
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
Full star icon 4.2 (22)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
RAG-Driven Generative AI
RAG-Driven Generative AI
Read more
Sep 2024 334 pages
Full star icon 4.5 (13)
eBook
eBook
  • eBook eBook €22.99
  • Paperback Paperback €40.99
€22.99 €32.99
€40.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 4.4 (95)
eBook
eBook
  • eBook eBook €22.99
  • Paperback Paperback €41.99
€22.99 €32.99
€41.99
Python for Algorithmic Trading Cookbook
Python for Algorithmic Trading Cookbook
Read more
Aug 2024 404 pages
Full star icon 4.6 (15)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €35.98
€24.99 €35.99
€35.98 €44.99
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Read more
Jan 2023 14hrs 31mins
Video
Video
  • Video Video €82.99
€82.99
Principles of Data Science
Principles of Data Science
Read more
Jan 2024 326 pages
Full star icon 4.8 (4)
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €29.99
€15.99 €23.99
€29.99
Mastering NLP from Foundations to LLMs
Mastering NLP from Foundations to LLMs
Read more
Apr 2024 340 pages
Full star icon 4.9 (24)
eBook
eBook
  • eBook eBook €21.99
  • Paperback Paperback €39.99
€21.99 €31.99
€39.99
Right arrow icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3
(1 Ratings)
5 star 0%
4 star 0%
3 star 100%
2 star 0%
1 star 0%
Janardhan K Jan 19, 2022
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3
I got a chance to view first few chapters of this course and felt the course content is pretty basic and I was expecting to see some mid to advanced level.
Feefo Verified review Feefo

People who bought this also bought

Left arrow icon
Machine Learning Engineering with Python
Machine Learning Engineering with Python
Read more
Aug 2023 462 pages
Full star icon 4.6 (36)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Deep Learning with TensorFlow and Keras – 3rd edition
Deep Learning with TensorFlow and Keras – 3rd edition
Read more
Oct 2022 698 pages
Full star icon 4.6 (45)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Modern Generative AI with ChatGPT and OpenAI Models
Modern Generative AI with ChatGPT and OpenAI Models
Read more
May 2023 286 pages
Full star icon 4.2 (34)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Generative AI with LangChain
Generative AI with LangChain
Read more
Dec 2023 368 pages
Full star icon 4 (34)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Causal Inference and Discovery in Python
Causal Inference and Discovery in Python
Read more
May 2023 456 pages
Full star icon 4.5 (49)
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €29.99
€15.99 €23.99
€29.99
Right arrow icon

About the authors

Left arrow icon
Profile icon Codestars By Rob Percival
Codestars By Rob Percival
Codestars, by Rob Percival, is a revolutionary on line learning platform on a mission to transform the way people learn to code. With a focus on simplicity, logic, and fun, Rob has empowered over half a million students through his courses. Recognizing the need for diverse and comprehensive learning experiences, Rob established Codestars as a collaborative effort. Codestars provides learners of all ages and proficiency levels with the tools and knowledge needed to build functional websites and apps. By making coding accessible and enjoyable, Codestars aims to simplify the learning journey and unlock the potential of aspiring coders worldwide.
Read more
See other products by Codestars By Rob Percival
Profile icon Jose Salvatierra Fuentes
Jose Salvatierra Fuentes
Github icon
Jose Salvatierra is the founder of Teclado and a seasoned software engineer with over seven years of experience in online teaching. Passionate about helping students learn to code, Jose aims to demystify software development and make it accessible to everyone. His teaching philosophy focuses on ensuring students truly understand the intricacies of coding, making the learning process intuitive and rewarding. Specializing in Python and JavaScript, Jose is adept in web and backend development, utilizing frameworks such as Flask, React, React Native, and AngularJS. He also has extensive experience with UNIX systems, MongoDB, PostgreSQL, and advanced system architecture design.
Read more
See other products by Jose Salvatierra Fuentes
Right arrow icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.