Database Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of Database Implementation and Administration




Total 800 training courses and degree programs available around the world.

United States - United Kingdom - Canada - Australia - India

Popular courses:
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Recovering Messaging Servers and Databases using Microsoft Exchange Server 2007
Database Management
Database Management Systems
Database Administration


Relational Database Design

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This class is a lecture/discussion format class which focuses exclusively on relational database design. Though some computer programs will be referenced in this class, the references to those programs are meant to help guide your building of relational databases. This class will focus exclusively on relational database design.

Prerequisites

For this course, a basic understanding of Windows and a spreadsheet program like Microsoft Excel is what you will need. If you have worked with data in any way, shape, or form, you will do just fine in this class.

Provisioning SQL Databases

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Prerequisites

This course requires that you meet the following prerequisites:
-Basic knowledge of the Microsoft Windows operating system and its core functionality.
-Working knowledge of Transact-SQL.
-Working knowledge of relational databases.
-Some experience with database design

Performance Tuning and Optimizing SQL Databases

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:
-Basic knowledge of the Microsoft Windows operating system and its core functionality.
-Working knowledge of database administration and maintenance
-Working knowledge of Transact-SQL.

Developing Microsoft SQL Server Databases

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.
This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2014 product features and technologies for implementing a database.
The secondary audiences for this course are individuals who are developers from other product platforms or previous versions of SQL Server looking to become skilled in the implementation of a SQL Server 2014 database.

Introduction to SQL Databases

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Administering Microsoft SQL Server 2012 Databases

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Below are some of the new features of SQL Server that have been discussed in this course:
Discussion around servicing SQL Server (Service Packs, Cumulative Updates, Hotfixes)
SQL Server use of automated update
Partial database containment
Users with passwords (contained users)
User-defined server roles
In-place upgrades of data-tier applications
Appendix with intro to AlwaysOn, High Availability and Replication concepts

After completing this course, students will be able to:
Plan and install SQL Server.
Describes the system databases, the physical structure of databases and the most common configuration options related to them.
Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
Create SQL Server Backups.
Restore SQL Server dat... [Read More]

Developing SQL Databases

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

After completing this course, students will be able to:
Design and Implement Tables.
Describe advanced table designs
Ensure Data Integrity through Constraints.
Describe indexes, including Optimized and Columnstore indexes
Design and Implement Views.
Design and Implement Stored Procedures.
Design and Implement User Defined Functions.
Respond to data manipulation using triggers.
Design and Implement In-Memory Tables.
Implement Managed Code in SQL Server.
Store and Query XML Data.
Work with Spatial Data.
Store and Query Blobs and Text Documents.

Audience

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.
The secondary audiences for this course are individuals who are developers from other... [Read More]

Performance Tuning and Optimizing SQL Databases

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

After completing this course, students will be able to:
Describe the high level architectural overview of SQL Server and its various components.
Describe the SQL Server execution model, waits and queues.
Describe core I/O concepts, Storage Area Networks and performance testing.
Describe architectural concepts and best practices related to data files for user databases and TempDB.
Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
Explain data collection strategy and techniques to analyze collected data.
Understand techniques to identify and diagnose bottlenecks to impro... [Read More]

Administering Microsoft SQL Server 2014 Databases

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This five-day instructor-led Microsoft SQL Server Database course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

After completing this course, students will be able to:
Plan and install SQL Server.
Describe system databases, the physical structure of databases, and the most common configuration options related to them.
Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.
Back up SQL Server databases.
Restore SQL Server databases.
Import and export data by using wizards, the bulk copy utility, and data-tier applications.
Work with SQL Server security models, logins, users, and contained databases.
Work with server roles and database roles.
Use permissions to secure resources.
Use SQL Server audit and Transparent Data Encryption.
Work with SQL Server Agent to configure and execute jobs.
Implement SQL Server Agen... [Read More]

Oracle Database Administration

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle Database Administration Training will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class.

The course is inteded for non-Oracle database administrators, application developers, and system administrators.

Overview of Oracle Database
ORACLE_HOME and ORACLE_SID
The Oracle Database vs. The Oracle Instance
Instance Memory Structures
Background Processes
Server Processes
Datafiles
Blocks, Extents, and Segments
Control Files
Redo Logs
The Oracle Architecture
SYS and SYSTEM Users

