SQLite databases with Python udemy course free download

What you'll learn:

SQLite Databases | Python Programming: (Build App and API )

  • Build an app with Python and SQLite
  • Build an API from scratch
  • Create and activate a virtual environment
  • Learn how to create a database and table
  • Create application Graphical User Interface -GUI
  • Connect Python application GUI to SQLite Database
  • Perform CRUD Operations from app GUI
  • Query and fetch data from a database table
  • Sort data returned from a database
  • SQLite Operators
  • Add new records into a table
  • Python Variables and Conditional Statements
  • Python Functions and Loops
  • The Python Dictionary and Lists

Requirements::

Description:

In this course you will learn interacting with SQLite3 databases. It makes it easy to access sqlite databases from python code. Manipulate and analyze your data using Python.

While you can store your data in files, this quickly becomes impractical.  A file can only be opened and written once, not by millions of people at the same time. If you want to make any kind of data-driven application you need to use a database system.

SQLite is a great little database. basically, it is a low-overhead, cross-platform, self-contained, zero-configuration, transactional SQL database engine. It's great when you want to move beyond files on the disk and start working with databases.

The best part is that it has bindings in lots of languages. In python, those bindings are in Python Package Index (pypi) as python-sqlite3 package.

The course teaches you how to setup a database and basic SQL with Python. Once you know how to work with SQLite, you can transfer that knowledge to working with other database systems like MySQL or Postgres.You will learn how to insert, retrieve, update and delete data amongst other things.

If you are a Python beginner and want to work with databases, this course is for you.

Who this course is for:

Course Details:

Download Course