SQLite for beginners

Practical Hands -on Introduction to SQLite

4.44 (267 reviews)
Udemy
platform
English
language
Databases
category
SQLite for beginners
4,230
students
4 hours
content
Feb 2022
last update
$59.99
regular price

What you will 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

Description

This course gives you a brief overview of SQLite and the SQLite’s distinctive features that make SQLite  one of the  most widely deployed SQL database engine.

SQLite is a software library that provides a relational database management system. The lite in SQLite means light weight in terms of setup, database administration, and required resource.  SQLite does NOT require a server to run.

Because of the serverless architecture, you don’t need to “install” SQLite before using it. There is no server process that needs to be configured, started, and stopped. SQLite uses dynamic types for tables. It means you can store any value in any column, regardless of the data type.

SQLite is self-contained means it requires minimal support from the operating system or external library. This makes SQLite usable in any environments especially in embedded devices like iPhones, Android phones, game consoles, handheld media players, etc.

SQLite is capable of creating in-memory databases which are very fast to work with.

SQLite database is integrated with the application that accesses the database. The applications interact with the SQLite database read and write directly from the database files stored on disk.


What You will learn includes:


  • Database Concepts

  • Download and Install SQLite

  • What is SQLite Studio

  • Attaching Sample Database to SQLite

  • How to connect to SQLite Database

  • Some Basic SQLite Commands

  • Some commonly used sqlite3 commands

  • SQLite Dump command

  • What is sqlite3 tool

  • SQLite SELECT statement

  • Querying data from all columns in a table

  • Querying data from specific columns in a table

  • Sorting data using ORDER BY clause

  • Removing duplicate records using DISTINCT clause

  • Filtering data with WHERE clause

  • Identifying NULL values

  • SQLite Data Types

  • SQLite Constraints

  • SQLite Create Table Statement

  • SQLite INSERT INTO  Table Statement

  • SQLite UPDATE Statement

  • SQLite DELETE Statement

  • SQLite DROP Table Statement

  • SQLite BETWEEN Operator

  • SQLite IN Operator

  • SQLite LIMIT clause

  • SQLite LIKE operator

  • SQLite GLOB Operator

  • SQLite Subquery

  • Building a subquery in a WHERE clause

  • Building a subquery in a WHERE clause using IN operator

  • Building a subquery in FROM clause

  • SQLITE Table Joins

  • SQLite LEFT Join

  • SQLite INNER Join

  • SQLite CROSS Join

  • SQLite SELF Join

  • SQLite ALiases

  • SQLite Aggregate Functions

  • Introduction to SQLite Aggregate Functions

  • SQLite AVG Function

  • SQLite COUNT Function

  • SQLIte SUM Function

  • SQLite MAX Function

  • SQLite MIN Function

  • SQLite GROUP_ CONCAT Function

  • SQLite GROUP BY Clause

  • SQLite HAVING Clause


























Content

Getting Started

Introduction
What is SQLite ?
Download and Install SQLite
What is SQLite Studio ?
Attaching Sample Database to SQLite
How to connect to SQLite Database
Database Concepts

Some Basic SQLite3 Commands

What is sqlite3 tool
Some commonly used sqlite3 commands
SQLite Dump command

Retrieving Data and Manipulating Data

SQLite SELECT statement
Querying data from all columns in a table
Querying data from specific columns in a table
Sorting data using ORDER BY clause
Removing duplicate records using DISTINCT clause
Filtering data with WHERE clause
Identifying NULL values
SQLite Data Types
SQLite ALiases

Creating Database Tables | Updating Data | Deleting Records

SQLite Constraints
SQLite Create Table Statement - Part 1
SQLite Create Table Statement - Part 2
SQLite INSERT INTO Table Statement
SQLite UPDATE Statement
SQLite DELETE Statement
SQLite DROP Table Statement

Some SQLite Operators

SQLite BETWEEN Operator
SQLite IN Operator
SQLite LIKE operator
SQLite GLOB Operator
SQLite LIMIT clause

