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
Introductory Framework
- Architectural analysis and functional overview of SQLite
- Foundational SQL principles and concepts
Initial Configuration and Access
- Deployment and installation procedures for SQLite
- Establishing database connectivity
- Utilization of the SQLite3 command-line interface
Data Management Operations
- Execution of primary queries and nested subqueries
- Schema creation and data ingestion
- Implementation of sorting mechanisms and data filtration
- Elimination of redundant data entries
- Specification of data types and column aliases
Operational Syntax and Control Structures
- Standard SQL operational logic
- Pattern matching using the GLOB syntax
- Result set limitation via the Limit clause
Table Management and Relationships
- Integration of Inner and Outer join strategies
- Application of Cross and Self join methodologies
- Construction and modification of table structures
- Execution of deletion and table removal protocols
- Enforcement of SQLite integrity constraints
Statistical Analysis and Aggregation
- Application of core aggregation functions (AVG, COUNT, MAX, MIN, and SUM)
- Grouping logic using the Group by statement
- Filtering aggregated results with the Having clause
- Illustrative examples of aggregate computations
Diagnostic and Resolution Protocols
Concluding Summary and Recommended Actions
Requirements
- Familiarity with basic SQL syntax and logic
Intended Audience
- Software Developers
