Description

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. This tutorial will give you a quick start with SQLite and make you comfortable with SQLite programming.

This tutorial has been prepared for beginners to help them understand the basic-to-advanced concepts related to SQLite Database Engine.

Before you start practicing various types of examples given in this reference, we assume that you are already aware about what is a database, especially RDBMS and what is a computer programming language.

What you'll learn

Become a UX designer.

You will be able to add UX designer to your CV

Become a UI designer.

Build & test a full website design.

Create your first UX brief & persona.

How to use premade UI kits.

Create quick wireframes.

Downloadable exercise files

Build a UX project from beginning to end.

Learn to design websites & mobile phone apps.

All the techniques used by UX professionals

You will be able to talk correctly with other UX design.

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

SQLite Tutorial
SQLite Overview
SQLite Installation
SQLite Commands
SQLite Syntax
SQLite Data Type
SQLite CREATE Database
SQLite ATTACH Database
SQLite DETACH Database
SQLite CREATE Table
SQLite DROP Table
SQLite INSERT Query
SQLite SELECT Query
SQLite Operators
SQLite Expressions
SQLite WHERE Clause
SQLite UPDATE Query
SQLite DELETE Query
SQLite LIKE Clause
SQLite GLOB Clause
SQLite LIMIT Clause
SQLite ORDER BY Clause
SQLite GROUP BY Clause
SQLite HAVING Clause
SQLite DISTINCT Keyword
Advanced SQLite
SQLite PRAGMA
SQLite Constraints
SQLite JOINS
SQLite NULL Values
SQLite ALIAS Syntax
SQLite Triggers
SQLite Indexes
SQLite INDEXED BY Clause
SQLite Views
SQLite Transactions
SQLite Subqueries
SQLite AUTOINCREMENT
SQLite Injection
SQLite EXPLAIN
SQLite VACUUM
SQLite Date & Time
SQLite Useful Functions
SQLite Interfaces
SQLite C/C++
SQLite Java
SQLite PHP
SQLite Perl
SQLite Python
SQLite Quick Guide
SQLite Useful Resources

Instructor

image
W3edify Infotech

President of Sales

4.5
Instructor Rating
0 Reviews
0 Students
1188 Course

Student Feedback

0
Course Rating
70%
15%
20%
3%
2%