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
- 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