Learn SQLite from scratch- Create SQL Queries

Learn SQLite from scratch: Create SQL Queries, available at $59.99, has an average rating of 4.55, with 22 lectures, based on 12 reviews, and has 977 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners to SQLite It is particularly useful for Beginners to SQLite.

Enroll now: Learn SQLite from scratch: Create SQL Queries

Summary

Title: Learn SQLite from scratch: Create SQL Queries

Price: $59.99

Average Rating: 4.55

Number of Lectures: 22

Number of Published Lectures: 22

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

Beginners to SQLite

Target Audiences

Beginners to SQLite

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

Course Curriculum

Chapter 1: SQLite Setup

Lecture 1: Introduction

Lecture 2: What is SQLite

Lecture 3: Install SQLite

Lecture 4: SQLite Studio

Lecture 5: Basic database concepts

Lecture 6: Restore a sample database

Lecture 7: Connecting to SQLite Database

Lecture 8: SQLite3 Utility

Lecture 9: SQLite Commands

Lecture 10: Backing an SQLite Database

Chapter 2: Query and Manipulate Data wit SQLite

Lecture 1: Using SQL SELECT Statement

Lecture 2: Query all data from columns in a table

Lecture 3: Query specific data in a column

Lecture 4: Sorting queried data

Lecture 5: Filtering data

Chapter 3: Creating Database Tables

Lecture 1: Using SQLite Constraint

Lecture 2: Create a database table: Part 1

Lecture 3: Create a database table: Part 2

Lecture 4: Insert data into database table

Lecture 5: Update data in database

Lecture 6: Delete data from a database

Lecture 7: Delete a database table

Instructors

247 Learning
An investment in knowledge pays the best interest

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 1 votes

4 stars: 3 votes

5 stars: 8 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!