SQL Server Training in Hyderabad

✓ Data Fundamentals

• What is Data and Data Formats
• Data Storages
• Structure Data Presence in Database
• On Premises and Cloud Data Storages 
• Database Providers and Products

✓ SQL Fundamentals

Sql Use in different Platforms

• Frontend Applications
• Business Intelligence
• Data Engineering
• Data Science

How To Interact wit Different Database by using Sql

Opportunities with Sql

✓ Versions and Editions in SQL Server

✓ Editions of SQL Server

• Enterprise Edition
• Standard Edition
• Developer Edition
• Work Group Edition
• Express Edition

✓ Features of Sql Server

✓ IDES in Sql Server

✓ Sql Server Tools

• Database
• SSIS
• SSRS
• SSAS

✓ SQL Server Database Installation

✓ Server Name, Instance and Authentication

✓ Installation Summary

✓ Sql Server Management Studio Installation

• Object Explorer
• Query Editor

✓ Sql Server Connections with SSMS

• Single instance
• Multi instance

✓ System Defined Databases and Usage

• Masterdb
• Msdb
• Modeldb
• Tempdb

✓ User Defined Database Creation and Usage

✓ Mdf, Ldf and Ndf Files

✓ Basic Operations on User Defined Tables

• Create User Tables
• insert Data
• Update Data
• Delete Data

✓ Difference Between Query and Command
✓ Query and Command Execution in Sql Server
✓ Parser, Compiler, Optimizer, Syntaxer and CLR
✓ Storage Engine [Sql Engine]
✓ Lock, File, Transaction Manager and Buffer Manager
✓ Buffer and Threads

✓ Create Table Structure
✓ Modify Table Structure

• Alter      Add
• Alter      Alter
• Alter   Modify

✓ Remove Data and Structure from Tables
✓ Select Into Command
✓ Truncate and Drop Difference
✓ Sql Server Datatypes

✓ Data Loading into Tables
✓ Single Row, Multi Row and Required Column Insert into Tables
✓ Modify Table Date
✓ Remove Data from Tables
✓ Difference Between Truncate, Delete and Drop
✓ Bulk Insert
✓ Merge Command Operations
✓ Insert Table Data from Another Table

✓ Data Loading into Tables
✓ Single Row, Multi Row and Required Column Insert into Tables
✓ Modify Table Date
✓ Remove Data from Tables
✓ Difference Between Truncate, Delete and Drop
✓ Bulk Insert
✓ Merge Command Operations
✓ Insert Table Data from Another Table

✓ Providing privileges [GRANT]
✓ Removing privileges [REVOKE AND DENY]
✓ Implicit and Explicit Grants

✓ Providing privileges [GRANT]
✓ Removing privileges [REVOKE AND DENY]
✓ Implicit and Explicit Grants

✓ Working with Select Statement
✓ Clauses
         • From
        • Where
        • Group By
        • Having
        • Order By

✓ Single Value Match Operators

       • Artha Matic           Operators
             +, -, *, %, /
        • Comparison Operators
               <, >, <=, >=, =, <>, !=
       • Logical        Operators
               AND, OR, NOT

✓ Multi Value Match Operators

        • In Not In
        • Between Not Between
        • Like Not Like
        • Exists Not Exists
        • Is Null Is Not Null

✓ Working With TOP

✓ Set Theory Generic Protocols
✓ Intersect
✓ Union
✓ Union All
✓ Except
✓ Working On Incremental Loading

✓ Simple Sub Query
✓ Correlated Sub Query
✓ Nested Sub Query
✓ Difference Between Simple and Correlated Sub Query

✓ Joins In Realtime Usage
✓ Cross Join and Cross Apply
✓ Inner Join [Equi, Non Equi]
✓ Natural Join
✓ Self-Join
✓ Left Outer Join
✓ Right Outer Join
✓ Full Outer Join
✓ Anti Left Outer Join
✓

✓ Anti Right Outer Join
✓ Working on ON and WHERE Clauses
✓ Merge Join
✓ Loop Join
✓ Hash Join

✓ Domain Integrity

• Not Null
• Default
• Check

✓ Entity Integrity

• Primary Key and Limitations
• Unique and Limitations

✓ Referential Integrity

• Foreign Key

✓ Kyes

• Composite Key
• Candidate Key
• Alternate   Key
• Super          Key
• Artificial    Key

✓ Normal Column and Identity Column

✓ Cascading

• On Delete Cascade
• On Update Cascade
• ON Delete Set NULL
• On Update Set NULL
• On Delete Set No Action

✓ What is Normalization
✓ Types Of Normalization
✓ 1: 1, 1: Many, Many to Many Relations
✓ Business, Conceptual, Logical, Physical Data Model
✓ Dimension, Fact Tables
✓ Dimension Model Schemas [ Star, Snowflake, Galaxy]
✓ Entity Relational Model [OLTP]
✓ Dimension Model [OLAP]

✓ Clustered Index Design and Structure
✓ Non-Clustered Index Design and Structure
✓ Unique Index Design
✓ Index with Included Columns
✓ Column Storage Index
✓ Full-Text Index Population
✓ Filtered Index Design
✓ Covering Index Design
✓ B-Tree and Online Indexes
✓ Index View Vs Materialized Views
✓ Fill Factor, TEMPDB, Pat Index

✓ What Is Schema and Realtime advantages with practical
✓ System Defined Procedures Usage with Example

• Sp_Help, Sp_HelpText, Sp_Rename, Sp_Tables, Sp_Who2, Sp_Who
• Sp_Spaceused, Sp_Statistics, Sp_ForeignKeys

✓ System Defined Views Usage with Example

