SqLite Tutorials
Sqlite Tutorials

SqLite Tutorials

SQLite is considered a de facto industry standard for lightweight, embedded SQL database programming. This SQLite 3 tutorial addresses all of SQLite’s major features. In this Tutorial you will learn how to read and write complex queries to a database using one of the most in demand skills. You can enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.

Some of the important point's, why you should learn SQLite are listed below:

  • Many well known applications and Internet browsers use SQLite due to its very small size (~250 Kb).  Also it is not an external program, and is instead bundled with the application using it. 
  • Google Chrome / Firefox’s Caching / Skype 
  • Most mobile platforms including IOS, Android, Blackberry 
  • Especially for Audio/Video files, SMS/MMS storage, Contacts, and Calendar Events 
  • Even Mac OS X 10.4 onward on Desktops/Laptops

Start Sqlite Tutorials

SqLite Tutorial

  SqLite - HOME   SqLite - Intro   SqLite - Installation   SqLite - Syntax   SqLite - Data Types   SqLite - Create DB   SqLite - Create Table   SqLite - Select   SqLite - Distinct   SqLite - Where   SqLite - And & Or   SqLite - Order By   SqLite - Insert Into   SqLite - Update   SqLite - Delete   SqLite - Injection   SqLite - Select Top   SqLite - Like   SqLite - Wildcards   SqLite - In   SqLite - Between   SqLite - Aliases   SqLite - Joins   SqLite - Inner Join   SqLite - Left Join   SqLite - Right Join   SqLite - Full Join   SqLite - Union   SqLite - Select Into   SqLite - Insert Into Select   SqLite - Constraints   SqLite - Not Null   SqLite - Unique   SqLite - Primary Key   SqLite - Foreign Key   SqLite - Check   SqLite - Default   SqLite - Create Index   SqLite - Drop   SqLite - Alter   SqLite - Auto Increment   SqLite - Views   SqLite - Dates   SqLite - Null Values   SqLite - Null Functions   SqLite - Data Types   SqLite - DB Data Types

SqLite Functions

  SqLite - Functions   SqLite - Avg()   SqLite - Count()   SqLite - First()   SqLite - Last()   SqLite - Max()   SqLite - Min()   SqLite - Sum()   SqLite - Group By   SqLite - Having   SqLite - Ucase()   SqLite - Lcase()   SqLite - Mid()   SqLite - Len()   SqLite - Round()   SqLite - Now()   SqLite - Format()