![]() |
| |||
![]() ![]() [CODE]Full Course SQL Oracle Training English | 7 Session | 2.45 GB 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 ![]() Code: http://www.filesonic.com/file/1352368334/part1.rar http://www.filesonic.com/file/1352366154/part2.rar http://www.filesonic.com/file/1352573484/part3.rar http://www.filesonic.com/file/1352579894/part4.rar http://www.filesonic.com/file/1352368354/part5.rar http://www.filesonic.com/file/1352355634/part6.rar |
![]() |
| Thread Tools | |
| Display Modes | |
| |