Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..
Batch
Date: Feb
26th @9:00PM
Faculty: Mr. Shekhar (15+ Yrs of Exp,.. & Real Time Expert)
Duration : 40 Days
Venue
:
DURGA SOFTWARE SOLUTIONS,
Flat No : 202,
2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038
Ph.No: +91 - 9246212143, 80 96 96 96 96
Syllabus:
SQL Server
MS SQL Server Development Topics:
- Background to T-SQL Querying and Programming
- Single-Table Queries
- Joins
- Subqueries
- Table Expressions
- Set Operators
- Beyond the Fundamentals of Querying
- Data Modification
- Transactions and Concurrency
- Programmable Objects
Background to T-SQL Querying and Programming:
SQL Server Architecture
- SQL Server Instances
- Databases
- Schemas and Objects
Creating Tables and Defining Data Integrity
- Creating Tables
- Defining Data Integrity
Single-Table Queries:
Elements of the SELECT Statement
- The FROM Clause
- The WHERE Clause
- The GROUP BY Clause
- The HAVING Clause
- The SELECT Clause
- The ORDER BY Clause
- The TOP and OFFSET-FETCH Filters
- A Quick Look at Window Functions
Predicates and Operators
CASE Expressions
NULL Marks
Working with Character Data
- Data Types
- Collation
- Operators and Functions
- The LIKE Predicate
Working with Date and Time Data
- Date and Time Data Types
- Literals
- Working with Date and Time Separately
- Filtering Date Ranges
- Date and Time Functions
- Querying Metadata
- Catalog Views
- Information Schema Views
- System Stored Procedures and Functions
Querying Metadata
- Catalog Views
- Information Schema Views
- System Stored Procedures and Functions
Joins:
Cross Joins
- ANSI SQL- Syntax
- Producing Tables of Numbers
Inner Joins
- ANSI SQL- Syntax
- Inner Join Safety
More Join Examples
- Composite Joins
- Non-Equi Joins
- Multi-Join Queries
Outer Joins
- Fundamentals of Outer Joins
- Beyond the Fundamentals of Outer Joins
Subqueries:
Self-Contained Subqueries
- Self-Contained Scalar Subquery Examples
- Self-Contained Multivalued Subquery Examples
Correlated Subqueries
Beyond the Fundamentals of Subqueries
- Returning Previous or Next Values
- Using Running Aggregates
- Dealing with Misbehaving Subqueries
Table Expressions:
Derived Tables
- Assigning Column Aliases
- Using Arguments
- Nesting
- Multiple References
Common Table Expressions
- Assigning Column Aliases in CTEs
- Using Arguments in CTEs
- Defining Multiple CTEs
- Multiple References in CTEs
- Recursive CTEs
Views
- Views and the ORDER BY Clause
- View Options
Set Operators:
The UNION Operator
- The UNION ALL Multiset Operator
- The UNION Distinct Set Operator
The INTERSECT Operator
- The INTERSECT Distinct Set Operator
- The INTERSECT ALL Multiset Operator
The EXCEPT Operator
- The EXCEPT Distinct Set Operator
- The EXCEPT ALL Multiset Operator
Beyond the Fundamentals of Querying:
Window Functions
- Ranking Window Functions
- Offset Window Functions
- Aggregate Window Functions
Pivoting Data
- Pivoting with Standard SQL
- Pivoting with the Native T-SQL PIVOT Operator
Unpivoting Data
- Unpivoting with Standard SQL
- Unpivoting with the Native T-SQL UNPIVOT Operator
Grouping Sets
- The GROUPING SETS Subclause
- The GROUPING and GROUPING_ID Functions
Data Modification:
Inserting Data
- The INSERT VALUES Statement
- The INSERT SELECT Statement
- The INSERT EXEC Statement
- The SELECT INTO Statement
- The BULK INSERT Statement
- The Identity Property and the Sequence Object
Deleting Data
- The DELETE Statement
- The TRUNCATE Statement
- DELETE Based on a Join
Updating Data
- The UPDATE Statement
- UPDATE Based on a Join
- Assignment UPDATE
Merging Data
- Modifying Data Through Table Expressions
- Modifications with TOP and OFFSET-FETCH
- The OUTPUT Clause
- INSERT with OUTPUT
- DELETE with OUTPUT
- UPDATE with OUTPUT
- MERGE with OUTPUT
- Composable DML
Transactions and Concurrency:
Transactions
Locks and Blocking
- Locks
- Troubleshooting Blocking
Isolation Levels
- The READ UNCOMMITTED Isolation Level
- The READ COMMITTED Isolation Level
- The REPEATABLE READ Isolation Level
- The SERIALIZABLE Isolation Level
- Isolation Levels Based on Row Versioning
Programmable Objects:
Variables
Batches
- A Batch As a Unit of Parsing
- Batches and Variables
- Statements That Cannot Be Combined in the Same Batch
- A Batch As a Unit of Resolution
- The GO n Option
Flow Elements
- The IF . . . ELSE Flow Element
- The WHILE Flow Element
- An Example of Using IF and WHILE
Temporary Tables
- Local Temporary Tables
- Global Temporary Tables
- Table Variables
- Table Types
Dynamic SQL
- The EXEC Command
- The sp_executesql Stored Procedure
- Using PIVOT with Dynamic SQL
Routines
- User-Defined Functions
- Stored Procedures
- Triggers
Error Handling
SSIS
Introduction to SQL Server Integration Services
- SSIS Historical Overview
- SSIS Architecture
- Tools of the Trade
- Creating a Simple Package
- Practice
SSIS Tools
