PostgreSQL: Introduction to SQL Queries
In this course, we will go over various table and data operations. We will learn to retrieve and modify data efficiently.
What you'll learn
PostgreSQL, commonly known as Postgress, is often called the world's most advanced open-source database. In this course, we will learn about various datatypes and their impact on performance and database designs. We will learn about various table operations, schemas, keys, and constraints. We will also learn how to efficiently retrieve data and make modification to data with insert, update, and delete operations.
Table of contents
- Introduction 1m
- Example of Data Types 2m
- Advantages of Proper Data Types 4m
- Different Data Types 3m
- Real World Scenarios 1m
- Scenario 1: Create Table with Different Data Type 1m
- Demo 1: Create Table with Different Data Type 5m
- Scenario 2: Create New Column Accepting Yes/No 1m
- Demo 2: Create New Column Accepting Yes/No 4m
- Scenario 3: Data Type and Default Values 1m
- Demo 3: Data Type and Default Values 8m
- Scenario 4: Incorrect Data Type and Problems 1m
- Demo 4: Incorrect Data Type and Problems 6m
- Scenario 5: Data Type and Integrity 1m
- Demo 5: Data Type and Integrity 4m
- Scenario 6: Data Type and Mac Address 1m
- Demo 7: Data Type and Mac Address 4m
- Summary 2m
- Introduction 2m
- What Is a Schema? 2m
- Scenario Setup 1m
- Scenario 1: Two Schema with Same Table Name 1m
- Demo: Two Schema with Same Table Name 4m
- What Is a Constraint? 1m
- Scenario 2: Check Constraint 1m
- Demo: Check Constraint 4m
- What Is a NOT-NULL Constraint? 1m
- Scenario 3: NOT-NULL Constraint 4m
- What Is a Unique Constraints? 1m
- Scenario 4: Unique Constraint 3m
- What Is a Primary Key? 1m
- Scenario 5: Primary Key 7m
- What Is a Foreign Key? 1m
- Scenario 6: Foreign Key 9m
- Summary 2m
- Introduction 1m
- SELECT Statement 4m
- Real World Scenario 1m
- Data Operations: Insert Statement 1m
- Scenario 1: Creating Schema Inserting Data from Another Table 1m
- Demo 1-1: Creating Schema Inserting Data from Another Table 3m
- Demo 1-2: Inserting Single Row at a Time 3m
- Demo 1-3: Inserting Multiple Rows at a Time 2m
- Demo 1-4: Inserting Multiple Rows with a Single Insert 2m
- Data Operations: Update Statement 1m
- Scenario 2: Updating Data into Table 1m
- Demo 2-1: Updating Single Row at a Time 6m
- Demo 2-2: Updating Multiple Rows at a Time 3m
- Demo 2-3: Updating Multiple Rows and Columns Together 2m
- Data Operations: Delete Statement 1m
- Scenario 3: Deleting Data from Table 1m
- Demo 2: Deleting Data from Table 5m
- Scenario Conclusion 1m
- Summary 1m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.