Title: Delphi Win32 - Building Database Application – P6
Duration: 19:36 min
Description: In this video, we will start discussion about SQL, specifically we will talking about query data with SQL.We will learn about query data with very simple SQL command with basic query statement. Next, we will talk more detail about query operator, such as like, between, in, or is null. We also will talk about grouping in SQL including aggregate functions and group expressions. Another topic we will cover in this video is about join, including normal join, left join, right join, and full outer join. And the last topic in this video is about nested selection.
Methodology: We use IBExpert as user interface to run the SQL commands. We start with very simple example and continue with more complex statements.
Technology Used : Firebird, IBExpert, SQL.
Example Constructed: We will create SQL statements to display all data of employee table. Then we will use the where expression to limit the results. The expression including usage of logical, like, in, and between operators. We also use the employee table to learn about aggregate function. We will create a very simple version of Employee and Department table to learn about join, including left join, right join, and full outer join.
Keyword: SQL, select, aggregate function, query operators, grouping, join.