PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Create a new database and an inventory table.
The columns in the table will contain text, numeric and date attributes.
Populate the table with data using basic data entry screens.
Change a single row.
Change all the rows.
Field Properties: Setting
Add a new column to the table and populate the column.
Finding and Filtering Data
Extract all rows from a specific warehouse.
Extract all rows from multiple warehouses.
Search columns for a string.
Extract based on a range of values.
Use the LIKE clause to extract data.
Create a derived column.
Calculate values using an aggregate function.
Calculate a value using a scalar function.
Operators in Queries
Perform concatenation of string.
Reformat a string.
Execute basic mathematical expressions.
Perform data arithmetic.
Use the GUI to generate and execute SQL.
Code a simple join and subquery.
Action Queries: creating
Using SQL DMSL statement insert, change, and delete rows in the table.
Create a form to perform data entry on the inventory table.
Design a basic detail report.
Design multiple summary reports.
Design a detail report with sub totals and grand totals.
Display and print a report.
Modify the reports design and display the results.
Change the sort order of the report.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.