sql.md

📝 Notes

SQL

Learn

1. What is it
2. What does it do
3. Why to use it
4. Getting started
5. Concepts
6. Code samples
7. Documentation

Resources

• SQL
• Keywords

Terms and concepts

• Database
• Database Modeling
• SQL or Structured Query Language
• CRUD or Create Read Update Delete
• DDL or Data Definition Language
• DML or Data Manipulation Language
• DCL or Data Control Language
• DBA or DataBase Administrator
• ETL or Extracting Transforming Loading
• Syntax

• Comments
  • Single line
  • Multi-line
• Keywords
  • Not case-sensitive

• Statements
• Conditionals

• Operators
  • Arithmetic
  • Bitwise
  • Comparison
  • Compound
  • Logical

• Truth table

• Structure (Entities)
  • DB or Database
    • Table
      • Columns or Fields or Attributes
        • Define (data type, name)
        • Limit
      • Rows or Records
        • Ilimit (optional)
      • Index

• Cardinality

• Keys
  • Primary
  • Foreing
• Queries
  • Subqueries
  • Aliases
  • Views
• Commands
  • Basic
  • Advanced
  • Scripts
• Relationship between tables
  • OneToOne
  • OneToMany
  • ManyToOne
  • ManyToMany
  • ManyToAny
  • Unidirectional
  • Bidirectional

• Database structure
• ER Diagram or Entity-Relationship model

• Database (Basic unit)
  • Entities
    • Table (Basic entity)
    • Schema
    • View
    • Trigger
    • Procedure
• SQL environment
  • Backup
  • Recovery

• SQL Server Functions

Software Developer

Built by javi ©️ 2023 - 2024
Found a bug or have an idea? Contact me.