Sql Fundamentals For Beginners

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 SystemConnecting to PostgreSQL Default DatabaseLoad sample databaseCreating database and tablesUsing constraintsRetrieving data from database tableUpdating data inside a tableDeleting data inside a database tableFiltering data returned from  a database tableSorting data returned from a database tableRetrieving data using various operatorsCombining data from multiple tablesUsing aggregate functions to manipulate data.Using subqueries

Overview

Section 1: Introduction and Database Setup

Lecture 1 Introduction

Lecture 2 What is SQL

Lecture 3 Basic Database Concepts

Lecture 4 What is PostgreSQL

Lecture 5 Download and install PostgreSQL for Windows

Lecture 6 Download and install PostgreSQL for Mac

Lecture 7 Connecting to a PostgreSQL Database

Lecture 8 Load sample database

Lecture 9 Exploring some database objects

Lecture 10 Using Constraints for data integrity

Lecture 11 Create database

Lecture 12 Create a table with PgAdmin

Lecture 13 Schema

Section 2: C R U D Operations

Lecture 14 Introduction

Lecture 15 Create a table with SQL

Lecture 16 Retrieve all data from Table with SQL SELECT

Lecture 17 Retrieve specific data from Table with SQL SELECT

Lecture 18 Modify data in table using SQL UPDATE

Lecture 19 Remove data from table using SQL DELETE

Lecture 20 Filtering Data using SQL WHERE Clause

Lecture 21 Ordering data using SQL ORDER BY Clause

Lecture 22 Subqueries

Lecture 23 Removing Duplicate Records

Lecture 24 Truncating a Table

Lecture 25 Adding new data to table using SQL INSERT

Section 3: SQL Operators

Lecture 26 Comparison Operators

Lecture 27 BETWEEN Operators

Lecture 28 NOT BETWEEN Operators

Lecture 29 LIKE Operators

Lecture 30 NOT Operators

Lecture 31 OR Operators

Lecture 32 AND Operators

Lecture 33 Combining OR | AND Operators

Lecture 34 IN Operators

Lecture 35 UNION OPerators

Lecture 36 UNION ALL Operators

Lecture 37 INTERSECT Operators

Section 4: Combining Data From Multiple Tables

Lecture 38 Introduction to Table Joins

Lecture 39 SQL INNER Joins

Lecture 40 SQL LEFT JOIN

Lecture 41 SQL OUTER JOIN

Lecture 42 SQL CROSS JOIN

Lecture 43 SQL NATURAL JOIN

Section 5: SQL AGGREGATE FUNCTIONS

Lecture 44 Introduction to aggregate functions

Lecture 45 SQL AVG Aggregate Function

Lecture 46 SQL COUNT Aggregate Function

Lecture 47 SQL MAX Aggregate Function

Lecture 48 SQL MIN Aggregate Function

Lecture 49 SQL SUM Aggregate Function

Lecture 50 Grouping Data using SQL GROUP BY Clause

Lecture 51 Splitting Groups using HAVING Clause

Lecture 52 Thank You

Beginners to SQL,Beginners to database