Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Overview of SQLite’s features and system architecture
- Foundational SQL concepts
Getting Started
- Installation process for SQLite
- Establishing connections to the database
- Utilizing the SQLite3 command-line tool
Data Manipulation in SQLite
- Executing queries and subqueries
- Creating tables and inserting records
- Sorting results and applying filters
- Eliminating duplicate entries
- Working with data types and aliases
SQLite Operators
- Standard SQL operators
- Using the GLOB operator
- Implementing the Limit clause
Managing SQLite Database Tables
- Performing inner and outer joins
- Executing cross and self joins
- Creating and updating table structures
- Deleting records and dropping tables
- Applying SQLite constraints
SQLite Aggregate Functions
- Core functions (AVG, COUNT, MAX, MIN, and SUM)
- Utilizing the Group by statement
- Applying the Having clause
- Practical aggregate examples
Troubleshooting
Summary and Next Steps
Requirements
- Familiarity with basic SQL concepts
Target Audience
- Software Developers
14 Hours
