SQL Introduction

Get down the basics of SQL databases. A step by setp guide.

SQL vs. NoSQL

NoSQL

SQL

Demo of structed data. Snapshot from PGAdmin.

Install PostGreSQL

Search Windows for pgAdmin
Overview of your SQL connections

Import Test Data

Create new database
Import bookstore.backup file into database bookstore
Data of the table customers

Create your own table

Activate Query Tool for database bookstore
CREATE TABLE owntable(
id SERIAL PRIMARY KEY,
street VARCHAR(127),
description TEXT
)
SELECT * FROM owntable;
ALTER TABLE table 
ADD COLUMN firstname VARCHAR(127) NOT NULL,
ADD COLUMN lastname VARCHAR(127) NOT NULL;
INSERT INTO owntable (firstname, lastname, street, description) 
VALUES (‘Luc’, ‘Brazilian’, ‘MainRoad 67’, ‘Home Adress’),
(‘Max’, ‘Maxman’, ‘SideRoad 68’, ‘Workplace’);
Newly inserted data

Hi, I am an electrical engineer with years of experience in software development as well as designing and building renewable energy plants.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store