SQLite Subquery

What is a subquery
Building a subquery in a WHERE clause using IN operator
Building a subquery in a WHERE clause using IN operator
Building a subquery in FROM clause

SQLITE Table Joins

SQLite LEFT Join
SQLite INNER Join
SQLite CROSS Join
SQLite SELF Join

SQLite Aggregate Functions

Introduction to SQLite Aggregate Functions
SQLite AVG Function
SQLite COUNT Function
SQLIte SUM Function
SQLite MAX Function
SQLite MIN Function
SQLite GROUP CONCAT Function
SQLite GROUP BY Clause
SQLite HAVING Clause

Reviews

Eduardo
July 10, 2023
Well rounded introduction course to SQLite and its basic functionality. Will be great to have a second course with advanced material and complex queries
John
June 28, 2023
The first 4 sections were very rudimentary, ie: how specifically, step by step, to download and install the program, and how to run it through the command prompt. Once the focus shifted to using the program itself, the course improved.
Bladimir
April 22, 2023
really like the slow pace speaking and easy to understand slides. Following along is much better than most youtube videos i have seen.
Tim
March 16, 2023
Clear pronunciation, well structured content, steps are described and shown, sometimes a bit slow, but can be sped up.
Yoong
March 9, 2023
The course covers essential skills to query sqlite databases precisely and clearly. It also covers creation of databases and tables.
Max
February 27, 2023
I was expected some additional info, a project or more complex connection of the functionalities. The teacher simply goes through the different features of SQLite one by one, showcasing them in a very small example. The beginning and ending of the very short videos repeat themselves in every video, which makes you fell like being stuck in a loop.
Anton
July 18, 2022
The instructor gave me everything I need to implement Sqlite into a CRUD application I'm building in Python. The instructor's voice was very pleasant. He was easy to understand. The instructor supplied good visuals with code for each concept presented.
Dieter
May 16, 2022
Bis jetzt ganz gut, toll sind die kleinen Einheiten die Zeit zum Überdenken, schreiben etc. lassen...
Robert
May 2, 2022
The instructor has all the delivery qualities I look for when I am learning a new software program. He is articulate, detailed, and understands this is a course for beginners. Thus he is deliberate in his delivery, which I GREATLY appreciate. The problem with most online course videos is that the instructor moves too fast, even in beginner courses. At least that is an issue for me, perhaps not others. I am thoroughly enjoying this instructor's pace and understanding of his audience.
Kataski
April 21, 2022
The instructor is detailed and the examples are worth a thousand-words. I like this instructor thus far.
Jerry
February 20, 2022
Finding his delivery very slow. I know it for beginners but I'm going to nod off if it doesn't speed up a bit. Haven't changed my mind yet and I have an issue with videos 22 & 23 section 4. On V22 he failed to address the commands after Both Foreignkey commands like they didn't exist and in 23 I believe he made an mistake.
Fionn
April 6, 2021
This is a great course for beginners. I really do appreciate the various options available for using SQLite and the measured delivery of the material.
Ronald
January 12, 2021
The tutorials are great but there needs to be a hands-on portion to create familiarization on the commands. The information is very straight forward but I don't feel like there's lab time or testing comprehension.
Ananda
March 16, 2020
Achei o curso muito bom, mas poderia ter algumas listas de exercícios para fazermos e ver ser está correto ou não.
Stephen
March 6, 2020
The early sessions feature a Power Point presentation ... but later sessions feature the QSLite Studio software and more helpful keyboard interaction. The subject is divided into small units which aides both initial learning but also future review. Overall, a good introductory course but don't expect the instructor to answer your questions.

Charts

Price

SQLite for beginners - Price chart

Rating

SQLite for beginners - Ratings chart

Enrollment distribution

SQLite for beginners - Distribution chart

Related Topics

2096842
udemy ID
12/20/2018
course created date
11/20/2019
course indexed date
Bot
course submited by