Treinamentos de Oracle

Oracle Database Develop PL-SQL Program Units Ed 2

Oracle Database Develop PL-SQL Program Units Ed 2

Course overview for course Oracle Database Develop PL-SQL Program Units Ed 2 The Oracle Database Develop PL-SQL Program Units Ed 2 course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers. Learn To Create, and execute stored procedures and functions. Design and use PL/SQL packages. Create overloaded package subprograms for more flexibility. Utilize Oracle-Supplied Packages Continue lendo

Oracle Database Program with PL-SQL

Oracle Database Program with PL-SQL

Course overview for Oracle Database Program with PL-SQL This Oracle Database Program with PL-SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more. Objectives of the course Oracle Database Program with PL-SQL Manage dependencies between PL/SQL subprograms Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors) Create stored procedures and functions Use conditional compilation to Continue lendo

Oracle Database PL/SQL Fundamentals Ed 2

Oracle Database PL/SQL Fundamentals Ed 2

Course overview of the couse Oracle Database PL/SQL Fundamentals Ed 2 The Oracle Database PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code. Learn To: Use various features of PL/SQL. Write anonymous blocks of code in PL/SQL. Use various PL/SQL conditional constructs and loops in program blocks. Interface the PL/SQL code with the database. Use stored procedures and functions in their program blocks. Handle Exceptions in PL/SQL code. Course Information Delivery Continue lendo

Oracle Database SQL and PL-SQL Fundamentals Ed 2

Oracle Database SQL and PL-SQL Fundamentals Ed 2

Course overview of the course Oracle Database SQL and PL-SQL Fundamentals Ed 2 This Oracle Database SQL and PL-SQL Fundamentals Ed 2 training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You’ll explore the concepts of relational databases. Learn To Write queries against single and multiple tables, manipulate data in tables and create database objects. Use single row functions to customize output. Invoke conversion functions and conditional expressions. Use group functions to report aggregated data. Continue lendo

Oracle Database Introduction to SQL Ed 2

Oracle Database Introduction to SQL Ed 2

Course overview for the course Oracle Database Introduction to SQL Ed 2 This Oracle Database Introduction to SQL Ed 2 training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Learn To Understand the basic concepts of relational databases ensure refined code by developers. Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database access to specific objects. Manage schema objects. Manage objects Continue lendo

Oracle Database SQL Workshop II Ed 2

Oracle Database SQL Workshop II Ed 2

Course overview for Oracle Database SQL Workshop II Ed 2 The Oracle Database SQL Workshop II Ed 2 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions. Course Information Delivery Method: Classroom Course Duration: 2 days Course Level: Advanced Audience Summary Oracle Databases Administrators PL/SQL Developers Prerequisites for the course Oracle Database SQL Workshop II Ed Continue lendo

Oracle Database SQL Workshop I Ed 2

Oracle Database SQL Workshop I Ed 2

Course overview for Oracle Database SQL Workshop I Ed 2 The Oracle Database SQL Workshop I Ed 2 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Course Information Delivery Continue lendo