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 capabilities and architectural framework
- Foundational SQL principles
Initialization
- Installation procedures for SQLite
- Establishing database connections
- Utilizing the SQLite3 command-line interface
Data Manipulation in SQLite
- Executing queries and subqueries
- Data insertion and record creation
- Data sorting and filtering techniques
- Identification and removal of duplicate entries
- Management of data types and column aliases
Operator Usage in SQLite
- Standard SQL operators
- Application of the GLOB operator
- Implementation of the LIMIT clause
Table Management in SQLite
- Execution of inner and outer join operations
- Performance of cross and self-joins
- Creation and modification of table structures
- Deletion and removal of tables
- Enforcement of SQLite constraints
Aggregate Functions in SQLite
- Core functions (AVG, COUNT, MAX, MIN, and SUM)
- Use of the GROUP BY statement
- Application of the HAVING clause
- Illustrative aggregate function examples for government data processing
Troubleshooting Procedures
Summary and Future Directions
Requirements
- Fundamental proficiency in SQL is required.
Intended Audience
- Software developers.
14 Hours
