Coding for Beginners: Scratch, Python, Java, C# & SQL

Create a new world in Kodu Game Lab, add objects and terrain, and program a cannon to shoot missiles at a fast cycle, then play-test.

Set up Kodu Game Lab on your computer by downloading from the Microsoft page, installing, selecting English, and creating a world to start building and programming your first game.

Program a Kodu game where a cycle navigates terrain and a cannon shoots missiles. The cycle eats apples, and the game ends with a win when no apples remain.

Program a Kodu cycle to award points when apples are shot or bumped, track blue team scores, and declare a winner once a set points goal is reached.

Explore Visual Studio Code, a cross-platform source code editor that bundles debugging, built-in git control, syntax highlighting, intelligent code completion, snippets, and refactoring in a customizable environment.

Install Visual Studio Code across Windows, Mac OS, and Linux, and explore features like intelligent code completion, debugging, navigation, refactoring, and Git integration with Python and JavaScript.

Variables are the foundational data type, storage locations with symbolic names and values that can change during execution; they may alias and map to actual data by the compiler.

Explore how value type variables store data across int, char, float, double, bool, and string, with memory allocation, default values, and the difference between assignment and equality.

Explore how programs declare and manipulate variables to store and update values. Learn arithmetic, logical, and relational operators, including remainder and string concatenation, and see how boolean results guide decisions.

Explore how conditional statements form a selection structure that executes commands based on true or false conditions. Learn if, else if, and boolean values with practical code examples.

Master loops and iteration by examining while and do-while structures, how conditions control repeated execution, and concrete hello world examples that illustrate endless and finite loops.

Explore arrays as a fixed-size, same-type data structure that replaces many variables with a single, indexable collection; declare, initialize, and access a single-dimensional int array in C.

Master one dimensional, two dimensional, and three dimensional arrays, using indices to organize class, school, and student data. Determine array size and dimensions.

Explore multidimensional arrays, focusing on 2d arrays with rows, columns, and zero-based indexing. Build and sum a rating matrix, compute an average, and ensure consistent types.

Explore how functions map inputs to outputs, creating modular, reusable blocks of code. See how parameters, return types, and signatures shape programs with built-in and user-defined functions.

Discover file input and file output by reading from and writing to files, using modes like read, write, append, and read-write, with examples in C++, Java, and Python.

Discover object oriented programming concepts, focusing on objects with attributes and methods, their interactions, and how analysis, design, and inheritance structure modular, reusable software.

Define objects and classes as the core of object oriented programming, where classes specify data fields and methods, and objects are instances that model real or conceptual entities.

Understand how objects and classes relate by exploring methods and variables: class variables, instance variables, member variables, and class and instance methods.

Encapsulation binds data and its functions, shields internal details from outside interference, and data hiding enforces access via public, private, and protected access.

Explore methods passing and dynamic dispatch, where objects choose the code to execute in response to a method call, enabling directional, inter-object communication.

Explore inheritance in object-oriented programming, where derived classes reuse and extend base classes, enabling single, multiple, multilevel, hierarchical, and hybrid inheritance to model real-world relationships.

Explore polymorphism, the ability of objects from a parent class and its descendants to share a common interface while implementing different behaviors, as shown with shapes and animals.

Explore generalization and specialization in logic and programming by forming a superclass from common subclass characteristics. Decide when to generalize with parent classes or specialize with subclasses in a team.

Explore links and associations in object oriented programming, defining relationships between objects and classes, and mastering one-to-one, one-to-many, and many-to-many cardinalities with practical examples.

Explore Visual Studio Code, a cross-platform source code editor and IDE that combines debugging, Git control, syntax highlighting, intelligent code completion, snippets, and customizable extensions for many languages.

Install Visual Studio Code on Windows, macOS, and Linux, then install language extensions like Python, and use code completion, debugging, navigation, refactoring, and Git integration.

Learn to code in Python using Visual Studio Code, create a hello world program, and run it in the terminal with print statements.

Discover Python lists, tuples, and dictionaries, learn how lists hold mixed data types and indexes start at zero, how tuples are immutable, and how dictionaries map keys to values.

Master Python data type conversion using built-in functions like int, float, list, and dict. Learn to convert strings to numbers, strings to lists, and handle unicode via ord.

