Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
PostgreSQL Bootcamp : Complete Beginner to Advanced Course
Rating: 4.3 out of 5(254 ratings)
33,243 students

PostgreSQL Bootcamp : Complete Beginner to Advanced Course

Learn PostgreSQL Database, PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin4
Created byKnowledge Nest
Last updated 6/2024
English

What you'll learn

  • Create Demo Database
  • All Operator
  • Any Operator
  • Avg Function
  • Create Table
  • Like Operator
  • Min Max Functions
  • Union Operators
  • Sum Function
  • Cross Join

Course content

1 section • 37 lectures • 5h 40m total length

  • Create Table4:22
  • Insert Data9:04

    Learn to insert data into a PostgreSQL table using insert into, with single and multiple row examples, verification queries, and best practices in pgadmin and SQL shell.

  • Select Data8:26

    Master PostgreSQL select operations by querying all and specific columns, filtering with where, sorting with order by, and limiting results with the limit clause on the employee table.

  • Add Column8:42
  • Update12:16
  • Alter Column8:42
  • Drop Column9:00
  • Delete10:33

    Delete data from a table using the PostgreSQL delete statement, mastering basic syntax, conditional where clauses, and subqueries for precise data cleansing.

  • Drop Table7:56
  • Create Demo Database9:43
  • Operators20:30

    Explore PostgreSQL operators, including equal, not equal, less than, greater than, between, like, in, and the logical and or operators, to filter and compare data.

  • Select Data8:26
  • Select Distinct6:24
  • Where9:48
  • Order By5:35
  • Limit7:29
  • Min Max Functions6:31
  • Count Function10:36
  • Sum Function6:25
  • Avg Function9:13
  • Like Operator11:06
  • In Operator9:46
  • Between Operator10:43
  • Aliase10:54
  • Joins5:41
  • Inner Join9:53
  • Left Join8:32
  • Right Join9:35
  • Full Joins9:06
  • Cross Join9:50
  • Union Operators7:39
  • Group By Clause7:40
  • Having Clause8:39
  • Exists Operator11:23

    Discover how the exists operator and correlated subqueries verify related data in PostgreSQL, including not exists and multiple conditions to find active development projects for employees.

  • Any Operator9:13
  • All Operator7:25

    Explore the all operator in PostgreSQL to perform set comparisons, using subqueries and array values to compare salaries against the benchmark salaries.

  • Case Expression14:09

Requirements

  • No Prior Knowledge is Required.

Description

Welcome to "PostgreSQL Bootcamp : Complete Beginner to Advanced Course," an intensive and comprehensive course designed to equip you with the skills and knowledge necessary to become proficient in PostgreSQL, one of the most powerful and widely used open-source relational database management systems (RDBMS).


In this course, you will embark on a journey from the fundamental concepts of PostgreSQL to advanced techniques, enabling you to harness the full potential of this robust database platform. Whether you are a novice looking to establish a solid foundation or an experienced user aiming to enhance your expertise, this course caters to learners of all levels.


The curriculum is structured to provide a step-by-step progression, starting with the basics of relational databases, SQL syntax, and PostgreSQL installation. You will then delve into essential PostgreSQL features such as data types, indexing, querying, and transactions, gaining a deep understanding of how to design and manage databases efficiently.


As you advance through the course, you will explore advanced topics including performance optimization, scalability, security mechanisms, backup and recovery strategies, and high availability configurations. Real-world scenarios and practical exercises will be incorporated to reinforce your learning and ensure you can apply your knowledge effectively in professional settings.


By the end of this course, you will have mastered PostgreSQL from the ground up, equipped with the skills to design, administer, and optimize PostgreSQL databases effectively. Whether you are pursuing a career as a database administrator, developer, or data analyst, this course will empower you to excel in your professional endeavors. Join us on this enriching journey and unlock the full potential of PostgreSQL!

Who this course is for:

  • Anyone Interested To Become a Data Analyst or Data Scientist.

Report abuse