PostgreSQL For Beginners

About this course

PostgreSQL is commonly known as Postgres and it is also  open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.  The course also covers the basics of creating tables, storing data with data types, and working with expressions,  operators, and strings. Topics include:Installing PostgreSQLVerify postgresql installationpostgresql INSERT StatementPostgres UNIQUE ConstraintsPostgres Truncate statementPostgres  UPDATEPostgresql INNER JOINRemoving Duplicate RecordsPostgres LIKE OperatorPostgresql OR OperatorSorting Data Server serviceSequencesSchemaRetrieving all Data from TableQuery Data fro specific columnLoading sample databasePostgresql DELETE StatementPostgresql DATA TypesPostgresql CREATE Table StatementPostgresql SubQueryPostgresql UNION OperatorPostgreSQL ORDER BY clausePostgreSQL UNION ALL OperatorPostgreSQL GROUP BY clausePostgreSQL FULL OUTER JOINPostgreSQL CROSS JOINPostgreSQL combining AND | OR  OperatorPostgreSQL AND OperatorPostgreSQL BETWEEN OperatorPostgreSQL NATURAL JOIN OperatorPostgreSQL SELECT statementCRUD OperationsPostgreSQL EXCEPT OperatorCreate a Database with PG4ADMINCreate a Table with PG4ADMINPostgreSQL NOT OperatorPostgreSQL NOT BETWEEN OperatorPostgreSQL LIMIT OperatorPostgreSQL INTERSECT OperatorPostgreSQL Left JoinPostgreSQL IN OperatorPostgreSQL HAVING clauseComparison operatorsCast and OperatorsFiltering Data with WHERE clause This is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL .

Course objectives

• understand the installation and configuration of PostgreSQL
• learn how to create and manage databases and tables
• gain practical experience with SQL operations and data retrieval