Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member 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
Related Courses
Data Management
35 hours
SAP ASE for Database Administrators
28 hours
Pivotal Greenplum for Developers
21 hours
MarkLogic Server
14 hours
SQL in Microsoft Access
14 hours
Access VBA
21 hours
Access - Data Base Designing
21 hours
Access Advanced
21 hours
Microsoft Access - download the data
14 hours
Access Intermediate
14 hours
VBA For Access & Excel
21 hours
MongoDB for Administrators
14 hours
MongoDB for Developers
14 hours
MongoDB for Advanced Users
14 hours