The Complete SQL Handwritten note

Description

The Complete SQL Handwritten note
– comprehensive notes and tip

Contents:

• Introduction to Databases
• Introduction to SQL
  2.1. Creating Tables
  2.2. Inserting Rows
  2.3. Retrieving Data
  2.4. Updating Rows
  2.5. Deleting Rows
  2.6. Altering Tables
• Querying with SQL
  3.1. Comparison Operators
  3.2. String Operators
  3.3. Logical Operators
  3.4. IN and BETWEEN Operators
  3.5. ORDER BY and DISTINCT
  3.6. Aggregations and GROUP BY
  3.6.1. Aggregations
  3.6.2. GROUP BY
• Common Concepts
  4.1. SQL Expressions
  4.2. SQL Functions
• Modeling Databases
  5.1. Core Concepts of ER Model
  5.2. Creating a Relational Database
• Joins
  6.1. Natural Join
  6.2. Inner Join
  6.3. Left Join
  6.4. Right Join
  6.5. Full Join
  6.6. Cross Join
• Views and Subqueries
• Transactions and Indexes
  8.1. Transactions
  8.2. Indexes

– Written by: Bhavana