Video description
Journey to database mastery as you learn how to create a simple database and manipulate its data. In this video, SQL expert Allen Taylor explains how to build a simple database with SQLite, an open source database engine. Part 1 introduces SQLite and explores its basic features. In Part 2 you'll create your first table and start entering some data. Part 3 explains basic queries and how to use the SELECT statement and the FROM and WHERE clauses.
After watching Creating a Database with SQLite, you will understand how to build a basic database and how to query and retrieve information from it.
What You Will Learn
- Discover the SQLite user interface features and characteristics
- Use SQLite to add or remove data in your database
- Work with multiple tables in a database
- Find the information you need in your database
Who This Video Is For
Programmers who are new to databases, as well as non-programmers who must retrieve information from databases.
Table of contents
- Installing and Touring an Open Source DBMS 00:04:51
- Installing an Open Source DBMS (SQLite)
-
Building and Maintaining a Simple Database
- Keeping Track of Customers 00:09:53
- Entering, Modifying, and Deleting Table Data 00:05:09
- Creating a Multi-table Database 00:14:41
-
Retrieving the Information You Want from a Database
- The SELECT Statement and the FROM Clause 00:03:40
- The WHERE Clause 00:05:40
Product information
- Title: Creating a Database with SQLite
- Author(s):
- Release date: September 2018
- Publisher(s): Apress
- ISBN: 9781484238998
You might also like
video
The Modern JavaScript Bootcamp (2019)
Learn JavaScript by building real-world apps. Includes 3 real-world projects, 80 programming challenges, and ES6/ES7! About …
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
video
Modern JavaScript From The Beginning
Learn and Build Projects with Pure JavaScript (No Frameworks or Libraries) About This Video Understanding of …
video
Algorithms: 24-part Lecture Series
Algorithms, Deluxe Edition, Fourth Edition These Algorithms Video Lectures cover the essential information that every serious …