Vi ste ovdje
Overview/Description
SQL Server 2012 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio tool. Using Transact-SQL you can select data from a databaseâs tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic Transact-SQL statements that can be used to...
Overview/Description
Microsoft SQL Server 2012 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2012 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then mapping the logins to the databases within the instance. Administrators also have the ability to encrypt a SQL Server instance using transparent data encryption (TDE) and to encrypt the data within a database using encryption certificates...
Overview/Description
To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: Creating Databases Release 2
identify the files and logical storage units that make up the Oracle database.
recognize the characteristics of the Oracle instance and its management interfaces.
distinguish between the...
Overview/Description
To explain the fundamentals of Oracle database control and how to use tablespaces
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: Database Control and Storage Structures Release 2
recognize how to use the Oracle Database 10g management framework.
recognize how to start up and shut down an Oracle 10g database.
identify the characteristics of initialization parameters and the alert log and...
Overview/Description
To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
3.0
Lesson ObjectivesOracle Database 10g: Database Interfaces Release 2
identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.
recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data.
recognize how to...
Overview/Description
To introduce the concepts of RDBMS and Oracle database administration, and explain how to install Oracle Database 10g software
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: Installing Oracle Database 10g Release 2
recognize the characteristics of a relational database system.
identify the basic tasks and tools involved in Oracle database administration.
identify the basic concepts involved in...
Overview/Description
To discuss how to manage backup and recovery in an Oracle 10g database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
4.0
Lesson ObjectivesOracle Database 10g: Managing Backup and Recovery Release 2
recognize the types of database failure that can occur in an Oracle 10g database and identify possible solutions.
recognize how to tune instance recovery and configure a database for maximum recoverability.
recognize how to multiplex the...
Overview/Description
To demonstrate how to manage schema objects and data in an Oracle 10g database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
3.0
Lesson ObjectivesOracle Database 10g: Managing Schema Objects and Data Release 2
identify the basic features of objects in a database schema.
recognize how to create and modify tables in an Oracle 10g database.
create, delete, and modify tables in an Oracle 10g database.
recognize the most common index types...
Overview/Description
To discuss how to manage undo data and manage lock conflicts in an Oracle database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
1.8
Lesson ObjectivesOracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
identify factors to take into consideration when managing undo.
recognize how to estimate required tablespace size and resize a tablespace in a given scenario.
calculate undo tablespace sizing and resize an undo...
Overview/Description
To recognize how various new features are used in Oracle 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: Miscellaneous New Features
recognize the new transaction and statistics monitoring enhancements in Oracle Database 10g.
recognize how tracing, statistical information gathering, and client and...
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
