SQL Fundamentals for beginners (Udemy.com)

Learn to interact with databases using SQL

( 6 Reviews )

Created by: Bluelime Learning Solutions

Produced in 2021

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 94 / 100

Course 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

Time: 6h

Instructor Details

Bluelime Learning Solutions

4.7 Rating
6 Reviews

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) (2021)
3.7 (260 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

17 Beginner C# Walkthrough Projects step by step

17 Beginner C# Walkthrough Projects step by step (2021)
3.9 (189 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

Coding for beginners (2021)
4.0 (117 Reviews)

- Provider: Udemy
- Time: 22h

$11.99

PostgreSQL Database Administration (DBA) for Beginners

PostgreSQL Database Administration (DBA) for Beginners (2018)
3.2 (93 Reviews)

- Provider: Udemy
- Time: 11.5h

$11.99

Python and Django Full-Stack Web Development for beginners

Python and Django Full-Stack Web Development for beginners (2021)
4.3 (58 Reviews)

- Provider: Udemy
- Time: 34.5h

$11.99

Learn Java by building 17 projects step by step

Learn Java by building 17 projects step by step (2018)
3.6 (52 Reviews)

- Provider: Udemy
- Time: 10.5h

$11.99

All courses by Bluelime Learning Solutions

Reviews

4.7

6 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Alexander

GREAT

By Abdullah Alharbi

well presented

By Chandra Mouli Barenkala

Brilliant

By Ejigayehu Zeleke

A very wonderful presentation! His calm and confidence voice add more interest to it! Thanks a lot! Great teacher!

By Kanthraj

It was totally good session which you have provided in this course thank you for this.

Missing for after every section if you have Questions to be answered by us that would be great learning in a two way communication.

Opening the PGADMIN 4 tools in every videos it took almost 30secs to 1min is wasted the video content, in the initial video was fine but in all the section and video completely made video length more

By Sriraksha S S