Database Clinic: SQLite

Go to class
Write Review

Free Online Course: Database Clinic: SQLite provided by LinkedIn Learning is a comprehensive online course, which lasts for 2-3 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. Database Clinic: SQLite is taught by Mark Niemann-Ross.

Overview
  • In this installment of the Database Clinic series, enhance your understanding of SQLite—the embedded database engine—by seeing how it handles a series of common tasks.

Syllabus
  • Introduction

    • Welcome
    • The Database Clinic series
    • What you should know
    • Use the exercise files
    1. SQLite in Five Minutes
    • A brief overview of SQLite
    • Strengths of SQLite
    • Weaknesses of SQLite
    2. Create a Database
    • Database creation
    • Overview of solution
    • SQLite import with Firefox
    • SQLite import with DB Browser for SQLite
    • SQLite import with SQLite3 command line tool
    3. Join Two Datasets
    • Join datasets
    • Overview of solution
    • Import the accidents data using Python
    • Import the vehicles data using Python
    • Import Excel files using Python
    • Calculations with SQLite and Python
    • Code review for R
    4. Search a Database
    • Search a database
    • Overview of solution
    • Correct information, wrong format
    • Subqueries and queries in SQLite
    5. Create, Read, Update, and Delete Operations
    • CRUD operations
    • Overview of solution
    • Create records in SQLite with Python
    • Update records in SQLite with Python
    • Delete records in SQLite with Python
    • Read records in SQLite with Python
    • CRUD operations in SQLite with R
    6. Averages and Calculations
    • Calculations
    • Overview of solution
    • Create a demographic split table
    • Create a forecast
    • Insights on this problem
    Conclusion
    • Next steps