CCIT
SQLite
Learn SQLite to master a lightweight, embedded database system. Ideal for mobile and small-scale applications, SQLite offers simplicity, efficiency, and easy integration, making it essential for robust data storage solutions.
Duration | 1 months
Course Objective

Master SQLite with a comprehensive course. Learn database design, SQL queries, transactions, and advanced topics such as triggers and indexing. Develop skills to create, manage, and optimize SQLite databases for diverse applications.

Key Features
Duration : 1 months
Theory Lectures : 28
Practical Lectures : 24
Course validity : 4 Years
Theory Notes :
Certificate :
Thing You will Learn
1. Introduction
  • What is Data
  • What is Database
  • Database Management System
  • Database Server
  • Why SQL
  • SQL commands
2. SQLite Installation
  • Download SQLite Installer
  • Choose the Appropriate DLL
  • Run the Installer
  • SQLite Shell Commands
  • Exit SQLite Shell
3. Communication with MySQL-Server
  • SQLiteStudio
  • DB Browser for SQLite
  • SQLite Shell
4. Data Types
  • Numeric Types
  • String Types
  • Date and Time Types
  • Binary Data
  • Special Types
5. Operators
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Concatenation Operator
  • Assignment Operators
  • IN Operator
  • LIKE Operator
  • IS Operator
  • BETWEEN Operator
6. Tables
  • Create Table
  • Table Name
  • Columns Name
  • Columns DataType
  • Constraints
  • All Tables in Database
  • Describe table
  • Drop table
7. Inserting record
  • INSERT statement
  • List the columns
  • Insert values
  • Inserting Single Row
  • Inserting Multiple Rows
  • Inserting with Subquery
  • Inserting with DEFAULT Values
  • Inserting with Expressions
8. Updating and Deleting record
  • UPDATE statement
  • Set column values
  • WHERE Clause
  • Updating rows
  • Multi-Table Updates
  • DELETE Statement
  • Conditional Deletion
  • Delete single record
  • Delete multiple records
9. Select Command
  • Select Statement
  • Selecting All Columns
  • Select single column
  • Select Multiple column
  • Column Aliases
  • Select Filtering Rows
  • Select Combining Conditions
  • Limiting Rows
  • Select records in Order
  • Pattern Matching
  • Filtering based on a set of values
  • Combining data from multiple tables
  • HAVING Clause
  • Subqueries
  • Aggregate Functions
10. Constraints
  • Primary Key
  • Foreign Key
  • Auto-Increment
  • Unique Constraint
  • Check Constraint
  • Not Null Constraint
  • Default Constraint
  • CASCADE Action
11. SET operations
  • UNION
  • UNION ALL
  • INTERSECT
  • EXCEPT (or MINUS)
12. Join Tables
  • Define Table Join
  • INNER JOIN
  • LEFT (OUTER) JOIN
  • RIGHT (OUTER) JOIN
  • FULL (OUTER) JOIN
  • CROSS JOIN
  • Self Join
  • Join Conditions
13. Views
  • Define Views
  • Create Views
  • Querying a View
  • Updateable Views
  • Joins in Views
  • Removing a View
14. ALTER Table
  • ALTER Command
  • Add Column
  • Drop Column
  • Modify Column
  • Rename Table
  • Rename Column
  • Change Column Position
  • Add or Remove Constraints
  • Multiple Alterations
  • Default Values
  • Auto-Increment
  • Data Type Conversion
15. Index
  • Create Index
  • Primary Index
  • Unique Index
  • Composite Index
  • Full-Text Index
  • DROP Index
16. Stored Function
  • Define Stored Function
  • create Function
  • Function Parameters
  • Function Return Type
  • Function Body
  • Calling the Function
  • Variables (DECLARE)
  • Flow Control
  • Drop Function
17. Trigger
  • Define Trigger
  • Creating Trigger
  • Trigger Naming Conventions
  • Accessing Old and New Values
  • Conditionals in Triggers
  • Rollback in Triggers
  • Disabling and Dropping Triggers
18. Transaction
  • Transaction Definition
  • Transaction Properties (ACID)
  • Transaction Control Commands
  • Savepoints
  • Auto-Commit Mode
  • Transaction Locks
  • Rollback and Commit Conditions
19. Normalization
  • Normalization Definition
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce-Codd Normal Form (BCNF)
  • Fourth Normal Form (4NF)
CCIT Notes

The CCIT Notebook on SQLite3 provides a concise guide to mastering SQLite database operations. Learn essential topics such as table creation, data manipulation, transactions, and integration with applications for effective data management.

  • Theory Notes
  • Course Book
  • PPT Notes
Certificate

Elevate your career prospects with CCIT's SQLite Certificate, recognized by leading companies. As an ISO-certified institution, our certificate features QR code verification, ensuring authenticity and opening doors to top-tier opportunities in the industry.