Bluelime Learning Solutions
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
Instructor Details
Courses : 34
Specification: SQL Fundamentals for beginners
|
9 reviews for SQL Fundamentals for beginners
Add a review
| Price | $14.99 |
|---|---|
| Provider | |
| Duration | 6 hours |
| Year | 2021 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$14.99
Ejigayehu Zeleke –
A very wonderful presentation! His calm and confidence voice add more interest to it! Thanks a lot! Great teacher!
Chandra Mouli Barenkala –
Brilliant
Alexander –
GREAT
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
Abdullah Alharbi –
well presented
Sriraksha S S –
very nice
Egnite AE –
Well explained. Useful examples to understand the basic functions of SQL
Sudeen Dalal –
If you are a beginner in SQL topic then this course will surely help you to know all the widely used basic & imp Queries.
Erik Holzapfel –
The first half worked really well, everything was explained in detail, whereas the quality of the second half of the course was lacking a little bit