SQLite Database Training in Vadodara - Arth Training Institute

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

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

• 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

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

• 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

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.