SQL Essential Training

Go to class
Write Review

Free Online Course: SQL Essential Training provided by LinkedIn Learning is a comprehensive online course, which lasts for 3-4 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SQL Essential Training is taught by Bill Weinman.

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
    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