Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Learn SQLite For Absolute Beginners - Crash Course

Name: Learn SQLite For Absolute Beginners - Crash Course
Rating: 3.9 (55 reviews)

Learn SQLite Fundamentals - Introduction to SQLite Database Crash Course - Basic SQL Commands covered.

Created bySandeep Kumar

Last updated 8/2022

English

What you'll learn

Start your career by learning all the basic SQL statements in SQLite.
Learn different ways to select Records from Tables.
Filter the Records of the Table.
How to sort the result.
GROUP BY Clause in SQLite
Create Tables and Insert Records
Update data inside table, modify tables
Delete and Drop tables

Course content

5 sections • 29 lectures • 1h 1m total length

Introduction0:22
An important Announcement0:12
Download Sqlite2:18
Starting with SQLite2:10

Create Database and tables in SQLite3:17
Create a permanent SQLite database in a chosen folder, define a stores table with store_id, item_id, and item_name, and use dot tables to verify and list the table.
Data Types in SQLite1:15
Discover the five major SQLite data types—null, integer, real, text, and blob—and how each stores undefined values, numbers, text, and images.
Insert records into table2:38
Create a table and insert records using sqlite's insert into table name values syntax, optionally specifying fields, and understand success or error messages for each insertion.
Select Records from table0:32
Saving table, database and changing colors1:30
Save tables and databases with dot save, view them in SQL, quit with dot quit, and customize terminal colors and font.
Opening database and some common errors2:07
Filter the Records of the table4:35
Filter records in SQLite by using select star from store where store id = 1, dot header on, and combine conditions with and or, noting semicolon rules.
AND, OR continued..1:45

Grouping4:48
Sorting the records0:50
Sort records using the order by clause to arrange results by invoice amount in ascending or descending order.
Between and In2:21
Explore how to use between and in operators in SQLite to filter invoice amount between 1700 and 6500, selecting specific fields like invoice ID and handling syntax with parentheses.
Update the records1:29
learn how to update records in SQLite by using the update command, set clause, and optional where clause to target specific rows like invoice id 10 and amount 100.
Structure of the table0:28
Date Functions1:20

Primary key constraints4:12
NOT NULL constraint4:18
Show how the not null constraint prevents null values in a column, using a student table with a not null name; distinguish between no value and null.
Unique Constraint1:59
Default constraint1:37
Learn how default constraints assign automatic values in SQLite by creating tables with default values and inserting rows without explicit values, such as default 'unknown'.
Check constraint2:19
Learn how to create a table with an amount field and enforce a check constraint that the amount must be greater than 900, then insert records and observe constraint enforcement.
Alter table structure2:33
Delete and Drop3:05
Backup and Restore2:20
Various modes in SQLite2:04
Explore different output modes in the SQLite command-line interface, including csv, tab, column, and insert, and see how the default list mode formats query results.
Final Wrap-up2:17

Requirements

No knowledge of SQL required for this course
A laptop/computer with Windows 8 or Windows 10

Description

'This SQLITE Course covers SQL using SQLITE Database but you can apply these SQL queries in SQL Server, Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2'.

"Welcome to the most popular Quality crash Course on SQLite"

Different shell commands covered
Covers different forms of SELECT Statements
Explains how to filter the Records
NULL Values are explained
How to save database
ORDER BY, GROUP BY are covered
Basic Data types used in Microsoft SQL

======================================================================================

Join this course which is the best "SQLite" course. I will share all the syntax of SQL with multiple examples along the way!!!

Want to start learning SQL from scratch with no previous coding experience?

You have come to the right place. Please have a look at the Course content carefully and ask a few questions yourself?

I have shared all the codes which are used in this course
Is the Course taught by a real-time expert? I have more than 15 years of experience as an Instructor and more than 10 years of experience in SQL. I firmly believe that if an Instructor does not have good experience, he/she will flood the course with poor content.
Is the Course content clear and Precise? The content is short, crisp, and clear.
The course assumes no prior knowledge of SQLite(SQLite database) and teaches you from absolute beginners
Once you Enroll in this course, you get lifetime access to this course and you will get all the future updates.
This Course is not for DBA(Database Administration) but certainly, helps you to become better.
If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.
If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.

Do you want to start on SQL but have no experience with SQL?
If you have some prior knowledge of SQL or if you are a complete fresher, you are at the right place. The Course teaches you to SQL right from Scratch. It will be the best course for absolute beginners.

There’s no risk involved in taking this Course!
I am sure that this is the best crash course on SQL and it is the perfect starting point to learn the basics of SQL.

Are you getting updated content?

Yes, I keep updating the content always to make sure, I provide all the information to my students.

Once you enroll for this course-

1) Selecting Records from Table - SELECT statement in SQL

2) Filtering the Records - Using the WHERE clause in SQL

3) Sorting Records - Using ORDER BY clause

4) Grouping data - using GROUP BY clause

5) Creating simple basic Tables - with constraints and without constraints

6) Keys, Index - PRIMARY KEY, UNIQUE INDEX

7) Inserting records(loading) - with INSERT Statement

8) Updating the records of a Table - Using the UPDATE statement

9) Modify table properties - ALTER statement

10) Deleting records from the table - DELETE statement

11) Removing tables from the database permanently - DROP statement

Note: This course helps to learn SQL using SQLite but it will also help to master SQL if you want to learn Oracle SQL, MySql, PostgreSQL, SQLite, DB2, etc.

Who this course is for:

Absolute beginners who have never used SQL on SQLite Server
Anyone who wants to refresh the knowledge of SQL
This is a crash couCollege Students who wants to attend a technical job interview for the first time will also be an ideal choicerse and is target for quick basic learning of SQL

Learn SQLite For Absolute Beginners - Crash Course

What you'll learn

Explore related topics

Course content

Introduction and Getting Started4 lectures • 5min

Database and Tables8 lectures • 18min

Grouping, sorting, modifying and delete6 lectures • 11min

Constraints, alter, delete and drop10 lectures • 27min

Bonus Section1 lecture • 1min

Requirements

Description

Who this course is for: