SQL for beginners with 🙁 PostgreSQL, MySQL, SQL Server )

Short Description

Master the basics of querying databases and manipulating data

What you’ll learn

  • Install and setup PostgreSQL Database Server
  • Install and setup MySQL Database Server
  • Install and setup Microsoft SQL Server
  • Query databases
  • Perform Database Table Joins
  • Filter Data
  • Sort Data
  • Aggregate Functions
  • Group Data

This course includes:

  • 8 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Requirements

  • A Computer and internet access required.

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.

MORE COURSE