SQLite Database Training in Vadodara - Arth Training Institute

SQLite Databse Training : Step By Step For Beginners to Advanced

SQLLite Databse Programming Training Overview

SQLite Database Training provides the essential knowledge and skills to effectively use SQLite for managing and querying lightweight, self-contained databases.

Prerequisites

Basic understanding of database concepts
Familiarity with SQL syntax and commands
Knowledge of a programming language (e.g., Python, C, Java) is beneficial but not required

SQLite Database Training Includes:

Introduction to SQLite
Installation and Setup
Database Creation and Management
SQL Basics
Advanced SQL Techniques
Data Types and Constraints
Database Optimization
Backup and Recovery
Integrating SQLite with Applications
Practical Projects

Key Highlights

Personal Coaching
Industry Experts with 15+ Year Experience
Morning, Noon, Evening Batch Timings
Training with Internship (Live Project Working)
Career Guidance

Course Content

Tools and Techniques:

Books
Online Courses
Documentation and Tutorials
Community Forums

Key Concepts of SQLite Database:

File-Based Database
Serverless
Zero Configuration
ACID Compliance
SQL Syntax
Data Types
Transactions
Indexes
Views and Triggers

Development Environment of SQLite:

SQLite Installation
SQLite Tools
Programming Language Integration

Learning Path of SQLite:

Basic SQL Knowledge
Setting up SQLite
Craeting and Managing Databases
Querying Data
Transactions
Advanced Features
Integration with Programming Languages

SQLite - Getting Started:

What is SQLite Database?
Introduction to DB Browser SQLite
Primary Key and Foreign Key Database
SQLite Constraints

SQLite - DDL,DML & SET Operations:

Create,Insert and Select in SQL
Delete and Drop Command
Alter Command in SQL

SQLite String Manipulation:

Substring Function in SQL
INSTR Function in SQL
CONCAT Function,UPPER and LOWER Functions
TRIM, LTRIM and RTRIM
Replace Function in SQL

SQLite - Operators in SQL:

Brief Overview of Operators
AND Operator
OR Operator
IN Operator
Between Operator
Like Operator
GLOB Operator
Limit Clause

SQLite - Aggregate Functions in SQL:

Overview of Aggregate Functions
Group by Statement Explanation
Having Clause
Examples of Aggregate Functions
Aggregate Functions Assignment

SQLite - Joins in SQL:

Inner Join
Examples of Inner Join Part:01
Examples of Inner Join Part:02
Left Outer,Right Outer and Full Outer Join
Examples of Outer Joins
Self Join
Cartesian Product
Assignments on Joins
Overview of JOINS
Introduction to JOINs
AS Statement
Full Outer Joins
Full Outer Joins
Left Outer Join
Right Joins
UNION
JOIN Challenge Tasks

SQLite - SubQuery in SQL:

Subquery with SELECT statement
Subquery Example Part-02
Subquery with INSERT, UPDATE, and DELETE
Correlated Subquery
Assignment on Subquery

SQLite - Analytical Functions in SQL:

Row Number
Rank and Dense Rank Functions
Partition By Clause with Rank and Dense Rank Functions
Rank and Dense Rank Example
Cumulative Sum,Moving Average and Moving Count
Examples Cumulative Sum,Moving Average and Moving Count

SQLite - Triggers in SQL:

Overview of Triggers
After and Before Insert Trigger Part-01
Before Insert Trigger Part-02
Update Trigger
Delete Trigger

SQLite - Advanced Concepts:

Case statement
Coalesce Function
Views in SQL
NullIf() Function
SQLite Indexes Part-01
SQLite Indexes Part-02
SQL Test
SQL Practice Test

SQL Statement Fundamentals:

Overview of Challenges!
SQL Cheat Sheet
SQL Statement Fundamentals
Challenge: SELECT
SELECT DISTINCT
Challenge: SELECT DISTINCT
COUNT
SELECT WHERE - Part One
SELECT WHERE - Part Two
Challenge: SELECT WHERE
LIMIT
Challenge: ORDER BY
BETWEEN
IN
LIKE and ILIKE
General Challenge 1

GroupBy Statements:

Introduction to GROUP BY
Aggregation Functions
GROUP BY - Challenge
HAVING
HAVING - Challenge Tasks

Advanced SQL Commands:

Overview of Advanced SQL Commands
Timestamps and Extract - Part One
Timestamps and Extract - Part Two
Quick Note on TO_CHAR
Timestamps and Extract - Challenge Tasks
Mathematical Functions and Operators
String Functions and Operators
SubQuery
Self-Join

Creating Databases and Tables:

Introduction to Section
Data Types
Primary Keys and Foreign Keys
Constraints
CREATE Table
INSERT
UPDATE
DELETE
ALTER Table
DROP Table
CHECK Constraint

Database Migration:

Add New Column
Add Employee
Get Employee Detail
Fix Checkbox State
Update & Delete Employee
Fix Material Banner.mp4
Fix Delete Error Message

Table Relation:

Address Table And Migration
40.Create Address Screen
Address Query
Address ChangeNotifier
Address ChangeNotifierProxyProvider
Insert Address Method
Provider Listener
Fix No Table Found Exception
Address Screen
Address By Employee
Delete Address and Employee

You are eligible for the following post after Training

SQLite Developer
Database Developer (SQLite)
SQLite Database Administrator
SQLite Programmer
SQLite Software Engineer
Senior SQLite Developer
Embedded Database Developer (SQLite)
SQLite Database Engineer
SQLite Data Architect
Junior SQLite Developer

Request for Free Demo Lecture

Fees Structure

Fees Structure will be depends on the what type of course you are joining, for example if you are joining for regular batch for 3 month course then fees will be 15000/- if you are joining in group then fees discount will be applicable, for weekend batch fees will be different, For Faculty Development Program and Industrial Training Fees will be different.