Explore Python decision making with if statements, nested ifs, and elif else blocks, using booleans, indentation, and print commands to control code flow.

Explore loops in Python, including while and for loops, with nested loops and a practical example that prints the index i while i < 5, and highlights infinite loop risks.

Explore while and for loops in Python, using range to control iterations, iterating over lists and strings, printing values, and nesting loops, with attention to loop else behavior.

Explore Python's core input and output tools by using print and input, then work with files through open, write, read, and close, including reading specific character counts.

Explore functions in Python to create modular, reusable code and boost code reuse. Define user defined and built-in functions with def, pass parameters, print outputs, and return, understanding function scope.

Learn to send a test email to multiple receivers from Python using an SMTP library, configure server and port, log in with credentials, and compose a simple subject and body.

Explore xml parsing with the document object model (dom) in Python. Read and extract product data from xml files by navigating nodes and attributes such as name and price.

Explore multithreaded programming in Python, where threads share data and communicate cheaply compared with processes, using thread and threading modules to create and run two threads.

Install Visual Studio 2019 Community Edition to access IntelliSense and autocomplete, and set up development for Windows Forms or console apps using C#, Visual Basic, C++, JavaScript, TypeScript, or Python.

Create your first desktop app with Windows Forms in Visual Studio 2019, select .NET framework 4.7.2, and explore a web app with home and privacy pages.

Create your first C# Windows Forms project in Visual Studio, name it, locate bin, then add a button, customize its text, and wire a click event to print hello world.

Click the large button to show a hello world message box, fix errors and warnings, and customize the Windows Forms button text, color (system drawing color blue), and other properties.

Explore how web applications work by examining web pages, web servers, and browsers, and distinguish the internet from the web. Learn how HTTP, HTML, and URLs connect clients to resources.

Learn how HTML describes web pages with markup, scripts, and CSS styling. See how browsers render HTML, link resources via unique URLs, and inspect page source for structure and metadata.

Create your first web app with ASP.NET in Visual Studio by adding an aspx page, setting the page title, and using an h1 header and a paragraph to display content.

Learn to add the paragraph and anchor tags, creating hyperlinks with href and target attributes. See how to use the image tag with src, and that css comes next.

Discover how to style an asp.net web app with css by creating a stylesheet, linking it in the head, and styling body and div elements with font-family and font-size.

Learn to embed client-side JavaScript in an ASP.NET web app with a script tag, connect a button click to a function that retrieves the date and updates a page element.

Explore styling a web button with css and javascript by removing borders, setting white text and padding, and adding a hover effect with the button info class.

Learn to add styling buttons with CSS and JavaScript by creating a new demo function. Wire click events to update elements via document.getElementById.

Learn how to add dynamic images with JavaScript by swapping image sources with buttons, using functions to toggle light on and off, and styling controls with CSS classes.

Discover how storing JavaScript in external files improves maintainability and performance, then contrast client-side and server-side programming with examples like JavaScript in the browser and dot net technologies.

Discover how a browser request becomes a response in asp.net via iis and the worker process, compiling pages into assemblies. See how the system.web libraries support the final response.

Analyze a web page execution flow in Chrome, detailing dns lookup, ssl, request and response timing, server processing, and client-side resource loading through the asp.net page glass model.

Explore the ASP.NET page lifecycle and event model, detailing init, load, postback handling, pre render, rendering, and unload, and show how to attach event handlers and process form submissions.

Explore state management by comparing client-side and server-side techniques to preserve web page state across roundtrips, using variables and controls to define the state.

Discover client-side state management using browser capabilities to store state on the client. Use query strings, cookies, hidden fields, and view state to preserve data across postbacks.

Learn how server side state management uses the server to store session state and application state, with session ids transmitted via cookies or url and stored in the application object.

Explore setting up a Java development environment with NetBeans IDE, install the JDK, and learn core object-oriented concepts—classes, objects, methods, and instance variables.

Learn to create your first Java program in NetBeans by starting a new Java project, writing a main class with a main method, and running it to print hello world.

Master Java declaration rules: one public class per source file, class name must match the file name, and the package statement should be first, with imports applying to all classes.

Explore how to design Java classes and objects by building a student class with name, age, grade, and school, plus constructors and a main method to print details.

