SQL Training – SQL Programming Language

Introduction

Participants of this course will be introduced to the techniques for writing SQL code to build Microsoft SQL Server or Oracle database structures and candidates will be provided with the opportunity to gain hands-on experience of querying and manipulating databases.

Prerequisites

There are no prerequisites required for this course.

Who should attend?

This course is ideal for technical users and developers who would like to understand SQL programming for developing applications using databases.

What will you learn?

• How to build stored procedures that retrieve and modify data
• How to implement IF-ELSE, WHILE and BEGIN-END blocks
• How to manipulate variables and parameters
• How to use SQL programming to extract and analyse database content

Course Outline

• Overview of SQL and the ANSI/ISO standards
• SQL fundamental building blocks
• Building the database schema: creating and modifying tables and columns
• Systems for protecting data integrity
• Using indexes to improve performance
• Techniques for manipulating data
• Using the SELECT statement
• Querying multiple tables
• Processing data with row functions
• Performing analysis with aggregate functions
• Techniques for creating views in a database