English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 0h 22m | 300 MB
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, 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
1 Installing and Touring an Open Source DBMS
2 Touring the User Interface of DB Browser for SQLite
3 Keeping Track of Customers
4 Entering, Modifying, and Deleting Table Data
5 Creating a Multi-table Database
6 The SELECT Statement and the FROM Clause
7 The WHERE Clause
Resolve the captcha to access the links!