
Lynda – Database Clinic – SQLite
English | Size: 395.62 MB
Category: Tutorial
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
DOWNLOAD:
http://nitroflare.com/view/9F4734B4D0CCB75/Lynda_-_Database_Clinic_-_SQLite.rar
If any links die or problem unrar, send request to http://goo.gl/aUHSZc
Leave a Reply