SQLite Course


SQLite Course Overview

SQLite is a self-contained, server less, zero-configuration, transactional SQL database engine, relational database management system (RDBMS). It’s widely used in Android and iOS applications. According to the Encyclopedia Britannica there are three types of database models; hierarchical model, network model and the relational model.

This course the ideal asset to learn SQLite. We will breakdown the database from begin to finish to help you not just realize what it is and how it functions, however rather ace every one of the capacities and you have to turn into an expert.

We will give you a detailed introduction and will help you progress from installing the system to learning the different important commands that are required to work with the database. You will also learn about constraints, joins and subqueries with detailed examples. At the end of this course, you will not only be familiar with SQLite but also how you can install it, work complex commands, generate a report and even manipulate data and tables.

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.

Anyone who want to learn SQL, Relational Databases and SQLite. Students Individuals moving into a database stream as administrator.

Basic knowledge of Web Programming will be helpful for the students like executing the commands. Also understanding the database terminology.

More than 5000 products maintained by SQLite, there are many companies still supporting and working on SQLite technology. In India majority of companies like Infosys, Capgemini, TCS, IGATE, Wipro hire people as administrator, developer and analyst.

The main topics covered Introduction and Installation of SQLite, SQLite Commands Databases and Clauses, SQLite Constraints Joins and Subqueries, SQLite Functions, SQLite Miscellaneous Functions.

SQLite Course Syllabus

Introduction to SQLite

  • Simple query
  • Sorting rows
  • Filtering data
  • Joining tables
  • Grouping data
  • Set operators
  • Subquery

More querying techniques

  • Changing data
  • Transactions
  • Data definition
  • Views
  • Indexes
  • Triggers
  • Full-text search

SQLite tools

SQLite Functions

  • SQLite Aggregate Functions
  • SQLite Date Functions
  • SQLite String Functions
  • SQLite Window Functions