Overview

يحتوي هذا الكورس علي 117 فيديو حوالي 30 ساعة تفصيليه من محاضر محترف بالاضافة لملفات التمارين هذه الكورس يؤهلك 100% بان تكون محترف قواعد بيانات اوراكل بكل سهولةهذا الكورس مقدم بطريقة سهلة وسلسه لتبسيط الفهم وتوصيل المعلومة بكل سهوله لكتم ترتيب الافكار وتنسيقها لتسهيل توصيل المعلومة اليك هذا الكورس من اقوي الكورسات اللي ممكن تشوفها سنبدأ من الصفر في قواعد البيانات و حتى الأحترافما ستتعلمهتعلم اصعب انواع الاسترجاع مع الربط بين الجداولاسترجاع البيانات من قواعد البيانات بكل سهولهبناء الجداول و الفيوز و الاندكسيز و السينونمالاضافه و التعديل و الحذف من الجداولمحتوى المقرر الدراسيعباره عن 25 قسممشتملين علي 117 محاضرةوقت الكورس28 h: 42 mسنبدأ الاول بنتنزيل الادوات المطلوبة وتنصيب الداتابيز علي الجهازومن ثم سنقوم بشرح التالي Introduction about Oracle - System development life cycle - What is Data ? - What is Database ? - What is DBMS ? - What is RDBMS ? - What is ORDBMS ? - What is table ? - What is Data Model and ERM ? - What is SQL ? - What is SQL*PLUS / Oracle SQL Developer ? - Types of is SQL statements - HR Schema tablesHistory and Architecture12C Oracle 12c Architecture Comparison between 12c and previous Releases Basic selectRestricting and Sorting - Using where clause - Comparison operators - Using between and - Using In operator - Using like operator - Using in null operator - Logical operator [ AND , OR , NOT ] - Order by clauseUsing conversion functions - Implicit and explicit conversion - to_char - to_number - to_date - General function ( NVL , NVL2 , NULLIF , COALESCE ) - Case function - Decode functionSubstitution Variables Character Function Number Function Date Function Using the group functions - Multi row function - Types of group function - Group by clause - Guideline for using group by What is joins and cartesian products Types of Joins Join in oracle DB 8i and prior SQL 1999 joins Oracle DB 8i and prior join syntax - Equijoin - Non Equijoin - Outer join - Self joinSQL 1999 joins - Cross join - Natural join - Using clause - On clause - Left outer join , right outer join , full outer joinUsing Subqueries to Solve Queries- Rules for using Subquery- Types of Subquery- Single Row Subquery- Multiple Row Subquery- Using Group function in Subquery- Having clause in Subquery- Single Subquery Operators- Multiple Row Subquery Operators- Not in and Subquery- Exists and Not ExistsUsing the Set Operators - Union operator - Guidelines when using the Union - Union All operator - Guidelines when using the Union All - Intersect operator - Guidelines when using Intersect - Minus operator - Guidelines when using Minus - Using the order by clause in set operatorsWhat is DML and insert rules Insert statement Insert Rows with null values Copy Rows from another tables Common errors insert and creating script Update statement Using Subquery in update Delete statement Truncate statement Compare between delete and truncate Commit and Rollback Save point Read consistency DB objects and data types-What is Schema ? and create table syntax-Default optionIncluding constraints [ PK , FK , UK , NOT NULL , CHECK]Constraint guidelinesCreating table using SubqueryAlter table statement [ Add, Modify , Drop ]Set unused option - read only - drop tableCreate Char datatype without sizeNull values and order by clauseOrder by clause TipsInterval functionsMany function do the same taskLong data typeSome SQL function Best practice DDL Alter table and constraints Tips you should know What is the Data Dictionary ? Data Dictionary Structure Naming Conversion in Data Dictionary Views Data Dictionary Views - User_objects / All_objects - User_tables / All_tables - User_tab_columns - User_constrains - User_cons_columnsAdding Comments to a a table Adding Comments to a column Comments Dictionary Views Creating Sequences NextVAl and CURRVAl Using the Sequence as Default value in Create Table Modify the Sequence Creating Synonyms Creating Indexes Dictionary Views for [Sequence , Synonyms , Indexes] What is a view ? Advantage of views Creating views Create simple view Create complex view Roles for performing DML operations on a view With check option clause With read only clause Removing a view How add constraints to the tables Rename the column name in the table Rename constraint name DEFERRABLE Constraints - DEFERRABLE INITIALLY deferred - DEFERRABLE INITIALLY immediate Global temporary table SQL LoaderRetrieving Data by using Subqueries - Create External Tables - Using Subquery as a source table - Multiple column Subquery - Pairwise comparison Subquery - Non - Pairwise comparison Subquery - Scalar Subquery - Correlated Subquery - With Clause Manipulating Data by Using Subqueries - Inserting by using a Subquery as a target - Updating by using Subquery as a target - Correlated update - Correlated deleteControlling User Access - Database Security - Data Security - System Privileges - Objects Privileges - Creating a user - Grant System Privileges - What is a Role ? - Creating a Role - Granting Objects Privileges - Related Dictionary views - Revoke Statement Introduction to Manipulating Data Using the explicit default value in insert statement Using the explicit default value in update statement Copy rows from another table examplesUsing the following types of multi table insert - Unconditional Insert - Conditional Insert All - Conditional Insert First - Pivoting Insert Manipulating Data Merge Statement Manipulating Data Flashback Statement Managing Data in Different Time Zones - Time Zones - Timestamp Data type - Timestamp with time zone - Timestamp with local time zone - V$TIMEZONE_NAMES - DBTIMEZONE - SESSIONTIMEZONE - current_date function - current_timestamp function - localtimestamp - alter session set time_zone - Extract expression - TZ_OFFSET function - from_tz function - to_timestamp function - to_yminterval function - to_dsinterval functionستجد الملفات اسفل كل فيديو

Skills

Reviews