Techsage | Oracle - SQL Server

Oracle

Oracle SQL Server & T-SQL Queries

Techsage an ISO Certified IT Training Institute 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.

Course Content - Oracle SQL Server

SQL Server Fundamentals & T-SQL Queries

SQL Server Installation - More
- 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 - More
- SQL Server Database Architecture
- Database Catalog and Storage Options
- Data Files : Purpose and Storage
- File groups : 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
- File growth 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 - More
- Tables Design Concepts & Normal Forms
- Table Creation Process and Options
- File Groups and Table Design
- Role of Schema 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
- DELETE versus TRUNCATE Statements
Normalization, Keys and Constraints - More
- 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 - More
- 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 - More
- 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 - More
- 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 - More
- 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 - More
- 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 - More
- Understanding ACID Properties, Scope
- Explicit and Implicit Transactions
- Comparing Auto commit and Explicit
- Comparing Auto commit and Implicit
- Nesting Of Transactions – Benefits
- Save points and working with Batches
- Object Blocking Issues & Solutions
- Query Blocking Issues & Solutions
- Nested Transactions and Save points
- Lock Hints in Queries & Performance
- Query Blocking – Real-world Considerations.

For more information about the training you can Contact US