SQL Essential Training

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.

Introduction

• Understanding SQL
• How to use the exercise files
• Course overview

1. Installation

• Installing on Windows
• Installing on a Mac

2. SQL Overview

• About SQL
• Database organization
• The SELECT statement
• Selecting rows
• Selecting columns
• Counting rows
• Inserting data
• Updating data
• Deleting data

3. Fundamental Concepts

• 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

4. Relationships

• Understanding JOIN
• Accessing related tables
• Relating multiple tables

5. Strings

• About SQL strings
• Finding the length of a string
• Selecting part of a string
• Removing spaces
• Folding case

6. Numbers

• Numeric types
• What type is that value?
• Integer division
• Rounding numbers

7. Dates and Times

• Dates and times
• Date- and time-related functions

8. Aggregates

• What are aggregates?
• Using aggregate functions
• Aggregating DISTINCT values

9. Transactions

• What are transactions?
• Data integrity
• Performance

10. Triggers

• Automating data with triggers
• Preventing updates
• Example: Timestamps

11. Views and Subselects

• Creating a subselect
• Searching within a result set
• Creating a view
• Creating a joined view

12. A Simple CRUD Application

• Embedding SQL
• The SELECT functions
• The INSERT, UPDATE, and DELETE functions

Conclusion

• Goodbye