SQLite

Description

 SQLite is often used as the on-disk file format for desktop applications such as version control systems, financial analysis tools, media cataloge and editing suites, CAD packages, record keeping programs and SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. It is the most used database engine in the world.It  is generally faster than SQL Server and it supports only a single writer at a time (meaning the execution of an individual transaction). It locks the entire database when it needs a lock (either read or write) but only one writer can hold a write lock at a time and database files have a maximum size of about 140 TB. lets you store data in structured manner. SQLite has higher performance. SQLite databases can also be queried and the data retrieval is much more robust. 

1. Introduction

2. Introduction to Installation of SQL

• Introduction to Database and RDBMS
• Introduction
• Installation

3. Commands Databases and Clauses

• Commands and Datatypes Part 1
• Commands and Datatypes Part 2
• Database Part 1
• Database Part 2
• Database Part 3
• Arithematic Operator
• Comparison Operator
• Logical Operator
• Bitwise Operator
• Clause

4. Constraints,Joins and Subqueries

• Constraints
• Joins
• Subqueries

5. Functions

6. Miscellaneous Functions

For more inputs on SQLite you can connect here.
Contact the L&D Specialist at Locus IT.