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 features and architecture
- Core SQL concepts
Getting Started
- Installing SQLite
- Establishing database connections
- Utilizing the SQLite3 tool
SQLite Data Manipulation
- Queries and subqueries
- Creating and inserting data
- Sorting and filtering results
- Eliminating duplicates
- Data types and aliases
SQLite Operators
- Standard SQL operators
- GLOB operator usage
- Applying the Limit clause
SQLite Database Tables
- Inner and outer joins
- Cross and self joins
- Table creation and updates
- Table deletion and dropping
- Applying SQLite constraints
SQLite Aggregate Functions
- Essential functions (AVG, COUNT, MAX, MIN, and SUM)
- Using the Group by statement
- Applying the Having clause
- Practical aggregate examples
Troubleshooting
Summary and Next Steps
Requirements
- Foundational SQL experience
Audience
- Developers