• Sys.Servers, Sys.Database, Sys.Objects, Sys.Schemas, Sys.View, Sys.Indexes
• Information_Schema. Tables, Information_Schema.Columns

✓ Difference Between Group by and Distinct, Performance Impact
✓ Group By and Having Usages to Identify and Eliminate Duplicates
✓ Rollup And Cube
✓ Creating Full Totals and Sub totals
✓ Comparing Rollup, Cube and Group Functions

✓ Advantages and Limitations of Views
✓ Tables Vs Views
✓ Simple Views [Modifiable View]
✓ Complex Views [Read Only View]
✓ Materialized Views
✓ Encypted Views, Schema Binding Views

✓ Advantages and Limitations of Functions
✓ System Defined Functions
• String Functions
                                          ASCII                                             LEN                                                RTRIM
                                         CHAR                                            LOWER                                        SPACE
                                        CHARINDEX                              LTRIM                                           STR
                                        CONCAT                                       NCHAR                                         STUFF
                                        CONCATE WITH +                 PATINDEX                                 SUBSTRING
                                         DATALENGTH                          REPLACE                                    UPPER
                                        LEFT                                                  RIGHT
• Aggregate Functions

                                         AVG                                               BINARY_CHECKSUM                    CHECKSUM
                                         CHECKSUM_AGG              COUNT                                                     COUNT_BIG
                                         GROUPING                             GROUPING_ID                                     MAX
                                          MIN                                              STDEV                                                         STDEVP
                                         SUM                                              VAR                                                                VARP
• Configuration Functions

                                         DATEFIRST                                     DBTS                                                 LANGID
                                         LANGUAGE                                   LOCK_TIMEOUT                      MAX_CONNECTIONS
                                        MAX_PRECISION                      NESTLEVEL                                  OPTIONS
                                       REMSERVER                                 SERVERNAME                              SERVICE NAME
                                       SPID                                                   TEXTSIZE                                          VERSION

• Cursor Functions
                                       CURSOR_STATUS                        CURSOR_ROW                         FETCH_STATUS

• Date and Time Functions
                                      CURENT_TIME                               STAMP DATEADD                    DATEDIFF
                                      DATENAME                                      DATEPART                                    DAY
                                      GATDATE                                         GATUTCDATE                             ISDATE
                                     MONTH                                              SYSDATETIME                             SYSDATETIMEOFFSET
                                    SYSUTCDATETIME                        SWITCHOFFSET                         TODATETIMEOFFSET
                                   YEAR
• Mathematical Functions
                                     ABS                                                        ACOS                                                   ASIN
                                    ATAN                                                     ATN2                                                    CEILING
                                   COS                                                         COT                                                      DEGRESS
                                   EXP                                                         FLOOR                                                 LOG
                                   LOG10                                                   PI                                                             POWER
                                  RADIANS                                              RAND                                                     ROUND
                                  SIGN                                                       SIN                                                           SQRT
                                  SQUARE                                               TAN
• Other Functions
                                    APPNAME                                       CAST                                                      COALESCE
                                    CONVERT                                      CURENT_USER                                   DATALENGTH
                                   GETANSINULL                              HOST_ID                                                 HOST_NAME
                                   IDENT_CURRENT                       IDENT_INCR                                          IDENT_SEED
                                   IDENTITY                                        ISNULL                                                      ISNUMARIC
                                  NEWID                                              NULLIF                                                      PARSENAME
                                 PERMISSIONS                                ROWCOUNT                                           ROWCOUNT_BIG
                                 SCOPE_IDENTITY                       SESSION_USER                                       STATEM_USER
                                 TRANCOUNT                                 USER_NAME
✓ System Defined Window Functions
                  • Intro to window functions
                  • Basic windowing syntax
                 • The usual suspects: SUM, COUNT, and AVG
                 • ROW_NUMBER ()
                 • RANK () and DENSE_RANK ()
                 • NTILE
                 • LAG and LEAD
                 • Defining a window alias
✓ User Defined Functions
               • Scalar-valued Functions
               • Table-valued Functions
✓ Difference Between Functions and Procedures                                                                                               

✓ Variable Declarations and Assignments
✓ Basic syntax
✓ Conditional Statements
✓ Multi Branching Conditional Statements
✓ Iterative Statements
✓ Exception/ Error Handling

✓ Use in Real Time and Types
✓ System Defined and User Defined Procedures
✓ Dynamic Sql Quires in Procedures
✓ In, Out, InOut Parameters
✓ Dynamic Data Insertion with Procedures
✓ Using TEMP Tables in Procedures
✓ Stored Procedure inside Stored Procedure

✓ Local Variables Vs Global Variables with Example
✓ Table Valued Variables
✓ Temporary Table Usage in Real Time
✓ Inline Views Vs Normal Views
✓ Common Table Expressions
✓ CTE usage in Real Time
✓ Multiple Examples using CTE
✓ Duplicate Finding and Removing
✓ Non-Recursive and Recursive CTE

✓ Use in Real Time
✓ Triggers Vs Procedures
✓ Types Of Triggers
✓ DML Triggers
✓ DDL Triggers
✓ FOR Triggers
✓ INSTEAD Of Triggers

✓ What is Cursor.
✓ Cursor Life Cycle
✓ Working Process of Cursor.

✓ Creating Dynamic SELECT Statements.
✓ Passing Dynamic Table Names
✓ Create a Procedure with Dynamic Table Names and Varables
✓ Normal SQL Vs. Dynamic SQL

✓ Project Explanation
✓ Day to Day Activities
✓ Real Time Database Environment
✓ Challenges
✓ Performance Tuning