Introduction To Relational Databases With PostgreSQL.
4 min read
Table of contents
- SQL Tutorial (Postgres)
- What is a Database?
- What is DBMS?
- What is SQL?
- What is RDBMS?
- Some Popular RDBMS
- What Is NoSQL Database?
- Types Of NoSQL Databases
- Why PostgreSQL?
- Structure Of SQL Databases
- Courses (Table)
- Interacting With SQL Databases
- Creating Database
- SQL Queries
SQL Tutorial (Postgres)
What is a Database?
A Database is an organized collection of data stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques.
What is DBMS?
The database management system (DBMS) is the software that interacts with end-users, applications, and the database itself to capture and analyze the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS, and the associated applications can be referred to as a "database system". Often the term "database" is also used loosely to refer to any of the DBMS, the database system, or an application associated with the database.
What is SQL?
SQL stands for Structured Query Language ( Pronounced as "sequel" ) which is a language used by databases. This language allows to handle the information using tables and shows a language to query these tables. Most of the databases management systems like SQL Server, Oracle, PostgreSQL, MySQL, MariaDB use this language to handle the data. With SQL you can insert, delete, and update data. You can also create, delete, or alter database objects.
What is RDBMS?
A Relational Database Management System (RDBMS) is a type of database management system (DBMS) that stores data in a row-based table structure that connects related data elements. An RDBMS includes functions that maintain the security, accuracy, integrity, and consistency of the data. This is different than the file storage used in a DBMS.
Some Popular RDBMS
- SQL Server
- IBM DB2
- Microsoft Access
- Azure SQL
What Is NoSQL Database?
A NoSQL (originally referring to "non-SQL" or "non-relational") database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.
Types Of NoSQL Databases
- Oracle NoSQL
- Amazon Neptune
- Allegro Graph
- Wide column
- Apache HBase
- Google BigTable
- Microsoft Azure Cosmos DB
PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open-source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!
Structure Of SQL Databases
|1||Learn SQL From Scratch||50|
|2||Learn C# From Scratch||70|
|3||Learn EF Core From Scratch||40|
Interacting With SQL Databases
- SQL Editor
CLI ( Command Line Interface )
SQL Command Line (PSQL In Postgres) is a command-line tool for accessing PostgreSQL Database. It enables you to enter and run SQL Commands Like SELECT, INSERT, ALTER
GUI ( Graphical User Interface )
PGAdmin is a web-based GUI tool used to interact with the Postgres database sessions, both locally and remote servers as well. You can use PGAdmin to perform any sort of database administration required for a Postgres database
ORM ( Object Relational Mapping )
ORM is a programming technique for converting data between incompatible type systems using object-oriented programming languages. This creates, in effect, a "virtual object database" that can be used from within the programming language.
ORM For Popular Programming Languages
- Django ORM
SQL editor is like a command-line interface but it has more features like autosuggestions and syntax highlighting that make you more productive with SQL, you can also save your connections and queries in SQL editor.
# With Default User createdb database_name # With Custom User createdb -U username database_name
SELECT - Selecting Data
SELECT values_to_select FROM table_name;
SELECT values_to_select FROM table_name WHERE column_name = value_to_check;
SELECT values_to_select FROM table_name LIMIT number_of_rows;
CREATE - Creating Data
CREATE type name;
CREATE DATABASE database_name;
CREATE TABLE table_name ( column_1 type_of_column, column_2 type_of_column, column_3 type_of_column, );
Did you find this article valuable?
Support Nouman Rahman by becoming a sponsor. Any amount is appreciated!