Contenido
OBJETIVES:
You learn concepts of relational databases, to create database structures and to store, retrieve, and manipulate data. Here you learn to query using Basic SQL Statements, restrict, sort, perform single row functions and group the queried data.
You will write advanced SELECT statements and use advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. You will query multiple tables, perform nested queries, implement constraints, use date and time functions, and create sequences and views.
You learn to write SQL and SQL Plus script files using the iSQL Plus tool to generate report-like output. Demonstrations and hands-on practice reinforce the fundamental concepts. The SQL Workshop will enhance your learning experience of SQL.
