Základní info
This Introduction to SQL/PLSQL Accelerated course will teach you SQL and PL/SQL programming language concepts. Learn how to write SQL commands, develop stored PL/SQL procedures, functions, packages and database triggers.This accelerated course covers 10 days worth of content in only 5 days.bLearn To:/pnderstand the fundamental and core concepts of relational databases.reate reports of sorted and restricted data.un data manipulation statements (DML).etrieve row and column data from tables.ontrol privileges at the object and system level.reate indexes and constraints; alter existing schema objects.reate and query external tables.reate anonymous PL/SQL blocks, functions and procedures.onditionally control code flow (loops, control structures).reate stored procedures, functions and packages.onditionally control code flow (loops, control structures).se PL/SQL packages to group and contain related constructs. reate triggers to solve business challenges. everage the Oracle supplied PL/SQL packages for various programming tasks.b Benefits to You/py enrolling in this course, you'll gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Extend the functionality of the SQL language with PL/SQL language to write application code.bParticipate in Hands-On Exercises/phrough hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more. Hands-on exercises will help reinforce your learning.bCourse Bundle Note/phis course is a combination of Oracle Database: Introduction to SQL and Oracle Database: Program with PL/SQL courses.
