
This course includes our updated coding exercises so you can practice your skills as you learn.
See a demo
Learn how Visual Studio Code serves as a cross-platform source code editor and integrated development environment with debugging, version control, syntax highlighting, autocomplete, snippets, refactoring, and customizable plugins and themes.
Install Visual Studio Code and start with the first steps, then explore editing, debugging, code navigation, extensions, and source control integration with Python and other languages.
Learn to set up Python in Visual Studio Code, create and save a hello world script, use autocomplete, and run it in the terminal, and execute scripts from the interpreter.
Master the concept of variables as the fundamental data type in programming, where an identifier stores a value that can change during runtime.
Explore key data types such as boolean, integer, character, float, double, and string, and distinguish assignment from equality in this fundamentals lesson.
Explains Python variables and memory allocation, automatic declaration on assignment, and printing with the built-in print function, including multiple assignment and basic types: numbers, strings, lists, tuples, and dictionaries.
Explore Python data types by building and manipulating lists, tuples, and dictionaries, access elements with indexes and slices, and learn core operations and common pitfalls.
Explore Python data type conversion using built-in functions to convert between types such as int, long, float, string, dict, and complex, with examples converting strings to numbers and Unicode.
Explore how variables store and update values, and how arithmetic and logical operators drive expressions, checks, and conditional decisions. Examine remainder, string concatenation, relational operators, and boolean results.
Explore how if statements drive conditional logic through the selection structure by choosing commands based on true or false conditions, using if, else if, and else blocks, with calculator examples.
Learn decision making in Python through if statements, nested ifs, and elif else blocks, using boolean expressions and proper indentation to control which print statements execute.
Explore how loops enable repeated execution, focusing on while and do-while loops, their conditions and updates, and pitfalls like endless loops illustrated by printing hello world.
Explore loops in Python, including while and for loops, and nested loops; learn loop control, incrementing indices, and termination conditions to avoid infinite loops.
Explore loops and iteration in Python, including while and for loops, iterating over sequences, using range to print values, and nesting loops for complex patterns.
Explore arrays in programming by storing multiple integers in a single array, indexing elements from 0 to size-1, initializing and printing values with loops in C.
Explore two-dimensional arrays in Python and compare them to one-dimensional arrays using class, school, and student examples. Learn to index, size, and select the appropriate array dimensions for multi-level data.
Explore multidimensional arrays and 2d arrays, with rows and columns, zero-based indexing, and practical rating matrix examples to compute sums and averages.
Learn how functions act as modular, reusable blocks of code with specific inputs and outputs, including parameters, return values, and examples like max finding in C and hello world.
Explore Python functions, including defining user defined functions with def, passing parameters, calling, and returning values; learn about modular code, side effects, and list mutation via references.
Explore file input and output in programming by reading from and writing to files, including read, write, append, and read-write modes across C++, Java, and Python, with practical examples.
Learn Python input and output basics, including print and input, plus file handling with open, write, read, and close, and how to inspect file name and mode.
Explore the fundamentals of object oriented programming, including objects, attributes, and methods. Follow the analysis, design, and programming cycle and see how object models and inheritance support modular, reusable code.
Explore objects and classes in object oriented programming, defining their identity, state, and behavior, and show how classes serve as blueprints for objects with data members and methods.
Explore how methods function as procedures in object-oriented programming, detailing class variables, instance variables, and the distinction between class methods and instance methods.
Explore encapsulation and data hiding, binding data and methods while restricting external access to internal state. See how public, private, and protected controls enable abstraction, decoupling, and safer refactoring.
Explain how a method call, or method passing, lets an object dynamically dispatch code to execute, enabling uni-directional messages between objects with input parameters.
Explore inheritance and object composition in object-oriented programming, with is-a relationships, base and derived classes, and inheritance types: single, multiple, multi-level, hierarchical, and hybrid; illustrated with animal and vehicle examples.
Explore polymorphism and subtyping in object-oriented programming, using a common interface across shapes like circle and square to draw and find area within an inheritance hierarchy.
Explore generalization and specification in object oriented programming, forming higher level classes from common traits and creating specialized subclasses. Understand is-a relationships and when to generalize or specialize.
Explore links and associations in object-oriented programming, defining association as a relationship between objects and a link as its instance, with one-to-one, one-to-many, many-to-many; relate to databases and DBMS.
Learn to send an email with Python using the smtplib library, configure the SMTP server and port, login with credentials, and send a test message to a recipient.
Discover how to parse XML in Python using the DOM API and minidom, loading the document into a DOM tree to iterate products and extract attributes like name and price.
Explore multithreading in Python by creating and managing threads, sharing data across the same process, and comparing kernel and user threads for lightweight concurrency.
Learn a three-step process to master sql in access, mariadb, and other relational databases, because the basic sql logic remains the same across systems despite small differences.
Learn why SQL matters: it is a structured query language used to store, manipulate, and retrieve data in relational databases, standard language for DBMS powering apps like Facebook and Twitter.
Install XAMPP, Apache, MySQL database server, and SQLYOG as a database client to set up a local web server and database environment.
Start and stop modules via the control panel, launching the Apache web server and the MySQL (MariaDB) database server. Note the process ID and port 3306.
Create your first database by connecting as root to localhost on port 3306, optionally setting a password, then run a create database query and view the empty schema.
Learn how to drop a database and recreate it using sql queries, view databases, and refresh the object browser, while understanding risks and the need for backups.
Create a student table by defining an id integer primary key, and a not null name varchar(30), plus optional age, grade, and degree fields.
Learn how to manage tables by creating and dropping tables, including using drop table to remove a table, verify by selecting, and using insert into to add rows.
Learn how to write insert statements with insert into, specify columns or provide all columns, and populate a students table with example values after executing the statements.
Create a new table from an existing one using create table as select * from students, copying all data and illustrating the resulting sets.
Master the select statement syntax to query a table, such as students, using select * for all columns or specify columns like name and age, then execute to view results.
Master the where clause to filter records in select queries, using exact values, quotes for strings, and applying the same logic to update and delete statements.
Master sql statement operators by using greater than, less than, and equal comparisons, and combine conditions with and or to refine selections from the students table.
Learn how to update data using update queries to modify existing records with set and where clauses, including updating multiple columns or all rows in a table.
Learn to delete data with delete statements in SQL, using delete from table where conditions to remove specific records or delete from table to remove all rows.
Learn to use the like operator in a where clause with wildcard characters to match patterns, such as names starting with Chris or containing Mal.
Learn how to limit results across MySQL, MSSQL, and Oracle using limit, top, and rownum syntax, with examples using select statements to fetch the top N records.
Learn how to use the order by clause to sort query results in ascending or descending order by one or more columns, with examples ordering by AIDS and names.
Explore how to use the group by clause with a select statement to group data by name, perform aggregations like sum and count, and precede an order by clause.
Learn to use the distinct keyword with select to return unique values. Apply select distinct on columns from a table, with where conditions, to remove duplicates.
Learn how to delete data with truncate table and delete from, keep the table structure with truncate, and remove entire tables with drop table, then verify results with select.
Build a practical Python foundation, then explore how programs work with files, objects and database information. This course combines introductory Python lessons with coding exercises and additional SQL material, making it useful for learners who want a wider view of application data.
The sequence begins with the development environment, variables, types and operators. You then study conditions, loops, functions and file operations, followed by object-oriented and additional Python concepts. A later database section introduces SQL tables, queries, filtering, ordering and grouping.
Skills you can develop
Read a short Python program and trace the values it produces.
Break a calculation or data-processing task into reusable steps.
Recognise invalid input and explain how your program handles it.
Connect a program's in-memory work with information stored in a database.
The final practice lessons focus on repeated file-processing runs and on validating and summarising a small data file. Use fictional input, calculate the result you expect and compare it with the program's output. The exercise gives you a concrete way to examine mistakes in data, logic and assumptions separately.
Choose this course if you are beginning Python or refreshing programming fundamentals and would like introductory database exposure as well. Allow time to reproduce examples and investigate errors between lessons.
The recorded exam references come from the former Microsoft MTA 98-381 syllabus. Microsoft retired MTA in 2022, so the course supports foundational learning rather than preparation for a currently bookable MTA exam. Check current Python and tool documentation when adapting older setup instructions or APIs to your own project.
A Python foundation beyond a historical exam label
The original MTA 98-381 context provides a way to organise the recorded lessons, but the reason to study them now is the programming itself. Variables, control flow, functions, files and objects remain useful things to understand. This course lets you work through those ideas in a structured sequence and then apply them in short exercises. Choose it as foundational Python learning and revision. It is not presented as an opportunity to obtain the retired MTA qualification or as complete coverage of every current Python development topic.
Understanding how values move
A variable is part of a sequence of operations, not just a name to remember. The types and operators sections help you examine how a value is created, converted and used. For each small example, ask what the value represents and what the next statement expects. If an input is text but a calculation needs a number, that difference matters. Recording intermediate values makes this visible. It also gives you a concrete question to investigate when a program produces an unexpected result or reports an error.
Making decisions and repeating work
The conditional and loop lessons give you the basic structures behind many everyday programs. A decision divides possible inputs into cases. A loop processes repeated work according to a rule. Before adding more code, explain those cases in ordinary language. Which values follow each branch? What changes between iterations? When should repetition stop? Working through those questions supports understanding even if the example is small. It also helps distinguish an incorrect algorithm from a simple typing mistake in an otherwise sound idea.
Collections, functions and files
These topics introduce different forms of organisation. A collection brings values together, a function groups a task and a file preserves information outside the immediate execution. The recorded examples offer a place to connect those roles. When you practise, give a function a clear result and choose sample input that makes the result easy to verify. If a file is involved, describe what data should be read or written. This keeps your explanation about behaviour rather than about the number of statements in the solution.
Working through the interactive exercises
Short coding problems provide feedback while the relevant concepts are still manageable. Attempt an exercise before inspecting a solution, then compare the reasoning as well as the output. Two pieces of code may produce the same result for one input while behaving differently for another. A useful follow-up is to choose a boundary case and explain why it matters. You are developing the habit of checking an assumption, rather than treating a successful run with one ordinary value as proof that everything is correct.
Approaching object-oriented material
The OOP section adds vocabulary for organising state and behaviour. Classes, methods and relationships should be connected with responsibilities you can describe. Ask what an object represents, which operations belong to it and what information another part of the program needs to know. The course introduces these ideas at a foundational level. You do not need to create a large class hierarchy to learn from them. A small example you can trace is often a better starting point than a design whose complexity hides the basic relationship.
Exploring the additional topics
The curriculum continues beyond the initial exam framework into further Python and SQL-related material. This gives you a view of how a foundation can lead toward other tasks. Treat each extension as an introduction and identify what background it assumes. The database material, for example, asks you to think about stored records rather than only values held during a calculation. The additional reading workshops encourage careful checks of program behaviour. They provide ways to revisit concepts without claiming that this course is a complete specialist pathway for every topic mentioned.
Studying with evidence of progress
Keep a small collection of your own examples: an input conversion, a branch, a loop, a function and a file operation. For each one, write an expected result and a sentence explaining it. When an exercise exposes a gap, revise the explanation and rerun the example. This produces a more useful record than a list of videos watched. It also helps if you return to Python after a break, because you can see which ideas you understood and which still depended on following an instructor step by step.
Deciding whether the course fits
This is a suitable starting point if you want a broad introduction to Python programming with practice and legacy certification context clearly identified. It also suits someone returning to earlier study who wants to consolidate core logic before choosing a specialised subject. It does not promise expert-level Python, a current Microsoft credential or a complete production application. Review the lesson list, choose a steady practice pace and use the exercises to test your understanding before moving to the next construct. That is how a historical study framework can become useful foundational learning.
Curriculum at a glance
Python introduction and historical MTA 98-381 context
Variables & Data Types
If-Statements and Conditional Logic
Loops and Iteration
Arrays, Functions and Files
Interactive exercises: create your first Python programs
Object-oriented Programming
Advanced Concepts in Python
Introductory SQL and stored data beyond the Python foundation
Historical MTA 98-381 study guidance and Python revision