Oracle DBA

Best SQL Server Training institution is SkillXpert. Learn SQL Server Training with one of the software industry expert, who have been dealing with SQL Server Applications since a decade.

Users and Schemas

• Introduction to Users and Schemas
• Definitions and Client Tools
• SQL Developer Login
• Creating An Application Schema

Pseudo Columns & Functions

• Using The Dual Table
• Functions
• Pseudo-Columns
• Using Rowid
• Using Rownum

Using Subqueries

• Simple Subqueries
• Inline Views
• Correlated Subqueries
• Scalar Subquery

Joining Tables

• Review of Joins
• Equijoins
• Inner Joins
• Outer Joins
• Cross Joins
• Natural Joins
• Using Named Subqueries

Group Operations

• About Group Processing
• Simple GROUP BY
• ROLLUP Function

Using Set Operators

• Set Operators Defined
• Relationship to Mathematical Set Theory
• Restrictions on Set Operators

Conditional Processing

• The DECODE Function
• The Case Expression
• Conditional Processing

SQL Functions (Character)

• What Are SQL Functions?
• Character Functions
• CONCAT
• LENGTH
• INSTR
• REPLACE
• UPPER
• LOWER
• INITICAP
• LPAD
• RPAD
• TRIM
• TO_CHAR
• SOUNDEX

SQL Functions (Non-Character)

• Numeric Functions
• The TO_CHAR Function with numbers
• Date/Time Functions
• Date Format Functions
• Date Arithmetic Functions
• Null Value Functions

SQL Data Manipulation Language

• The INSERT Statement
• INSERT Statement Categories
• The UPDATE Statement
• The DELETE Statement
• Transactions
• Complex Table References
• The MERGE statement

Advanced

• Analytical Functions
• Queries for Queries
• Techniques to compare data
• Efficiently writing SQL queries

Job Opportunities:

After the course completion, we have strong clients Relation Existing with many IT Organizations, we will help the students with Placement Assistance Program with these Clients.

List of the Companies Offering Job Opportunities to our Students.

Infosys	Wipro	Prokarma
Cognizant	Virtusa	Marlabs
GalaxESolutions	CapGemini	Cigniti
Polaris	HSBC	ValueLabs
NCR	Dell	IBM
Deloitte	NTT Data	GalaxESolutions
Persistent	iGate	Sapient

Course Complete Certification:

We implemented Course Complete Certification process to give enormous information and support through the projects to our students, the one who gets the course complete certification is eligible to login to the projects developed and will be developed by us on the related technology, tools and course.

This Access will be provided for 12 months for the student from the day when he gets his CCC for SkillXpert.