Learn SQLite from scratch: Create SQL Queries

Focused View

247 Learning

1:58:55

136 View

1. SQLite Setup

1. Introduction.mp4

00:20

2. What is SQLite.html

3. Install SQLite.mp4

06:40

4. SQLite Studio.mp4

05:50

5. Basic database concepts.mp4

04:31

6.1 chinook.zip

6.2 db+schema.zip

6. Restore a sample database.mp4

07:16

7. Connecting to SQLite Database.mp4

07:26

8. SQLite3 Utility.mp4

03:10

9. SQLite Commands.mp4

10:31

10. Backing an SQLite Database.mp4

08:06

2. Query and Manipulate Data wit SQLite

1. Using SQL SELECT Statement.mp4

05:37

2. Query all data from columns in a table.mp4

04:53

3. Query specific data in a column.mp4

05:17

4. Sorting queried data.mp4

08:21

5. Filtering data.mp4

06:59

3. Creating Database Tables

1. Using SQLite Constraint.mp4

04:21

2. Create a database table Part 1.mp4

06:46

3. Create a database table Part 2.mp4

07:03

4. Insert data into database table.mp4

07:43

5. Update data in database.mp4

03:47

6. Delete data from a database.mp4

02:41

7. Delete a database table.mp4

01:37

Description

Query and manipulate databases

What You'll Learn?

Setup an SQLite Database Server
Restore a sample database
Backup sample database
Query and manipulate database
Build queries
Create database tables
Insert data into database
Update data in database
Delete data in database
Filter and sort data

Who is this for?

Beginners to SQLite

More details

Description
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures.
SQLite is very carefully tested prior to every release and has a reputation for being very reliable. Most of the SQLite source code is devoted purely to testing and verification. An automated test suite runs millions and millions of test cases involving hundreds of millions of individual SQL statements and achieves 100% branch test coverage. SQLite responds gracefully to memory allocation failures and disk I/O errors.
In this course you will learnÂ how to:
Setup an SQLite Database Server
How to restore a sample database
How to query database
How to create queries
How to create database tables
How to insert data into database
How to update data in database
How to delete data in database
How to filter and sort data
Who this course is for:
Beginners to SQLite

User Reviews

Rating

average 0

Total votes0

Focused display

SQLite

247 Learning

Instructor's Courses

Hello and welcome to 247 Learning.We create online courses that will help you acquire useful and productive technical skills that can be applied to real world jobs. We have over 18,000 students on Udemy that have signed up to our courses . We are continuously adding more courses to our course catalogues. We are looking forward to welcoming you to one or more of our courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.