Python - A 3-step process to Master Python 3 + Coding Tips™

Explore variables as the foundational data type, binding a symbolic name to a mutable storage location whose value can change at runtime, with simple C-style examples.

Explore how python handles variables as memory locations, assign values with =, print results, and use multiple assignment, string slicing, concatenation, and basic data types like numbers and strings.

Explore common data types: bool, int, char, float, double, and string, and how memory allocation and default values shape variables. Compare assignment and equality, and distinguish strong versus weak typing.

Learn Python data types by working with lists, tuples, and dictionaries; master indexing, slicing, accessing keys and values, and printing to illustrate type conversion and data structure behavior.

Learn how to convert data types in Python using built-in functions like int, float, list, dict, and chr/ord, with practical examples turning strings into numbers and collections.

Explore how variables store user and computed values, and apply arithmetic, relational, and logical operators including modulo and boolean results to solve problems in Python.

Master if statements and conditional logic using boolean conditions to run code blocks, understand if, else if, and else structures, and explore a simple calculator example.

Master Python if statements, elif and else, and nested conditionals to control code execution. Learn how boolean expressions, indentation, and tabbing determine which statements run.

Explore loops and iteration in programming, using while and do-while constructs to repeat statements like printing hello world, guided by conditions and increments.

Explore loops and iteration in Python, including while and for loops. See do while and nested loops with the i variable increments and i < 5.

Master loops and iteration in Python with for and while constructs, else clauses, and nested loops through practical examples using ranges and lists.

Discover how arrays store a fixed-size collection of same-type elements, declare and initialize them, access elements by indices, and print values with a loop in C.

Compare one and two dimensional arrays, demonstrate indexing across classes and schools, and show how three dimensional arrays capture multiple dimensions of students.

Explore multidimensional arrays with two dimensional indexing for rows and columns, using zero-based indexes, and build a 3x4 rating matrix to compute per-row averages and note out-of-bounds errors.

Explore functions as reusable blocks of code with defined inputs and outputs, learn about function signature, parameters, return types, and how to call built-in functions from main for modular programs.

Define and call Python functions with def to perform specific actions, reuse code, and observe parameters, printing, returning values, and reference-based list modification.

Learn to use file input and output to read from and write to files, using read-only, write-only, append, and read-write modes across C++, Java, and Python.

Explore Python's basic input and output, including print and input, and learn file operations with open, read, write, and close to handle standard input, keyboard input, and text files.

Explore object oriented programming through objects, attributes, and methods, and learn how they interact to model data, behavior, analysis, and modular, reusable software design.

Explore the fundamentals of object oriented programming by defining objects and classes, distinguishing instances from classes, and identifying attributes, data members, and member functions.

Explore the five method concepts in python's object oriented programming: class variables, instance variables, member variables, class methods, and instance methods; learn how each relates to class or object data.

Master encapsulation and data hiding in object oriented programming by binding data and methods, restricting external access, and enabling safe refactoring and decoupled code.

Explore message passing and dynamic dispatch, where a method call lets an object select and execute the appropriate code, enabling unidirectional communication and class method invocation across processes.

Explore inheritance, the mechanism to create new classes from existing ones by extending and refining capabilities, reusing base data and methods. Learn about single, multiple, multilevel, hierarchical, and hybrid inheritance.

Polymorphism, a key concept in object oriented programming, lets the same operation name behave differently for objects from a parent class or its descendants. Circle and square implement draw differently.

Explore how generalization merges common characteristics of subclasses into a higher-level superclass, forming is-a relationships. Explain how specialization uses distinguishing features to form specialized subclasses from existing classes.

Explore associations and links in object-oriented design, detailing one-to-one, one-to-many, and many-to-many cardinalities, and how these relationships connect classes, objects, and databases.

Set up a test email workflow in Python by composing from, to, subject, and body, configure the SMTP server, log in, and send the message.

Explore how to parse XML documents in Python using the document object model (DOM), extract elements and attributes, and iterate through products to retrieve names and prices.

Explore multi-threaded programming in Python by creating threads that share the main thread's data space for easy communication, and compare kernel and user threads with the thread and threading models.

Master SQL through a three-step process, learning the basics and advanced concepts that apply across MySQL, MariaDB, Microsoft SQL Server, Oracle, PostgreSQL, Informix, and MS Access.

Discover why SQL is essential as a structured query language. Learn to store, manipulate, and retrieve data in relational databases, and to create or drop databases and tables.

Install and configure XAMPP with Apache and MySQL, then use SQLYOG as a database client to set up a local web server, file transfer, and optional email features.

Use the control panel to start and stop modules, launch the Apache web server to serve pages, and start the MySQL/MariaDB database service on port 3306, confirming the server status.

Create a new database with a sql query, verify a successful connection on port 3306 with root and an empty password, and view the new database in the object browser.

Learn to drop and recreate a database via SQL queries, view databases, and understand the risk of data loss without a backup.

Create tables in a database by defining an integer id, a varchar name, and a not null constraint, then set a primary key and view the students table.

Master dropping tables with the drop table statement, observe effects on selects, and learn inserting new rows with insert into to manage database data.

Master the basic sql insert syntax by using insert into with a table, its columns, and corresponding values to populate records.

Create a new table from an existing one using a select statement, duplicating all data from the students table and understanding result sets.

Master the basics of the select statement, learning its syntax, how to retrieve all columns with select *, or fetch specific columns like name and age from a table.

Use the where clause to filter records in select statements, returning rows that meet a condition. Apply quotes for text comparisons and extend the clause to update or delete statements.

Master SQL operators by using greater than, greater or equal, less than, and less or equal in select statements; combine conditions with and and or to narrow results.

Master update queries to modify existing table records, update selected rows with where conditions, or update all rows without a where clause, using set assignments for one or multiple columns.

Learn to delete data with SQL delete statements, such as delete from students where name = Chris, and remove all records with a simple delete from table.

Learn how the like operator in a where clause uses wildcards to match patterns, such as names starting with Chris or containing mal, using % as the wildcard.

Master how to limit data across MySQL, MSSQL, and Oracle using limit, top, and rownum clauses. Learn practical syntax and database-specific nuances to retrieve the top N records.

Learn how the order by clause sorts data in ascending or descending order by one or more columns, ensuring the sorting column appears in the column list.

Learn how to use the group by clause with a select statement to group data by name, sum ages, and count records, then order by name.

Learn how to eliminate duplicate records and return only unique values using the distinct keyword. Understand the basic syntax of select distinct column from table where conditions are true.

Discover how to remove data from an existing table using truncate table, delete from, and drop table, while preserving or recreating table structure. See practical examples and basic SQL concepts.