SQL and PostgreSQL- The Complete Developer Guide

SQL and PostgreSQL: The Complete Developers Guide, available at $119.99, has an average rating of 4.69, with 292 lectures, 44 quizzes, based on 9861 reviews, and has 65597 subscribers.

You will learn about Master the fundamentals of relational databases Acquire the skills necessary to obtain a database administrator (DBA) or database developer job Design fast and efficient databases using the latest technologies Practice your skills with many quizzes, projects, and built-in exercises Learn and apply multiple database design patterns Optimize queries for superb read and write efficiency Understand how PostgreSQL stores information at the hardware level Connect PostgreSQL to front-end apps using an API Build common app features, such as a like and mention systems Handle complex concurrency issues and race conditions Advance your database designs using schema migrations See how to use PostgreSQL to speed up automated tests This course is ideal for individuals who are Any developers looking to understand databases or Application engineers seeking to expand their backend skillset It is particularly useful for Any developers looking to understand databases or Application engineers seeking to expand their backend skillset.

Enroll now: SQL and PostgreSQL: The Complete Developers Guide

Summary

Title: SQL and PostgreSQL: The Complete Developers Guide

Price: $119.99

Average Rating: 4.69

Number of Lectures: 292

Number of Quizzes: 44

Number of Published Lectures: 290

Number of Published Quizzes: 44

Number of Curriculum Items: 336

Number of Published Curriculum Objects: 334

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Master the fundamentals of relational databases

Acquire the skills necessary to obtain a database administrator (DBA) or database developer job

Design fast and efficient databases using the latest technologies

Practice your skills with many quizzes, projects, and built-in exercises

Learn and apply multiple database design patterns

Optimize queries for superb read and write efficiency

Understand how PostgreSQL stores information at the hardware level

Connect PostgreSQL to front-end apps using an API

Build common app features, such as a like and mention systems

Handle complex concurrency issues and race conditions

Advance your database designs using schema migrations

See how to use PostgreSQL to speed up automated tests

Who Should Attend

Any developers looking to understand databases

Application engineers seeking to expand their backend skillset

Target Audiences

Any developers looking to understand databases

Application engineers seeking to expand their backend skillset

Database structure design?  It’s here.  Query tuning and optimization? You’ll master it.  Complex queries? Yes indeed!

This is the only course online that will teach you how to design a database, store complex data, optimize your queries, everything that is needed for operating a production, scalable database!

Every app in the world, whether it is a mobile app built with Flutter, a web app constructed with React, or a plain HTML page, needs to store information in a database.  Although there are many different databases you can use, PostgreSQLhas been a number-one pick for decades, offering scalable performance, rock-solid uptime, and flexible design systems.  This course will teach you everything you need to know about PostgreSQL to use it on your next big project!

Don’t know anything about databases at all? No problem. We begin with an overview of SQL, the language used to interact with PostgreSQL. Through an incredible number of exercises, you’ll get practical, hands on experience working with realistic datasets.  You will understand how to store, fetch, and update information with a series of powerful commands. 

After gaining experience with elementary operations, you will move on to understanding database design patterns, offering multiple ways to structure your database for efficient data modeling. You’ll see many different scenarios with different types of data, and understand the pros and cons to several approaches.

This course is packed with practice exercises and quizzes. You’ll get immediate practice on all of the different topics and features that you learn!  In addition, you’ll understand exactly where to use each of these features in real and practical projects.

Besides getting practical hands-on experience, you’ll also get a behind-the-scenes look at how PostgreSQL works internally. We’ll dive into raw data files, investigating how PostgreSQL stores information on your hard drive bit by bit.  This knowledge is invaluable when it comes time to start tuning your queries for performance.  By having a natural instinct of how PostgreSQL works, you can plan on being able to get every last bit of performance out of your database.

Here is a partial list of some of the topics that are covered in this course:

Apply powerful SQL commands to store, update, and retrieve information

Build relationships between records using foreign keys between tables

Understand PostgreSQL’s numerous data types, and when to use each

Assemble reports of business data by using aggregation pipelines

Work with millions of records to simulate real production queries

Exercise your query logic skills through the use of sets and sorting operators

Compose queries out of smaller reusable units using subqueries

Use different design patternsto efficiently model your data

