C++ - A 3-Step Process to Master C++ in 7 days for Beginners

Explore how if statements use boolean conditions with else if and else blocks to control which commands run, illustrated by a simple calculator example.

Learn loops and iteration in C++ by using while and do-while constructs to print hello world multiple times, control repetition with a condition, and prevent endless loops.

Learn how to use single-dimensional arrays in C to store multiple values, declare and initialize an array, and access elements by 0-based indices with contiguous memory, including printing results.

Explore how one-dimensional arrays become two-dimensional and three-dimensional arrays to store multi-class, multi-school student data, using indices and array size concepts to manage dimensions.

Explore multidimensional arrays with two-dimensional matrices indexed by row and column, using zero-based indexing for reviewers and movies. Declare a 3x4 rating matrix and compute a reviewer's average.

Understand that a function is a reusable block of code with specific inputs and outputs, enabling modularity and code reuse.

Master file input and output in C++ by learning to open, read, write, append, and read-write modes for handling text files.

Explore the fundamentals of object oriented programming, focusing on objects, attributes, and methods, and learn how object interactions drive modular, reusable software from analysis to design and coding.

Explore objects and classes as the core of object-oriented programming, where classes define data and methods and objects are instances, with examples like a circle's center, radius, and area operations.

Explore five types of methods and variables in object oriented programming: class variables, instance variables, member variables, class methods, and instance methods, and how they relate to classes and objects.

Master encapsulation and data hiding by binding data with its manipulating methods and restricting access with public, private, and protected access, enabling decoupled, maintainable classes.

Discover how dynamic dispatch enables message passing, letting objects select the code to run on a method call. Explore communication via messages, invoking class methods in unidirectional interactions across processes.

Explore how inheritance lets derived classes extend base classes, reuse methods, and model real-world relationships, from single to multiple, multilevel, hierarchical, and hybrid inheritance.

Polymorphism lets code treat circles and squares through a common interface, with a single draw method behaving differently per subclass, as shown by circle, square, cat, and dog examples.

Explore generalization and specialization in object-oriented design, where common characteristics form a superclass and distinguishing features create specialized subclasses, guiding when to generalize or specialize in a project.

Learn how links and associations define relationships between objects in classes, with cardinalities like one-to-one, one-to-many, and many-to-many, and see their use in databases and object-oriented programming.

Master sql through a three-step process that applies across popular relational databases, including mysql, oracle, postgresql, and ms access, focusing on retrieval and data management concepts.

SQL, the structured query language, enables storing and manipulating data in relational databases. Most popular web and mobile apps rely on SQL for creating and dropping databases and tables.

Install and configure XAMPP to run Apache, MySQL (MariaDB), and PHP locally, then install SQLYOG Community Edition as the database client.

Start and stop the apache web server and the mysql server to serve web pages and use the database, monitor server status, observe port 3306, and note the process ids.

Create your first database by connecting to the local server as root, using an empty password for the test version, then run create database my new test database.

Master the basics of database management by executing show databases and drop database queries, learning how to recreate a dropped database, and understanding the risks of data loss.

Learn to create a student table with id as integer, name as varchar(30), and grade as integer. Define a primary key on id and use decimal for degree as needed.

Explore how to drop a table in SQL, verify consequences with a select, and then use insert into to add new rows, reinforcing table management basics.

Learn how to use insert statements to add data into a table, specifying columns or omitting them with values, and verify results by refreshing the table.

Learn to create a new table from an existing table using select statements, duplicating all data with create table as select *, and view the results as a result set.

Master the basic select statement syntax to retrieve all columns or specific fields, such as names and ages, from a student table and refine results with targeted column names.

Master the where clause in basic select queries to filter records from a table, using conditions with integers or quoted strings and preparing for updates or deletes.

Learn sql operators beyond equality, including greater than, less than, and, or, to filter data. Example: select name and age from students where age > 8 and name = Tim.

Learn to update data using update queries to modify specific records, using where conditions, and apply updates to multiple columns or all rows in a table.

Learn to delete data using delete statements, including delete from students where name equals Chris, and delete all records with delete from a table.

Use the like operator in a where clause with wildcard characters such as % to filter names by partial matches, including starting with 'Chris' or containing 'MAL'.

Learn how to limit results in MySQL, MSSQL, and Oracle using limit, top, and rownum, with side-by-side syntax examples to return the top n records.

Learn how to use the order by clause to sort query results in ascending or descending order, including multiple columns and ensuring the sort columns appear in the select list.

Learn how to use the group by clause with a select statement to group identical data by name, and then summarize with counts and sums, before ordering by name.

Learn how to use the distinct keyword with select to return only unique records and eliminate duplicates in sql queries.

Learn how to use truncate table to delete all records while preserving the table structure. Compare truncate with delete and drop table for removing data or the entire table.