Delphi Practical Advanced Course With SQL

Explore inserting into unsorted and sorted arrays, determine insertion points via input or comparison, shift elements right, update counts, and handle full arrays with a new array.

Remove an element from an array in Delphi by locating its position and shifting elements left, with unsorted and sorted array scenarios and a practical code walkthrough.

Master removing duplicate elements from an array in Delphi by building a separate array of unique values, comparing each element to subsequent ones, and preserving the original data.

Learn how to merge two arrays by creating a new array with combined size, copying the first then the second array, and optionally deduplicating to produce a final merged array.

Learn how to compute the intersection of two arrays by looping through each element, using a boolean flag to collect common values into a third array.

Learn how to use string grids in Delphi to display two-dimensional arrays as a multiplication table. Configure column and row counts, address cells, and populate values with nested for loops.

Explore two dimensional arrays in Delphi by building a grid of student marks across subjects and quarters, using nested loops to populate with random values and compute totals and averages.

Learn to read a csv file into a 2d array in a Delphi project and display it in a grid, including parsing csv columns and handling file existence.

Learn objects as class instances with properties and methods, see how to create, reuse, and manage user-created objects in Delphi, including how to instantiate them and manage memory.

Create a boxer object with attributes such as name, age, and weight, and add methods to determine weight class and registration details, using private and public sections.

Explore object methods in Delphi with a boxer class, mastering mutators, accessors, and auxiliary methods, and implementing a constructor, the two string function, and weight class logic.

Learn to define and use a boxer object in Delphi, including attributes, mutators, accessors, constructors, and destructors, and apply five-step object usage from import to free.

Learn to work with objects and arrays by building a boxer class, creating an array of boxer objects, and displaying formatted output with toString.

Explore inserting into multi-tabled databases in Delphi, focusing on parent and child tables, normalization, and referential integrity. Validate primary and foreign keys and use selections to ensure valid activity references.

Delete records in a multi-table Delphi SQL database by removing child learner rows before deleting the parent activity to maintain referential integrity, with prompts and cascading delete options.

Update a learner’s payable amount for a selected activity in a multi-table database, honoring the parent-child integrity constraint and applying a voucher amount and user feedback.

Create a learner object to store id, name, and amount paid, with a calculated amount due and a to-string display for reuse.

Learn to query data with SQL in Delphi, using select, from, and where clauses to fetch fields from the learners table, apply conditions, and use wildcards.

Master SQL basics by learning select statements, from clauses, and where filters, using star and wildcard, like, greater than, less than, and, or, not logic with learners and activities tables.

Master SQL basics by using select statements and where clauses, including is null, is not null, between, and in, with hands-on practice on the learner table.

Learn advanced SQL wildcard patterns using star and question mark to match names such as containing 'll', ending in 'n', or starting with 'l', plus Delphi equivalents.

Dive into advanced sql queries by joining multiple tables using from and where clauses, apply aliases to simplify field references, and use distinct and order by to refine results.

Explore advanced SQL calculations by creating calculated fields, aliasing with as, and using format, round, and int to compute totals, currency values, and due amounts.

Master advanced date handling in SQL by using hash delimiters for dates, applying between and comparison operators, and extracting year, month, and day to calculate ages and filter records.

Explore aggregate functions like count, min, max, sum, and average, and learn how group by and having clauses produce class-level statistics and filtered dashboards.

Explore advanced SQL string functions, including left, right, mid, length, and upper/lower case, with examples that extract initials, get middle substrings, and chain functions while noting aliasing and reserved words.

Learn how to insert data using SQL insert into, specifying the learner table and fields, supplying values, handling nulls, dates in hash format, and respecting primary keys.

Master the SQL update command to modify data in the learners table using set and where clauses, with backups to avoid updating all rows.

Learn to delete data using delete from, apply precise where clauses, and safeguard records with backups; explore subqueries and in-clauses for targeted deletions.

Learn to run SQL queries in Delphi using an AdoQuery, build a form and data module, and filter learners by name, class, or paid amount with parameterized SQL.

Master Delphi sql insert workflows using a data module and query, building and executing multi-line inserts, then displaying results in a data grid.

Execute a Delphi SQL update by building and executing an update query, handling quotes with a quoted string function, and updating a learner's surname by ID, then verify results.

Demonstrates implementing a delete operation in Delphi with SQL, including building a delete statement, executing it, and refreshing the data grid after deletion.