->
Lynda - Database Clinic: SQLite - 588032
Lynda - Database Clinic: SQLite
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.


Table of Contents

  • Introduction
  • 1. SQLite in Five Minutes
  • 2. Create a Database
  • 3. Join Two Datasets
  • 4. Search a Database
  • 5. Create, Read, Update, and Delete Operations
  • 6. Averages and Calculations
  • Conclusion
  • Lynda - Database Clinic: SQLite


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss