
Learn Python automation for recurring data warehouse tasks. Read excel or csv files, connect to SQL Server, load data, and run procedures, all scheduled with Windows Task Scheduler.
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.
We have covered all the below things.
Read Data from Excel
Write Data from Excel
Read Specific sheet
Read specific cell
Write data
Sql Connectivity
Load Data in sql server
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.
We have covered all the below things.
Read Data from Excel
Write Data from Excel
Read Specific sheet
Read specific cell
Write data
Sql Connectivity
Load Data in sql server
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.
We have covered all the below things.
Read Data from Excel
Write Data from Excel
Read Specific sheet
Read specific cell
Write data
Sql Connectivity
Load Data in sql server
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well.
We have covered all the below things.
Read Data from Excel
Write Data from Excel
Read Specific sheet
Read specific cell
Write data
Sql Connectivity
Load Data in sql server