SQL Server on 16th Mar (Monday) 2:00PM-3:00PM at Maitrivanam(Hyd) by Mr. Bhaskar

Syllabus:

Introduction to DBMS:-

Understanding Data & Information
Database
DBMS
RDBMS
DB DESIGN
   Using ER MODEL
   Using Normalization

Introduction to SQL Server :-

Understanding Client/Server Architecture
SQL Server Versions
SQL Server Instance
SQL Server Editions
Tools in SQL Server
SQL Server Management Studio
Creating Sample DB manually & using wizard
Introduction to TSQL
Sublanguages of TSQL
   DDL,DML,DRL,TCL,DCL
Creating Tables
Inserting Data into Tables
Working With Single Table Queries :-
Writing Queries using SELECT statement
Understanding Query Flow
Operators in SQL Server
Clauses in SQL Server
Filtering Data Using WHERE clause
Sorting Data Using ORDER BY clause
Eliminating Duplicates using DISTINCT clause
Using TOP clause
DML commands :-
Copying data from one table to another
Update Command
Delete Command
Using OUTPUT clause
DDL commands :-

Creating Tables from another table
ALTER command
DROP command
TRUNCATE command
DELETE vs TRUNCATE
Built-in Functions :-
Scalar Functions
    String
    Date
    Mathematical
    Conversion
    Environment
    Working with NULL & coalesce
Group Functions
Aggregating Data :-
Writing Queries using Aggregate functions
Grouping Data Sets
Filtering Groups using HAVING clause
Adding Grand Total
Grouping_id function
Generating Matrix Report
Using New Window Functions
Merging Data With JOINS & UNION :-
Importance of Join operation
Types of Joins
   Inner join or equi join
   Outer join
     Left Outer Join
     Right Outer Join
     Full Outer Join
   Non-equi Join
   Self Join
   Cross Join
Complex joins
Stacking Data with UNION
Finding Set Difference
JOIN VS UNION
SubQueries :-
Importance of Subquery
Types of Subqueries
    Single Row Subqueries
    Multi Row Subqueries
    Nested Queries
    Co-related Subqueries
Derived Tables
Subqueries as Expressions
WITH clause
TOP N Queries
Database Transactions :-

Controlling Transactions using COMMIT & ROLLBACK
Introducing ACID properties
Working With LOCKS
Viewing DeadLocks
Various Isolation Properties

Database Security :-

Understanding privileges
Types of privileges
Granting & Revoking Privileges

Schema Objects :-
Views
Synonyms
Creating indexes
Examining Query Execution Plan
Materialized Views
TSQL programming :-
Introduction to TSQL
Writing programs
Working with variables
Controlling Procedural Flow
Working With CURSOR
Handling Errors
Controlling Transactions
Stored Procedures :-
Introduction to Stored Procedures
Working with Parameters
Working with OUT parameters
Optional parameters
Calling stored procedures from front-end applications
User Defined Functions :-
Creating Scalar Functions
Working with Inline Table-Valued Functions
Triggers & AUDIT TRAILS :-
Purpose of creating Triggers
Using AFTER triggers
Using INSTEAD OF triggers
Disabling triggers
Auditing Data changes
Advanced Topics in SQL SERVER
Creating Reports using SSRS