Starting and Shutting Down an Oracle Database
SYSDBA and SYSOPER System Privileges
Oracle Database Startup
Oracle Database Shutdown
Altering Database Availability
Suspending and Resuming... [Read More]

Oracle Database 11g: Administration Workshop 1

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students 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.

Learning Objectives

Describe Oracle Database Architecture
Install and configure Oracle Database 11g
Configure Oracle Net services
Manage the database storage structures
Create and administer user accounts
Perform basic backup and recovery of a database
Manage users and schemas
Manage data and concurrency
Monitor and administer undo data
Backup and recover a database
Monitor performance
Use the database diagnostic monitor

Oracle Database 11g R2: PL/SQL Fundamentals

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle 11g course will provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming.

This course equips students to develop database server-side PL/SQL program units within an Oracle database. In addition to receiving the print copy of this course book, all students will receive e-Learning modules.

Course Outline

Choosing a SQL &, PL/SQL Interface
Using SQL Developer
Using SQL *Plus
Using Application Express
Using JDeveloper Studio

Language Features
Understanding PL/SQL
Structure of a PL/SQL Program Block
Using PL/SQL from SQL *Plus

Declare Clause
About the Declare Clause
Declare Simple Types
Declare Complex Types
Type ... Table
Type ... Record

Begin Clause
About the Begin Clause
Performing Data Manipulation
Logic Control &, Branching
Loop
If-Then-Else
Case

Exception Cl... [Read More]

Oracle Database 11g R2: Grid Infrastructure & ASM

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V



This training course provides a step-by-step guide for configuring and using the Oracle Grid Infrastructure in a single server environment, and it forms the basis for expanding this infrastructure to a clustered server configuration.

Advanced database and storage administration tasks are considered, including Oracle Restart and Automatic Storage Management (ASM).

With this course you will learn about:
Preparing a host system for the Grid Infrastructure and Oracle RDBMS installations and performing those installations.
Preparing a host system for ASM storage management.
Partitioning and configuration of storage devices for ASM storage on both Linux and MS Windows servers.
Utilizing Oracle Restart for automatic sequencing and restarting of Oracle software components.
Obtain an introduction to Oracle High-Availability Services including the Server Control and Clusterware Control utilities.
Review the Oracle server stack architecture including operating system virtualization and storage subsystem virtualization layers.
Using ASM for storage of some or all database files, thereby providing a d... [Read More]

Oracle Database 11g R2: Encryption & Advanced Data Security

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Threats to data security abound and are increasing in sophistication and frequency. Organizations have both an ethical and oftentimes a legal responsibility to understand the countermeasures available, to compare these against those threats to which they are exposed, and to properly apply such countermeasures.

This training course module considers how encryption technology should, and should not, be employed within an Oracle database environment in response to known threats and risks. It will also discuss other best security practices which pertain to application security, host system configuration and the database installation.

Within this training course we will discuss these topics:
Consider examples of common security threats and sensitive data which might exist within an organization.
Review the essentials of a sound and secure database installation.
Consider known database security weaknesses and how these may be addressed.
Consider examples of specific attacks which could be launched against individual components within a data center or within the public networks.
Review the theory and concepts which underl... [Read More]

Oracle Database 11g R2: Data Warehousing & Oracle Warehouse Builder

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle 11g course will highlight the features within the Oracle database specifically intended to support data warehouses and data mining operations.

Concepts include data warehousing and the requirements to initially configure a data warehouse installation. Aditionnal concepts are how the Oracle Warehouse Builder (OWB) product may be used to implement and maintain both transactional and warehouse databases, and the movement of data between those two different types of installations.

This course highlights the features within the Oracle database specifically intended to support data warehouses and data mining operations.
Data warehousing concepts and the requirements to initially configure a data warehouse installation.
How the Oracle Warehouse Builder (OWB) product may be used to implement and maintain both transactional and warehouse databases, and the movement of data between those two different types of installations.

Among the specific topics considered within this course are:
Understanding star and snowflake schemas and other data warehouse physical and logical database objects.
Understanding and enc... [Read More]

