Search

SQL with PostgreSQL For Beginners [Free Online Course] - TechCracked

SQL with PostgreSQL For Beginners

Learn SQL and PostgreSQL from scratch

This course includes:
  • 8.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion


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


Description

SQL is a standard language for accessing and manipulating databases.

SQL is one of the most  in-demand tech skill used across many industries.

What is SQL?

SQL stands for Structured Query Language

What Can SQL do?
  • SQL lets you access and manipulate databases
  • SQL can execute queries against a database
  • SQL can retrieve data from a database
  • SQL can insert records in a database
  • SQL can update records in a database
  • SQL can delete records from a database
  • SQL can create new databases
  • SQL can create new tables in a database
  • SQL can create stored procedures in a database
  • SQL can create views in a database
  • SQL can filter data returned from a database
  • SQL can sort data returned by a database.
  • SQL can be used to truncate and drop tables.

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.

Also See : Google BigQuery and PostgreSQL: SQL for Data Analysis

Enroll Now

Post a comment

0 Comments