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

SQL Database 101: Basics of SQLite3, Python and Flask App, available at $19.99, has an average rating of 4.25, with 21 lectures, based on 2 reviews, and has 16 subscribers.

You will learn about SQL Python SQLite3 Python to create SQL database Flask App integration with SQL database Have a detailed knowledge and understanding of SQL database, one of the most widely used databases Convert CSV/Excel files to SQL database Knowledge of all the essential SQL commands In-depth knowledge of creating database This course is ideal for individuals who are Professionals beginning their journey in SQL or database generation or Experienced data scientists or Anyone curious to master SQL from beginner to Advanced in short span of time or Anyone who wants to learn how to use SQL and SQLite3 or Anyone who had enough of multiple excel or csv files and wants a organized database It is particularly useful for Professionals beginning their journey in SQL or database generation or Experienced data scientists or Anyone curious to master SQL from beginner to Advanced in short span of time or Anyone who wants to learn how to use SQL and SQLite3 or Anyone who had enough of multiple excel or csv files and wants a organized database.

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

Summary

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

Price: $19.99

Average Rating: 4.25

Number of Lectures: 21

Number of Published Lectures: 21

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 21

Original Price: £19.99

Quality Status: approved

Status: Live

What You Will Learn

SQL
Python
SQLite3
Python to create SQL database
Flask App integration with SQL database
Have a detailed knowledge and understanding of SQL database, one of the most widely used databases
Convert CSV/Excel files to SQL database
Knowledge of all the essential SQL commands
In-depth knowledge of creating database

Who Should Attend

Professionals beginning their journey in SQL or database generation
Experienced data scientists
Anyone curious to master SQL from beginner to Advanced in short span of time
Anyone who wants to learn how to use SQL and SQLite3
Anyone who had enough of multiple excel or csv files and wants a organized database

Target Audiences

Professionals beginning their journey in SQL or database generation
Experienced data scientists
Anyone curious to master SQL from beginner to Advanced in short span of time
Anyone who wants to learn how to use SQL and SQLite3
Anyone who had enough of multiple excel or csv files and wants a organized database

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.

Course Curriculum

Chapter 1: Introduction to the course

Lecture 1: Intro to the course

Lecture 2: Working with Databases

Lecture 3: Using Python with databases

Lecture 4: SQLite3 module

Lecture 5: Web Application

Chapter 2: Getting started

Lecture 1: Install python

Lecture 2: Install PyCharm

Lecture 3: Install Dependencies

Chapter 3: Create SQL database

Lecture 1: Create a database

Lecture 2: Create a table in database and close the script

Lecture 3: Add data manually to the SQL database

Chapter 4: Add data – convert CSV to SQL database

Lecture 1: Create SQL database for you CSV files

Lecture 2: CSV to SQL database

Chapter 5: Connect SQL to Flask (Web) application

Lecture 1: Link app with SQL

Lecture 2: Display table and data in the Flask app

Lecture 3: Connect Flask App Homepage

Chapter 6: Display app on HTML

Lecture 1: Display your HTML page

Lecture 2: HTML page – create a table within

Lecture 3: HTML page – add data to the table within

Lecture 4: HTML page – Formatting table

Lecture 5: HTML page – Finalising table

Instructors

Akash Singh
PhD in Bioinformatics and Genetics. Academic & Pharma leader

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 0 votes
5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu