Tutorials
Hands-On Python
Hands-On Python
  • Hands-On Python Tutorial For Real-World Business Analytics Problems
  • Preface
    • Section I. A Note From The Author
    • Section II. Tutorial Overview
    • Section III. What Is The Preflight Checklist?
    • Section IV. Supplimentery Material
  • Preflight Checklist
    • Section V. Select Your Difficulty Setting
    • Section VI. Download Anaconda
    • Section VII. Download PyCharm (Optional)
    • Section VIII. Download SQL Server Developer Edition
    • Section IX. Configure Database Environment
    • Section X. Download The Source Code
    • Section XI. Starting JupyterLab
    • Section XII. How To Get Help With This Tutorial
  • Language Basics
    • Lesson 1. Obligatory Hello World
    • Lesson 2. Code Comments
    • Lesson 3. Data Types
    • Lesson 4. Variables
    • Lesson 5. String Concatenation
    • Lesson 6. Arithmetic Operators
    • Lesson 7. Making Decisions
    • Lesson 8. Control Flow With if-elif-else
    • Lesson 9. Control Flow With while
    • Lesson 10. Data Structures Part I: List
    • Lesson 11. Data Structures Part II: Tuples
    • Lesson 12. Data Structures Part III: Dictionaries
    • Lesson 13. Looping With for
    • Lesson 14. Functions
    • Lesson 15. Importing Modules
    • Lesson 16. Python Programming Standards
  • Advanced Topics
    • Lesson 17. Functional Programing With map
    • Lesson 18. Generators
    • Lesson 19. Comprehensions
    • Lesson 20. Basic File Operations
    • Lesson 21. Working With Data In Numpy
    • Lesson 22. Working With Data In Pandas
    • Lesson 23. Working With JSON
    • Lesson 24. Making File Request Over HTTP And SFTP
    • Lesson 25. Interacting With Databases
    • Lesson 26. Saving Objects With Pickle
    • Lesson 27. Error Handling
    • Lesson 28. Bringing It All Together
  • Solutions To Real World Problems
    • Lesson 29. Download A Zip File Over HTTP
    • Lesson 30. Looping Over Files In A Directory
    • Lesson 31. Convert Comma Delmited Files To Pipe Delimited
    • Lesson 32. Combining Multiple CSVs Into One File
    • Lesson 33. Load Large CSVs Into Data Warehouse Staging Tables
    • Lesson 34. Efficiently Write Large Database Query Results To Disk
    • Lesson 35. Working With SFTP In The Real World
    • Lesson 36. Executing Python From SQL Server Agent
Powered by GitBook
On this page
  1. Preflight Checklist

Section VIII. Download SQL Server Developer Edition

PreviousSection VII. Download PyCharm (Optional)NextSection IX. Configure Database Environment

Last updated 3 years ago

You need to download the free version of SQL Server.

Why am I using SQL Server instead of PostgreSQL or MySQL for this tutorial? Cause I ain't here to waste your time. I mean, I'm assuming you're reading this for reasons. I'm the one sitting here writing this bloody thing and I'd much rather be logging hours on my A-10 simulator.

Nah! You took time out of your busy life to come here to learn how to make that bread and I got your back!

SQL Server is a nice mid-market database that, because of its power and price point, can be found in organizations across the spectrum of revenue and headcount. That means your skills are more portable and you have more places to apply to where you might be qualified.

When it comes time to hand out them resumes, you wanna be thinking more carpet bomb and less precision guided.

But you're on a Mac you say? All good. There are a couple more steps for you, but it's not that big a deal.

Well it's KIND of a big deal. At this time there is not full support for database related lessons on non-Windows machines. If you manage to find solutions to problems I have not addressed yet, give me a shout. DMs are open.

Windows

Non-Windows Machines

You can run SQL Server on non-Windows machines using Docker. Follow the links below for resources on getting SQL Server on your machine.

Download SQL Server Developer Edition
How to Install SQL Server on a Mac
Installing SQL Server In Mac Using Docker [Video]