SQL

HR. Software Solution (HRSS) provides in-depth training program for our various Technical and Non-Technical Professionals.

What is SQL?

SQL stands for Structured Query Language. It is functionality complete, i.e., through SQL we can insert, manipulate, update, delete data in a database. Without the knowledge of SQL a database administrator cannot administer a database. It is the used as the query language of all the databases in the world. Customize Corporate Training - Customized training on specific Software Testing tools for the corporate needs. Experienced Technical Professional- Advanced program where professional are taught specific Software Testing Tools and New Technology needed for Career Advancement. Experienced Non-Technical Professionals- 10 to 12 weeks program where professionals are taught and trained in the following areas:

  • Structured Query Language (SQL) / UNIX / XML, HTML,
  • Object Oriented Concepts, VBscript
  • Automation Tool: Quality Center, QTP, Win Runner, & LoadRunner
  • Black Box, Grey Box and White Box testing.
  • Business Analysis (Requirement Gathering, Analysis)
  • Oracle
  • Software Development Life Cycle(SDLC) / Rational Unified Process.
  • Test Management Tools - Test Director / Quality Center
  • Integration of Mercury Tools -(WinRunner / Quick Test Professional/ Load Runner) with Test Director and Quality Center
  • Perfomance Testing Tool- LoadRunner

Introduction

  • What is SQL?
  • Advantages of SQL
  • Way of Writing SQL
  • SQL Statements

RDBMS

  • What is RDBMS?
  • Terminology Used
  • SQL Connection with RDBMS

SQL SELECT Statements

  • Selecting All Columns Selecting Specific Columns
  • Column Alias
  • Concatenation Operator
  • Arithmetic Operators
  • Comparison Conditions
  • Logical Conditions
  • ORDER BY Clause

Functions

  • Single Row Functions
  • Character Functions
  • Number Functions
  • Date Functions
  • Conversion Functions
  • General Functions
  • Multiple Row Functions
  • Group Function

Joins

  • Equijoins
  • Non-Equijoins
  • Joining Three Tables
  • Self Joins
  • Left Outer Joins
  • Right Outer Joins
  • Full Outer Joins
  • Cross Joins
  • Natural Joins

Subquery

  • What is Subquery?
  • Types of Subquery
  • Group Function
  • Having Clause

Data Manipulation Language

  • Insert
  • Update
  • Delete
  • Merge

Data Definition Language

  • Create
  • Alter
  • Drop
  • Rename
  • Truncate

Transaction Control

  • Commit
  • Rollback
  • Savepoint

Data Control Language

  • Grant
  • Revoke

Constraints

  • Not Null
  • Unique Key
  • Primary Key
  • Foreign Key
  • Check
  • Dropping a Constraint
  • Enabling & Disabling

Other Concepts

  • Sequence
  • View
  • Index
  • Synonyms
What's 18 - 2 =

class for demo

NEW BATCH STARTED

Noida
Jamia Nagar Batch
Maharani Bagh Batch
Patna

Our COURSES

Partners

query button