Oracle SQL Server & T-SQL Queries

Rate the Course:   
4.40 out of 5 - Based on 231 Ratings

Croma Campus an ISO Certified IT Training Institute in Noida provides the ideal training for “Oracle SQL Server & T-SQL Queries” for freshers/experienced/professional/non- professionals who want to make career in Oracle and cater the need of dynamic IT Companies. We also provide professional real time projects to students in their final semester.

We have expertise trainers who focus on quality and easiest education and also provide you “Hands on experience”. After Certified Oracle SQL Server training you will be provided with the placement in MNCs as we are associated with various top level MNCs.

Why to opt for Oracle-SQL Server & T-SQL Queries?

  • It is a secure form and you get data protection.
  • High performance and a standard benchmark for data warehousing.
  • Enable Self Service and mobility at a minimal cost.
  • Easy to use and advanced analytics tools.
  • Built-in memory with high speed.

Key Features of Oracle SQL Server & T-SQL Queries Training are:

  • Design POC (Proof of Concept): This process is used to ensure the feasibility of the client application.
  • Video Recording of every session will be provided to candidates.
  • Live Project Based Training.
  • Job-Oriented Course Curriculum.
  • Course Curriculum is approved by Hiring Professionals of our client.
  • Post Training Support will helps the associate to implement the knowledge on client Projects.
  • Certification Based Training are designed by Certified Professionals from the relevant industries focusing on the needs of the market & certification requirement.
  • Interview calls till placement.

SQL Server Fundamentals & T-SQL Queries

SQL Server Installation

  • SQL Server 2012 Installation
  • SQL Server 2014 Installation
  • WMI Checks & Configuration Tool
  • Server Components and Purpose
  • Firewall Options and Instance Rules
  • Service Accounts, Purpose and Usage
  • Authentication Modes & Logins
  • Instance Configuration Options
  • Testing Multiple Installations
  • Management Studio (SSMS) Tool Usage
  • Shared Features and Client Components

Database Design Concepts

  • SQL Server Database Architecture
  • Database Catalog and Storage Options
  • Data Files : Purpose and Storage
  • Filegroups : Purpose and Usage
  • Log files : Purpose and Audits
  • Use of Transaction Log Files
  • Sizing and Placement – Data Files
  • Sizing and Placement – Log Files
  • Locations and Sizing Recommendations
  • Filegrowth and MAXSIZE Options
  • Scripting Database Structures
  • Database ALTERs and Considerations
  • Designing Very Large Databases (VLDB)
  • Placement of Files and Filegroups
  • DB Design Parameters and Limitations
  • Design Recommendations from Codeplex

Table Design and Queries

  • Tables Design Concepts & Normal Forms
  • Table Creation Process and Options
  • File Groups and Table Design
  • Role of Schemas and Table Design
  • DML, DDL and SELECT Operations
  • Single Row and Multi-Row Inserts
  • Table Aliases, Column Aliases & Usage
  • INSERT & SELECT Variants in T-SQL
  • Data Types and Column Usage
  • Row size Computation & NULLs
  • Basic INSERT, UPDATE, DELETE
  • Multi-Row Inserts and SELECT Statements
  • SELECT Queries with Schema References
  • Basic Data Types & NULL Value Compares
  • Design Limitations & UPDATES
  • Role of Log Files for DML Operations
  • DELETE versus TRUNCATE Statements

Normalization, Keys and Constraints

  • Normalization & Constraints Concepts
  • Normal Forms in Table Design
  • OLTP Database Model and BCNF
  • NULL Property and Importance
  • UNIQUE KEY Columns and Usage
  • PRIMARY KEY – Usage & Limitations
  • Use of FOREIGN KEY References
  • CHECK and DEFAULT Constraints
  • Composite Primary Keys & Use
  • Identity Property & Duplicate Keys
  • Identity Property with PRIMARY KEY
  • Managing Keys and Constraints
  • Recommendations & Naming Conventions

Views and Joins – Queries

  • Views in SQL Server and Usage
  • SELECT Query Variants in Views
  • WHERE, IN, EXISTS and BETWEEN
  • SCHEMABINDING & ENCRYPTION Options
  • Views with ALTER TABLE, TOP Clause
  • Data Validations and Orphan Views
  • Database Diagrams and Entity Relations
  • Views for Enforcing Data Level Security
  • Common System Views and DMVs – Audits
  • Using JOINS with Cascaded Views

