Курс Oracle PL/SQL Fundamentals vol. I & II

4.4
4 397 комментариев
Payment
Обучение платное
Certificate
Сертификация бесплатная
Duration
20 часов курса
О курсе

In this Oracle 11g PL/SQL Bundle you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Программа
Oracle 11g PL/SQL Fundamentals I
Introduction
The instructor has provided additional resources and example files for you to use.If you would like to access these, please download the attached .zip file, which contains the files shown in this course.
Course Setup
Selecting the Appropriate Database Tool
Understanding PL/SQL
PL/SQL Blocks
Working with SQL Plus
DECLARE Clause Objects
PL/SQL Available Data Types
Declaring Simple Data Types and Assignments
Declaring Complex Data Types and Assignments
Declaring Complex RowTypes and Assignments
Требования
  • Familiarity with database and programming principles
Что Вы изучите?
  • Over 90 lectures and 20 hours of content
  • Prepare your enviornment
  • Introducing Database Program Units
  • Creating and Maintaining Packages
  • Using System-Supplied Packages
  • Creating and Maintaining Database Triggers
  • Implementing System Event Triggers
  • Work with Oracle database tools
  • Understand and work work language features
  • Work with DECLARE, BEGIN & EXCEPTION clause
  • Understand and use nested blocks
  • Use explicit cursors
Лекторы
Intellezy Trainers
Intellezy Trainers
Computer Training Specialists


At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Платформа
Udemy
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Oracle PL/SQL Fundamentals vol. I & II
96.99 $ 149.99 $
Рейтинг
4.4
2 377
1 520
409
72
50