
Identify variables as store locations with symbolic names that hold values. Assign x=5 and y=8, then z = x + y to show how values change at runtime.
Explore data types in programming, including booleans, integers, characters, floating point and strings, and learn the difference between assignment and equality in strongly and weakly typed languages.
Explore how programs declare variables to store information and how operators apply to operands for arithmetic, logic, remainder, and relational operations, producing boolean results.
Master conditional logic with if statements for angular beginners, using boolean conditions to execute command blocks, apply if-else decisions, and build simple scenarios such as a calculator.
Explore loops and iteration by examining while and do-while constructs, using a hello world example, conditions and increments, and common endless-loop pitfalls.
Explore arrays in C by creating fixed-size collections of same-type elements, using indices from 0 to size-1. Learn creation, assignment, and accessing elements with loops and printf to print values.
Explore one-dimensional, two-dimensional, and three-dimensional arrays using student examples to show how indices determine positions, how length dictates size, and when to use nested arrays for classes, schools, and beyond.
Explore multidimensional arrays with two-dimensional matrices, learn row and column indexing, zero-based semantics, and how to declare, initialize, and access ratings across rows and columns.
Explore how functions provide reusable, modular blocks with specific inputs and outputs, define signatures, and call them across programs to compute results.
Explore file input and output, including how to create, open, read, write, and append to files, using read-only, write-only, read/write, and append modes with C++, Java, and Python examples.
Explore object oriented programming as thinking in objects with attributes and methods that interact, and learn how object oriented analysis and design map requirements to classes and interfaces.
Explore how objects and classes define data formats, procedures, and behavior in object oriented programming, with objects as instances and classes as the blueprint.
Learn the five key method terms in object-oriented programming: class variables, instance variables, member variables, class methods, and instance methods, and how they relate to class and object data.
Explore encapsulation and data hiding in object-oriented programming, binding data to methods and restricting external access with public, private, and protected interfaces.
Explore dynamic dispatch through message passing, where a method call triggers object-specific code and objects communicate via unidirectional messages that name methods and pass parameters.
Explore inheritance as the mechanism to extend base classes into derived subclasses, and examine single, multiple, multilevel, hierarchical, and hybrid inheritance with real-world class hierarchies.
Polymorphism in object oriented programming lets the same operation name behave differently across a circle, square, or other subclasses while the calling code stays agnostic to the specific type.
Master generalization and specialization by seeing how common characteristics form a superclass, how is-a relationships link subclasses, and how distinguishing features create specialized subclasses.
Explore links and associations in object-oriented concepts, define associations, links, and cardinality (one-to-one, one-to-many, many-to-many), with practical examples.
Discover Angular 8, an open-source framework using TypeScript to build web apps with components, services, and navigation. Learn why it remains stable, modular, and Google-supported with a declarative UI.
Set up the Angular 8 environment by verifying Node and npm versions, installing Node.js, and installing the Angular CLI, then choose and install a code editor like Visual Studio Code.
Create your first angular 8 project, set up with css, explore folders in vscode, and run ng serve to start the dev server on localhost:4200.
Explore the basic folder structure of a new Angular project, including app and source folders, node_modules, and key files like angular.json and package.json, with focus on components and modules.
Master sql with a three-step process that applies across Microsoft sql server, IBM db2, Oracle, MariaDB, Postgres, Informix, and MS Access, highlighting the universal logic of structured query language.
Discover why sql is essential for storing, manipulating, and retrieving data in relational databases and why it is the standard language for relational database systems powering web apps.
Install and configure a free, open-source web server stack by downloading and setting up Apache, MariaDB or MySQL, and SqlYog community edition as the database client.
Learn to start and stop core services from the control panel, including Apache and MySQL, track process IDs, and use the default MySQL port 3306, avoiding Tomcat.
Create your first database by connecting to the skill host as root, test the connection, and view the new database in the object browser with tables, views, and stored procedures.
Learn how to view databases using queries, execute drop database commands, and recreate databases, while understanding the risks of data loss and the importance of backups.
Learn how to create database tables, define columns such as id integer and name varchar(30), apply constraints like not null and primary key, and write basic create table queries.
Master essential database commands by creating and dropping tables, executing select queries, and inserting new rows with the insert into statement.
Learn the basics of insert statements in sql: use insert into table (columns) values (values), and know when to omit column names for all-columns inserts, with a students example.
learn how to create a new table from an existing table using a select statement, so the new table can copy all data from the original and produce result sets.
Master the basics of the select statement by selecting all columns with select *, or specific fields like name and ages from the students table, then execute to view results.
Master the where clause to filter records in select statements, using numeric conditions and quoted strings, and apply the same logic to update and delete operations.
Master SQL operators beyond equals, including greater than, greater or equal, less than, and less or equal, and combine conditions with and or to build precise queries.
Learn to update data with update queries to modify records and update selected rows, verify with a select, and see examples like renaming a student and setting grades to five.
Execute delete statements to remove records, such as delete from students where name = Chris. Delete all records by omitting the where clause, and verify changes in the table.
Discover how the like operator in the where clause uses wildcards, notably % for any characters, to match names containing mal or starting with chris.
Learn how to limit records across MySQL, MSSQL, and Oracle using limit, top, and rownum with practical examples and database-specific syntax.
Learn how to use the order by clause to sort data in ascending or descending order on one or more columns, with practical examples.
Learn how the group by clause works with a select statement to group identical data into groups, precede the order by clause, and compute aggregates by name.
Master the distinct keyword in SQL by using select distinct with from and where clauses to return only unique records and remove duplicates.
Learn how to delete data with truncate table, delete from, and drop table, and verify results with select, illustrating when to remove data or drop a table in SQL.
Explore how an Angular application is organised while strengthening the programming foundations around it. This course combines an introductory Angular 8 section with lessons on variables, control flow, functions, objects and SQL, making its wider learning scope clear from the outset.
The framework recordings introduce the development environment, a first Angular project and its component structure. Earlier sections revisit general coding ideas, while later database lessons cover creating tables, querying records, filtering, ordering and grouping results.
Use the material to examine
How a component fits into the structure of a small application.
Which responsibilities belong together and which should remain separate.
How a variable, condition or function contributes to visible behaviour.
Where a database query answers a different part of the application problem.
The final reading workshops connect the older examples with a deliberate review process. Inventory a project's dependencies, describe a small behaviour test and plan an update using official guidance. Another activity asks you to explain component boundaries before adding more Angular code. These exercises help make an older project's assumptions visible.
This course suits learners who want a broad foundations resource and a first look at Angular's structure. Basic familiarity with web development will help with the framework-specific material. Review the curriculum carefully if your main interest is Angular, because a substantial part of the course covers general programming and databases.
The videos use legacy Angular 8 and are not a complete course on the current Angular release. Consult current Angular documentation for installation, supported tools and migration instructions. Choose the course for conceptual orientation and a structured way to investigate the recorded examples.
Understanding an older Angular application
Angular 8 provides the explicit framework context for the recordings. This course connects that introduction with programming foundations and an SQL extension, then adds reading work on component boundaries and migration planning. The material is most useful when approached as something to understand before changing. A framework version tells you which environment shaped the examples; it does not remove the need to identify the input, responsibility and visible behaviour of each part of an application.
Using the fundamentals deliberately
Variables, types, decisions, loops, arrays and functions appear in the general programming sections. They can support a beginner or a learner revisiting an unclear concept before examining the framework. When a component example is confusing, ask whether the difficulty actually concerns the framework or the underlying program logic. A condition still selects a case, and a function still groups a responsibility. Understanding those operations makes it easier to follow a recorded application without treating every unfamiliar result as an Angular-specific problem.
Approaching the Angular section
The deeper Angular material introduces the version and examples shown in the recordings. Rather than starting by reproducing every dependency exactly, first identify the behaviour the example is meant to demonstrate. What information is supplied? Which part of the interface depends on it? What action changes the result? You can then compare that explanation with a compatible reproduction. Installation steps and dependency details may differ in another environment. The course does not promise a complete walkthrough of every current Angular facility or a guaranteed migration to a particular release.
Why component boundaries matter
The reading activity on component boundaries asks you to explain responsibilities before adding code. A boundary becomes useful when you can state what a component receives, what it displays or decides and what it communicates to another part of the application. Without that explanation, a growing interface can collect unrelated decisions in the same place. The exercise is not about creating the largest possible number of components. It is about making a division that another person can understand and that supports the behaviour you are trying to preserve.
Connecting OOP vocabulary with design
The broader object-oriented material introduces classes, methods and relationships. Use it as vocabulary for responsibility and collaboration, rather than as a requirement to make every example elaborate. A clear design should make its assumptions easier to inspect. If a component or supporting object needs information, identify where that information comes from. If it changes something, describe the result. This way of reading the course connects general programming concepts with application structure while remaining at the introductory level of the listed curriculum.
Understanding the SQL extension
The database sections introduce stored records and query concepts beyond the immediate interface. This is a useful connection, but a component's current state and a database record are not identical responsibilities. The course can help you recognise why both may exist in an application. It is not complete backend architecture or production database training. Keep the learning purpose of each section clear so that the additional technologies broaden your understanding instead of obscuring the Angular example you are currently studying.
Planning a migration before attempting one
The update workshop focuses on inventory, tests and a plan. A migration begins with knowing what exists: the application structure, dependencies and behaviours that matter. An inventory should support a decision, not merely collect names. Which parts are tied to an older toolchain? Which interactions should still work after a change? The reading exercise gives you a way to organise those questions. It does not claim that every older project can be upgraded by following one universal sequence or that a written plan proves compatibility.
Preserving observable behaviour
Before changing a version or dependency, describe a small set of interactions that reveal important behaviour. A normal case may not be enough; consider a state transition or a boundary relevant to your example. The purpose is to compare before and after with something more concrete than the impression that the page still looks similar. This is suggested reasoning around the workshop. A complete automated regression system, deployment pipeline or production upgrade service is not included by implication.
Selecting the course for its actual strengths
Choose this course if you want an introduction to the recorded Angular 8 context, a review of programming fundamentals or a planning exercise for understanding legacy code. Basic JavaScript or TypeScript familiarity will help with framework-specific material. Use current official documentation when selecting tools or implementation details for a newer project. The useful outcome is a clearer explanation of component responsibilities and a more reviewable set of migration questions. For comprehensive current Angular development, plan additional study matched to the version and project you intend to use.
Curriculum at a glance
Variables & Data Types
If-Statements and Conditional Logic
Loops and Iteration
Arrays
Functions & Files
Object-oriented Programming
Diving into Angular 8
Beyond Angular: From Angular to SQL - Using Databases to Store Data
A 3-Step Guide for Beginners