SQL and Python languages will be accessed to manage data into a DB Server, including functions for connecting to a database, preparing and issuing SQL statements, fetching rows from result sets, calling stored procedures, committing and rolling back transactions, handling errors, and retrieving metadata into Pandas.
Data will be queried according to segmentation and demographics goals using built-in database functions, subsequently providing valuable business insights.
Jupiter NBTK A > Understand the datasets > Store into SQL DB > Query data for analysis
Jupiter NBTK B > Create Complete DB > Prepare variables > Provide final strategy
Source: kikosikera/2019_09_20_py_sql