Companies Home Search Profile
TrainingHub TrainingHub

Practical Postgres: Master The Most Important Parts of SQL

Focused View

5:10:23

0 View
  • 1. Introduction.mp4
    03:19
  • 2. What a Database is & Types of Databases.mp4
    04:47
  • 3. What is SQL.mp4
    02:19
  • 4. Why Postgres.mp4
    02:35
  • 5. Setup Mac.html
  • 6. Setup Windows.html
  • 1. What is a Table.mp4
    04:38
  • 2. Common Conventions.mp4
    04:52
  • 3. Data Types.mp4
    04:01
  • 4. Creating Our First Table.mp4
    06:58
  • 5. EXERCISE Creating our first table.mp4
    01:03
  • 6. EXERCISE WALKTHROUGH Creating our first table and nullable columns.mp4
    06:27
  • 1. Types of Operations CRUD.mp4
    01:50
  • 2. Insert statements.mp4
    03:19
  • 3. Select statements.mp4
    05:43
  • 4. Update statements.mp4
    03:06
  • 5. Delete statements.mp4
    01:44
  • 6. Transactions.mp4
    03:55
  • 7. CRUD Quiz.html
  • 1. Setup.html
  • 2. LIKE & ILIKE.mp4
    03:26
  • 3. OR statements and parenthesis.mp4
    09:22
  • 4. Alias.mp4
    03:13
  • 5. ORDER BY.mp4
    01:43
  • 6. Primary Keys and Indexes.mp4
    04:23
  • 7. EXERCISE Robust Queries.mp4
    03:04
  • 8. Data for exercise.html
  • 9. EXERCISE WALKTHROUGH Robust Queries.mp4
    15:00
  • 1. Why we need relationships.mp4
    04:52
  • 2. Types of Relationships.mp4
    08:09
  • 3. Entity Relationship Diagrams.mp4
    09:31
  • 4. EXERCISE Designing a Database.mp4
    02:31
  • 5. EXERCISE WALKTHROUGH Designing a Database.mp4
    07:35
  • 6. Foreign Keys.mp4
    05:43
  • 7. Leaf Land DB Setup.mp4
    03:14
  • 8. Join statements.mp4
    11:01
  • 9. Schemas.mp4
    03:15
  • 10. EXERCISE Joins.mp4
    02:27
  • 11. EXERCISE WALKTHROUGH Joins.mp4
    10:36
  • 1. Aggregates & Group By.mp4
    04:58
  • 2. Date Trunc.mp4
    02:45
  • 3. Nested Queries.mp4
    03:41
  • 4. CTES WITH Queries.mp4
    04:43
  • 5. EXERCISE Product Revenue.mp4
    02:14
  • 6. EXERCISE WALKTHROUGH Product Revenue.mp4
    20:58
  • 7. EXERCISE User Insights.mp4
    00:57
  • 8. EXERCISE WALKTHROUGH User Insights.mp4
    11:36
  • 9. EXERCISE Monthly Sales.mp4
    00:46
  • 10. EXERCISE WALKTHROUGH Monthly Sales.mp4
    19:02
  • 1. Creating a shipping schema and table.mp4
    03:36
  • 2. Inserting from query.mp4
    03:31
  • 3. Updating from queries.mp4
    03:40
  • 1. Whats a View.mp4
    02:08
  • 2. Creating a View.mp4
    03:01
  • 3. Materialized Views.mp4
    04:12
  • 1. What is a Function.mp4
    05:53
  • 2. Creating a Discount Function.mp4
    06:03
  • 3. Using Functions.mp4
    03:21
  • 4. Triggers.mp4
    05:36
  • 5. EXERCISE Functions & Triggers.mp4
    00:54
  • 6. EXERCISE WALKTHROUGH Functions & Triggers.mp4
    07:52
  • 1. JSONB.mp4
    07:59
  • 2. Finding queries with long execution time.mp4
    02:27
  • 3. Database Hosting.mp4
    02:36
  • 4. Datagrip.mp4
    05:39
  • 5. Thank You.mp4
    00:34

    • Description

    Learn the most critical parts of postgresql from the ground up.

    What You'll Learn?

    • Write complex SQL queries in postgres
    • Create well designed schemas
    • Understand how to utilize advanced tools to improve postgres efficiency
    • Leverage constraints to keep data high quality

    Who is this for?

  • Anyone interested in learning SQL with a specific focus on postgres

    • What You Need to Know?

  • No experience needed

    • More details

    Description

    Unlock the power of PostgreSQL with a course designed by a seasoned CTO for real-world application. Skip the fluff and dive straight into the heart of what matters in day-to-day database operations.

    Why This Course?

    • Curated content based on 15+ years of industry experience

    • Focus on practical skills used daily in professional settings

    • Efficient learning path, eliminating unnecessary complexities

    What You'll Learn:

    1. Robust Query Writing: Master the art of crafting efficient and powerful SQL queries

    2. Essential PostgreSQL Features: Explore views, triggers, and functions

    3. Data Manipulation: Become proficient in update, insert, and delete operations

    4. Database Architecture: Understand schemas and effective database design

    Whether you're a beginner starting from scratch or a professional looking to sharpen your skills, this course will elevate your PostgreSQL proficiency to new heights. Join us to gain practical knowledge that you can implement immediately.

    Transform your database skills and boost your career prospects with this laser-focused, industry-driven PostgreSQL course!

    Learn from real-world scenarios and hands-on exercises that simulate actual workplace challenges. Gain confidence in your ability to handle complex database tasks efficiently. By the end of this course, you'll possess the skills that top companies seek in their database professionals, setting you apart in the competitive tech landscape.

    Who this course is for:

    • Anyone interested in learning SQL with a specific focus on postgres

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category

    PostgreSQL

    Udemy
    Udemy
    View courses Udemy
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 61
    • duration 5:10:23
    • Release Date 2024/10/31

    Courses related to PostgreSQL

    Subtitle
    PostgreSQL High Performance Tuning Guide
    Udemy Lucian Oprea
    Lucian Oprea
    PostgreSQL High Performance Tuning Guide
    2:40:21
    English subtitles
    09/07/2023
    The Complete Python/PostgreSQL Course 2.0
    Udemy Jose Salvatierra
    Jose Salvatierra
    The Complete Python/PostgreSQL Course 2.0
    13:31:23
    12/22/2022
    Babelfish for AWS Aurora PostgreSQL - Hands on Learning
    Udemy Amit Arora
    Amit Arora
    Babelfish for AWS Aurora PostgreSQL - Hands on Learning
    2:07:06
    12/04/2023