Course Outline

Introduction

  • Overview of SQLite features and architecture
  • SQL basic concepts

Getting Started

  • Installing SQLite
  • Connecting to the database
  • Using the SQLite3 tool

SQLite Data Manipulation

  • Query and subquery
  • Create and insert
  • Sorting and filtering
  • Removing duplicates
  • Data types and aliases

SQLite Operators

  • Basic SQL operators
  • GLOB operator
  • Limit clause

SQLite Database Tables

  • Inner and outer joins
  • Cross and self joins
  • Create and update tables
  • Delete and drop tables
  • SQLite constraints

SQLite Aggregate Functions

  • Basic functions (AVG, COUNT, MAX, MIN, and SUM)
  • Group by statement
  • Having clause
  • Aggregate examples

Troubleshooting

Summary and Next Steps

Requirements

  • Basic SQL experience

Audience

  • Developers
  14 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Testimonials (4)

Related Courses

Related Categories