5 out of 5
5
1 review on Udemy

SQL with PostgreSQL for Beginners: Analyze | Manipulate Data

Write SQL Queries for Data Analysis and Manipulation on PostgreSQL Databases
Instructor:
Bluelime Learning Solutions
4,781 students enrolled
English [Auto]
Create Database and Table
Insert data into database
Retrieve data from database
Update existing data inside database
Delete data from database
Filter and sort data
Aggregate data using aggregate functions
Analyse data using analytic functions
Truncate and drop tables
Perform table join on multiple tables
Implement stored procedures

SQL stands for Structured Query Language. It is one of the most in-demand tech skills in the world.

What Can SQL do?

  • SQL lets you access and manipulate databases

  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can filter data returned from a database

  • SQL can sort data returned by a database.

  • SQL can be used to truncate and drop tables.

PostgreSQL is a powerful, open source object-relational database  management system.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.

What You Will Learn

  • Perform CRUD Operations

  • PostgreSQL Database Objects

  • Database Concepts

  • Creating a database using PostgreSQL GUI

  • Creating tables with PostgreSQL GUI and SQL Commands

  • Inserting Data into tables

  • Query and read data stored inside a table

  • Filter and Sort data from a table

  • Using Sub query to retrieve data

  • Updating existing data stored inside a database

  • Query and eliminate duplicate records

  • Deleting records stored inside database

  • Truncating a database table

  • Dropping a database table

  • Implementing Stored Procedure

  • Joining and querying data from multiple tables

  • Using various aggregate functions and grouping data

  • Using various Operators to query data

  • Using various Analytic Functions

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!
5
5 out of 5
1 Ratings

Detailed Rating

Stars 5
1
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0
648f0df7be02d5b04cf22d62909c9e1f
Course available for 2 days
30-Day Money-Back Guarantee

Includes

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

External Links May Contain Affiliate Links read more

Never Miss Any Course Join Our Telegram Channel Join Channel
+ +