Instructor Led Aggregate Functions Training Classes
From Last Minute Training
SQL Fundamentals of Querying
...ge.
* Recognize proper syntax for an SQL statement.
* Use aggregate functions, column aliases, and mathematical expressions in a query statement.
* Use the WHERE clause to select specific rows of information from a database.
* Search for specific character strings or numeric data in a database.
* Write queries that return both aggregate and non-aggregate information simultaneously.
* Write
more...
From NACE EDUCATION
My SQL
...
* Grouping rows together
* Using group by
* Multiple aggregate functions
* Grouping by multiple fields
* Using group by with other where
* Sorting group by queries
* Using group by with multiple tables
* More multi-table group by queries
* Selecting groups by their aggregate value
* where and having
* where and having example
* Inner joins (SQL inner join syntax)
*
more...
From The Career Center
SQL - Structured Query Language
...:
Recognize proper syntax for an SQL statement.
Use aggregate functions, column aliases, and mathematical expressions in a query statement.
Use the WHERE clause to select specific rows of information from a database.
Search for specific character strings or numeric data in a database.
Write queries that return both aggregate and non-aggregate information simultaneously.
Write
more...
SQL Database Design & Implementation
This course teaches you how to use the Transact-SQL language to query and program Microsoft
SQL Server 2000 in a Windows Server Server environment. This course also assists you in preparing
for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator
Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise
Edition.
Upon successful
more...
