Introduction to SQLite Case Study

In this segment, Favio will discuss how you can install and work with the SQLite browser. But before that, the segment will help you understand why we decided to use SQLite in the first place. 

In the forthcoming video, Favio will introduce you to SQLite and explain how it is different from MySQL. 

In the next segment, you will learn how to execute queries directly on Python.

Let us recall what you learned in the video:

• One of the key reasons for using SQLite is that it comes readily installed with Python and is generally the go-to library when we want to run SQL queries directly on Python. 
• SQLite is lightweight and small. Installing the SQLite browser on your system will take only a few kilobytes.
• Except from the data types, the code used to run in SQLite and MySQL is the same.
• You can integrate Python and Tableau directly using existing SQLite libraries on Python.

In the video, you also saw the differences between MySQL and SQLite, as summarized in this image.

Finally, you also learned why it is important for one to know how to use SQL on Python:

• Python can work as a single interface for running simple queries and complicated calculations at the same time.
• You can create a single workflow to create databases, run queries, and use Python functions and libraries that are common to data analytics.
• Most big data libraries (e.g., Apache Spark) run SQL code through Python because it is the only way to parallelize and distribute code in a cluster.
• Most employees and companies require using SQL on Python because it is far easier to maintain and version SQL code when it is embedded in Python.

Now that you have learned how to use SQLite, in the next video, you will learn how to install the SQLite browser on your machine.

So, in the video, you learned how to install SQLite on your machine.

In the next video, Favio will run some basic queries to get you familiarized with the SQLite interface. Let us go ahead and watch the video.

So, as you saw in the video, the interface of SQLite is very similar to the MySQL interface.