Database Admin school training courses in Austin, TX (public, in-house or online)

This course covers database administration as a managerial discipline, addressing database administrative practices and procedures common for various types of businesses and technology. Important issues in daily operation and long-term planning of database administration are examined in depth. Administration of Oracle database management systems is also introduced to enhance students’ understanding of database administrators’ tasks and responsibilities

The Oracle Certification Program begins with the Associate level. At this apprentice skill level, Oracle Certified Associates have a foundation of knowledge that will allow them to act as a junior team member working with database administrators or application developers. When you are ready to advance your Oracle database expertise then it’s time to take the next step toward becoming an Oracle Certified Professional. Oracle Certified DBAs have proven skills managing a large-scale database o...

Full archival course description>>

Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for th...

Full archival course description>>

This course introduces students to the responsibilities of a database administrator (DBA). You will learn the underlying architecture of the Oracle database server and the essential tasks required to manage databases such as how to start up and shut down an Oracle instance. You will also learn the components that comprise a database, practice creating a database, importing data into its tables, and securing the database. Finally, you will learn how to troubleshoot real-life scenarios. This cour...

Full archival course description>>

After completing this SQL Server 2008 R2 training course, students will be able to:
Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
Plan, install and configure SQL Server 2008 R2
Backup and restore databases
Import and export wizards and explain how they relate to SSIS
Use BCP and BULK INSERT to import data
Manage security
Assign, configure fixed database roles and create and assign user defined database roles
Full archival course description>>