Course Details

SQL programme has the below stated topics:

• Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures

• Update database content with SQL and transaction handling

• Retrieve data with filter conditions and from multiple tables using various types of join

• Process data with row and aggregate functions

• Creating and modifying tables, constraints and indexes

• Modifying table contents

• Retrieving data from tables

• Applying conditions to filter retrieved rows

• Joining multiple tables

• Applying row and aggregate functions