Have a question?
Message sent Close
4.2 out of 5
4.2
38 reviews on Udemy

SQL Fundamentals for beginners

Learn to interact with databases using SQL
Instructor:
Bluelime Learning Solutions
5,141 students enrolled
English [Auto]
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

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

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.2
4.2 out of 5
38 Ratings

Detailed Rating

Stars 5
18
Stars 4
13
Stars 3
6
Stars 2
1
Stars 1
0
3fdbfa77d421f39052cd2d2439672429
Course available for 2 days
30-Day Money-Back Guarantee

Includes

6 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW