MP4 | Video: AVC 1280x720 | Audio: AAC 48KHz 2ch | Duration: 3 Hours | 588 MB

Genre: eLearning | Language: English

Video Series Overview. This first topic in the Oracle database video series introduces you to the topics that will be covered during this video series. Goktug also answers some important questions about databases and Oracle in particular.

RDMS Concepts. This second topic in the Oracle database video series will explain Relational Database Management Concepts (RDMS), including the concepts of database, unstructured, semi-structured, and unstructured data, table, tuple, row, attribute, relational integrity, normalization, OLTP (Online Transactional Process) and OLAP (Online Analytical Process) systems, ACID, and schema object. The Oracle database is introduced as well.

Retrieving Data using the SQL Select Statement in Oracle. This third topic in the Oracle database video series shows you how to retrieve data using the SQL Select statement. Follow along with Goktug in this hands-on session.

Restricting and Sorting Data using SQL in Oracle. This fourth topic in the Oracle database video series shows you how to restrict and sort data in Oracle. Learn how to limit the rows that are retrieved by a query, sort the rows, and restrict output at runtime. Follow along with Goktug in this hands-on session.

Using Single Row Functions in SQL to Customize Output in Oracle. This fifth topic in the Oracle database video series shows you how to use single row functions in SQL to customize output in Oracle. Also learn how to use character, number, and date formats in SQL statements. Follow along with Goktug in this hands-on session.

Using SQL Conversion Functions and Conditional Expressions in Oracle. This sixth topic in the Oracle database video series shows you how to use SQL conversion functions and conditional expressions in Oracle. Follow along with Goktug in this hands-on session.

Using the SQL Group By and Having Clauses in Oracle. This seventh topic in the Oracle database video series shows you how to use the SQL Group By and Having clauses in Oracle. Follow along with Goktug in this hands-on session.

Using the SQL Join Statement to Retrieve Data from Multiple Tables in Oracle. This eighth topic in the Oracle database video series shows you how to use the SQL join statement to retrieve data from multiple tables in Oracle. Follow along with Goktug in this hands-on session.

Using SQL Subqueries in Oracle. This ninth topic in the Oracle database video series shows you how to use SQL subqueries to solve more complex queries in Oracle. Follow along with Goktug in this hands-on session.

Inserting, Updating, and Deleting Data from Tables in Oracle. This tenth topic in the Oracle database video series shows you how to use the SQL INSERT, UPDATE, and DELETE statements to insert, update, and delete data from Oracle tables. Follow along with Goktug in this hands-on session.