SQL Training
ROICIANS
Course Information
| Level | Beginner |
|---|---|
| Batch Availability | Weekdays, Weekend |
| Mode of Class | Classroom, Online, Hybrid |
| Duration | 20 hours |
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 SQL
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)
Functions
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
Categories of Commands
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
Joins
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)
Sub Queries
Learn how to fetch data, depending upon indirect conditions,
- Single Row Sub Queries
- Multiple row sub Queries
- Complex Sub Queries
- Correlated sub Queries
Constraints
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
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 Date | Weekend/ Weekdays | Timing | Location | Action |
|---|---|---|---|---|
| Weekdays | 05:30 PM - 08:30 PM | Brampton, ON | Enroll Now |
Other Courses
Oracle Admin I
Batch Availability: Weekdays, Weekends
Mode of Class: In-Classroom, Online
Duration: 39 hours
Data Guard
Batch Availability: Weekdays, Weekends
Mode of Class: In-Classroom, Online
Duration: 30 hours
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