Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

SQLite Advanced Course

Master advanced SQLite techniques and optimize your database for high-performance applications. This course is designed for experienced learners who want to specialize in complex database architecture, deep optimization, and advanced querying practices.

5.0 Rating Advanced Level 12 Weeks

About this Course

In this advanced SQLite course, you will learn the most powerful techniques for optimizing complex databases, including advanced indexing strategies, complex joins, triggers, and stored procedures. The course focuses on performance tuning and ensuring data integrity in high-demand environments.

Course Objective

To develop expertise in advanced SQLite features such as full-text search, custom functions, and complex triggers. Learners will also focus on the performance optimization of large datasets and real-time data processing, culminating in a project that involves implementing all the learned techniques.

Skills you'll gain

Full-Text Search (FTS) Custom Functions and Stored Procedures Advanced Indexing and Query Optimization Triggers and Event-Driven Architecture Data Security and Encryption in SQLite

Syllabus

  • Introduction to SQLite and Use Cases
  • Setting Up SQLite Environment
  • Basic CRUD Operations: SELECT, INSERT, UPDATE, DELETE
  • Data Types in SQLite
  • SQLite Data Constraints
Practice Task: Create a table and practice basic CRUD operations.

  • Advanced SELECT Statements and Filtering
  • Sorting and Limiting Results
  • Working with Aggregate Functions (COUNT, AVG, SUM)
  • Grouping Data with GROUP BY and HAVING
  • Aliases and Subqueries
Practice Task: Write queries to sort and group data in various ways.

  • Introduction to Joins (INNER, LEFT, RIGHT)
  • Self Joins and Cross Joins
  • Relationships in SQLite and Foreign Keys
  • Composite Keys and Constraints
  • Managing Null Values in Joins
Practice Task: Join two tables and filter the results based on certain criteria.

Project: Develop a basic library management system with tables for Books, Members, and Borrowing Records.
  • Database Schema Design
  • Implementing CRUD Operations
  • Building Simple Queries for Borrowing/Returning Books
  • Adding Relationships between Tables
  • Testing and Reviewing Project

  • Transactions in SQLite: COMMIT and ROLLBACK
  • Managing Concurrent Transactions
  • Savepoints and Nested Transactions
  • Locking and Isolation Levels
  • Error Handling in Transactions
Practice Task: Write transactions that demonstrate data consistency using COMMIT and ROLLBACK.

  • Creating and Managing Views
  • Using Indexes for Query Optimization
  • Query Performance Analysis
  • Optimizing Database Schema
  • Tips for Efficient Query Writing
Practice Task: Create indexes on sample tables and analyze performance improvements.

  • Using Aggregate Functions (SUM, AVG, MIN, MAX)
  • Date and String Functions
  • CASE and COALESCE Expressions
  • Handling JSON Data in SQLite
  • Recursive Queries with Common Table Expressions (CTEs)
Practice Task: Use aggregate functions and CTEs to create complex queries.

Project: Develop an inventory management system to track stock levels and movement.
  • Database Schema Design
  • Managing Stock Levels
  • Integrating Transactions for Inventory Management
  • Creating Views for Inventory Reports
  • Testing and Reviewing Project

  • Understanding SQLite Error Codes
  • Exception Handling in SQLite
  • Debugging Techniques for SQLite Queries
  • Ensuring Data Integrity with Constraints
  • Best Practices for Error Logging
Practice Task: Simulate common SQLite errors and resolve them.

  • Using SQLite in Python Applications
  • Connecting SQLite with Mobile Applications (Android, iOS)
  • Integrating SQLite with Web Applications
  • Caching and Data Synchronization
  • Managing Database Files
Practice Task: Build a sample application that integrates with SQLite.

  • Using Custom Collation Sequences
  • Working with BLOB Data in SQLite
  • Creating User-Defined Functions (UDFs)
  • Using the SQLite Full-Text Search (FTS) Extension
  • Practical Use Cases for Custom Functions
Practice Task: Implement a user-defined function to process data.

Project: Develop a sales management system that manages sales, inventory, and reporting with analytics.
  • Designing the Database Schema
  • Implementing CRUD Operations for Sales and Inventory
  • Advanced Queries for Reporting
  • Integrating User-Defined Functions for Analytics
  • Testing, Debugging, and Final Review

About the Instructor

Shalini Baskaran

Founder & CEO

4.98 Instructor rating

40 Students

Shalini Baskaran, is the CEO and Curriculum Director at Savvy Axiss. With a deep background in computer science, she has designed numerous courses to build strong foundations for aspiring programmers. Known for her clear, practical teaching style, she excels at making complex topics accessible. She is passionate about empowering students with real-world skills, and she looks forward to guiding you through this foundational journey in programming.

Fee ₹ 3999

₹ 2999

ENROLL NOW

Duration

12 Weeks

Class Time

1.5 Hours

Enrolled

220 students

Language

English / Tamil

Skill Level

Advanced

Schedule

Monday to Friday

Certificate

Yes

SoftSkill Trainning

Free

Share this Course