Angular 5 - A 3-Step Process to Master Angular for Beginners

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 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.

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.