Released
10/13/2017
SQLite is a powerful embedded database engine that’s a core storage technology in Android and iOS applications. In this installment of the Database Clinic series—in which experts and their databases of choice are pitted against a series of the same challenges— Mark Niemann-Ross demonstrates how to leverage SQLite to solve common database problems. After providing a brief overview of the strengths and weaknesses of SQLite, Mark explains how to create a database and populate it using a public dataset. He also shows how to use a SQLite database with programming languages such as Python and R, handle subqueries and queries in SQLite, and more.
Topics include:
- Strengths and weaknesses of SQLite
- Creating a database
- Joining data sets
- Calculations with SQLite and Python
- Searching a database
- Subqueries and queries in SQLite
- CRUD operations in SQLite with R
Skill Level Intermediate
2h 10m
Duration
10,021
Views
https://www.lynda.com/SQLite-tutorials/Database-Clinic-SQLite/588032-2.html.
Direct Link => https://www.file-upload.com/2420pn5fs29c
► Mirror link:
https://www.file-upload.com/2ub48txgt5a2