Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 22 hours on-demand video
  • 7 articles
  • 46 downloadable resources
  • 24 coding exercises
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development SQL

SQL and PostgreSQL: The Complete Developer's Guide

Become an expert with SQL and PostgreSQL! Store and fetch data, tune queries, and design efficient database structures!
Highest Rated
Rating: 4.7 out of 54.7 (730 ratings)
7,910 students
Created by Stephen Grider
Last updated 10/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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
  • Practice all of these skills using a huge number of built-in exercises
Curated for the Udemy for Business collection

Course content

36 sections • 287 lectures • 22h 12m total length

  • Preview04:12
  • Database Design
    05:11
  • Database Terminology
    3 questions
  • Creating Tables
    04:42
  • Analyzing CREATE TABLE
    03:30
  • Inserting Data Into a Table
    04:49
  • Retrieving Data with Select
    02:07
  • Create, Insert, and Select!
    1 question
  • Calculated Columns
    04:37
  • Calculating Phone Revenue
    00:58
  • Using Calculated Columns
    1 question
  • Exercise Solution
    01:03
  • String Operators and Functions
    06:17

  • Filtering Rows with "Where"
    03:49
  • More on the "Where" Keyword
    02:30
  • Compound "Where" Clauses
    05:24
  • A "Where" Exercise Overview
    00:37
  • Practicing Where Statements
    1 question
  • A "Where" Solution
    00:56
  • "Where" With Lists
    00:37
  • A More Challenging 'Where'
    1 question
  • A "Where" With Lists Solution
    01:42
  • Calculations in "Where" Clauses
    02:05
  • Trying Calculations in Where Clauses
    1 question
  • Solving Calculations
    01:51
  • Updating Rows
    04:16
  • Deleting Rows
    03:16
  • Try Updating Records In a Table!
    1 question
  • A Solution for Updating Rows
    01:29
  • Practice Deleting Records
    1 question
  • Solution for Deleting Rows
    01:17

  • The Plan Moving Forward
    01:43
  • Approaching Database Design
    07:28
  • Let's Design Some Schema
    2 questions
  • One-to-Many and Many-to-One Relationships
    06:33
  • A 'Has One' or 'Has Many'?
    4 questions
  • One-to-One and Many-to-Many Relationships
    05:41
  • Identifying One-to-One and Many-to-Many Relationships
    3 questions
  • Primary Keys and Foreign Keys
    05:29
  • Understanding Foreign Keys
    08:19
  • Foreign Keys; How Do They Work?
    4 questions
  • Auto-Generated ID's
    05:47
  • Creating Foreign Key Columns
    04:38
  • Running Queries on Associated Data
    06:48
  • Exercise Overview
    02:07
  • Creating and Using Foreign Keys
    1 question
  • Foreign Key Creation Solution
    02:09
  • Foreign Key Constraints Around Insertion
    05:35
  • Constraints Around Deletion
    05:00
  • Commands You’ll Need for the Next Video
    00:22
  • Testing Deletion Constraints
    04:37
  • Setting Foreign Keys to Null on Delete
    02:58
  • What Happens On Delete?
    2 questions
  • Adding Some Complexity
    02:56

  • Adding Some Data
    03:56
  • Queries with Joins and Aggregations
    03:23
  • Joining Data from Different Tables
    07:38
  • Another Quick Join
    02:22
  • Exercise Overview
    01:13
  • Practice Joining Data
    1 question
  • A Joinful Solution
    01:42
  • Alternate Forms of Syntax
    05:51
  • Missing Data in Joins
    06:16
  • Why Wasn't It Included
    02:22
  • Four Kinds of Joins
    09:25
  • Each Join in Practice
    04:14
  • Does Order Matter?
    04:11
  • Test Your Joining Knowledge
    5 questions
  • Exercise Overview
    00:55
  • Joins, Joins, Join!
    1 question
  • Two Possible Solutions
    02:59
  • Where with Join
    06:44
  • Three Way Joins
    08:29
  • A Bit of Practice
    04:58
  • Three Way Exercise
    1 question
  • Exercise Solution
    02:52

  • Aggregating and Grouping
    02:10
  • Picturing Group By
    05:29
  • Selecting Columns After Grouping
    2 questions
  • Aggregate Functions
    02:59
  • Combining Group By and Aggregates
    04:47
  • A Gotcha with Count
    02:35
  • Visualizing More Grouping
    03:10
  • Exercise Overview
    00:39
  • Practice For Grouping and Aggregating
    1 question
  • Grouping Solution
    01:20
  • Adding a Layer of Difficulty
    00:42
  • Grouping With a Join!
    1 question
  • Solution
    01:27
  • Filtering Groups with Having
    04:43
  • Having In Action
    02:35
  • More on Having!
    06:47
  • A Having Exercise Overview
    03:36
  • Practice Yourself Some Having
    1 question
  • A Quick Solution
    02:32

  • A New Dataset
    10:22
  • Investigating This Dataset
    02:34
  • Some Group By Practice
    01:20
  • Group By Review
    1 question
  • Group By Review Solution
    02:25
  • Remember Joins?
    02:13
  • Inner Join Review
    1 question
  • Of Course You Remember!
    01:25

  • The Basics of Sorting
    02:14
  • Two Variations on Sorting
    02:40
  • Offset and Limit
    06:38
  • Exercise Overview
    00:25
  • Sorting, Offsetting, and Limiting
    1 question
  • Exercise Solution
    01:20

  • Handling Sets with Union
    05:43
  • A Few Notes on Union
    03:45
  • Commonalities with Intersect
    03:23
  • Removing Commonalities with Except
    05:49
  • Union Exercise Overview
    01:26
  • Merging Results with Union
    1 question
  • Exercise Solution
    01:27

  • What's a Subquery?
    05:48
  • Thinking About the Structure of Data
    04:46
  • What's the Data Look Like?
    4 questions
  • Subqueries in a Select
    05:41
  • Exercise Overview
    01:05
  • Embedding in Select
    1 question
  • Select Solution
    01:18
  • Subqueries in a From
    07:58
  • From Subqueries that Return a Value
    02:45
  • Example of a Subquery in a From
    08:56
  • Exercise Overview
    01:15
  • Subquery From's
    1 question
  • Exercise Solution
    01:59
  • Subqueries in a Join Clause
    04:52
  • More Useful - Subqueries with Where
    08:11
  • Data Structure with Where Subqueries
    05:35
  • Exercise Overview
    00:57
  • Subquery Where's
    1 question
  • Exercise Solution
    02:05
  • The Not In Operator with a List
    04:09
  • A New Where Operator
    06:20
  • Finally Some!
    05:21
  • Is It A Valid Subquery?
    3 questions
  • Exercise Overview
    00:27
  • Practice Your Subqueries!
    1 question
  • A Quick Solution
    01:33
  • Probably Too Much About Correlated Subqueries
    16:39
  • More on Correlated Subqueries
    08:53
  • A Select Without a From?
    03:28
  • Exercise Overview
    00:45
  • From-less Selects
    1 question
  • Exercise Solution
    01:19

  • Selecting Distinct Values
    04:14
  • Exercise Overview
    00:29
  • Some Practice with Distinct
    1 question
  • A Distinct Solution
    00:40

Requirements

  • A Mac, PC, or Linux-based Computer

Description

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, PostgreSQL has 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 patterns to 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!

Who this course is for:

  • Any developers looking to understand databases
  • Application engineers seeking to expand their backend skillset

Featured review

Xavier Sanna
Xavier Sanna
40 courses
12 reviews
Rating: 5.0 out of 52 months ago
I see a course from Stephen, I buy. No thinking, no looking at the reviews or content. No comparing with other courses fron other instructors. The title is just enough to know what will be covered and knowing you will be rewarded for your efforts once you cross the finish line. Thanks to this guy, I became a much better developer, and scored a new job recently. Huge Thanks to you Stephen and your amazing work.

Instructor

Stephen Grider
Engineering Architect
Stephen Grider
  • 4.7 Instructor Rating
  • 277,539 Reviews
  • 729,953 Students
  • 29 Courses

Stephen Grider has been building complex Javascript front ends for top corporations in the San Francisco Bay Area.  With an innate ability to simplify complex topics, Stephen has been mentoring engineers beginning their careers in software development for years, and has now expanded that experience onto Udemy, authoring the highest rated React course. He teaches on Udemy to share the knowledge he has gained with other software engineers.  Invest in yourself by learning from Stephen's published courses.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.