SQL Fundamentals for beginners
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.
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.
Installing PostgreSQL Relational Database System
Connecting to PostgreSQL Default Database
Load sample database
Creating database and tables
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.
Author : Bluelime Learning Solutions
Ratings : 4.1 / 5.0
Students : 7,215 students