by Allen Taylor | Released September 2018 | ISBN: 9781484238998

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 LearnDiscover 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 ForProgrammers who are new to databases, as well as non-programmers who must retrieve information from databases. Show and hide more

1. Installing and Touring an Open Source DBMS 00:04:51
2. Installing an Open Source DBMS (SQLite)
   • Touring the User Interface of DB Browser for SQLite 00:04:07
3. 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
4. Retrieving the Information You Want from a Database
   • The SELECT Statement and the FROM Clause 00:03:40
   • The WHERE Clause 00:05:40
Show and hide more