What is a Database?
A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just a database.
To create a database using SQL you need to install a software called Xampp:
What is a Xampp?
XAMPP is a package that installs Apache, MariaDB, PHP, and Perl onto Windows, Linux, or Mac. It is a very simple way to get a web development environment up and running with little knowledge.
What is Database Table?
Table stores and displays data in a structured format consisting of columns and rows that are that are similar to those seen in Excel spreadsheet
What is SQL?
Basically, SQL stands for Structured Query Language which is basically a language used by databases. This language allows to handle the information using tables and shows a language to query these tables and other objects related (views, functions, procedures, etc.). ... With SQL you can insert, delete, and update data.
I learn also about:
-The SQL CREATE DATABASE Statement
-CREATE DATABASE Example
-The SQL DROP DATABASE Statement
-DROP DATABASE Example
-The SQL BACKUP DATABASE Statement
-BACKUP DATABASE Example
-BACKUP WITH DIFFERENTIAL Example
-The SQL CREATE TABLE Statement
-SQL DROP TABLE Example
-SQL TRUNCATE TABLE
-SQL ALTER TABLE Statement
-ALTER TABLE-ADD Column
-ALTER TABLE-ALTER/MODIFY COLUMN
-Change data type Example
-DROP COLUMN Example
-SQL Create Constraints
-SQL Constraints
-SQL NOT NULL Constraint
-SQL NOT NULL ON CREATE TABLE
-SQL NOT NULL ON ALTER TABLE
-SQL UNIQUE Constraint
-SQL UNIQUE Constraint on CREATE TABLE
-SQL UNIQUE Constraint on ALTER TABLE
-DROP a UNIQUE Constraint
-SQL PRIMARY KEY Constraint
-SQL PRIMARY KEY on CREATE TABLE
-SQL PRIMARY KEY on ALTER TABLE
-DROP a PRIMARY KEY Constraint
-SQL FOREIGN KEY Constraint
-SQL FOREIGN KEY on CREATE TABLE
-SQL FOREIGN KEY on ALTER TABLE
-DROP a FOREIGN KEY Constraint
-SQL CHECK Constraint
-SQL CHECK on CREATE TABLE
-SQL CHECK on ALTER TABLE
-DROP a CHECK on ALTER TABLE
-SQL DEFAULT Constraint
-SQL DEFAULT on CREATE TABLE
-SQL DEFAULT on ALTER TABLE
MYSQL DATA TYPES (VERSION 8.0)
String Data Types
Numeric Data Types
SQL Server Data Types
MS Access Data Types
BASIC SQL COMMAND
-SELECT STATEMENT
-Multiple Queries
-Case Sensitivity
-Syntax Rules
-Selecting Multiple Columns
-Selecting All Columns
-The Distinct Keyword
-The Limit Keyword
-Fully Qualified Names
-Order BY
-Sorting Multiple Columns
