Database Management

Description:
The goal of this course is to provide information technology profesionals with the knowledge and skills necessary to successfully manage databases and develop database based applications.

Relational databases today drive most critical legacy, desktop and Web-enabled applications. Designing a database that accurately and completely captures user requirements is vital for success. Managing database so that it performs at its maximum is equally important. This course provides a comprehensive foundation for designing, building, and working with relational databases. It follows the development process path from database software installation, database and application design to effective use of relational databases in computing environment. From administrative viewpoint it focuses on using SQL language and available GUI tools to conduct common database activities.

Hands-on activities, guided walk-throughs, use-case scenarios and best practices are used to reinforce learning.

Audience:
Data Analysts, developers, future DBAs and anyone involved in designing, building and using relational databases, implementing database applications, or managing database development projects.

Prerequisites:
Basic computing skills. Knowledge of operating systems such as Microsoft Windows or Linux. Strong personal interest for database systems.

Objectives:
Upon completion of this training, the student should be able to:

• Perform installation of database software
• Understand database concepts
• Develop a data model to describe an application's data
• Create database objects
• Look up the structure of a database
• Query and manipul ate data
• Import and export data from and to a spreadsheet
• Modify user privileges and monitor user actions
• Perform database health and security checks
• Perform database backup and recovery

Format:
This class, including hands-on activities, is offered as a private, instructor-led class taught at a instructor’s facility on one week for up to 9 students.

For additional information please call us at 312.804.0772 or send us an email at abrar@ecgmn.com or use our contact form.

Home Page