Sqlite Fundamentals - Comprehensive Sql Course On Sqlite

A comprehensive course on SQLite Fundamentals and SQL

What you'll learn
Learn to write SQL queries in SQLite database
Hands on experience of all the major concepts.
Answer variety of database problems through SQL
At the end of this course, You will be able to use SQL statements in any database management system.
Requirements
No Experience of SQL and database are required
All you need a Computer machine; windows, Mac, and Linux users are all welcome
Tools:SQLite Studio/ SQLite Db Browser
Description
Unlike MySQL, Oracle, PostgreSQL, or SQL Server SQLite database is a server less database that serves the different purpose altogether. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.Use of SQLite:SQLite database requires no administration so it is best suited for embedded devices and the internet of things.Why to Learn SQL:SQL aka Structured Query Language is the most popular database language so it's use is everywhere whether we talk about Database,Data warehousing,Data Science or BI.Many big companies like Deloitte,Amazon,Netflix etc using this language to retrieve data from database.Important thing needs to understand that,the basic syntax of SQL for all databases is the same, so, if you have mastered SQL on SQLite database , the use of SQL on other databases would not be a problem for you.SQLite Major Topics:Introduction to SQLite DatabaseOperators in SQLAggregate Functions in SQLJoins in SQLSub-query in SQLAnalytical functionsTriggers in SQLAdvanced topics(Case statement,Views,Index,etc)Another aspect of this course is that not only I am going through all the concepts but also give the practical demonstration by writing SQL queries.The pace of this course is very slow,means,I will emphasize ample time on the subject and will try to cover everything that I can.After this Course:Once your are done with the course,you will have maximum knowledge of SQL and you will be ready to apply all these concepts.Cheers..!!Have a Great Learning..!!!

Overview

Section 1: SQLite: Getting Started

Lecture 1 Database Overview

Lecture 2 What is SQLite Database?

Lecture 3 SQLite Installation

Lecture 4 Introduction to SQlite Studio

Lecture 5 Introduction to DB Browser SQLite

Lecture 6 Primary Key and Foreign Key Database

Lecture 7 SQLite Constraints

Section 2: SQLite: DDL,DML and Set Operators

Lecture 8 Create,Insert and Select in SQL

Lecture 9 Delete and Drop Command

Lecture 10 Alter Command in SQL

Lecture 11 Update command in SQL

Lecture 12 Union and Union All

Section 3: SQLite: String Manipulation

Lecture 13 Substring Function in SQL

Lecture 14 INSTR Function in SQL

Lecture 15 CONCAT Function,UPPER and LOWER Functions

Lecture 16 TRIM, LTRIM and RTRIM

Lecture 17 Replace Function in SQL

Section 4: SQLite: Operators in SQL

Lecture 18 Brief Overview of Operators

Lecture 19 AND Operator

Lecture 20 OR Operator

Lecture 21 IN Operator

Lecture 22 Between Operator

Lecture 23 Like Operator

Lecture 24 GLOB Operator

Lecture 25 Limit Clause

Section 5: SQLite: Aggregate Functions in SQL

Lecture 26 Overview of Aggregate Functions

Lecture 27 Group by Statement Explanation

Lecture 28 Having Clause

Lecture 29 Examples of Aggregate Functions

Section 6: SQLite: Joins in SQL

Lecture 30 Inner Join

Lecture 31 Examples of Inner Join Part:01

Lecture 32 Examples of Inner Join Part:02

Lecture 33 Left Outer,Right Outer and Full Outer Join

Lecture 34 Examples of Outer Joins

Lecture 35 Self Join

Lecture 36 Cartesian Product

Section 7: SQLite: SubQuery in SQL

Lecture 37 Subquery with SELECT statement

Lecture 38 Subquery Example Part-02

Lecture 39 Subquery with INSERT, UPDATE, and DELETE

Lecture 40 Correlated Subquery

Section 8: SQLite: Analytical Functions in SQL

Lecture 41 Row Number

Lecture 42 Rank and Dense Rank Functions

Lecture 43 Partition By Clause with Rank and Dense Rank Functions

Lecture 44 Rank and Dense Rank Example

Lecture 45 Cumulative Sum,Moving Average and Moving Count

Lecture 46 Examples Cumulative Sum,Moving Average and Moving Count

Section 9: SQLite: Triggers in SQL

Lecture 47 Overview of Triggers

Lecture 48 After and Before Insert Trigger Part-01

Lecture 49 Before Insert Trigger Part-02

Lecture 50 Update Trigger

Lecture 51 Delete Trigger

Section 10: SQLite: Advanced Concepts

Lecture 52 Case statement

Lecture 53 Coalesce Function

Lecture 54 Views in SQL

Lecture 55 NullIf() Function

Lecture 56 SQLite Indexes Part-01

Lecture 57 SQLite Indexes Part-02

Students/Professionals curious about learning SQL in SQLite Database,Professionals who wants to learn SQL for further enhancement of their knowledge and skill sets.