Introduction to SQLite

Focused View

Brian Jepson

1:16:23

218 View

01 - Introduction

01 - Embedding SQL everywhere with SQLite.mp4

01 - Embedding SQL everywhere with SQLite 1.mp4

00:57

02 - SQLite vs. other SQL engines.mp4

01:51

03 - How to use the exercise files.mp4

01:01

02 - 1. SQLite Quick Start

04 - Starting SQLite.mp4

04:16

05 - The SQLite command-line interface.mp4

03:21

06 - DB Browser for SQLite.mp4

04:29

07 - Retrieving data with SELECT.mp4

03:41

08 - Filtering your SELECT with the WHERE clause.mp4

02:26

09 - Grouping your results.mp4

02:50

03 - 2. Creating and Modifying Data

10 - Creating a table with the CREATE TABLE statement.mp4

02:26

11 - Setting rules on your data.mp4

02:50

12 - Enforcing relationships between tables.mp4

07:11

13 - Adding data to a table.mp4

02:46

14 - Modifying an existing table.mp4

05:27

15 - Deleting data.mp4

01:07

04 - 3. Going Further with SELECT

16 - Combining multiple tables with JOINs.mp4

05:11

17 - Basic functions.mp4

02:43

18 - Aggregate functions.mp4

02:24

19 - Window functions.mp4

02:03

20 - Queries of queries.mp4

02:13

21 - Transactions and isolation.mp4

05:17

05 - 4. Embedding SQLite

22 - Web browsers.mp4

04:28

23 - Programming languages.mp4

02:00

24 - Internet of Things.mp4

02:57

06 - Conclusion

25 - Next steps.mp4

00:28

Description

As a developer, you will encounter the SQLite database engine in a lot of places: as a storage engine for web browsers, in IoT, on mobile phones, for configuration and log storage, and many more use cases. In this course, programmer and data analyst Brian Jepson gives you all the information you need to get started using SQLite. Learn about SQLite setup and the command-line interface. Check out DB Browser and learn to use the SELECT statement. Explore ways to create, add, modify, and delete data, then deep dive into more uses of SELECT and other functions. Find out how to work with SQLite databases from a web application, pair it with programming languages, and embed it in phones and IoT devices. Get started with this very versatile engine!

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQLite

Brian Jepson

Instructor's Courses

I'm the Publishing Director for Raspberry Pi, where I manage our book and magazine publishing programs. I'm also the author or co-author of several technical books, including the Arduino Cookbook from O'Reilly Media. Outside of work, I collaborate with like-minded artists, technologists, and non-profits in Rhode Island to create experiences that get people excited about STEM/STEAM careers and hobbies. These experiences involve fun combinations of CAD, CNC, 3D printing, Arduino, Raspberry Pi, retro computers, and a host of boards, electronic components, modules, and materials.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.