Retrieving Data from Oracle Database with SQLMP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4 Hours | Lec: 45 | 603 MBGenre: eLearning | Language: EnglishLearn to use Oracle SQLOracle database is one of the top and most widely used relational database management systems in the world .

This beginners course will teach you how to retrieve data from an oracle database.

We will start off by downloading and installing oracle database 11g express which is free to use.

Then we will install TOAD which is a tool we will be using to connect to the oracle database and retrieve data.

Topics we will cover in this course includes:Retrieving DataUsing SELECT StatementsUsing FROM clauseUsing WHERE Clause for filtering dataUsing NOT OperatorUsing the LIKE OperatorUsing IS NULLUsing ORDER BY ClauseUsing DISTINCTUsing DescribeUsing and creating viewsUsing Sub-QueryRestricting and Sorting DataUsing ORDER BY ClauseUsing GROUP BY and HAVING ClauseRetrieving Data with Aggregate FunctionsIntroduction to aggregate functionsUsing AVG functionUsing COUNT functionUsing MAX functionUsing MIN functionRetrieving Data with Table JoinsIntroduction to Table JoinsUsing Equi JoinsUsing Non Equi JoinsUsing Cartesian JoinUsing Outer JoinUsing Self JoinRetrieving Data with Analytic FunctionsIntroduction to Analytic FunctionsThe SyntaxPartition By ClauseFirst and Last FunctionRow number FunctionsDense Rank FunctionLag FunctionLEAD FunctionRANK FunctionRetrieving Data with SET OperatorsUsing UNION ALL SET OperatorUNION SET OperatorUsing INTERSECT OperatorUsing Minus OperatorBy the end of this course you will have enough skill to retrieve data from an oracle database.