SQL and PostgreSQL: The Complete Developer's Guide
4.6 /5- Offered byUDEMY
SQL and PostgreSQL: The Complete Developer's Guide at UDEMY Overview
Duration | 22 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website  |
Credential | Certificate |
SQL and PostgreSQL: The Complete Developer's Guide at UDEMY Highlights
- 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
SQL and PostgreSQL: The Complete Developer's Guide at UDEMY Course details
- Any developers looking to understand databases
- Application engineers seeking to expand their backend skillset
- 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
- 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.
SQL and PostgreSQL: The Complete Developer's Guide at UDEMY Curriculum
Simple - But Powerful - SQL Statements
What is PostgreSQL All About?
Database Design
Database Terminology
Creating Tables
Analyzing CREATE TABLE
Inserting Data Into a Table
Retrieving Data with Select
Create, Insert, and Select!
Calculated Columns
Calculating Phone Revenue
Using Calculated Columns
Exercise Solution
String Operators and Functions
Filtering Records
Filtering Rows with "Where"
More on the "Where" Keyword
Compound "Where" Clauses
A "Where" Exercise Overview
Practicing Where Statements
A "Where" Solution
"Where" With Lists
A More Challenging 'Where'
A "Where" With Lists Solution
Calculations in "Where" Clauses
Trying Calculations in Where Clauses
Solving Calculations
Updating Rows
Deleting Rows
Try Updating Records In a Table!
A Solution for Updating Rows
Practice Deleting Records
Solution for Deleting Rows
Working With Tables
The Plan Moving Forward
Approaching Database Design
Let's Design Some Schema
One-to-Many and Many-to-One Relationships
A 'Has One' or 'Has Many'?
One-to-One and Many-to-Many Relationships
Identifying One-to-One and Many-to-Many Relationships
Primary Keys and Foreign Keys
Understanding Foreign Keys
Foreign Keys; How Do They Work?
Auto-Generated ID's
Creating Foreign Key Columns
Running Queries on Associated Data
Exercise Overview
Creating and Using Foreign Keys
Foreign Key Creation Solution
Foreign Key Constraints Around Insertion
Constraints Around Deletion
Commands You?ll Need for the Next Video
Testing Deletion Constraints
Setting Foreign Keys to Null on Delete
What Happens On Delete?
Adding Some Complexity
Relating Records With Joins
Adding Some Data
Queries with Joins and Aggregations
Joining Data from Different Tables
Another Quick Join
Exercise Overview
Practice Joining Data
A Joinful Solution
Alternate Forms of Syntax
Missing Data in Joins
Why Wasn't It Included
Four Kinds of Joins
Each Join in Practice
Does Order Matter?
Test Your Joining Knowledge
Exercise Overview
Joins, Joins, Join!
Two Possible Solutions
SQL and PostgreSQL: The Complete Developer's Guide at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?