Software Courses

SQL Programming

SQL(Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables. SQL offers two main advantages over older read–write APIs such as ISAM or VSAM. Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, e.g. with or without an index.

Course Content

Understanding Core Database Concepts

Understand how data is stored in tables

Understand relational database concepts

Understand data manipulation language (DML)

Understand data definition language (DDL)

Creating Database Objects

Choose data types

Understand tables and how to create them.

Create views

Create stored procedures and functions

Manipulating Data

Select data

Insert data

Update data

Delete data

Understanding Data Storage

Understand normalization

Understand primary,foreign,and composite keys

Understand indexes

Administrating a Database

Understand database security concepts

Understand database backups and restore