Basic SQL

1. What is SQL? (Structured Query Language)

2. Learn Basic SQL#

• Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
  • Introduction
  • Why learn SQL for BI?
  • Tutorial start
  • SQL SELECT statement
  • AS field alias
  • WHERE clause
  • ORDER BY clause
  • INNER JOIN
  • Aliasing tables
  • GROUP BY clause
  • HAVING clause
  • Outro
• Learn Basic SQL in 15 Minutes (PART 2/3) | Creating Tables | SQL Tutorial | Business Intelligence
  • Intro
  • What are data tables?
  • SQL data types
  • The data source
  • Creating a data table in SQL
  • Deleting a data table in SQL
  • SQL column constraints
  • Inserting data into a SQL table
  • Updating SQL tables
  • Outro
• Learn Basic SQL in 15 Minutes (PART 3/3) | SQL Functions Tutorial | Business Intelligence
  • Intro
  • Tutorial start
  • TRIM, LTRIM & RTRIM functions
  • LEFT & RIGHT functions
  • LPAD & RPAD functions
  • SUBSTRING function
  • LENGTH function
  • LOCATE function
  • Separating first & last names
  • UPPER & LOWER functions
  • CONCAT function
  • Conditional Expressions
  • CASE statements
  • Outro

3. MySQL Cheat Sheet