Revenue & Benefits: SQL/QBF - Live Training

Interested in SQL/QBF syntax? Fill out this training request form.

Duration: 3 Days

Key Topics

• Connecting to a database
• Use of QBF to retrieve information
• Using QBF to update single or multiple rows / fields
• Usage of SQL as both a query and update tool
• Command language utilized in SQL
• Using mathematical functions in SQL
• Data types, nulls and defaults
• Understanding how tables join to create complex queries
• Creation of temporary tables
• Using SQL as an update tool
• Ability to create and manipulate look-up tables from existing tables or other sources such as .csv files
• Text Editing using Vi
• Working with Directories
• Working with Files
• Saving and Printing SQLs and output

Audience

• System Administrators

Outcome

• Be able to use the SQL functions, create bespoke SQLs, bulk updates and changes, using QBF to edit data plus give you a greater understanding of the database architecture