Always be learning. Invest in you.
Personalized learning experiences, courses taught by real-world professionals.
Start my 1-month free trial

SQLite import with DB Browser for SQLite

From the course: Database Clinic: SQLite

Unlock the full course today

Join today to access over 15,000 courses taught by industry experts or purchase this course individually.

Start my 1-month free trial
  • Course details

    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.

    Instructor

    • Mark Niemann-Ross

      Mark Niemann-Ross

      Science fiction author and educator at LinkedIn learning
      View on LinkedIn

      Mark Niemann-Ross is a technologist with experience in hardware, software, and science fiction.

      Mark has been helping developers navigate APIs for almost 30 years, and has been responsible for third-party programs at Quark and Adobe. In addition to hands-on technology, he's also been involved in technology education, starting with a degree in industrial education and most recently working as a content manager for LinkedIn Learning.

      Mark's science fiction has most recently appeared in Analog Science Fiction and Fact. He's currently working on a murder mystery solved by a refrigerator.

      View all courses by Mark Niemann-Ross

    Skills covered in this course

  • Welcome

    - [Male Instructor] My next attempt is to use DB Browser for SQLite, with the SQLite library. This worked better than using a web browser but I was still unable to select the format of the fields before import. All fields were imported as text files. This may be acceptable for your needs so I'm going to show how it works. In the next video, I'll show how to import the CSV file, plus select the field formats. DB Browser is an open-source SQLite browser, written in C++ and available on GitHub. The official download page is at sqlitebrowser.org. There are installable versions for Macintosh, for Windows, for Portable Applications, and for Linux. As well as the original source code. Once you've installed DB Browser for SQLite, importing a dataset is incredibly easy. First, create a new database. I can either use the icon in the upper left-hand corner, or I can go under the File menu and select New Database. It asks me what I would like to name this database, and in this case, I'll call it…

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
    Download the exercise files for this course. Get started with a free trial today.
  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Download on the App Store
    Get it on Google Play
    Watch this course anytime, anywhere. Get started with a free trial today.

Course Contents