.MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch

Genre: eLearning | Language: English + .VTT | Duration: 6 hours | Size: 2.15 GB

Learn to interact with databases using SQL

What you'll learn

Installing PostgreSQL relational database management system

Connecting to a database

Loading a sample database

Creating database and table

Using constraints to ensure data intergrity

Using SQL SELECT Statement to retrieve data

Using SQL CREATE Statement to create a table

Using SQL UPDATE Statement to modify data

Using SQL DELETE to remove data

Using SQL DISTINCT to filter duplicate data

Filter data using SQL WHERE Clause

Sort data using SQL ORDER BY

Manipulating data with various operators

Retrieve and combine data from multiple tables

Manipulating data using Aggregate Functions

Requirements

Basic knowledge of using a computer

Basic knowledge of using the internet

Description

Almost all applications you interact with on a daily basis involves data which are stored in databases . Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.

SQL is the language used to interact with the data inside these databases. SQL skills are always in demand due to the ever increasing use and reliance of data.

In this beginners course, you will learn the building blocks of SQL by interacting with a PostgreSQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.

Topics include:

Installing PostgreSQL Relational Database System

Connecting to PostgreSQL Default Database

Load sample database

Creating database and tables

Using constraints

Retrieving data from database table

Updating data inside a table

Deleting data inside a database table

Filtering data returned from a database table

Sorting data returned from a database table

Retrieving data using various operators

Combining data from multiple tables

Using aggregate functions to manipulate data.

Using subqueries

Who this course is for:

Beginners to SQL

Beginners to database