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.
Screenshots

#