SQL with PostgreSQL For Beginners

SQL with PostgreSQL For Beginners

What you’ll learn

• Understand PostgreSQL Database Objects
• Perform CRUD Operations
• Creating a database using PostgreSQL GUI
• Creating tables with PostgreSQL GUI and SQL Commands
• Use SQL to insert records in a database
• Use SQL to execute queries against a database
• Use SQL to retrieve data from a database
• Use SQL to update records in a database
• Use SQL to delete records from a database
• Use SQL to create stored procedures in a database
• Use SQL to create views in a database
• Use SQL to filter and sort data returned from a database
• Query and eliminate duplicate records
• Joining and querying data from multiple tables
• Using various aggregate functions and grouping data
• Using various Operators to query data
• Using various Analytic Functions