Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 692 MB | Duration: 1h 52m

After completing this course you will get knowledge of basic concepts SQLite Studio and you can start writing code on your own.

What you'll learn

Requirements

Basic knowledge of Computers

Description

SQLite is an open source, serverless, zero-configuration, self-contained, stand alone, transaction relational database ee designed to be embedded into an application.

This course help you to start with SQLite Studio. Once you complete this tutorial, you will get basics of SQLite and SQLite Studio.

Concepts covered in this course:

Overview

Installation

CREATE Database

CREATE Table

DROP Table

INSERT data into Table

SELECT data from Table

WHERE Clause

UPDATE Statement

DELETE Statement

LIKE Clause

GLOB Clause

LIMIT Clause

ORDER BY Clause

DISTINCT Keyword

GROUP By Clause

HAVING Clause

Constraints

Working with NULL values

ALTER Statement

VACCUM

INDEX

VIEW

AUTOINCREMENT

TRIGGERS

Subqueries

BETWEEN

UNION

Aggregate Functions

Transaction

I will explain all the basic concepts using SQLite and also Same concept will be explained SQLite Studio with examples.

I will also provide document for each concept for your reference.

Who this course is for:

People who wants to learn Database concepts or SQLite.



DOWNLOAD
uploadgig