SUBSCRIBE VIA EMAIL TO GET NEW BATCH UPDATES

Enter your email address to get new batch updates:

Delivered by FeedBurner

Wednesday, December 31, 2014

SQL Server on 5th Jan (Monday) 7:00PM at Maitrivanam (Hyd) by Mr. Vijay Kumar

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

No comments:

Post a Comment

Blog Archive