دوره حضوری Oracle SQL & PL/SQL

مطالب این دوره با توجه به نیاز بازار کار در واحد تحقیق و توسعه تدوین شده است.

سرفصل دوره Oracle SQL & PL-SQL

• Introducing Oracle Database
• Retrieving Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Using Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables Using Joins
• Using Sub-queries to Solve Queries
• Using the SET Operators
• Manipulating Data
• Using DDL Statements to Create and Manage Tables
• Introduction to PL/SQL
• Declaring PL/SQL Identifiers
• Writing Executable Statements
• Interacting with the Oracle Server
• Writing Control Structures
• Working with Composite Data Types
• Using Cursors
• Handling Exceptions
• Creating Stored Procedures and Functions