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 features and architecture.
- Basic SQL 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
