Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Share Post: Reddit Facebook
Giveaway [Udemy] SQL with PostgreSQL for Beginners: Analyze | Manipulate Data
#1
SQL with PostgreSQL for Beginners: Analyze | Manipulate Data | Udemy

Quote:Description
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

https://www.udemy.com/course/sql-with-po...CF573CB425
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Giveaway [Udemy] Programming for beginners with : C++ | C# | Java | Python baziroll 0 644 11-20-2021 , 01:28 PM
Last Post: baziroll
  Giveaway [Udemy] Modern React Developer Masterclass for Beginners (2021) baziroll 0 601 09-29-2021 , 08:20 PM
Last Post: baziroll
  Giveaway [Udemy] Extreme MySQL Course From beginners to Master baziroll 0 571 09-28-2021 , 06:58 PM
Last Post: baziroll
  Giveaway [Udemy] Character Design for Beginners baziroll 0 579 09-27-2021 , 02:09 PM
Last Post: baziroll
  Giveaway [Udemy] Data Analyst Bootcamp: Complete Course to be a Data Analyst baziroll 0 618 09-27-2021 , 02:08 PM
Last Post: baziroll



Users browsing this thread: 1 Guest(s)