Introduction To SQLite Databases for Python Programming
What you'll learn
- After completing this course you will get knowledge of basic concepts SQLite in Python Programming and you can start writing code on your own.
- Basic knowledge of Computers
SQLite is an open source, serverless, zero-configuration, self-contained, stand alone, transaction relational database engine designed to be embedded into an application. Python by default will have the SQlite3 module installed in it, we need not to install this module separately. This course help you to start with using SQLite3 module in Python. To use sqlite3 module in Python Programming, you must first create a connection object that represents the database and then optionally you can create a cursor object, which will help you in executing all the SQL statements.
Once you complete this tutorial, you will get basics of SQLite3 module.
Concepts covered in this course:
Sample Database Creation
Create a Table
Inserting Data into a table
Selecting Data from a table
Selecting Data Using Where Clause
Order By Clause
Update Data in a table
Module in-built Functions
Importing data from CSV file
Exporting data into CSV file
Exception handling with example
I will explain all the basic concepts using SQLite3 module in Python Programming with examples.
I will also provide document for each concept for your reference.
After completing this course, you will be in a position to understand SQLite3 concepts and start writing your own scripts in Python Programming for your requirements.
Who this course is for:
- People who wants to learn database concepts of SQLite in Python Programming.
I have experience in data science and I am very good at Python programing, Tableau (BI Tool) and R programing. Based on my experience I have created the course by taking real time into consideration.
Also, I have good knowledge of Oracle Applications Techno Functional with experience over 11 years in various modules like AP, AR, GL,iExpenses, iProcurement, PO, OM, INV, Service Contracts, HRMS Work Structures, FixedAssets, E-Business Tax Manager and Workflow. I have worked on various implementation Projects as well as support projects. I have exposure of concepts of Oracle Advance Pricing and have taken many training to people. Also, having good knowledge on Oracle Cloud module like Human Capital Management, Fusion Procurement contracts and Fusion Project Portfolio Management (PPM). I have experience in SCM and Finance modules. Also, I have experience in Oracle Reporting tools like XML and Fusion OTBI.Exposure on RICE (Reports, Interfaces, Conversions, Extensions) components in the areas of Implementation, Up-gradation, and Customization. Having good experience in Bill Presentment Architecture in iReceivables. Oracle Fusion Data loading and also very good knowledge in iStore concepts.