Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

SQLite Intermediate Course

Take your SQLite skills to the next level with this intermediate course, covering advanced querying techniques, data relationships, and optimization practices. Ideal for learners with a basic understanding of SQLite who want to deepen their database management capabilities.

4.8 Rating Intermediate Level 8 Weeks

About this Course

This intermediate-level SQLite course delves into complex data querying, joins, and data integrity. You'll explore how to handle relationships between tables, leverage subqueries, and optimize query performance for real-world applications.

Course Objective

To enhance learners' database skills by focusing on relational data handling, query optimization, and advanced data manipulation techniques. The course concludes with a project demonstrating these intermediate skills.

Skills you'll gain

Relational Database Management Advanced Joins and Subqueries Transaction Control and Data Integrity Query Optimization Techniques

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

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 ₹ 2999

₹ 1999

ENROLL NOW

Duration

8 Weeks

Class Time

1.5 Hours

Enrolled

250 students

Language

English / Tamil

Skill Level

Intermediate

Schedule

Monday to Friday

Certificate

Yes

Share this Course