PostgreSQL Crash Course (2023)

PostgreSQL Crash Course (2023), available at $59.99, has an average rating of 4.75, with 45 lectures, 5 quizzes, based on 6 reviews, and has 36 subscribers.

You will learn about Basics commands of PostreSQL like CRUD operations in table. How to work with the relational databases? Important & most used functions in PostgreSQL. How to work with primary, logical, and foreign keys within a database ? How to work with real-time large datasets ? Extended features of PostgreSQL. This course is ideal for individuals who are Database Developers who are curious about PostgreSQL It is particularly useful for Database Developers who are curious about PostgreSQL.

Enroll now: PostgreSQL Crash Course (2023)

Summary

Title: PostgreSQL Crash Course (2023)

Price: $59.99

Average Rating: 4.75

Number of Lectures: 45

Number of Quizzes: 5

Number of Published Lectures: 45

Number of Published Quizzes: 5

Number of Curriculum Items: 50

Number of Published Curriculum Objects: 50

Original Price: ?3,299

Quality Status: approved

Status: Live

What You Will Learn

Basics commands of PostreSQL like CRUD operations in table.

How to work with the relational databases?

Important & most used functions in PostgreSQL.

How to work with primary, logical, and foreign keys within a database ?

How to work with real-time large datasets ?

Extended features of PostgreSQL.

Who Should Attend

Database Developers who are curious about PostgreSQL

Target Audiences

Database Developers who are curious about PostgreSQL

What is PostgreSQL ?

1. PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.

2. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

Why to use PostgreSQL ?

1. PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset.

2. In addition to being free and open source, PostgreSQL is highly extensible.

3. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!

Why to choose this Course ?

In this course you will learn wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database.

Also you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc.) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL. Course contains some interesting quizzes on basis of PostgreSQL concepts like creating tables, inserting data, designing data models, creating relational structures and inserting and querying relational data in tables.

Enjoy the course !

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Inroduction

Lecture 2: Instructions

Chapter 2: Basics of PostgreSQL

Lecture 1: What is Database ?

Lecture 2: What is PostreSQL ?

Chapter 3: Setup

Lecture 1: PostgreSQL Installation

Lecture 2: Setup PSQL

Chapter 4: Basics of PostgreSQL

Lecture 1: How to Create Database ?

Lecture 2: How to Connect to Databases ?

Lecture 3: A Very Dangerous Command

Lecture 4: How To Create Tables ?

Lecture 5: Insert Into

Chapter 5: How to work with real-world Database ?

Lecture 1: Create Dummy Database

Lecture 2: Select From

Lecture 3: Order By

Lecture 4: Distinct

Lecture 5: Where Clause and AND

Lecture 6: Comparison Operators

Lecture 7: Limit, Offset & Fetch

Lecture 8: IN

Lecture 9: Between

Lecture 10: Like And iLike

Lecture 11: Group By

Lecture 12: Group By Having

Lecture 13: Adding New Table And Data Using Mockaroo

Chapter 6: Functions in PostgreSQL

Lecture 1: Calculating Min, Max & Average

Lecture 2: AVG & SUM

Lecture 3: Basics of Arithmetic Operators

Lecture 4: Alias

Lecture 5: Coalesce

Lecture 6: NULLIF

Lecture 7: Timestamps And Dates Course

Lecture 8: Adding And Subtracting With Dates

Lecture 9: Extracting Fields From Timestamp

Lecture 10: Age Function

Chapter 7: Keys, Constraints, Update, Delete & Joins

Lecture 1: What Are Primary Keys

Lecture 2: Unique Constraints

Lecture 3: How to Delete Records

Lecture 4: How to Update Records

Lecture 5: On Conflict Do Nothing

Lecture 6: What Is A Relationship/Foreign Keys

Lecture 7: Inner Joins

Lecture 8: Left Joins

Lecture 9: Deleting Records With Foreign Keys

Chapter 8: Extended Features

Lecture 1: Exporting Query Results to CSV

Lecture 2: Serial & Sequences

Instructors

FlexiBrains Global
Online Education Community

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 1 votes

4 stars: 0 votes

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