SQL Training

ROICIANS

Course Information

Level
Batch Availability Weekdays, Weekend
Mode of Class Classroom, Online, Hybrid
Duration 20 hours

Enquiry Form

Key Features

Hands-on Learning Program

Get trained from working professional

Get trained as per market Trend

work on live projects

Training on all latest tools and skill

Continuous Interview preparation

Complete job assistance (Canada only)

Mock interview session from working QA professionals

Course Overview

This Course is aimed to provide practical in depth SQL Training, this training is meant to provide knowledge from Basic to advance level. SQL Training is for all the databases i.e Oracle, SQL Server etc. We prepare students on Real time scenarios.

  • No prior IT knowledge required.
  • A person from any academic background can learn SQL.
  • There is no pre-requisite to learn SQL.
  • Anyone who wants to switch into IT field
  • Anyone with No or minimal IT knowledge
  • Anyone who want to gain skills to extract and analyze data from database
  • Anyone who wants to explore their interest in databases.
  • Anyone who wants to extract more than average salary
  • Anyone who does not like coding
  • Every sector of industry is using database for storage, so job scope is very broad
  • It does not require any prior expertise.
  • SQL is must to have skill for any IT or Non IT Jobs
  • SQL language syntax is same no matter which database is being used
  • Get Trained on Latest Versions in production: As we provide job oriented trainings, our focus is always training on the versions which are being used in market neither obsolete one nor on the version which is not launched in market yet.
  • Training from Working Senior DBA’s: Database handling requires lots of expertise, that’s why one must get trained from someone who understands all in and outs of database. Mostly database has run time scenarios which cannot be taught without expertise. We always make sure that we provide best experienced Trainer.
  • Certification Preparation: Our training cover all practical and theoretical concepts database. After completing the training, one can easily appear for certification exam..
  • Complete Job Assistance: This is job oriented training in which we make sure that you get 100% industry exposure.
  • We prepare student for interviews from day one: Our experts are technical recruiters who evaluate you according to market trends.

COURSE CURRICULUM

Introduction to Course

  •  Introduction to Database
  • Restricting Data(Using Clauses)
  • Operators- Arithmetic
  • Logical Operators(AND,OR,NOT)
  • Operators- Comparison
  • Operators- Set (UNION,UNION ALL,INTERSECT,MINUS)
  • Concatenation Operator
  • General Operators (LIKE, IN, Between, Exist)

Single Row Functions

  • Character
  • Number
  • Date

Multiple Row Functions

  • Avg()
  • Min()
  • Max()
  • Count()
  • Sum()

Using Rollup, Cube

Usage of Having , Group by Clause

Having vs Where Clause

Learn how to manipulate and create database objects. This section is very important from interview point of view because Categories of commands are basic of SQL and it is must if you want to proceed

  • DDL(Create, Drop, Alter, Rename, Add, Modify)
  • DML(Insert, Update, Delete, Select)
  • DCL(Grant, Revoke)
  • DDL VS DML

Creating Tables, Indexes, Constraints ,Sequences, Synonyms and Views

Dropping Tables, Indexes, Constraints, Sequences, Synonyms and Views

Modifying Tables, Indexes, Constraints ,Sequences, Synonyms and Views

Learn how to fetch data from more than one table. Now a days you will not find every detail in one table, so joins are very useful to extract data from different tables simultaneously

Oracle Joins

  • Equi Join
  • Non Equi Join
  • Self Join
  • Outer Join

SQL Server Joins

  • Inner Join
  • Natural Join
  • Cross Join
  • Outer Join(Left Outer Join ,Right Outer Join, Full Outer Join)

Learn how to fetch data, depending upon indirect conditions,

  • Single Row  Sub Queries
  • Multiple row sub Queries
  • Complex Sub Queries
  • Correlated sub Queries

Learn how to restrict type of data to be inserted in a column, at the time of database designing and planning we always focus on table designing which data should be allowed or not allowed in column.Not Null Constraint

  • Modifying
  • Dropping
  • Implementation when table already Exists
  • Column Level Implementation

Check Constraint

  • Adding
  • Dropping
  • Implementation when table already Exists
  • Table and Column Level Implementation

Unique key constraint

  • Adding
  • Dropping
  • Implementation when table already Exists
  • Table and Column Level Implementation

Primary key constraint

  • Adding
  • Dropping
  • Implementation when table already Exists
  • Table and Column Level Implementation
  • Differentiating Unique and Primary Key

Foreign key constraint

  • Adding
  • Dropping
  • Implementation when table already Exists
  • Table and Column Level Implementation
  • Differentiating Unique and Primary Key

Database objects, what are their uses and how to create them. Database objects are Views, Index, synonym, sequence, tables Views

  • Creating Read only views
  • Creating Views with CHECK Option
  • Creating Force Views
  • Modifying Views

Indexes

  • Internal Working of Indexes
  • Creating B-Tree, Bitmap ,Unique, Functional Indexes
  • Creating Index On Multiple Columns

Synonyms

  • Public Synonym
  • Accessing Different Schemas
  • Dropping

Sequences

  • Creating Sequences
  • Nextval, Currval functions
  • Implementing Sequence on Tables

Table

  • Advance level operations on Table

Course Schedule

Start DateWeekend/ WeekdaysTimingLocationAction
21/06/2021Weekdays05:30 PM - 08:30 PMBrampton, ON
Start Date 21/06/2021
Batch Availability Weekdays
Timing 05:30 - 08:30 PM
Location Brampton, ON
Action

Enquiry Form

OTHER COURSES

cloud-sync Logo

Oracle Admin I

Level:  Intermediate
Batch Availability : Weekdays ,Weekends
Mode of Class: In-Classroom,Online
Duration : 39 hours

secure Logo

Data Guard

Level:  Advance
Batch Availability: Weekdays ,Weekends
Mode of Class: In-Classroom,Online
Duration: 30 hours

server Logo

RAC

Level:  Advance
Batch Availability: Weekdays ,Weekends
Mode of Class: In-Classroom,Online
Duration: 39 hours

We can help you

Just call at +1-(289)-499-4040 for more details