What is SQL SERVER?

SQL Server is a Microsoft product. It used to manage and store information. SQL Server is a “relational database management system”. Apart, this term means two things. First, that data stored inside SQL Server in a “relational database”. second, that SQL Server is an entire “management system”, not a database. SQL itself stands for Structured Query Language. The language used to manage and administer the database server.

Why We Take  SQL Server Training In kosmik Technologies

Kosmik Technologies provides SQL Server Training in Hyderabad. We offer Real time Database Design in hands on experience in live Case Studies.

 

SQL Server Training in Hyderabad

 

SQL SERVER COURSE CONTENT

 
Chapter 1: About Database & Data Warehouse
 
• What is Database?
 
• What is Data Warehouse?
 
• Difference between Database & Data Warehouse
 
Chapter 2: SQL Server 2012/2014 Database Design
 
• Database Creation using GUI
 
• Database Creation using T-SQL Scripts
 
• DB Design using Files
 
• File locations and Size Parameters
 
• DB Log Files, Growth and Placement
 
• DB Structure Modifications & Ownership
 
Chapter 3: SQL Server Tables and T-SQL Queries
 
• Table creation using T-SQL Scripts
 
• DML Operations: INSERT, UPDATE, DELETE
 
• Single Row and Multi-Row Insert Statements
 
• Table Aliases, Column Aliases & Usage
 
• Table creation with Schemas
 
• DELETE versus TRUNCATE Statements
 
• SELECT Queries and Sub Queries
 
• Schemas and Nested Queries with Aliases
 
Chapter4: Constraints, Keys and Data Validation
 
• Data Integrity and Normal Forms
 
• Tables with Keys & Constraints
 
• NULL and IDENTITY Properties – Usage
 
• UNIQUE KEY Constraint and NOT NULL
 
• PRIMARY KEY Constraint & Importance
 
• FOREIGN KEY and REFERENCE Attributes
 
• CHECK and DEFAULT Constraints, Usage
 
Chapter 5: Joins, Sub Queries and Nested Queries
 
• SELECT Statements – IIF, SWITCH, CHOOSE
 
• ORDER BY, GROUP BY, GROUPING, HAVING
 
• Sub Queries, Nested Queries and EXISTS
 
• DELETE from SELECT, UPDATE from SELECT
 
• INSERT INTO … SELECT & Data Copy
 
• Inner Joins – Purpose and Performance
 
• Outer Joins – Types, Advantages and Usage
 
• Cross Joins – Advantages and Limitations
 
• Self Joins and Sub Queries
 
Chapter 6: Joins, Views and Nested Queries
 
• Benefits of Views – End User Access
 
• Defining Views on Tables and Views
 
• SCHEMABINDING and ENCRYPTION Options
 
• ALTER TABLE Issues and Solutions with Views
 
• System Views & Management Views: Audits
 
• Joins and Nested Sub Queries in Views
 
Chapter 7: User Defined Functions and Joins
 
• Functions – Syntax, Usage and Importance
 
• Scalar Valued Functions and Examples
 
• Table Valued Functions and Examples
 
• System Functions and Joins – CROSSAPPLY
 
• Date, Time and Conversion Functions
 
• String Functions and Meta-data Functions
 
• ROWCOUNT, GROUPING, ROLLUP Functions
 
• Joining Functions and Tables / Views
 
Chapter 8: Indexes and Query Tuning
 
• Need for Indexes, Index Types & Usage
 
• Indexing Table & View Columns
 
• Index SCAN AND SEEK
 
• PRIMARY KEYS and Non Clustered Indexes
 
Chapter 9: Stored Procedures and Benefits
 
• Need for Stored Procedures & Syntax
 
• Use of Variables and Query Parameters
 
• Stored Procedures with Loops &IF… ELSE
 
• SCHEMABINDING and ENCRYPTION Options
 
• INPUT, OUTPUT & RESULTSET Parameters
 
• System Stored Procedures and Nesting
 
• Dynamic SQL Queries and Parameters
 
• Stored Procedures, Data Validation Options
 
• OUTPUT Parameters and Result set Options
 
Chapter 10: Triggers and Memory Limitations
 
• Triggers – Architecture, Types & Usage
 
• DML Triggers and Performance Impact
 
• INSERTED and DELETED Memory Tables
 
• Triggers for Audit Operations (Memory)
 
Chapter 11: Cursors, Stored Procedures, CTE
 
• Cursor Declaration and Fetch Options
 
• STATIC and DYNAMIC Cursor Types
 
• SCROLL and FORWARD_ONLY Cursors
 
• LOCAL and GLOBAL Cursors – Scope
 
• KEYSET Cursors and Temp Objects
 
• Embedding Cursors in SPs and Functions
 
• Temp Tables and Procedures with Cursors
 
• Common Table Expressions (CTE) and Queries
 
• Stored Procedures with CTE: Tuning Options
 
Chapter 12: Transactions & Procedures
 
• Transaction Options and Stored Procedures
 
• ACID Properties in T-SQL and Scope
 
• EXPLICIT Transaction Types and Issues
 
• IMPLICIT Transactions Types and Issues
 
• AUTOCOMMIT Transaction and Advantages
 
• Nested Points and Save Points usage
 
• Query Blocking Issues and Query Hints
 
• SPs with Transactions & Temp Objects