Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

SQLite Beginner Course

Learn the basics of SQLite, a powerful yet lightweight database solution commonly used in mobile and small-scale applications. Perfect for beginners eager to develop a foundational understanding of databases and data management with SQLite.

4.8 Rating Beginner Level 4 Weeks

About this Course

This beginner-level SQLite course introduces essential database concepts, such as creating and managing tables, inserting and retrieving data, and formulating basic queries. Learn to handle data efficiently, setting the foundation for more advanced data management skills.

Course Objective

To provide learners with the foundational knowledge of SQLite, from setting up databases to performing basic CRUD operations, culminating in a practical project that consolidates these fundamental skills.

Skills you'll gain

Database Setup and Table Creation Basic Queries and CRUD Operations Data Filtering and Sorting Simple Data Manipulation

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

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

₹ 999

ENROLL NOW

Duration

4 Weeks

Class Time

1.5 Hours

Enrolled

250 students

Language

English / Tamil

Skill Level

Beginner

Schedule

Monday to Friday

Certificate

Yes

Share this Course