Vi ste ovdje
Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.
Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.
Prerequisites
Familiarity with data processing concepts and techniques
Expected Duration (hours)
1.8
Lesson Objectives
Oracle Database 11g: Subqueries and Regular Expressions
identify the steps for writing multiple-column and scalar subqueries.
recognize the steps for...
Overview/Description
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
1.9
Lesson Objectives
Oracle Database 11g: Getting Started With PL/SQL
recognize the features...
Overview/Description
To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
1.3
Lesson Objectives
Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures
recognize the steps for performing...
Overview/Description
To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
1.7
Lesson Objectives
Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors
recognize the steps for creating user...
Overview/Description
To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors
identify the steps for trapping...
Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
2.3
Lesson Objectives
Oracle Database 11g: Subprograms, Packages, and Exception Handling
identify the benefits of modularized and layered...
Overview/Description
To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
2.3
Lesson Objectives
Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations
recognize the steps for overloading...
Overview/Description
To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g: Using Triggers and the PL/SQL Compiler
identify the steps for creating and using...
Overview/Description
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
1.3
Lesson Objectives
Oracle Database 11g: PL/SQL Code and Dependency Management
identify the steps for selectively including PL/SQL source code by using conditional...
Overview/Description
Planning SQL Server infrastructure includes planning from the hardware up all the way to individual table configurations. This course addresses the activities involved in planning database physical and logical structures using the Microsoft Planning and Assessment Toolkit, implementing policy-based management, and managing SQL Server with System Center. This course is part of a series of Skillsoft courses that covers the objectives for exam 70-465. This exam is required for the certification MCSE: Data Platform.
Target Audience
Database professionals who design 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
