SQL Fundamentals for beginners

SQL Fundamentals for beginners, available at $54.99, has an average rating of 4.7, with 52 lectures, based on 348 reviews, and has 23373 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners to SQL or Beginners to database It is particularly useful for Beginners to SQL or Beginners to database.

Enroll now: SQL Fundamentals for beginners

Summary

Title: SQL Fundamentals for beginners

Price: $54.99

Average Rating: 4.7

Number of Lectures: 52

Number of Published Lectures: 52

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 52

Original Price: $94.99

Quality Status: approved

Status: Live

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

Who Should Attend

Beginners to SQL
Beginners to database

Target Audiences

Beginners to SQL
Beginners to database

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

Course Curriculum

Chapter 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

Chapter 2: C R U D Operations

Lecture 1: Introduction

Lecture 2: Create a table with SQL

Lecture 3: Retrieve all data from Table with SQL SELECT

Lecture 4: Retrieve specific data from Table with SQL SELECT

Lecture 5: Modify data in table using SQL UPDATE

Lecture 6: Remove data from table using SQL DELETE

Lecture 7: Filtering Data using SQL WHERE Clause

Lecture 8: Ordering data using SQL ORDER BY Clause

Lecture 9: Subqueries

Lecture 10: Removing Duplicate Records

Lecture 11: Truncating a Table

Lecture 12: Adding new data to table using SQL INSERT

Chapter 3: SQL Operators

Lecture 1: Comparison Operators

Lecture 2: BETWEEN Operators

Lecture 3: NOT BETWEEN Operators

Lecture 4: LIKE Operators

Lecture 5: NOT Operators

Lecture 6: OR Operators

Lecture 7: AND Operators

Lecture 8: Combining OR | AND Operators

Lecture 9: IN Operators

Lecture 10: UNION OPerators

Lecture 11: UNION ALL Operators

Lecture 12: INTERSECT Operators

Chapter 4: Combining Data From Multiple Tables

Lecture 1: Introduction to Table Joins

Lecture 2: SQL INNER Joins

Lecture 3: SQL LEFT JOIN

Lecture 4: SQL OUTER JOIN

Lecture 5: SQL CROSS JOIN

Lecture 6: SQL NATURAL JOIN

Chapter 5: SQL AGGREGATE FUNCTIONS

Lecture 1: Introduction to aggregate functions

Lecture 2: SQL AVG Aggregate Function

Lecture 3: SQL COUNT Aggregate Function

Lecture 4: SQL MAX Aggregate Function

Lecture 5: SQL MIN Aggregate Function

Lecture 6: SQL SUM Aggregate Function

Lecture 7: Grouping Data using SQL GROUP BY Clause

Lecture 8: Splitting Groups using HAVING Clause

Lecture 9: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 3 votes
2 stars: 10 votes
3 stars: 50 votes
4 stars: 137 votes
5 stars: 148 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu