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
- Queries and subqueries
- Creating and inserting data
- 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
- Creating and updating tables
- Deleting and dropping tables
- SQLite constraints
SQLite Aggregate Functions
- Basic functions (AVG, COUNT, MAX, MIN, and SUM)
- GROUP BY statement
- HAVING clause
- Aggregate function examples
Troubleshooting
Summary and Next Steps
Requirements
- Basic SQL experience
Target Audience
- Developers
14 Hours
