SQL Database 101: Basics of SQLite3, Python and Flask App

SQL database for beginners, with transferable skills to other types of databases.

Learn the pillars of database usage and design, the SQLlite3. We will understand the basics or SQL queries to designing a database and adding data to this database. And, finally displaying the SQL database using a Web application using Flask and HTML

This class is designed for people with little to no experience: If you don’t know SQL, and never used SQL or if you’ve only fetched data then this course is for you. All you need is a computer, internet and willingness to learn.

Python is one of the most popular programming languages (and this is important because if you get stuck there should be plenty of help on the internet for you). Python is found in applications everywhere, ranging from research to industry, as well as entertainment industry. Programming in general allows for you to greatly reduce workload, as well as solve problems that would be impossible to solve by hand, or create great, new, and fun applications/software.

SQL is the language that you can use to interact with one major database type (SQL databases), one that is very wide-spread in today's world. Knowing SQL will give you a nice ability and understanding of how to handle data and databases, and being able to integrate it into Python code enables you to create great, dynamic, and automatic systems that combine the power of programming and data. Python and SQL can also convert all your data sitting in CSV or numerous excel files into an organised structure which is both light to view and easy to manipulate.

This course will be using SQLite3 in Python, which allows us to execute SQL commands through python, and will allow you to create, connect, use, and manage local SQL-based databases. And finally we will utilise Flask to create a HTML web application to dislpay your SQL database.