Oracle Database 11g R2: Advanced PL/SQL Programming & Tuning

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle 11g course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. The PL/SQL programming language is at the core of most Oracle database applications.

First, we will explore the advanced features of the language which allow powerful and effective database applications to be built.

Next, we will discuss performance tuning techniques which allows these applications to run efficiently.

Finally, we will consider critical security measures which should be implemented to counter hacker attacks and other security threats. In addition to receiving the print copy of this course book, all students will receive e-Learning modules.

Among the specific topics contained within these training materials are:
Invoking external procedures and integrating these into PL/SQL applications. These include external Java classes using the JDBC interface and external C programs contained within DLL libraries.
Using dynamic SQL to extend the functionality and flexibility of database programs, including the DBMS_SQL() system-supplied package for maximum flexibility.
Identifyin... [Read More]

Oracle Database 11g R2: Administration I

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of database administrators. While it is true that the hardware and software platforms on which the DBMS runs have become increasingly complex, as has the database software itself, the capabilities provided by the Oracle database have correspondingly become more sophisticated.

The overall objective of this training course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. These training materials are the starting point for Oracle database administrators and sets the foundation for advanced administrator training and certification. Major tasks to be considered within this course are:
Configuration of the Linux and MS Windows operating systems in anticipation of a database installation
Server Class installation of the Oracle 11g R2 Enterprise Edition database
Verification of a valid database installation
Database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and te... [Read More]

Oracle Database 11g R2: Administration II

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. Important subject areas include advanced database configuration, performance monitoring and tuning, configuring for recovery, troubleshooting and fault diagnosis, and use of the extensive advisory framework. Sometimes configuration and operational problems can exist within an Oracle database installation because important technologies are either not fully understood or not properly implemented.

Advanced technologies which should be applied to any mission-critical database installation. The Database Resource Manager is an essential tool for database tuning and achieving optimum performance, and is often used in combination with the advisors. The Database Scheduler is a sophisticated tool which can automate many administration tasks and integrate the database into the larger data center and systems infrastructure. All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery s... [Read More]

Oracle 10g Database on Enterprise Linux

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 10g Database on Enterprise Linux. Students will learn how to configure the Linux operating system for optimal performance with an Oracle database. Then they will install and create an Oracle 10g database on Linux. In addition, the students will also learn how to tune the database to take advantage of the Linux operating system and the Enterprise level features of the OS.

Introduction to Linux
Kernel Version Information
Common Linux Commands
Navigating the File System
Using the Virtual File System
The Basics of Bash Shell Scripting

Preparing Oracle
Setting Shared Memory Parameters
Setting Semaphore Parameters
Managing Packages
Configuring the X Window System
Creating the Necessary Linux Users

Installing Oracle on Linux
File System Security
Setting Environment Variables
Creating Oracle Directories
Managing Multiple Version of Oracle Software
Using the Oracle Universal Installer
Installation Pre-requisites
Read More]

MySQL

Course Format: Classroom
School/Trainer: GTC Economic Development and Corporate Training
Training Center(s)/Venue(s): Greenville, Simpsonville, Taylors, United States
  V

This course will give students the skills they need to set up and manage a MySQL database. Students will learn the basics of designing a relational database and learn to use SQL statements to create databases, tables and manage data in the data tables. Students will create a MySQL database and will identify the types of data that can be stored in data tables. Students will use the PHPMyAdmin tool to view and manage their MySQL databases. Students will learn to write applications which use MySQL databases.

•Students will install MySQL, connect to the MySQL database application and create a database and set up users for their database.
•Students will design a relational database.
•Students will use MySQL commands to define a database and tables.
•Students will add records to their database, edit records, delete records and select records.
•Students will use MySQL functions to work with database data.
•Students will explore tools, applications and programming environments that work with MySQL.
•Students will work with transactions and advanced SQL queries.
•Students will explore feature that are new to MySQL 5.
•Students wil... [Read More]

Pages: 1 2 3 4 5 6 ...


Find Database training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - New Zealand
Pakistan - Philippines - Singapore - South Africa - United Arab Emirates
United Kingdom - United States



Tips:
You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.



- Other Topics -
- Online/E-learning -
Database
Ask for Training
Add Courses