SQL Course Content

بسم الله الرحمن الرحيم
المدونه ان شاء الله هتكون مهتمة بكورسات اوراكل و تقديم مقالات  و اخبار عنها

List of Courses will be Introduced:

• Oracle Database 11g, SQL Fundamentals 1&2
• Oracle Database 11g, Program with PL/SQL
• Oracle Database 11g,Advanced PL/SQL
• Oracle Database 11g, Administration Workshop 1
• Oracle Database 11g, Administration Workshop2
• Oracle Database 11g,  Manage Oracle On Linux 
• SHELL Scripting for Database Administrators Using (Bash - KSH)
• Oracle Database 11g, Performance Tuning
• Oracle Database 11g,  SQL Tuning
• Oracle Database 11g, RAC
• Oracle Database 11g, DataGuard
• Oracle Database 11g, Security
• Oracle Database 11g,  Backup & Recovery
• ORACLE WebLogic Server 11g
• ORACLE EBS R12: Install, Patch, and Maintain Applications
• ORACLE Database 12c: Upgrade From 11g

ان شاء الله سيتم تسجيل كورس ال SQL كامل و رفعه فى المدونه
سيتم ادراج موضوعات عن محتويات كل كورس على حده

Oracle SQL Course Content:

• Introduction to SQL & How to use (SQL Plus, SQL Developer)
• Retrieving Data Using 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 Subqueries to Solve Queries
• Using the Set Operators
• Manipulating Data
• Using DDL Statements to Create and Manage Tables
• Creating Other Schema Objects
• Controlling User Access
• Managing Schema Objects
• Managing Objects with Data Dictionary Views
• Manipulating Large Data Sets
• Managing Data in Different Time Zones
• Retrieving Data by Using Subqueries
• Regular Expression Support
• Writing Advanced Scripts