free SQL Essential Training

Start Learning for 100% Free – SQL Essential Training, Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2021, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager.

Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using 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.

This course was created by Bill Weinman. We are pleased to offer this training in our library.


Understanding SQL
How to use the exercise files
Course overview

  • Installation
    Installing on Windows
    Installing on a Mac
  • SQL Overview
    About SQL
    Database organization
    The SELECT statement
    Selecting rows
    Selecting columns
    Counting rows
    Inserting data
    Updating data
    Deleting data
  • 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
  • Relationships
    Understanding JOIN
    Accessing related tables
    Relating multiple tables
  • Strings
    About SQL strings
    Finding the length of a string
    Selecting part of a string
    Removing spaces
    Folding case
  • Numbers
    Numeric types
    What type is that value?
    Integer division
    Rounding numbers
  • Dates and Times
    Dates and times
    Date- and time-related functions
  • Aggregates
    What are aggregates?
    Using aggregate functions
    Aggregating DISTINCT values
  • Transactions
    What are transactions?
    Data integrity
  • Triggers
    Automating data with triggers
    Preventing updates
    Example: Timestamps
  • Views and Subselects
    Creating a subselect
    Searching within a result set
    Creating a view
    Creating a joined view
  • A Simple CRUD Application
    Embedding SQL
    The SELECT functions
    The INSERT, UPDATE and DELETE functions


Download Now