What you’ll learn

Learn how to Download and Install SQLite

Learn how to attach a sample database to SQLite

How to connect to SQLite Database

Learn how to execute Some commonly used sqlite3 commands

How to backup entire database and tables using SQLite Dump command

Learn to fetch data from database using SQLite SELECT statement

Learn to query and fetch all data from a database table

Learn to query and fetch specific data from a database table

Learn to sort data returned from a database using ORDER BY clause

Learn to filter data returned from a database using WHERE clause

Learn how to remove duplicate records using SQLITE DISTINCT

Learn how to identify NULL values in a database table

Learn about various SQLite Data Types

Learn how SQLite Constraints works

Learn how to create new table

Learn how to add new records into a table

Learn how to Update existing records inside a database table

Learn how to Delete existing records in a database

Learn how to Drop a table

Learn how to use various SQLite operators to manipulate data

Learn how to extract data from multiple tables using table joins

Learn how to use Aliases

Learn how to use various types of Aggregate functions to perform calculations on records in a database table

Learn how to group data with GROUP BY clause

Learn how to Filter grouped data using HAVING clause

 

Are there any course requirements or prerequisites?

Basic knowledge of a computer

Basic internet navigation skills

Basic understanding of database concepts will help but not mandatory

Basic working knowledge of Standard SQL will help but not mandatory

 

Who this course is for:

Beginner SQL Developers

Beginner Data Analyst

Beginners to SQLite

Beginner DBA's ( Database Administrators)