SQL Training Course

SQL Training Course

Click on the buttons inside the tabbed menu:

Course Description

The SQL program is designed to help the participant to understand the basics of application development in a RDBMS environment and to successfully work in this domain.
There are multiple courses available to fit the requirement of students and working Professionals. 1. SQL for Oracle RDBMS. 2. SQL for SQL Server Environment;
What skills will the student gain?
After the completion of this course, the student will be able to:

  • Understand the basics of RDBMS
  • ·   Learn about commands in a database environment
  • ·   Learn about the different types of commands in RDBMS
  • ·  
  • ·  
  • ·  

Mode of Training

The AWS training is delivered in the following modes - Regular Classroom, Fast-track, Self-Study and Online live trainer

Locations:

The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.

To know more about the schedules in those cities click here -->

Schedule for Kolkata

Outside the country it is delivered in Dhaka, Thimpu, Singapore, Kuala Lumpur, Middle East, Africa and Australia.

The course outline delivered during the class is as follows -

  • Introduction

  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Overview of Oracle Database 12c and Related Products
  • Overview of relational database management concepts and terminologies
  • Introduction to SQL and its development environments
  • What is Oracle SQL Developer?
  • Starting SQL*Plus from Oracle SQL Developer
  • The Human Resource (HR) Schema
  • Tables used in the Course
  • Retrieving Data using the SQL SELECT Statement

  • Capabilities of the SELECT statement
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Use of the DESCRIBE command
  • Restricting and Sorting Data

  • Limiting the Rows
  • Rules of precedence for operators in an expression
  • Substitution Variables
  • Using the DEFINE and VERIFY command
  • Using Single-Row Functions to Customize Output

  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions
  • Using Conversion Functions and Conditional Expressions

  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nest multiple functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Use conditional IF THEN ELSE logic in a SELECT statement
  • Reporting Aggregated Data Using the Group Functions

  • Group Functions
  • Creating Groups of Data
  • Restricting Group Results
  • Displaying Data from Multiple Tables Using Joins

  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • Non equijoins
  • OUTER join
  • Using Subqueries to Solve Queries

  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries
  • Using the SET Operators

  • Set Operators
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations
  • Managing Tables using DML statements

  • Data Manipulation Language
  • Database Transactions
  • Introduction to Data Definition Language

  • Data Definition Language
  • Introduction to Data Dictionary Views

  • Introduction to Data Dictionary
  • Describe the Data Dictionary Structure
  • Using the Data Dictionary views
  • Querying the Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes

  • Overview of sequences
  • Overview of synonyms
  • Overview of indexes
  • Creating Views

  • Overview of views
  • Managing Schema Objects

  • Managing constraints
  • Creating and using temporary tables
  • Creating and using external tables
  • Retrieving Data by Using Subqueries

  • Retrieving Data by Using a Subquery as Source
  • Working with Multiple-Column subqueries
  • Using Scalar subqueries in SQL
  • Correlated Subqueries
  • Working with the WITH clause
  • Manipulating Data by Using Subqueries

  • Using Subqueries to Manipulate Data
  • Inserting by Using a Subquery as a Target
  • Using the WITH CHECK OPTION Keyword on DML Statements
  • Using Correlated Subqueries to Update and Delete rows
  • Controlling User Access

  • System privileges
  • Creating a role
  • Object privileges
  • Revoking object privileges
  • Manipulating Data

  • Overview of the Explicit Default Feature
  • Using multitable INSERTs
  • Using the MERGE statement
  • Performing flashback operations
  • Tracking Changes in Data
  • Managing Data in Different Time Zones

  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
  • Working with INTERVAL data types

Schedule

If you are located outside Kolkata or would like to attend our session during your visit to Kolkata then please feel free to write us at palium.skills@gmail.com for any queries related to program,
upcoming schedule and fee. Call: +91-9051092035 or WhatsApp: +91-9051092035

Schedule for AWS Training in 2018 is as follows:
Month Dates No of Hours
January Completed
February Completed
March Completed
April Completed
May Completed
June Completed
July Completed
August 26th Aug (Fast-track) 30
September 4th - weekday, 23rd - fast-track 30
October TBA 30
November 4th - fast-track,6th - weekday 30
December 2nd - fast-track, 4th - weekday 30

Study Mode & Fees

Course/Certification Name Delivery Mode Fees Special Offers
SQL Fundamentals Classroom Rs. 5,000+ 18% GST best offers for 3+ enrollments
Oracle SQL Certification Exam Online Exam Rs. 11,000 + 18% GST Payable directly to Oracle, discounts available from time to time
SQL Fundamentals Fast-track Classroom training talk to uss best offers available
SQL Fundamentals Online live trainer Rs. 5,000+ 18% GST best offers available
SQL Fundamentals Self-study Rs. 1,000 + 18% GST --

FAQs

The commonly asked questions pertaining to AWS training are -

Q: What are the pre-requisites for taking the SQL course?

A: Basic computer knowledge is the only pre-requisite

Q: Will this be theoretical or hands-on?

A: This is a complete hands-on training where the trainer will demonstrate each feature and participants will follow and do the same on the system.

Q: Will I get access to the SQL system?

A: Yes, trainer will demonstrate how to access the instance.

Q: Will I incur any charges for accessing the application?

A: The standard features are available for free. There are some premium services for which charges maybe imposed by service provider.

Q: What if I have doubts after completing the class?

A: You can gather your doubts and come by prior appointment to get your doubts cleared.

Q: What help will I get for clearing the Certification Exam?

A: Our trainer is a Certified person and will provide guidance and tips for clearing the exam. Besides, you will get access to question bank for clearing the exam

Q: Will I receive a certificate for the course?

A: Yes, participants receive a certificate after completing the course provided they have attended 90% of the class.

Get help now
CONTACT US +91-9051092035 (24×7)
WhatsApp +91-9051092035 (24×7)
Enquire Now

A Few Things You’ll Love!

  • Experienced Training Partner
  • Certified & Industry Experts Trainers
  • Multiple Training Delivery Models
  • Customized Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance

Palium Skills