Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
Query
Advanced SQL
DB
Constraints, Unique, Check, Default, Indexes,
Auto Increment, Dates, Views, Injection, Hosting,
Data types, Not Null
Using Joins
(Inner, Left, Right, Full, Self & Cartesian)
Union Clause
NULL Values
Alias Syntax
Alter Command
Truncate Table
Using Views
Having, Exists, Any and All Clause
Transactions
Wildcards
Date Functions
Temporary Tables
Clone Tables
Sub Queries
Using Sequences
Handling Duplicates
Injection
Case, Null Functions
Stored Procedures, Comments
and Operators
Unique, Check, Default
Where Clause
AND & OR Clauses
Like, Between, NOT, IN
Top
Order By
Group By
Distinct Keyword
Sorting Results
=,<,>,<>,<=,>=,!=
Min and Max
Count, Average and Sum
Database Key
Terms
Relational Database
(relational model, in which the raw data is organized into sets of tuples, and the tuples organized into relations)
DBMS
Primary Key
Foreign Key
DDL (Create DB, Schema, Contraints,Users,Table, Truncate (entire table))
DML (Insert, update or Delete (data alone))
Most Important
SQL commands
QUERY
- Select, update, Delete, Insert Into
TABLE
- Create, Drop, Alter Table
INDEX
- Create, Drop
DB
- Create, Drop , Backup
Database Tuning
(
https://www.tutorialspoint.com/sql/sql-database-tuning.htm
)
SQL Keywords
(
https://www.w3schools.com/sql/sql_ref_keywords.asp
)