Database Management System (DBMS)¶
SQL - Structured Query Language or Sequel (declarative language) for maintaining and utilizing data in relational databases
Learn SQL¶
Popular Database Systems¶
- MySQL open-source owned by Oracle)
- MariaDB (fork of MySQL)
- Micrsoft SQL Server
- Oracle
- PostgreSQL(open-source)
- MongoDB
- IBM DB2, Infromix
SQL Study Guide by General Assembly¶
- Getting Started with SQL
- Exploring SQL Data with Basic Queries
- Refining Queries with Where Clauses & Conditionals
- Modifying Text Queries with String Functions
- Handling Null Values
- User Aggregate Functions to Summarize and Compare Data
- Using Case to make new fields
- Joining Tables in SQL
- Joining Multiple Tables in SQL
- Writing SQL Subqueries
References¶
- Normalization
- Database Engine Rankings
- System Properties Comparison SQL Server vs MySQL vs Oracle
- BigQuery vs SQL Server vs MySQL
Database Systems¶
SQL Server¶
- SQL Server technical documentation
- SQL Shack SQL Server training
- SQL Server Business Intelligence Resources
MySQL¶
- MySQL Docs
- MySQL Common Queries
- MySQL Alternatives & Competitors
- Top MySQL Features - 8 Major Advantages of Using MySQL
- Best practises for InnoDB tables
Oracle¶
Backlinks:
list from [[DBMS]] AND -"Changelog"