Indexes and Joins

  • Indexes : Need, Types and Usage
  • Index : Architecture & Placement
  • Index Pages : Design and References
  • Query Optimizer and Query Executions
  • Index SCAN and Index SEEK Plans
  • Clustered & Non Clustered Indexes
  • SORT_IN_TEMPDB Options for Indexes
  • FILLFACTOR and PAD_INDEX Options
  • INCLUDED Column Indexes & Types
  • Using Indexes with Table Constraints
  • Unique Indexes and Tuning Options
  • Indexed Views, Query Plans and Tuning

Stored Procedures and Joins

  • Stored Procedures – Benefits
  • Types of Stored Procedures
  • Use of Variables and Parameters
  • Using SPs for SQL Data Validations
  • Using SPs for Data Reporting Operations
  • Using SPs for Joined Data Sets
  • System Stored Procedures and Usage
  • Dynamic SQL Queries & Usage
  • RECOMPILE Options and Advantages
  • Using SPs with Cursors – Querying
  • Procedures with Temporary Tables

Functions and Sub Queries

  • Functions – Types and Benefits
  • Scalar Value Functions & Usage
  • Inline Table Value Functions & Usage
  • Multi-line Functions – Scope, Usage
  • CROSSAPPLY and CONVERT options
  • SCHEMABINDING, ENCRYPTION Options
  • Embedding Functions in Queries
  • System Functions and Query Audits
  • Date, Time and String Functions
  • Aggregate and GROUPING Functions
  • Date Functions and CONVERT() Styles
  • Comparing CAST and CONVERT()
  • Using CROSSAPPLY, ROLLUP, GROUP BY
  • Comparing HAVING & WHERE in SELECT

Stored Procedures with Triggers & Cursors

  • Triggers – Types and Usage
  • Understanding Trigger Executions
  • DML Triggers & Performance Impact
  • INSERTED and DELETED Memory Tables
  • FOR Triggers – Importance and Usage
  • Instead Of Triggers – Importance
  • BULK Operations with DML Triggers
  • Using Triggers for Audit Operations
  • Triggers for Data Sampling Operations
  • Database Level Triggers – Usage
  • Server Level Triggers – Usage
  • Triggers for Updatable Views (Cascade)
  • Cursor Variables – Types and Usage
  • STATIC versus DYNAMIC Cursors
  • SCROLL Versus FORWARD_ONLY Cursors
  • LOCAL, GLOBAL and KEYSET Cursors
  • Cursors For Dynamic SQL Queries
  • Embedding Cursors in Stored Procedures
  • Using Temporary Tables with Procedures
  • Temp Tables versus Table Variables

Stored Procedures with Transactions

  • Understanding ACID Properties, Scope
  • Explicit and Implicit Transactions
  • Comparing Autocommit and Explicit
  • Comparing Autocommit and Implicit
  • Nesting Of Transactions – Benefits
  • Savepoints and working with Batches
  • Object Blocking Issues & Solutions
  • Query Blocking Issues & Solutions
  • Nested Transactions and Savepoints
  • Lock Hints in Queries & Performance
  • Query Blocking – Real-world Considerations.

Please write to us at info@cromacampus.com for the course price, schedule & location.

Enquire Now

Frequently Asked Questions:

All training courses offered by us are through IT Professional with 10+ years of experience. Freshers/College Students/Professionals(IT & Non-IT) can spot the quality of training by attending one lecture. Hence, we provide one free demo class to all our trainees so that they can judge on their own.

No, you don’t have to pay anything to attend the demo class. You are required to pay the training fee after free demo only if you are fully satisfied and want to continue the training.

To register for free demo, visit our campus or call our counsellors on the numbers given on contact us page.

Yes, all the trainees shall work on live projects provided by Croma Campus after completing their training part.

You will never lose any lecture. You can choose either of the two options:
View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.

Please note, access to the course material will be available for lifetime once you have enrolled into the course.

Yes, Training certificate & Project completion will be issued by Croma Campus(ISO 9001-2000 Certified Training Center)

Yes, Croma Campus conduct special training programs on week end for college students throughout the year.

Croma Campus is the largest education company and lots of recruitment firms contacts us for our students profiles from time to time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

Yes, Course Fee can be paid in two equal installments with prior Approval.

Yes, Croma Campus offer various group or special discounts.

No, Lab is open from 8 A.M. to 8 P.M. seven days a week. This time can be extended upto 11 PM if need arises.

Yes, students can take breaks during their exams and can resume it later without paying any fee. Apart from this, Students can attend batches for revision even after completion of their courses.

Batch strength differ from technology to technology. Minimum batch strength at Croma Campus is 10 and maximum batch strength is 30.

Drop us a query

Course Features

Get Practical and Well focused training from Top IT Industry experts.

Get Routine assignments based on learning from previous classes.

Live project, during or after the completion of the syllabus.

Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

Get certification after the course completion.

+91-9711526942 whatsapp

Testimonials