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
Introduction
- Overview of SQLite features and architecture
- Foundations of SQL
Getting Started
- Installation of SQLite
- Establishing database connections
- Utilizing the SQLite3 command-line tool
SQLite Data Manipulation
- Working with queries and subqueries
- Creating records and inserting data
- Sorting and filtering results
- Handling duplicate data
- Exploring data types and aliases
SQLite Operators
- Essential SQL operators
- The GLOB operator
- Using the LIMIT clause
SQLite Database Tables
- Inner and outer joins
- Cross and self joins
- Creating and updating table structures
- Deleting and dropping tables
- Applying SQLite constraints
SQLite Aggregate Functions
- Core functions (AVG, COUNT, MAX, MIN, and SUM)
- The GROUP BY statement
- The HAVING clause
- Practical aggregate function examples
Troubleshooting
Summary and Next Steps
Requirements
- Fundamental knowledge of SQL
Target Audience
- Software Developers
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2900 € + VAT*
Contact us for an exact quote and to hear our latest promotions