PDF Archive

Easily share your PDF documents with your contacts, on the Web and Social Networks.

Share a file Manage my documents Convert Recover PDF Search Help Contact



Pl SQL Online Training .pdf



Original filename: Pl SQL Online Training.pdf
Title: Microsoft Word - i.doc
Author: pdf

This PDF 1.4 document has been generated by PScript5.dll Version 5.2 / GPL Ghostscript 8.70, and has been sent on pdf-archive.com on 04/06/2015 at 09:04, from IP address 175.101.x.x. The current document download page has been viewed 893 times.
File size: 108 KB (6 pages).
Privacy: public file




Download original PDF file









Document preview


info@monstercourses.com

www.MonsterCourses.com

SQL Online Training
Duration: 30 hours

1. Introduction to DB Concepts
i.

Disadvantages of File Processing System

ii. Advantages of Data Base Management System
iii. Data Base Management System Terminology
iv. How these are related to SQL
v. What is SQL and T-SQL?
1. Getting Started with SQL
a. 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
www.MonsterCourses.com

+1(772) 777-1557

info@monstercourses.com

www.MonsterCourses.com

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
b.

Data Types used in SQL

xii.

Numeric Data Types

xiii.

Character or Text Data Types

xiv.

Date and Time related Data Types

xv.

Miscellaneous Data Types
1. Operators in SQL

a.

What is an Operator?

b.

Different Categories of Operators

i.

Arithmetic Operators

ii.

Relational Operators

iii.

Logical Operators

www.MonsterCourses.com

+1(772) 777-1557

info@monstercourses.com

iv.

www.MonsterCourses.com

Miscellaneous Operators
1. Functions in SQL

a.

What are different categories of functions in SQL?

b.

What is a Scalar Function?

c.

What is an Aggregate Function?

d.

Different predefined Scalar functions available in SQL

xvi.

Numeric Functions

xvii.

String Functions

xviii. Date Time functions
xix.
e.

Miscellaneous Functions
Different predefined Aggregate Functions in SQL

1. CONSTRAINTS in SQL
1. What is a Constraint and its advantages
2. Types of Constraints
xx. Predefined Constraints
xxi. User Defined Constraints
1. More of predefined Constraints
xxii. PRIMARY KEY CONSTRAINT
xxiii. FOREIGN KEY CONSTRAINT
xxiv. CHECK CONSTRAINT
xxv.

NOT NULL CONSTRAINT

xxvi. UNIQUE CONSTRAINT
1. What is a User Defined Constraint?

www.MonsterCourses.com

+1(772) 777-1557

info@monstercourses.com

www.MonsterCourses.com

1. 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

1. SET Operators
xxxi.

UNION

xxxii.

UNION ALL

xxxiii.

INTERSECT

1. SUB QUERIES
2. VIEWS in SQL
a.

What is a view and its advantages?

b.

Types of Views
1. INDEXES

a.

What is an Index and its advantages?

b.

Types of Indexes

xxxiv.

CLUSTERED INDEX

xxxv.

NON CLUSTERED INDEX

T-SQL:
1. T-SQL
a.

What is T-SQL?

www.MonsterCourses.com

+1(772) 777-1557

info@monstercourses.com

www.MonsterCourses.com

b. What we can do with T-SQL?
1. 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.
xl.

Looping Statements
FOR / WHILE Statements for Looping
1. 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

e. Differences between Stored Procedures and Functions
1. Error Handling in T-SQL
a.

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

a.

What is a Cursor and its advantages?

b.

Different types of Cursors and its usage
1. Triggers

a.

What is a Trigger and its advantages?

b.

Different Types of Triggers

www.MonsterCourses.com

+1(772) 777-1557

info@monstercourses.com

c.

www.MonsterCourses.com

How to write and make the Triggers to fire automatically

www.MonsterCourses.com

+1(772) 777-1557


Related documents


chapter 9 11 informatic practices xii web
pl sql online training
seunit3
introduction to sql language
comps sem4 dbms assignments
devry cis 336 week 4 group project task 2


Related keywords