Python is a high-level interpreted and object-oriented programming language. Like JavaScript, it doesn't have to be compiled before it can be executed - it runs within an interpreter (like the Python Shell) that handles the conversion into machine code.
SQL (Structured Query Language, pronounced "sequel") is how we manage structured data and communicate with relational databases.
Via Asabeneh's helpful "30 Days of Python" repo:
"Python is a high-level programming language for general-purpose programming. It is an open source, interpreted, objected-oriented programming language. Python was created by a Dutch programmer, Guido van Rossum. The name of Python programming language was derived from a British sketch comedy series, Month Python's Flying Circus. The first version was released on February 20, 1991."
In the py_guides and sql_guides folders, you'll find topics divided into different files. This guide is not meant to be deployed. My focus is fleshing out my notes on Python before moving on to SQL.
Also, make sure you first download Python and learn how to set up the Python Shell (instructions to come).
- The Very Basics (writing comments & print)
- Variables, Data, and Values
- Doing Math
- Playing with Strings
- Expressions & Loops
- Dictionaries
- Lists
- Tuples
- Objects, Classes, and OOP
- Functions
- Simple PY solutions to Popular Technical Challenges
This guide doesn't include everything to know. It is, however, a great place to start.
The Python guide follows Google's Python style guide as closely as possible. This involves the following:
- Using
pylintfor code linting - Using
yapffor auto-formatting - Including Google's setting file for Vim and
pylintrc
An SQL guide is forthcoming, as well as notes on accessibility and testing.
Many people enjoy LeetCode, but I think NeetCode and CodeSignal are easier to use and include more approachable coding questions.
Thank you to my instructors at General Assembly for my first steps into Python and SQL. Also shout-out to the many helpful YouTube channels I still refer to: Traversy Media, Web Dev Simplified, The Net Ninja, Programming with Mosh, and Fireship.
© 2023 Brady Gerber. All Rights Reserved.