MySQL Course
Course Outline
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 |
Oracle Training
For details on Oracle Training email us at training@isacsoftware.com
