Chapter 1: Database
Introduction to Database and RDBMS Concepts
Chapter 2: Retrieving and Sorting
To access our information in the database we need to query the database with the SELECT command. SELECT will do exactly as the name describes
Chapter 3: Restricting Data
By using LIMIT clause in SELECT statement we can limit no of record fetching.
Chapter 4: Built-in Functions
SQL has many built-in functions for performing calculations on data. SQL aggregate functions return a single value, calculated from values in a column
Chapter 5: Displaying Data from Multiple Table (Joining)
Thus far we have only been getting data from one table at a time.
Chapter 6: Aggregate Functions and Aggregation Using GROUP BY Clause (Grouping)
By definition, aggregate functions allow us to perform a calculation on a set of records and return a single returned value.
Chapter 7: Subquery
A subquery is a SELECT statement that is embedded in another SQL statement. The outer statement uses the result returned by the inner statement.
Chapter 8: Manipulating table
Data Manipulation Language (DML) statements are used for managing data within tables. Some commands of DML are: INSERT, UPDATE, DELETE
Chapter 9: Creating and Managing Table
In database systems, the goal is to store information in an orderly fashion.
Chapter 10: Indexing & Engine
Tables in database can grow very large, but as a table gets bigger, retrievals from it become slower. To keep your queries performing well
Chapter 11: SQL Programming
Learn how to create procedure, Trigger and use Explicit Transaction and programming construct
For details on Oracle Training email us at email@example.com