Overview
-
Learn how to use SQL to manage your database. Explore beginner-level tutorials on creating tables, defining relationships, and manipulating strings with SQL and SQLiteStudio.
Syllabus
-
Introduction
- Understanding SQL
- How to use the exercise files
- Course overview
- Installing on Windows
- Installing on a Mac
- About SQL
- Database organization
- The SELECT statement
- Selecting rows
- Selecting columns
- Counting rows
- Inserting data
- Updating data
- Deleting data
- Creating a table
- Deleting a table
- Inserting rows
- Deleting rows
- The NULL value
- Constraining columns
- Changing a schema
- ID columns
- Filtering data
- Removing duplicates
- Ordering output
- Conditional expressions
- Understanding JOIN
- Accessing related tables
- Relating multiple tables
- About SQL strings
- Finding the length of a string
- Selecting part of a string
- Removing spaces
- Folding case
- Numeric types
- What type is that value?
- Integer division
- Rounding numbers
- Dates and times
- Date- and time-related functions
- What are aggregates?
- Using aggregate functions
- Aggregating DISTINCT values
- What are transactions?
- Data integrity
- Performance
- Automating data with triggers
- Preventing updates
- Example: Timestamps
- Creating a subselect
- Searching within a result set
- Creating a view
- Creating a joined view
- Embedding SQL
- The SELECT functions
- The INSERT, UPDATE, and DELETE functions
- Goodbye
