MODULE 1:

• Introduction Anaconda Python Package
• Introduction to Database and RDMS
• Introduction to Ms-SQL server environment
• Life cycle of oil and gas data.
• Recap of Python Programming Language
• Data Containers recap
• Pandas Recap

MODULE 2:

• Introduction to pyodbc connector
• Introduction to elements of database design
• Decision-making and code flow control
• Functions and Classes.
• Introduction to drivers and SQL connectivity.
• Reading data from SQL databases.
• SQL Data types.
• Design validation and null value handling.

MODULE 3 :

• Conditions in SQL queries
• Python data filtering vs. SQL data filtering
• Introduction to base map creation for oil fields using Python and SQL
• Introduction to SQL operators and other conditioning statements
• Adding data into SQL databases.
• Single data row insertion.
• Multiple data row insertion
• Excel-Python-SQL integration for bulk data loading.
• Introduction to elements of Database design.
• Displaying data in interactive dashboards

MODULE 4:

• Deleting and updating records in SQL databases.
• Export data from SQL to various data types.
• Database dashboarding.
• Creating a data monitoring solution for oil and gas production using SQL and Python
• Introduction to data views (table views)
• Backing up data from SQL tables.
• Basic Housekeeping in ms-sql server.

MODULE  5:

• Basic SQL report generation
• Creating a Database from Scratch
• Create multisource data application in Python.
• Create a Basic Production/Injection Event Recording System in SQL and Python
• Reservoir Management application using SQL and Python. 
• Converting Operational data from SQL to Production Engineering and Monitoring Solutions.

MODULE  6:

• Introduction to object-relational databases.
• Introduction to PostgreSQL.
• Basic Operations and Custom datatypes in PostgreSQL
• Introduction to Document Databases.
• Introduction to MongoDB and NoSQL technology.
• Introduction to JSON and BSON files and Structures.