
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.
Learn to read and write Excel files with Python using openpyxl, including reading sheets and cells and writing data in Visual Studio Code.
Explore how to read data from multiple Excel sheets in Python using openpyxl, iterate over rows and columns, and handle dynamic column counts.
Read Excel data in Python using pandas dataframes, using pd.read_excel to load data from specific sheets, columns, or cells, and install pandas via pip.
Learn to read excel data with pandas, select specific columns using usecols, and filter by country values like Germany and Canada, including skipping rows.
Learn how to load data from Excel into SQL Server table using Python and pandas, including creating the table, inserting rows, and truncating to avoid duplicates.
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