SQL Online training

                                           Duration : 30 hours

SQL/Pl Online Training course outline

Introduction to DB Concepts

  • Disadvantages of File Processing System
  • Advantages of Data Base Management System
  • Data Base Management System Terminology
  •  How these are related to SQL
  • What is SQL and T-SQL
  • Getting Started with SQL

Different Types of Commands in SQL

vi.  Data Definition Language Commands

  • CREATE COMMAND
  • INSERT COMMAND
  • ALTER COMMAND
  • TRUNCATE COMMAND
  • DROP COMMAND
  • vii.   Data Manipulation Commands
  • INSERT COMMAND
  • DELETE COMMAND
  • UPDATE COMMAND

viii. Data Control Language Commands

  • GRANRT COMMAND
  • REVOKE COMMAND
  • ix. Data Retrieval Commands
  • SELECT COMMAND
  • WHERE CLAUSE
  • GROUP BY CLAUSE
  • HAVING CLAUSE
  • ORDER BY CLAUSE

x. Transaction Control Language Commands

  • COMMIT COMMAND
  • ROLLBACK COMMAND
  • SAVE POINT COMMAND

xi.  Examples for all the above categories of commands

  • Data Types used in SQL
  • Numeric Data Types
  • Character or Text Data Types
  • Date and Time related Data Types
  • Miscellaneous Data Types

Operators in SQL

  • What is an Operator
  • Different Categories of Operators
  • Arithmetic Operators
  • Relational Operators
  • Logical Operators
  • Miscellaneous Operators

Functions in SQL

  • What are different categories of functions in SQL
  • What is a Scalar Function?
  • What is an Aggregate Function?
  • Different predefined Scalar functions available in SQL
  • Numeric Functions
  • String Functions
  • Date Time functions
  • Miscellaneous Functions
  • Different  predefined Aggregate Functions in SQL

CONSTRAINTS in SQL

  1. What is a Constraint and its advantages
  2. Types of Constraints
  • Predefined Constraints
  • User Defined Constraints
  1. More of predefined Constraints
  • PRIMARY KEY CONSTRAINT
  • FOREIGN KEY CONSTRAINT
  • CHECK CONSTRAINT
  • NOT NULL CONSTRAINT
  • UNIQUE  CONSTRAINT
  1. What is a User Defined Constraint?
  2. JOINS in SQL

a.       What is a JOIN and what is its necessity

b.      Types of JOINS

xxvii.         INNER JOIN

xxviii.       NATURAL JOIN

xxix.          OUTER JOIN : LEFT OUTER , RIGHT OUTER

xxx.            CARTESIAN JOIN

SET Operators

xxxi.         UNION

xxxii.         UNION ALL

xxxiii.       INTERSECT

SUB QUERIES

VIEWS in SQL

a.       What is a view and its advantages

b.      Types of Views

INDEXES

a.       What is an Index and its advantages

b.      Types of Indexes

xxxiv.       CLUSTERED INDEX

xxxv.        NON CLUSTERED INDEX

T-SQL:

T-SQL

a.       What is T-SQL?

bWhat we can do with T-SQL?

Different Programming Constructs in T-SQL

a.       Conditional Statements:

xxxvi.       IF Statements

xxxvii.     IF ELSE Statements

xxxviii.    NESTED IF ELSE Statements

xxxix.       Switch or Case Statements

b.      Looping Statements

xl.                 FOR / WHILE Statements for Looping

Stored Procedures and Functions

a.       What is a Stored Procedure

b.      How to write and execute a Stored Procedure

c.       What is an user defined function

d.      How to write and execute a Function

eDifferences between Stored Procedures and Functions

Error Handling in T-SQL

a.       Use of TRY CATCH Statements in SP and Functions to Handle Errors

Cursors

a.       What is a Cursor and its advantages

b.      Different types of Cursors and its usage

Triggers

a.       What is a Trigger and its advantages

b.      Different Types of Triggers

c.       How to write and make the Triggers to fire Automatically

SQL/PL  Online Training by real time industry experts with hands on

Fill up quick inquiry form to get more details on SQL/Pl online training

Click here to register for the PLSQL online training.

PLSQL Online Training Video

Coming Soon

Click here to register for the PLSQL online Training video Tutorials

About our SQL online training instructor:

  • Working in the top MNC in USA.
  • Very experienced got 11+ years of experience.
  • Trained more than 500+ students online.
  • SQL PL Interview Questions.
  • Certified and corporate trainer on SQL
  • Expertise in SQL online training.
  • Hands on SQL online training.

Click here to register for the PLSQL online training.