Oracle SQL Language Query statement-beyond OCP proficient in Oracle video tutorial training 29

Oracle SQL Language Query statement-beyond OCP proficient in Oracle video tutorial training 29

This course introduces:

Oracle Video tutorial, wind Brother this set of Oracle Tutorial training is the <<oracle database SQL language Training course >> 4th 5 sets: Oracle SQL language query statement. Learn about Oracle database SQL query restriction sequencing, Oracle SQL JOIN queries, Oracle SQL subqueries, and more.

Video Learning Address:

Http://edu.51cto.com/course/course_id-8047.html

Oracle SQL language Query statement, the course content is as follows:

Oracle SQL query Restriction ordering

Select Basic Features

Construct an expression

Using the LIKE operator

Using compound conditions

Use & Replace

Sorting using queries

Oracle SQL Join Query

Use natural connections

Using an inner connection

Use outer join-left OUTER JOIN

Use outer link-right outer join

Use outer connection-full connection

Using cross joins-cartesian product

Using the Connect semi Join

Using the Connect anti Join

Using the Connect self join

Oracle SQL Sub-query

Simple sub-query exercises

Write more complex subqueries

Sub-queries of different types

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/8F/00/wKiom1jRFvPBLKbXAACQOtOqESw874.gif-wh_500x0-wm_ 3-wmp_4-s_57631876.gif "title=" SQL Foundation "alt=" Wkiom1jrfvpblkbxaacqotoqesw874.gif-wh_50 "/>

This article is from the Oracle Database tutorials Blog, so be sure to keep this source http://oracle13c.blog.51cto.com/8020378/1908974

Oracle SQL Language Query statement-beyond OCP proficient in Oracle video tutorial training 29