Master decision making in Java with simple and nested if statements, if-else logic, and switch-case constructs, including break and default handling, illustrated by variable examples.

Master Java loops including the for loop, Y loop, and do Y loop, with initialization, condition checks, and updates, and understand the break statement.

Discover how to define and call Java methods with parameters and return types, using max number and void examples to print results and enable code reuse.

Explore arrays in Java, a fixed-size, type-homogeneous data structure. Learn declaring, iterating with loops, printing elements, and computing sum, min, and max values.

learn Java file input/output using input and output streams, handle io exceptions like file not found with try and throws io exception, demonstrated by a simple copy example.

This lecture shows Java as an object oriented language, with classes as templates for objects that have states and behaviors, and explains constructors and object creation.

Master SQL through a three step process, learning the structured query language for retrieving and managing data across relational database management systems like Oracle, Sybase, Postgres, and MS Access.

Discover why sql is the standard language for relational databases, enabling storing, retrieving, defining, creating and dropping databases and tables, and powering apps like Facebook and Twitter.

Install and configure a local web development stack with XAMPP, including Apache, MariaDB/MySQL, and PHP or Perl, using SQLYOG as the database client and Mercury email server.

Start and stop server modules, including the Apache web server to serve pages. Start the MariaDB/MySQL database on default port 3306 and monitor the status log.

Connect to localhost as root with no password, then create your first database via GUI or SQL query, and explore tables, views, and procedures in the object browser.

Run queries to list databases, create new ones, and drop databases, with a browser refresh showing results. Be careful: dropping a database deletes all data unless a backup exists.

Create the first students table by defining an integer id as primary key, a not null varchar(30) name, and a grade as integer or decimal.

Drop a table with the drop table statement, then verify with a select query. Learn inserting rows using insert into to add data.

Learn how to create insert into statements by listing column names and values, or omitting column names to fill all columns, with examples using a students table.

Create a new table from the students table using select * from students, and understand that the resulting data is shown as a result set.

Explore handling files in Java using the java.io package, including file input and output streams. Learn to read and write data and manage io exceptions with try and throws.

Learn to use the where clause in a select statement to filter records from a table by conditions with numeric comparisons and quoted strings, ensuring only matching rows are fetched.

Discover how to use SQL operators to filter data, including greater than, greater or equal, less than, less or equal, and, or, to combine multiple conditions in select statements.

Use update queries to modify existing records in a table, updating selected rows with conditions, such as renaming a student, or changing all grades when there is no where condition.

Learn how to delete data using delete statements by executing delete from students where name = Chris, refreshing the table, and optionally removing all records with delete from students.

Learn how the like operator in the where clause uses wildcards to match names with flexible patterns, including contains with % and starts with patterns, and distinguish it from equals.

Practice creating insert statements in a new query editor and learn how top, limit, and rownum fetch limited records across SQL Server, MySQL, and Oracle.

Master the order by clause to sort data by one or more columns in ascending or descending order, ensuring the sort column appears in the select list.

Explore how the group by clause clusters identical data in a select statement, precedes the order by clause, and enables aggregates like sum and count by name.

Use the distinct keyword with select to fetch only unique records and eliminate duplicates, illustrated by selecting names from a students table and the syntax select distinct column_name from table.

Learn to delete data with SQL using truncate table to remove all records while preserving the table, and contrast with drop table; the lecture shows an empty result after truncation.

Explore how Flutter uses Dart to build fast, cross-platform mobile apps for Android and iOS at 60 fps, with its own UI components and Material Design.

Install and configure Flutter, Dart, and IntelliJ to set up a complete development environment. Learn to use flutter doctor, install plugins, and configure paths across Windows, macOS, and Linux.

Create a new mobile project with Flutter and Dart, configure the Dart SDK, plugins, and Flutter framework, then run to see a hello world and use hot reload.

Develop a flutter calculator app with two text fields for bill amount and percent, a raised button, and learn stateless versus stateful widgets.

Learn to build a Flutter app by forming a widget tree with a column layout, padding, and a scaffold root featuring an app bar and a calculate button.

Create a flutter app entry point with a main function and runApp. Wrap deep calculator widget in a material app to display bill amount, tip, and total under Deep Calculator.