Course

1. Install and set up the database software (e.g., SQL Server, MySQL, or SQLite). Explore database features and basic syntax. 
2. Practice basic datatypes and operators in SQL. Write queries using arithmetic, logical, and comparison operators. 
3. Write SQL expressions and evaluate them using SELECT statements. 
4. Create a new database and attach/detach it. Explore database management commands. 
5. Create tables with various datatypes and constraints (PRIMARY KEY, NOT NULL). 
6. Drop existing tables safely using DROP TABLE. 
7. Insert records into tables using INSERT INTO. 
8. Update existing records using UPDATE with conditions. 
9. Delete records from tables using DELETE with conditions. 
10. Write SELECT queries with WHERE clause and different conditions (>, <, =, LIKE, IN, BETWEEN). 
11. Perform JOIN operations: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN. 
12. Create and use triggers for automatic actions on table events (INSERT, UPDATE, DELETE). 
13. Work with DATE and TIME functions: CURRENT_DATE, NOW(), DATEADD, DATEDIFF, etc. 
14. Define and use keys in tables: PRIMARY KEY, FOREIGN KEY, UNIQUE, and AUTO_INCREMENT/IDENTITY. 
15. Mini project: Create a database for a small business or student management system with multiple tables, keys, triggers, and CRUD operations. 

Course Objective 

The course will help the students to understand how an embedded database engine can be used for database-related applications. 

Course Outcomes 

CO-PO mapping  

• Using SQLite by Jay A Kreibich
• The Definitive Guide to SQLite 2nd ed. Edition by Grant Allen and Mike Owens
• Android SQLite Essentials by Sunny Kumar Aditya and Vikash Kumar Karn