
أساسيات قواعد بيانات أوراكل Oracle Database 11g: SQL Fundamentals -محتوي مترجم الي العربية
E£4,000.00
E£7,000.00
Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This course introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS).
-:program Outline
· RELATIONAL DATABASES & DATA MODELS · SELECTION & SETUP OF THE DATABASE INTERFACE · USING THE DATABASE INTERFACE · INTRODUCTION TO THE SQL LANGUAGE · THE SELECT STATEMENT · RESTRICTING RESULTS WITH THE WHERE CLAUSE · PSEUDO COLUMNS, FUNCTIONS & TOP-N QUERIES · JOINING TABLES · USING THE SET OPERATORS · SUMMARY FUNCTIONS · AGGREGATING DATA WITHIN GROUPS · USE DDL TO CREATE & MANAGE TABLES · USE DML TO MANIPULATE DATA · UNDERSTANDING THE DATA MODELS
Target Audience :-
The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are: • Business and non-IT professionals • Application designers and database developers • Business Intelligence (BI) analysts and consumers • Database administrators • Web server administrators