Database 101 For Support Professionals

This database class is geared towards support professionals. This is not a DBA course, rather, its purpose is to teach support professionals how to navigate around a database and provide basic support functions.

Course Objectives:

• Learn footprint/architecture of four mainstream databases:
  • Oracle
  • Sybase
  • Microsoft SQLServer
  • MySQL
• Practice starting/stopping the database
• Examine configuration and error logs
• Learn how to do basic support such as:
• Check space
• Check locks
• Examine users/processes/connections
• Learn basic syntax for DML (Data Manipulation Language) statements such as Insert, Update, Delete, and Select
• Provide and overview of database objects such as triggers, procedures, functions, etc.

Lab Exercises (for each database):

• Start/Stop database under normal conditions
• Start/Stop database under failed conditions and correct
• Analyze error logs
• Analyze footprint on disk and in memory
• Show how to list processes
• Show how to list users
• Show how to examine disk space usage
• Determine if transactions are blocked and why