SQLite Fundamentals – Comprehensive SQL course on SQLite

SQLite Fundamentals – Comprehensive SQL course on SQLite, available at $54.99, has an average rating of 4.6, with 57 lectures, 1 quizzes, based on 89 reviews, and has 3611 subscribers.

You will learn about 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. This course is ideal for individuals who are Students/Professionals curious about learning SQL in SQLite Database or Professionals who wants to learn SQL for further enhancement of their knowledge and skill sets. It is particularly useful for Students/Professionals curious about learning SQL in SQLite Database or Professionals who wants to learn SQL for further enhancement of their knowledge and skill sets.

Enroll now: SQLite Fundamentals – Comprehensive SQL course on SQLite

Summary

Title: SQLite Fundamentals – Comprehensive SQL course on SQLite

Price: $54.99

Average Rating: 4.6

Number of Lectures: 57

Number of Quizzes: 1

Number of Published Lectures: 57

Number of Published Quizzes: 1

Number of Curriculum Items: 62

Number of Published Curriculum Objects: 62

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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

Target Audiences

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

Unlike MySQL, Oracle, PostgreSQL, or SQL Server SQLite database is a server less database that serves the different purpose altogether. SQLiteemphasizes 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 Database
Operators in SQL
Aggregate Functions in SQL
Joins in SQL
Sub-query in SQL
Analytical functions
Triggers in SQL
Advanced 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..!!!

Course Curriculum

Chapter 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

Chapter 2: SQLite: DDL,DML and Set Operators

Lecture 1: Create,Insert and Select in SQL

Lecture 2: Delete and Drop Command

Lecture 3: Alter Command in SQL

Lecture 4: Update command in SQL

Lecture 5: Union and Union All

Chapter 3: SQLite: String Manipulation

Lecture 1: Substring Function in SQL

Lecture 2: INSTR Function in SQL

Lecture 3: CONCAT Function,UPPER and LOWER Functions

Lecture 4: TRIM, LTRIM and RTRIM

Lecture 5: Replace Function in SQL

Chapter 4: SQLite: Operators in SQL

Lecture 1: Brief Overview of Operators

Lecture 2: AND Operator

Lecture 3: OR Operator

Lecture 4: IN Operator

Lecture 5: Between Operator

Lecture 6: Like Operator

Lecture 7: GLOB Operator

Lecture 8: Limit Clause

Chapter 5: SQLite: Aggregate Functions in SQL

Lecture 1: Overview of Aggregate Functions

Lecture 2: Group by Statement Explanation

Lecture 3: Having Clause

Lecture 4: Examples of Aggregate Functions

Chapter 6: SQLite: Joins in SQL

Lecture 1: Inner Join

Lecture 2: Examples of Inner Join Part:01

Lecture 3: Examples of Inner Join Part:02

Lecture 4: Left Outer,Right Outer and Full Outer Join

Lecture 5: Examples of Outer Joins

Lecture 6: Self Join

Lecture 7: Cartesian Product

Chapter 7: SQLite: SubQuery in SQL

Lecture 1: Subquery with SELECT statement

Lecture 2: Subquery Example Part-02

Lecture 3: Subquery with INSERT, UPDATE, and DELETE

Lecture 4: Correlated Subquery

Chapter 8: SQLite: Analytical Functions in SQL

Lecture 1: Row Number

Lecture 2: Rank and Dense Rank Functions

Lecture 3: Partition By Clause with Rank and Dense Rank Functions

Lecture 4: Rank and Dense Rank Example

Lecture 5: Cumulative Sum,Moving Average and Moving Count

Lecture 6: Examples Cumulative Sum,Moving Average and Moving Count

Chapter 9: SQLite: Triggers in SQL

Lecture 1: Overview of Triggers

Lecture 2: After and Before Insert Trigger Part-01

Lecture 3: Before Insert Trigger Part-02

Lecture 4: Update Trigger

Lecture 5: Delete Trigger

Chapter 10: SQLite: Advanced Concepts

Lecture 1: Case statement

Lecture 2: Coalesce Function

Lecture 3: Views in SQL

Lecture 4: NullIf() Function

Lecture 5: SQLite Indexes Part-01

Lecture 6: SQLite Indexes Part-02

Instructors

Saad Qureshi
Computer Scientist || Freelancer || Programmer

Rating Distribution

1 stars: 6 votes
2 stars: 1 votes
3 stars: 17 votes
4 stars: 31 votes
5 stars: 34 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu