The Complete Python/PostgreSQL Course 2.0
The Complete Python/PostgreSQL Course 2.0, available at $89.99, has an average rating of 4.7, with 155 lectures, based on 1931 reviews, and has 14607 subscribers.
You will learn about How to leverage the power of databases (in-memory, SQLite, and PostgreSQL) to upgrade your Python applications Prevent common pitfalls: avoid SQL injection attacks, store database credentials securely, and optimize the performance of your applications Understand how databases work and how to take advantage of their features from the ground up, by building multiple projects This is a no-nonsense, no-frills course on fully mastering PostgreSQL and how to use it effective within and outside of your Python apps Learn how to work with dates and times effectively in Python applications Produce engaging charts, graphs, and reports using database data This course is ideal for individuals who are Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases. or Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applications or Business analysis and data scientists who want to create larger applications or interact with larger data sets through a database It is particularly useful for Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases. or Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applications or Business analysis and data scientists who want to create larger applications or interact with larger data sets through a database.
Enroll now: The Complete Python/PostgreSQL Course 2.0
Summary
Title: The Complete Python/PostgreSQL Course 2.0
Price: $89.99
Average Rating: 4.7
Number of Lectures: 155
Number of Published Lectures: 155
Number of Curriculum Items: 155
Number of Published Curriculum Objects: 155
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- How to leverage the power of databases (in-memory, SQLite, and PostgreSQL) to upgrade your Python applications
- Prevent common pitfalls: avoid SQL injection attacks, store database credentials securely, and optimize the performance of your applications
- Understand how databases work and how to take advantage of their features from the ground up, by building multiple projects
- This is a no-nonsense, no-frills course on fully mastering PostgreSQL and how to use it effective within and outside of your Python apps
- Learn how to work with dates and times effectively in Python applications
- Produce engaging charts, graphs, and reports using database data
Who Should Attend
- Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases.
- Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applications
- Business analysis and data scientists who want to create larger applications or interact with larger data sets through a database
Target Audiences
- Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases.
- Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applications
- Business analysis and data scientists who want to create larger applications or interact with larger data sets through a database
Master PostgreSQL and use it in your Python apps!
Python and PostgreSQL are two of the most in-demand skills in the world. After completing this course, you’ll be confident in adding both to your resume/CV.
Everything you’ll learn in this course is relevant to other database systems too, like MySQL, Microsoft SQL Server, or Oracle.
With this course, you’ll master PostgreSQL and how to work with it from Python. If you use Python and you want to augment your skills with a database, you’ll love this course!
You will:
-
Work with different types of databases (in-memory, SQLite, and PostgreSQL), and understand when to use each in your Python apps.
-
Build a programming journal project to add a SQLite database to your Python application.
-
Improve a database design incrementally so you’re not bound by your initial design.
-
Model different relationships with PostgreSQL, including one-to-many and many-to-many.
-
Reduce errors by applying database changes using database migrations with Python and alembic.
-
Build a polling app to learn about advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.
-
Work with dates and times in PostgreSQL, and avoid common timezone pitfalls.
-
Structure Python apps like a professional, to make development much easier.
-
Produce data analysis reports and charts using matplotlib with PostgreSQL data.
You’ll also tackle advanced PostgreSQL topics, such as:
-
User-Defined Functions
-
Stored Procedures
-
Locking
-
Async database connections
As you can see, you’re going to learn a lot!
But this is a no-nonsense, no-frills course. We have planned, crafted, and edited every lecture to be concise and compact. No time wasted, so you can master PostgreSQL in record time.
We’ve created dozens of diagrams to explain database concepts, as well as code-along videos. But you won’t just be watching me code! You’ll develop the projects yourself first, to gain hands-on experience and master PostgreSQL.
Also, throughout the course, I provide data sets with challenges and exercises for you to practice what you’ve learned.
I’ve been teaching and helping students online for over 8 years, and this course is the culmination of my teaching experience. I know how to help you understand concepts fully and quickly, in the best way for you.
When you complete this course you’ll be able to:
-
Extend your Python applications with database functionality using PostgreSQL.
-
Answer complex questions using data and generate reports.
-
List PostgreSQL as one of your strongest skills.
Check out the free preview videos for more information and to try out the course!
I’ll see you on the inside!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Welcome to this course!
Lecture 2: Initial setup (for newer Pythonistas)
Lecture 3: Get the complete e-book here
Chapter 2: A Full Python Refresher
Lecture 1: Introduction to this section
Lecture 2: Access the code for this section here
Lecture 3: Variables in Python
Lecture 4: String formatting in Python
Lecture 5: Getting user input
Lecture 6: Writing our first Python app
Lecture 7: Lists, tuples and sets
Lecture 8: Advanced set operations
Lecture 9: Booleans in Python
Lecture 10: If statements
Lecture 11: The "in" keyword in Python
Lecture 12: If statements with the "in" keyword
Lecture 13: Loops in Python
Lecture 14: List comprehensions in Python
Lecture 15: Dictionaries
Lecture 16: Destructuring variables
Lecture 17: Functions in Python
Lecture 18: Function arguments and parameters
Lecture 19: Default parameter values
Lecture 20: Functions returning values
Lecture 21: Lambda functions in Python
Lecture 22: Dictionary comprehensions
Lecture 23: Unpacking arguments
Lecture 24: Unpacking keyword arguments
Lecture 25: Object-Oriented Programming in Python
Lecture 26: Magic methods: _str_ and _repr_
Lecture 27: @classmethod and @staticmethod
Lecture 28: Class inheritance
Lecture 29: Class composition
Lecture 30: Type hinting in Python 3.5+
Lecture 31: Imports in Python
Lecture 32: Relative imports in Python
Lecture 33: Errors in Python
Lecture 34: Custom error classes
Lecture 35: First-class functions
Lecture 36: Simple decorators in Python
Lecture 37: The 'at' syntax for decorators
Lecture 38: Decorating functions with parameters
Lecture 39: Decorators with parameters
Lecture 40: Mutability in Python
Lecture 41: Mutable default parameters (and why they're a bad idea)
Chapter 3: Build a Programming Journal with Python & SQL
Lecture 1: Overview of the project
Lecture 2: Creating our user menu
Lecture 3: What is SQL?
Lecture 4: Using Python lists as an in-memory database
Lecture 5: A SQLite data viewer
Lecture 6: CREATE TABLE: new tables with SQL
Lecture 7: How to write comments in SQL
Lecture 8: CREATE TABLE exercises
Lecture 9: How to connect to a SQLite database with Python
Lecture 10: Connecting to SQLite in our app
Lecture 11: What is a cursor?
Lecture 12: INSERT INTO: add data to a table
Lecture 13: INSERT INTO exercises
Lecture 14: How to insert data into SQLite with Python
Lecture 15: SELECT: retrieve data from a table
Lecture 16: SELECT exercises
Lecture 17: Retrieving results from a cursor
Lecture 18: WHERE: search with SQL
Lecture 19: WHERE exercises
Lecture 20: DROP TABLE: deleting entire tables
Lecture 21: DROP TABLE exercise
Lecture 22: What is a SQL injection attack?
Chapter 4: A Movie Watchlist App with Python & SQL
Lecture 1: Overview of the project
Lecture 2: Three development stages of our project
Lecture 3: Our starting code for this project
Lecture 4: Queries we'll need for the project to begin with
Lecture 5: Write the database.py file
Lecture 6: UPDATE: changing data with SQL
Lecture 7: UPDATE exercises
Lecture 8: Write our user menu and functions
Lecture 9: Watched movies: second approach
Lecture 10: DELETE FROM: removing rows with SQL
Lecture 11: DELETE FROM exercises
Lecture 12: Stage 2: watching movies
Lecture 13: Relational data: primary and foreign keys
Lecture 14: Relational data exercise
Lecture 15: Watched movies: final approach
Lecture 16: Stage 3: adding new watched movies
Lecture 17: Auto-incrementing row IDs
Lecture 18: Auto-incrementing exercise
Lecture 19: JOIN: access two tables at once with SQL
Lecture 20: Use JOINs to retrieve the movies a user has watched
Lecture 21: Types of JOINs with examples
Lecture 22: ORDER BY: sort the returned table
Lecture 23: LIMIT: getting a certain number of rows
Lecture 24: LIKE: flexible searching
Lecture 25: What is an index in SQL?
Lecture 26: Adding an index to our table for more efficient searching
Chapter 5: Introduction to PostgreSQL: Migrating our App
Lecture 1: SQLite vs. PostgreSQL
Lecture 2: How to install PostgreSQL
Lecture 3: How to run and access PostgreSQL
Instructors
-
Codestars • over 2 million students worldwide!
Teaching the Next Generation of Coders -
Jose Salvatierra
Founder of Teclado and Software Engineer -
Teclado by Jose Salvatierra
Software Development For Everyone
Rating Distribution
- 1 stars: 19 votes
- 2 stars: 21 votes
- 3 stars: 110 votes
- 4 stars: 604 votes
- 5 stars: 1177 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024