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.
Duration 14 hours
Course Outline
Introduction
- Overview of SQLite’s key features and architectural design
- Foundational SQL concepts
Getting Started
- Installing the SQLite environment
- Establishing database connections
- Utilizing the SQLite3 command-line tool
SQLite Data Manipulation
- Working with queries and subqueries
- Creating structures and inserting data
- Techniques for sorting and filtering records
- Eliminating duplicate entries
- Exploring data types and aliases
SQLite Operators
- Application of basic SQL operators
- Usage of the GLOB operator
- Implementing the LIMIT clause
SQLite Database Tables
- Performing inner and outer joins
- Executing cross and self joins
- Creating and updating table structures
- Deleting and dropping tables
- Understanding SQLite constraints
SQLite Aggregate Functions
- Using core functions (AVG, COUNT, MAX, MIN, and SUM)
- Utilizing the GROUP BY statement
- Applying the HAVING clause
- Practical aggregate function examples
Troubleshooting
Summary and Next Steps
Requirements
- Familiarity with fundamental SQL concepts
Target Audience
- Software Developers
