Explore More Topics...
- Application Software
- Software Development Life Cycle
- Database Components
- Database Platforms
- GUI tools for SQL Development
- Database Table
- ROWs and COLUMNs
- SQL
- Database Hosting
- CREATE TABLE
- ALTER TABLE
- DROP TABLE
- Data Types
- JSON Data Type
- NUll vs NOT NULL
- CHECK Constraint
- DEFAULT Constraint
- UNIQUE Constraint
- AUTO INCREMENT
- INSERT
- SELECT INTO
- UPDATE
- UPSERT
- DELETE
- TRUNCATE
- SELECT *
- WHERE Clause
- LIMIT OFFSET
- DISTINCT
- ORDER BY
- BETWEEN Operator
- CONCAT
- IN Operator
- NOT IN Operator
- IS NULL Operator
- IS NOT NULL Operator
- 'AND' and 'OR' Operators
- '>' and '<' Operator
- '< >' or '!=' Operator (not equal)
- '=' (equal to) Operator
- LIKE Operator
- NOT LIKE Operator
- EXISTS, ANY and ALL Clause
- SQL Aliases
- GROUP BY
- HAVING Clause
- COUNT, SUM, AVG, MIN, MAX Functions
- CASE statement
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- UNION and UNION ALL
- PIVOT
- Sub Queries
- GROUP RANK
- JSON SELECT
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- DATE functions
- STRING functions
- NUMERIC functions
- SQL Execution Order
- COALESCE
- CAST
- What is RDBMS
- Primary Key
- Foreign Key
- Cardinality
- Normalization
- Second Normal Form
- Third Normal Form
- Business key, Natural key and Candidate Key
- Surrogate Key
- Database Index
- Index Types
- Structured VS Unstructured
- ERD (Data Model)
- Database View
- Stored Procedure
- DB Function
- DB Trigger
© 2024 Tansy Academy. All rights reserved