[Lynda] Database Clinic: SQLite

Author

image of author Mark Niemann-Ross Mark Niemann-Ross

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
Show More Show Less
Size: 395.58M

 

https://www.lynda.com/SQLite-tutorials/Database-Clinic-SQLite/588032-2.html.


FRIENDLY WEBSITES

 

Tutorials For Free, Guides, Articles & Community Forum.OneHack.Us | Tutorials For Free, Guides, Articles & Community Forum. A place where everyone can share knowledge with each other



RELATED POSTS

2 Comments

  1. freecoursesonline January 2, 2018 Reply
  2. Drovosek December 24, 2017 Reply

Add a Comment

Your email address will not be published. Required fields are marked *