Full Course SQL Oracle Training
Date: 12 June 2011, 03:06
|
Full Course SQL Oracle Training English | 7 Session | 2.42GB Genre: eLearning Operation and close the Oracle databases Run the application server iSQL * Plus SQL Language Basics Introduction to the SQL language Data types, Oracle Data types Transactions Operators Values ??Literals Select simple sentences Simple queries Simple Queries Where use of the phrase Boolean Logical Operators Different parameters Sort rows Use expressions Expressions SQL * PLUS principles Make a connection to the tool SQL * PLUS Use the SQL * PLUS Memory usage SQL Buffer Part 1 Memory usage SQL Buffer Part 2 Use the files Scripts Customize the environment tool SQL * PLUS Coordinate the results of queries Format the results and generate reports (1) Format the results and generate reports (2) Division results for the sets and perform calculations Add a header and remove the page Save reports and delete formats Create reports using the files Scripts Variables Variables Uses variables Variables 1 Uses variables Variables 2 Use the command Accept Tool iSQL * PLUS Use the iSQL * PLUS Single Row Functions Functions Introduction Dealing with Nulls values The use of text functions Character Functions 1 The use of text functions Character Functions 2 The use of text functions Character Functions 3 Numeric Functions Numerical Functions Date functions Date Functions 1 Date functions Date Functions 2 Transfer Functions Conversion Functions 1 Transfer Functions Conversion Functions 2 Miscellaneous functions, Miscellaneous Functions Data collection and aggregation functions Functions Group Functions assembly Group By statement Having the words Use the commands Rollup and Cube Overlapping functions Nesting Functions Sub queries and subqueries Joins links Link between the tables Link between the tables by using the Join The link between more than two tables Link is conditional Cartesian Join Links Outer Joins Link Self Join Link Non-Equality Use transactions Set Operators Subqueries Subqueries 1 Subqueries Subqueries 2 Modify data Use sentences DML Modify the data Updating Data Use of the phrase Merge Delete data from tables Close rows and tables Sentences Transaction Control Data Types to identify the types of data Review on the database elements Data Types Data Types Data Types History (1) Data Types History (2) Calculations on the history Types of binary data Binary Data types ROWID data types Constraints and restrictions Tables Tables Create the tables (1) Create tables (2) Temporary tables Temporary Tables Adjustments to the tables Delete columns and tables Constraints Constraints UNIQUE and CHECK constraints Restrictions Primary KEY and FOREIGN KEY Activate and delete constraints Constraints Restrictions Deferred Deferred Constraints Views virtual tables Create virtual tables Creating Views 1 Create virtual tables Creating Views 2 Modify the virtual tables Modifying Views The use of virtual tables Using the VIEWS Virtual tables JOIN VIEWS Virtual tables Inline Views Other elements of the databases The establishment of numerical strings Sequences Modified chains Numerical Sequences Synonyms Synonyms Types of Synonyms Synonyms Indexes Indexes Programs stored Stored Programs Users and confidential data Create and modify user accounts, User Accounts Documentation Authentication Add attributes to user accounts (1) Add attributes to user accounts (2) Control permits the user accounts Prevention grants and privileges Privileges Privileges Object Privileges elements System Privileges System privileges Create and use groups of privileges Roles Create and set the forms Profiles Creating a Database Connection Working with Database Objects Creating Tables Modifying Tables Managing Constraints Removing Tables Accessing Data Building Simple Queries Accessing Multiple Tables Using Functions to Customize Output Working With Groups of Data Manipulating Data Adding Data Modifying Data Removing Data Saving and Discarding Changes Exporting Data Importing Data Adding PL/SQL Components PL/SQL Blocks Using Triggers Using Procedures and Functions Using Packages Building Reports Producing a User Defined Report Using Source Code Control Versioning Files Note: Videos Explanation in Arabic, with English.
|
DISCLAIMER:
This site does not store Full Course SQL Oracle Training on its server. We only index and link to Full Course SQL Oracle Training provided by other sites. Please contact the content providers to delete Full Course SQL Oracle Training if any and email us, we'll remove relevant links or contents immediately.