Course Outline
This course is designed to provide the practical knowledge necessary to generate SQL queries in a variety of SQL enabled tools such as the Crystal Report Writer, Microsoft Reporting Services, Excel or similar. In our classroom environment through practical examples a large selection of SQL statements are examined including data selection, sorting, grouping, search criteria, calculations and temporary tables.
The following details the topics covered in our 2 day SQL Fundamentals course.
Topics
• The SELECT statement
• Selecting specific columns from the table . .
• Sorting the Rows
• Using both Ascending and Descending
• Sorting on Multiple Columns
• Using the WHERE Clause
• Using Relational Operators
• Using Comparison Conditions
• Forming Compound Conditions
• Using Display Labels
• Using Aggregated Functions
• Multiple Table Selects
• Creating a Cartesian Product
• Creating Outer Joins
• Using temporary tables
• Creating Views
• Using a GROUP BY Clause
• Using a HAVING Clause
Who Should Attend:
This course is designed for anyone intending to use products such as Crystal Report Writer, Microsoft Reporting Services, Excel or other similar SQL enables tools to access and extract data held in a relational database.