Delphi Practical Advanced Course With SQL

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.

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

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.

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