Hands-On Python Tutorial For Real-World Business Analytics Problems

Foundational skills for data science, data engineering, and data visualization.

Author: Bob Wakefield
Co-Author: Rehman Gul

This tutorial is currently in beta release. All lessons are complete with the exception of lesson 35 which is on hold for the moment. All code works. Some lessons may have typos.

Preface

I. A Note From The Author II. Tutorial Overview

III. What Is The Preflight Checklist? IV. Supplimentery Material

Preflight Checklist

V. Download Anaconda VI. Download PyCharm (Optional)

VII. Download SQL Server Developer Edition VIII. Configure Database Environment

IX. Download The Source Code X. Starting JupyterLab

XI. Sign Up For Code Wars XII. How To Get Help With This Tutorial

Language Basics

1. Obligatory Hello World 2. Code Comments

3. Data Types 4. Variables

5. String Concatenation 6. Arithmetic Operators

7. Making Decisions 8. Control Flow With if-elif-else

9. Control Flow With While 10. Data Structures Part I: List

11. Data Structures Part II: Tuples 12. Data Structures Part III: Dictionaries

13. Looping With for 14. Functions

15. Importing Modules 16. Python Programming Standards

Advanced Topics

17. Functional Programing With map 18. Generators

19. Comprehensions 20. Basic File Operations

21. Working With Data In NumPy 22. Working With Data In Pandas

23. Working With JSON 24. Making File Request Over HTTP And SFTP

25. Interacting With Databases 26. Saving Objects With Pickle

27. Error Handling 28. Bringing It All Together

Solutions To Real World Problems

29. Download A Zip File Over HTTP 30. Looping Over Files In A Directory

31. Convert Comma Delmited Files To Pipe Delimited 32. Combining Multiple CSVs Into One File

33. Load Large CSVs Into Data Warehouse Staging Tables 34. Efficiently Write Large Database Query Results To Disk

35. Working With SFTP In The Real World 36. Executing Python From SQL Server Agent

I. A Note From The Author	II. Tutorial Overview
III. What Is The Preflight Checklist?	IV. Supplimentery Material

V. Download Anaconda	VI. Download PyCharm (Optional)
VII. Download SQL Server Developer Edition	VIII. Configure Database Environment
IX. Download The Source Code	X. Starting JupyterLab
XI. Sign Up For Code Wars	XII. How To Get Help With This Tutorial

1. Obligatory Hello World	2. Code Comments
3. Data Types	4. Variables
5. String Concatenation	6. Arithmetic Operators
7. Making Decisions	8. Control Flow With if-elif-else
9. Control Flow With While	10. Data Structures Part I: List
11. Data Structures Part II: Tuples	12. Data Structures Part III: Dictionaries
13. Looping With for	14. Functions
15. Importing Modules	16. Python Programming Standards

17. Functional Programing With map	18. Generators
19. Comprehensions	20. Basic File Operations
21. Working With Data In NumPy	22. Working With Data In Pandas
23. Working With JSON	24. Making File Request Over HTTP And SFTP
25. Interacting With Databases	26. Saving Objects With Pickle
27. Error Handling	28. Bringing It All Together

29. Download A Zip File Over HTTP	30. Looping Over Files In A Directory
31. Convert Comma Delmited Files To Pipe Delimited	32. Combining Multiple CSVs Into One File
33. Load Large CSVs Into Data Warehouse Staging Tables	34. Efficiently Write Large Database Query Results To Disk
35. Working With SFTP In The Real World	36. Executing Python From SQL Server Agent