See how to divide database objects into different schemas to maintain them more easily

Validate your data using simple ‘check’ rules

Construct perfect designs for common features such as ‘like’, ‘follow’, and ‘tag’ systems

Speed up your queries with indexes– you’ll see exactly how they work behind the scenes!

Dive into some of the most complex queries around with recursive common table expressions

Deal with concurrency issues easily by applying transactions

I made this course to be the perfect resource for engineers just getting started with their first database.  Master the database itself, and see how to apply it with real designs.  Sign up today and master PostgreSQL!

Course Curriculum

Chapter 1: Simple – But Powerful – SQL Statements

Lecture 1: Join Our Community!

Lecture 2: Course Resources

Lecture 3: What is PostgreSQL All About?

Lecture 4: Database Design

Lecture 5: Creating Tables

Lecture 6: Analyzing CREATE TABLE

Lecture 7: Inserting Data Into a Table

Lecture 8: Retrieving Data with Select

Lecture 9: Calculated Columns

Lecture 10: Calculating Phone Revenue

Lecture 11: Exercise Solution

Lecture 12: String Operators and Functions

Chapter 2: Filtering Records

Lecture 1: Filtering Rows with Where

Lecture 2: More on the Where Keyword

Lecture 3: Compound Where Clauses

Lecture 4: A Where Exercise Overview

Lecture 5: A Where Solution

Lecture 6: Where With Lists

Lecture 7: A Where With Lists Solution

Lecture 8: Calculations in Where Clauses

Lecture 9: Solving Calculations

Lecture 10: Updating Rows

Lecture 11: Deleting Rows

Lecture 12: A Solution for Updating Rows

Lecture 13: Solution for Deleting Rows

Chapter 3: Working with Tables

Lecture 1: The Plan Moving Forward

Lecture 2: Approaching Database Design

Lecture 3: One-to-Many and Many-to-One Relationships

Lecture 4: One-to-One and Many-to-Many Relationships

Lecture 5: Primary Keys and Foreign Keys

Lecture 6: Understanding Foreign Keys

Lecture 7: Auto-Generated IDs

Lecture 8: Creating Foreign Key Columns

Lecture 9: Running Queries on Associated Data

Lecture 10: Exercise Overview

Lecture 11: Foreign Key Creation Solution

Lecture 12: Foreign Key Constraints Around Insertion

Lecture 13: Constraints Around Deletion

Lecture 14: Commands You’ll Need for the Next Video

Lecture 15: Testing Deletion Constraints

Lecture 16: Setting Foreign Keys to Null on Delete

Lecture 17: Adding Some Complexity

Chapter 4: Relating Records with Joins

Lecture 1: Adding Some Data

Lecture 2: Queries with Joins and Aggregations

Lecture 3: Joining Data from Different Tables

Lecture 4: Another Quick Join

Lecture 5: Exercise Overview

Lecture 6: A Joinful Solution

Lecture 7: Alternate Forms of Syntax

Lecture 8: Missing Data in Joins

Lecture 9: Why Wasnt It Included

Lecture 10: Four Kinds of Joins

Lecture 11: Each Join in Practice

Lecture 12: Does Order Matter?

Lecture 13: Exercise Overview

Lecture 14: Two Possible Solutions

Lecture 15: Where with Join

Lecture 16: Three Way Joins

Lecture 17: A Bit of Practice

Lecture 18: Exercise Solution

Chapter 5: Aggregation of Records

Lecture 1: Aggregating and Grouping

Lecture 2: Picturing Group By

Lecture 3: Aggregate Functions

Lecture 4: Combining Group By and Aggregates

Lecture 5: A Gotcha with Count

Lecture 6: Visualizing More Grouping

Lecture 7: Exercise Overview

Lecture 8: Grouping Solution

Lecture 9: Adding a Layer of Difficulty

Lecture 10: Solution

Lecture 11: Filtering Groups with Having

Lecture 12: Having In Action

Lecture 13: More on Having!

Lecture 14: A Having Exercise Overview

Instructors

Stephen Grider
Engineering Architect

Rating Distribution

1 stars: 34 votes

2 stars: 49 votes

3 stars: 440 votes

4 stars: 2495 votes

5 stars: 6850 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!