SUBSCRIBE VIA EMAIL TO GET NEW BATCH UPDATES

Enter your email address to get new batch updates:

Delivered by FeedBurner

Saturday, February 28, 2015

ORACLE (Free Workshop) ( Topic: Diff b/w Joins & Sub Query) on 1st Mar (Sunday) by Mr. KrishnaReddy 7:15AM at Maitrivanam(Hyd)

ORACLE (Free Workshop) ( Topic: Diff b/w Joins & Sub Query) on 1st Mar (Sunday) by Mr. KrishnaReddy 7:15AM at Maitrivanam(Hyd)



Posted by at No comments:

Selenium on 2nd Mar (Monday) by Mr. Nagesh.K 7:30AM-9:00AM at Maitrivanam(Hyd)

Selenium on 2nd Mar (Monday) by Mr. Nagesh.K 7:30AM-9:00AM at Maitrivanam(Hyd)

http://durgasoft.com/Selenium-nagesh.asp
Posted by at No comments:

C Language On 2nd Mar (Monday) by Mr. Ramana 7:15AM at S.R.Nagar(Hyd)

C Language On 2nd Mar (Monday) by Mr. Ramana 7:15AM at S.R.Nagar(Hyd)

http://durgasoft.com/C-language%20Ramana1.asp
Posted by at No comments:

.NET On 2nd Mar (Monday) by Mr.Mohan Reddy 9:00AM at KPHB (Hyd)

.NET On 2nd Mar (Monday) by Mr.Mohan Reddy 9:00AM at KPHB (Hyd)

http://durgasoft.com/Dot%20Net%20MohanReddy%20kphb.asp
Posted by at No comments:

CORE JAVA (Fast Track) On 2nd Mar (Monday) by Mr. Ratan 10:00AM at Maitrivanam(Hyd)


CORE JAVA (Fast Track) On 2nd Mar (Monday) by Mr. Ratan 10:00AM at Maitrivanam(Hyd)


http://durgasoft.com/Core%20Java%20Ratan_Maitrivnm_add.asp
Posted by at No comments:

Sharepoint on 2nd Mar (Monday) by Mr. Ratan 8:00AM at Maitrivanam(Hyd)

Sharepoint on 2nd Mar (Monday) by Mr. Ratan 8:00AM at Maitrivanam(Hyd)

http://durgasoft.com/Sharepoint-jan%20manjunadh.asp
Posted by at No comments:

.Net On 2nd Mar (Monday) by Mr. Mahesh (Microsoft Certified & RealTime Expert) 10:30AM at Maitrivanam(Hyd)

.Net On 2nd Mar (Monday) by Mr. Mahesh (Microsoft Certified & RealTime Expert) 10:30AM at Maitrivanam(Hyd)

http://durgasoft.com/Dot%20Net%20Maheshbabu_26.asp
Posted by at No comments:

Android On 2nd Mar (Monday) by Mr. Mahesh 10:30AM atS.R Nagar (Hyd)


Android On 2nd Mar (Monday) by Mr. Mahesh 10:30AM atS.R Nagar (Hyd)


http://durgasoft.com/Android%20mahesh_Sr%20add.asp
Posted by at No comments:

ORACLE 11g/12c On 2nd Mar (Monday) by Mr. KrishnaReddy 3:00PM at Maitrivanam(Hyd)


ORACLE 11g/12c On 2nd Mar (Monday) by Mr. KrishnaReddy 3:00PM at Maitrivanam(Hyd)

http://durgasoft.com/Oracle%20Krishna%20Reddy.asp
Posted by at No comments:

CORE JAVA (Fast Track) On 2nd Mar (Monday) by Mr. Ratan 4:00PM-6:00AM at Maitrivanam(Hyd)

CORE JAVA (Fast Track) On 2nd Mar (Monday) by Mr. Ratan 4:00PM-6:00AM at Maitrivanam(Hyd)

http://durgasoft.com/Core%20Java%20Ratan_Madapue_add.asp
Posted by at No comments:

Aptitude on 2nd Mar (Monday) by Team of Experts 6:00PM-8:00PM at Matrivanam(Hyd)

Aptitude on 2nd Mar (Monday) by Team of Experts 6:00PM-8:00PM at Matrivanam(Hyd)


http://durgasoft.com/Aptitude%20Training%20add-4.asp
Posted by at No comments:

JSP (Free Batch) on 3rd Mar (Tuesday) by Mr. NagoorBabu 3:00PM-4:30PM at Maitrivanam(Hyd)


JSP (Free Batch) on 3rd Mar (Tuesday) by Mr. NagoorBabu 3:00PM-4:30PM at Maitrivanam(Hyd)

http://durgasoft.com/JSP%20nagoorbabu_3.asp
Posted by at No comments:

CORE JAVA On 4th Mar (Wednesday) by Mr. Nagoor Babu 7:00AM at Maitrivanam(Hyd)


CORE JAVA On 4th Mar (Wednesday) by Mr. Nagoor Babu 7:00AM at Maitrivanam(Hyd)


http://durgasoft.com/Core%20Java%20Nagoor%20add.asp
Posted by at No comments:

PL/SQL on 4th Mar (Wednesday) by Mr. Krishna Reddy 11:00AM at Maitrivanam(Hyd)

PL/SQL on 4th Mar (Wednesday) by Mr. Krishna Reddy 11:00AM at Maitrivanam(Hyd)

http://durgasoft.com/PLSQL-krishnareddy%20add.asp
Posted by at No comments:

Hibernate (Fast Track) On 4th Mar (Wednesday) by Mr. Naveen 5:00PM at S.R Nagar (Hyd)


Hibernate (Fast Track) On 4th Mar (Wednesday) by Mr. Naveen 5:00PM at S.R Nagar (Hyd)

http://durgasoft.com/Hibernate-NaveenFT.asp
Posted by at No comments:

Selenium Mr. Nagesh.K 4th Mar (Wednesday) 6:30PM-8:30PM Maitrivanam(Hyd)

Selenium Mr. Nagesh.K 4th Mar (Wednesday) 6:30PM-8:30PM Maitrivanam(Hyd)

http://durgasoft.com/Selenium-nagesh1.asp
Posted by at No comments:

Spring (Fast Track) on 4th Mar (Wednesday) by Mr. Naveen 7:00PM at S.R Nagar (Hyd)


Spring (Fast Track) on 4th Mar (Wednesday) by Mr. Naveen 7:00PM at S.R Nagar (Hyd)


http://durgasoft.com/Spring%20naveen%20add%20-FT_4%20.asp
Posted by at No comments:

HADOOP On 5th Mar (Thursday) by Mr. Ramakrishna 8:30AM-9:30AM at Madhapur (Hyd)

HADOOP On 5th Mar (Thursday) by Mr. Ramakrishna 8:30AM-9:30AM at Madhapur (Hyd)

http://durgasoft.com/Hadoop%20ramakrishna%20madhapur.asp
Posted by at No comments:

CORE JAVA on 5th Mar (Thursday) by Mr. Siva 9:15AM at KPHB(Hyd)



CORE JAVA on 5th Mar (Thursday) by Mr. Siva 9:15AM at KPHB(Hyd)

http://durgasoft.com/Core%20Java%20Siva%20kphb.asp

Posted by at No comments:

Testing Tools (Manual + Selenium) On 5th Mar (Thursday) by Mr. Nagesh.K 10:00AM-1:00PM at Maitrivanam(Hyd)


Testing Tools (Manual + Selenium) On 5th Mar (Thursday) by Mr. Nagesh.K 10:00AM-1:00PM at Maitrivanam(Hyd)

http://durgasoft.com/Testing%20Tools%20Nagesh.asp
Posted by at No comments:

HADOOP on 5th Mar (Thursday) by Mr. Ramakrishna 11:00AM-1:00PM at Maitrivanam(Hyd)



HADOOP on 5th Mar (Thursday) by Mr. Ramakrishna 11:00AM-1:00PM at Maitrivanam(Hyd)

http://durgasoft.com/Hadoop%20ramakrishna%20srnagar.asp
Posted by at No comments:

C -Language On 5th Mar (Thursday) by Mr. Kiran 6:00PM at Maitrivanam(Hyd)

C -Language On 5th Mar (Thursday) by Mr. Kiran 6:00PM at Maitrivanam(Hyd)

http://durgasoft.com/C-language%20Kiran.asp
Posted by at No comments:

HADOOP On 5th Mar (Thursday) by Mr. Ramakrishna 7:00PM-9:00PM at Maitrivanam(Hyd)


HADOOP On 5th Mar (Thursday) by Mr. Ramakrishna 7:00PM-9:00PM at Maitrivanam(Hyd)

http://durgasoft.com/Hadoop%20ramakrishna%20srnagar7-9.asp
Posted by at No comments:

Spring (Weekend Workshop) on 7th Mar (Saturday) by Mr. Naveen 9:00AM at S.R Nagar(Hyd)


Spring (Weekend Workshop) on 7th Mar (Saturday) by Mr. Naveen 9:00AM at S.R Nagar(Hyd)

http://durgasoft.com/Spring%20naveen_Weekend%20add%20.asp
Posted by at No comments:

Struts (Weekend Workshop) On 7th Mar (Saturday) by Mr. AnjiReddy 9:00AM at S.R Nagar(Hyd)

Struts (Weekend Workshop) On 7th Mar (Saturday) by Mr. AnjiReddy 9:00AM at S.R Nagar(Hyd)

http://durgasoft.com/Struts%20Anji%20Reddy%20srnagar%20week.asp
Posted by at No comments:

CV's (One Day Workshop) On 7th Mar (Saturday) by Mr. AnjiReddy 4:00PM at S.R Nagar(Hyd)

CV's (One Day Workshop) On 7th Mar (Saturday) by Mr. AnjiReddy 4:00PM at S.R Nagar(Hyd)


http://durgasoft.com/CVSAnjireddy-%20add.asp
Posted by at No comments:

ASP.NET MVC On 9th Mar (Monday) by Mr. MaheshBabu 7:00AM at Maitrivanam(Hyd)

ASP.NET MVC On 9th Mar (Monday) by Mr. MaheshBabu 7:00AM at Maitrivanam(Hyd)

http://durgasoft.com/ASP.NET%20MVC-Mashesh.asp
Posted by at No comments:

SPRING On 11th Mar (Wednesday) by Mr. Sriman 7:30PM at Maitrivanam (Hyd)

SPRING On 11th Mar (Wednesday) by Mr. Sriman 7:30PM at Maitrivanam (Hyd)

http://durgasoft.com/Spring%20Sriman%20new.asp
Posted by at No comments:

Android On 12th Mar (Thursday) by 9:00AM at S.R Nagar (Hyd)


Android On 12th Mar (Thursday) by 9:00AM at S.R Nagar (Hyd)


http://durgasoft.com/Android%20mahesh_SrNagar%20add.asp
Posted by at No comments:

Spring (Fast Track) On 12th Mar (Thursday) by Mr. Naveen 7:00AM at S.R Nagar (Hyd)


Spring (Fast Track) On 12th Mar (Thursday) by Mr. Naveen 7:00AM at S.R Nagar (Hyd)

http://durgasoft.com/Spring%20naveen%20add%20-FT%20.asp
Posted by at No comments:

Webservices (Weekend workshop) On 14th Mar (Saturday) by Mr. Ravichandra 9:00AM by S.R Nagar (Hyd)



Webservices (Weekend workshop) On 14th Mar (Saturday) by Mr. Ravichandra 9:00AM by S.R Nagar (Hyd)

http://durgasoft.com/WebServices%20RaviChandra%20weekends.asp
Posted by at No comments:

Hibernate (Fast Track) On 16th Mar (Monday) by Mr. Naveen 11:00AM at S.R Nagar (Hyd)


Hibernate (Fast Track) On 16th Mar (Monday) by Mr. Naveen 11:00AM at S.R Nagar (Hyd)

http://durgasoft.com/Hibernate-Naveen_FT-16.asp
Posted by at No comments:

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



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


http://durgasoft.com/SQL%20Server-Bhaskar.asp
Posted by at No comments:

Struts (Fast Track) On 19th Mar (Thursday) by Mr. Naveen 9:00AM at S.R Nagar (Hyd)



Struts (Fast Track) On 19th Mar (Thursday) by Mr. Naveen 9:00AM at S.R Nagar (Hyd)

http://durgasoft.com/Struts%20naveen_19.asp
Posted by at No comments:

Friday, February 27, 2015

CORE JAVA (Fast Track) Mr. Ratan 2nd Mar (Monday) 10:00AM Maitrivanam(Hyd)

Posted by at No comments:

C Language Mr. Ramana 2nd Mar (Monday) 7:15AM S.R.Nagar(Hyd)

 http://durgasoft.com/#sthash.eDuCmO9w.dpuf
Posted by at No comments:

Selenium Mr. Nagesh.K 2nd Mar (Monday) 7:30AM-9:00AM Maitrivanam(Hyd)

Posted by at No comments:

ORACLE (Free Workshop) ( Topic: Diff b/w Joins & Sub Query) Mr. KrishnaReddy 1st Mar (Sunday) 7:15AM Maitrivanam(Hyd)

Posted by at No comments:

Testing Tools (Interview FAQ's) (Free workshop) Mr. Nagesh.K 1st Mar (Sunday) 4:00PM Maitrivanam(Hyd)

Posted by at No comments:

WCF Security & Web API (Free Workshop) Mr. Mahesh Babu 1st Mar (Sunday) 9:00AM Maitrivanam(Hyd)

Posted by at No comments:

JUNIT (One Day Workshop) Mr. AnjiReddy 28th Feb (Saturday) 4:00PM S.R Nagar (Hyd)

Posted by at No comments:

Spring (Weekend Workshop) Mr. AnjiReddy 28th Feb (Saturday) 9:00AM S.R Nagar (Hyd)

Posted by at No comments:

Hibernate (Weekend Workshop) Mr. Naveen 28th Feb (Saturday) 9:00AM S.R Nagar (Hyd)

Posted by at No comments:

JQuery (Free Workshop) Mr. Mahesh Babu 28th Feb (Saturday) 9:00AM Maitrivanam(Hyd)

Posted by at No comments:

Tuesday, February 24, 2015

Sharepoint on 25th Feb (Wednesday) 8:00AM at Maitrivanam(Hyd) by Mr. Manjunadha

http://durgasoft.com/Sharepoint-jan%20manjunadh.asp
Posted by at No comments:

ORACLE (FastTrack) on 25th Feb (Wednesday) 11:00AM at Maitrivanam(Hyd) by Mr. Wilson

http://durgasoft.com/Oracle_Wilson.asp
Posted by at No comments:

Adv.Java (Fast Track) on 25th Feb (Wednesday) 5:30PM-7:00PM at KPHB (Hyd) by Mr. AnjiReddy

http://durgasoft.com/Advjava_AnjiReddy%20Kphb.asp
Posted by at No comments:

C Language on 26th Feb (Thursday) 7:00AM at S.R.Nagar(Hyd) by Mr. Ramana

http://durgasoft.com/C-language%20Ramana1.asp
Posted by at No comments:

.Net on 26th Feb (Thursday) 10:30AM at Maitrivanam(Hyd) by Mr. Mahesh (Microsoft Certified & RealTime Expert)

http://durgasoft.com/Dot%20Net%20Maheshbabu_26.asp
Posted by at No comments:

SCJP on 26th Feb (Thursday) 11:00AM at Maitrivanam(Hyd) by Mr. Durga

http://durgasoft.com/SCJP%20Durga%20add2.asp
Posted by at No comments:

D2K (Forms & Reports) on 26th Feb (Thursday) 6:00PM at Maitrivanam(Hyd) BY Mr. KrishnaReddy

http://durgasoft.com/D2K%20Krishna%20Reddy.asp
Posted by at No comments:

SVN on 26th Feb (Thursday) 7:30PM-9:00PM at Maitrivanam(Hyd) by Mr. Sriman

http://durgasoft.com/SVN%20sriman.asp
Posted by at No comments:

CORE JAVA on 27th Feb (Friday) 7:00AM at Maitrivanam(Hyd) by Mr. Nagoor Babu

http://durgasoft.com/Core%20Java%20Nagoor%20add.asp
Posted by at No comments:

JUINT (One Day Workshop) on 28th Feb (Saturday) 4:00PM at S.R Nagar (Hyd) by Mr. AnjiReddy

http://durgasoft.com/JUNIT-AnjiReddy-Regbatch.asp
Posted by at No comments:

ORACLE on 2nd Mar (Monday) 3:00PM at Maitrivanam(Hyd) by Mr. KrishnaReddy

http://durgasoft.com/Oracle%20Krishna%20Reddy.asp
Posted by at No comments:

JSP (Free Batch) on 3rd Mar (Tuesday) 3:00PM-4:30PM at Maitrivanam(Hyd) by Mr. NagoorBabu

Syllabus:
1. Introduction
2. Jsp LifeCycle
3. Jsp Implicit Objects & Scopes
4. Jsp Directives
               1.page
               2.include
                3.taglib
5. Jsp Scripting Elements    
    
               1.declaratives
               2.scriptlets
               3.expressions
6. Jsp Actions
               a.Standard Actions
                              1. useBean tag
                              2. setProperty tag
                              3. getProperty tag
                              4. include tag
                              5. forward tag
                              6. param tag
                              7. plug-in tag
                              8. params tag                   
                              9. fallback tag                   
                            10. directives tag
                            11. scriptlet tag
                            12. expression tag
               b.Custom Actions
                            1. Classic Tags
                            2. Simple Tags
7. JSTL & Tag Library
Posted by at No comments:

Testing Tools (Manual + Selenium) on 5th Mar (Thursday) 10:00AM-1:00PM at Maitrivanam(Hyd) by Mr. Nagesh.K

http://durgasoft.com/Testing%20Tools%20Nagesh.asp
Posted by at No comments:

HADOOP on 5th Mar (Thursday) 7:00PM-9:00PM at Maitrivanam(Hyd) by Mr. Ramakrishna

Syllabus:
• BigData
  • What is BigData
  • Characterstics of BigData
  • Problems with BigData
  • Handling BigData
• Distributed Systems
  • Introduction to Distributed Systems
  • Problems with Existing Distributed Systems to deal BigData
  • Requirements of NewApprocach
  • HADOOP history
• HADOOP Core Concepts
  • HDFS
  • MapReduce
• HADOOP Cluster
  • Install Pseudo cluster
  • Install Multi node cluster
  • Configuration Introduction to HADOOP Cluster
  • The Five Deamons working
    • NameNode
    • JobTracker
    • SecondaryNameNode
    • TaskTracker
    • DataNode
  • Introduction to HADOOP EcoSystem projects
• Writing MapReduce programs
  • Understanding HADOOP API
  • Basic programs of HADOOP MapReduce ApplicationForm
    - Driver Code
    - Mapper Code
    - Reducer Code
  • Eclipse intigration with HADOOP for Rapid Application Development
• Understanding ToolRunner
  • More about ToolRunner
  • Combiner
  • Reducer
  • configure and close methods
• Common MapReduce Algorithems
  • Sorting
  • Searching
  • Indexing
  • TF-IDF
  • Word_CoOccurance
• HADOOP EcoSystem
  • Flume
  • Sqoop
  • Importing data from RDBMS using sqoop
  • Hive
  • Introduction to hive
  • Creating tables in hive
  • Running queries
  • Pig
  • Introduction to pig
  • Different modes of pig
  • when to use hive and when to use pig
  • HBASE
  • Basics of HBASE
• Advanced MapReduce Programming
  • Developing custom Writable
  • Developing custom WritableComparable
  • Understanding Input Output formats
• Introduction to Ooziee
• Hands ons Exercise for each concept
Posted by at No comments:

SPRING on 11th Mar (Wednesday) 7:30PM at Maitrivanam (Hyd) by Mr. Sriman

Syllabus:

S.NO
Topics Detailed
Content
1 Introduction to
Spring		 What is Spring

How Spring fits into the Enterprise world

Spring Modules
2 Spring Core
(Basic
Concepts)		 Theory/Practical

•What is a Core Container
• Introduction to IOC
• Types of DI
• Setter VS Constructor
• Resolving Constructor Confusion
• Collection DI
• Bean Inheritance
• Collection Merging
• Inner Beans
• Using IDRef
• Bean Aliasing
• Bean Scopes
• Inner Beans
• Null String
• Bean Auto wiring
• Nested Bean Factories
3 Spring Core
(Advanced
Concepts)		 Theory/Practica

• P – Namespace
• Dependency Check
• Depends On
• Factory Beans
• Static Factory Method
• Instance Factory Method
• Aware Interfaces
• Bean Lifecycle
• Method Replacement
• Lookup Method Injection
• Property Editors
• Bean Factory Postproces
4 Spring Core
(3.0
Annotations)		 Theory/Practical

• Spring VS Java Config Project annotations
• @Required
• @Autowire
• @PostConstruct
• @PreDestroy
• @Qualifier
• @Resource
•@Component
• @Service
• @Controller
• @Named

Various Annotation based Post Processors
(AutowiredAnnotationBeanPostProcessor,
CommonAnnotationBeanPostProcessor,
PersistenceAnnotationBeanPostProcessor,
RequiredAnnotationBeanPostProcessor)
5 Spring AOP Theory/Practical

• AOP Concepts
• Programmatic VS Declarative AOP
• Programmatic AOP
i. Types of Advices
ii. Types of Pointcuts
iii. Working with proxies
• Declarative AOP
i. Using AOP 2.0 Config element
ii. OGNL Expressions
• Aspect J AOP
6 Spring Tx Theory/Practical
• Aop 2.0 Configuration driven Transaction Management
• Aspect J annotation based Transaction Management
7 Spring JDBC Theory/Practical
• What is DAO pattern?
• Ways to implement Spring DAO
• Choosing an approach for JDBC database access
• JDBC Template
• Executing Statements
• Running Queries
• SQL Parameters
8 Spring MVC Theory/Practical
• Spring 3.0 features
• Introduction to Spring MVC
• Handler Mapping
• Controllers
• Validations
• Handler Interceptors
• Views
• Form tags
9 Spring ORM   Spring Integration with ORM
• Integrating with Hibernate
• Creating and Injecting Hibernate Session Factory
• Managing Transaction
10 Q & A   Question and Answers
Posted by at No comments:

Spring (Fast Track) on 12th Mar (Thursday) 7:00AM at S.R Nagar (Hyd) by Mr. Naveen

Syllabus:
i. Spring Introduction
ii. Containers & Responcibilitys
iii. Spring containers(core&j2ee_context)
iv. RTP,IOC
v. How to Achive IOC by-using Dependency Injection
vi. Types of Dependency Injections
i.setter
ii.Constructor

a. Important DI among Constructor&setter
b. Dependency-Checking (declarative&Annotation based)
c. Autowiring Delarative&Annotation
d. Dependency Injection (DI)
e. primitive data types
f. secondary data types by using ref ,ref bean
g. Collections &Predefined Classes(File,URL,Properties,Class etc.) DI
vii. Singleton,Factory Pattern,Instance Factory ,StaticFactory
viii. Types of Java beans
ix. Spring pojo's
x. .property file reader classes
xi. Spring-i18n

Bean lifyCycles:

i.Programatic
ii.Declarative
iii.Anotation(@PostConstruct and @PreDestroy )
BeanPostProcessor
MethodReplacer
EventHandling

DAO
i.Spring-JDBC
i.Using DataSource
ii.using JDBCTemplate
iii.NamedParameter
ii.Spring-ORM
Dao with Plain Hibernate
Dao with HibernateTemplate

AOP

i.programatic AOP
ii.Declarative AOP
iii.Pointcuts programatic&Declarative(@Pointcut(Exprestion))
iv.AspectJ
SpringTX

Importance of Transaction Management
i.JTA
ii.Deff BMT&CMT
iii.Spring Programatic&Declarative-TX

Spring-Remoting

Spring Remoting Applications
i.Sockets
ii.RMI &Spring RMI
iii.Hesion
iv.Burlap
v.Http Invoker

Spring MVC&WEB

Spring mvc architechure

i. Deff types of
i.Hadlers
ii.Controllers
iii.ViewResolvers
ii. Validations
iii. Interceptors
iv. MVC @annotation support
v. Spring-Strut's Integration
Posted by at No comments:

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
Posted by at No comments:

Posted by at No comments:

Monday, February 23, 2015

JASPER REPORT on 24th Feb (Tuesday) 7:30PM-9:00PM at Maitrivanam(Hyd) by Mr. Sriman

Syllabus:
1. Introduction

2. Steps to design Jasper Reports

3. Flow Diagram

4. Parameters

5. Data Source

6. Fields

7. Expressions

8. Variable

9. Charts

10. I Reports Tool

Posted by at No comments:

MSBI on 24th Feb (Tuesday) 9:30AM at Kphb (Hyd) by Mr.Bhaskar

SQL SERVER INTEGRATION SERVICES (SSIS)
 SSIS - COURSE CONTENT
 Introduction to Data Warehouse Concepts
o What is Data Warehouse
o Need for Data Ware house
o OLTP vs. OLAP
o What is BI
o Tools for BI
o Goals of BI
o Dimension and FactTables
o Cube
o Measure
o Surrogate Keys
o Data Warehouse Schemas
 Star Schema
 Snow Flake Schema
o Cube Storage
 ROLAP
 MOLAP
 HOLAP
o Data Warehouse vs. Data Marts
 Introduction to SSIS
o Understand BIDS Components
o DTS vs. SSIS
o Control Flow
o Data Flow
o Event Handlers
o Package Explorer
o Connection Managers etc
 Introduction to ControlFlow Items
o Containers
 ForLoop Container
 ForEachLoop Container
 Sequential Container
o Predecesor Constraints
o Control Flow Tasks
 Data Flow
 Execute SQL Task
 File System Tasks
 DBA Related Tasks etc
 Data Flow Items
o Data Flow Sources
o Data Flow Destinations
o Data Flow Transformations
 Agregate
 Audit
 Sort
 Merge
 Merge Join
 Union Al
 Lokup
 Fuzy Lokup
 Fuzy Grouping
 Conditonal Split
 Export Column
 Import Column
 Slowly Changing Dimensions (SCD)
 Derived Column
 Copy Column
 Cache Transformation etc,.
 SIS Variables and Expresions
o System Variables
o Local Variables
o Expresions
o Transactions and Check Points in SIS packages
 Create, Build and Deploy a package
o Create Package
o Build Package
o Deploy package
 Ad config files
 Ad Loging
 Ad Event Handlers
 Ad Eror Handling and Debuging
 Types of Deployments
 SQL Server
 File System
 Schedule SIS Packages
o Introduction to SQL Server Agent Service
o Create a Job to Schedule the Package Execution
o Introduction to MSDB database
o Conect o Integration Server and Execute the Package
o Run the package using DTEXEC cm
SRS Course Content
 Data Warehouse Concepts
 Introduction to BI
 Introduction to SRS
 SRS Architecture
 Tols in SRS
 Report Designer
 Report Manager
 Report Builder
 Tols available in the Market o create Reports
 Scenarios to use SRS
 Lifecycle of the Report (Phases in the Report)
 What is a Report
 Data Sources
 Data Sets
 Shared Vs Embeded Data Sources/Data Sets
 Steps to create a Report
 SRS Data Regions
 Table
 Matrix
 List
 Chart
 Gauge
 Image
 Nested Data Regions
 Sub Reports
 Indicator etc
 Types of Reports
 Tabular and Matrix Reports
 Dril Down Reports
 Dril Thru Reports
 Parameterized Reports
 Single value Parameters
 Multiple Value Parameters
 Customized Reports using List Control
 Nested Data Region Reports
 Document Map Reports
 Chart, Gauge, Indicator, Image Reports
 More Features in SRS
 Use of Row Group and Column Groups
 Ad Report Header and Report Foter
 Ad Page Numbers, Execution Time etc in the Foter
 Expresions in the Reports
 Conditonal Formating
 Date and Curency Format
 Using Sorting
 Ad Page Breaks Before and After
 Ad Background Images in the Report
 Report Format - Changing Style, Font, Color etc
 Report Performance Tuning
 Build and Deploy a Report o the Report Server
 Report Server Configuration
 View Reports On Line
 Export Reports to diferent formats – Excel, PDF, Tif, CSV etc,.
 Introduction to Report Manager
 Managing Reports
 Subscriptions (for Report Delivery)
 Push (Thru E-mail)
 Pul (Thru Shared Folder)
 Linked Reports
 Snapshot of a Report
 Report Security
 Cache a Report
 Report Builder to Create Ad-hoc Reports
SSAS Course Content
What Is Microsoft Business Intelligence?
Define Business Intelligence.
Understand the Cube Structure.
Deploy and View a Sample Cube.
View a Cube by using Excel.
View a Cube by using SQL Reporting Services.
OLAP Modeling
Understand Basic OLAP Modeling (star schema).
Understand Dimensional Modeling (stars and snowflakes)
Understand Measure (fact) and Cube Modeling.
Model with SQL Server Business Intelligence Development Studio (BIDS).
Intermediate SSAS
Learn how to Create Key Performance Indicators (KPIs).
Discover how to Create Perspectives.
See how to Create Translations for Cubes and Dimensions.
Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting.
Cube Storage and Aggregation
View Aggregation Designs.
Customize Aggregation Designs.
Implement Proactive Caching.
Understand Writeback in Dimensions.
Review Semi-Additive Measures in OLAP Cubes.
Understand Basic MDX Syntax
Understand Basic MDX Syntax.
CUse the MDX Query Editor in SSMS.
Understand Common MDX Functions and Tasks.
Understand Writeback in Dimensions.
MDX Expressions
Understand the Calculation Subtab.
Learn how to add Calculated Members.
Understand Common MDX Functions and Tasks.
Explore how to add MDX Script Commands.
SSAS Administration
Implement SSAS Security .
Implement XMLA Scripts in SSMS.
Deploy and Synchronize Databases.
Understand SSAS Database Backup and Restore.
SQL SERVER 2008 R2 for DEVELOPERS
Introducing SQL Server 2008 R2
 What's New in SQL Server
 SQL Server History and Editions
 Basics of Database Design
 Introduction to RDBMS
 ERD Modelling
 Normalization and Demoralization
 Business Integrity
 Constraints in SQL Server
 Data Types
 SQL Server 2008 R2 Architecture
 Files and File Groups
 Transaction Logs
 T-SQL
 DDL and DML Commands
 Operators
 Variables
 Local
 Global
 Programming Constructs
 System Functions
 SELECT Statements
 Basic Select Statements
 Using Where Clause
 Using GROUP BY and HAVING
 Advanced Select Statements
 Joins
 Inner Join
 Outer Join
1. Left outer join
2. Right outer Join
3. Full Outer Join
 Cross Join
 Self Join
 Sub Queries, Correlated Sub Queries
 Case Statements
 UNION and UNION ALL
 EXCEPT and INTERSECT
 Cube Operator
 Rollup Operator
 Triggers
 Need
 Features
 Types of Triggers
After
 Instead of
 Creating, Altering, Dropping DML Triggers
 Magic Tables
 Recursive and Nested Triggers
 Views
 Need
 Features
 Types of views
 View Maintenance
 Stored Procedures
 Need
 Features
 Types of Stored Procedures
 User Defined Stored Procedures
 System Stored Procedures
 Functions
 Need
 Features
 Types of Functions
 Indexes
 What Is An Index?
 Types Of Indexes
 Features
 Tuning Queries for improve Performance
 Tuning Indexes for improve Performance
 Transactions
 Need
 Features
 Transaction Properties (ACID)
 Transactions Types
 Transaction Logs
 Checkpoint
 Save Point
 Distributed Transactioning
 Nested Transactions
 Concurrency and Locks
 Problems Related to Concurrency
 Transaction Isolations
 Locking
 Lock Hints
 Lock Escalation
 Live locks
 Deadlocks
 Blocking
 Advanced Transact-SQL
 Ranking Functions
 Cursors
 Common Table Expression(CTE)
 PIVOT and Unpivot
 Exception Handling (Error Handling)
 Temp Tables
Posted by at No comments:

MSBI on 24th Feb (Tuesday) 7:00PM at Maitrivanam(Hyd) by Mr. Bhaskar

SQL SERVER INTEGRATION SERVICES (SSIS)
 SSIS - COURSE CONTENT
  • Introduction to Data Warehouse Concepts
o What is Data Warehouse
o Need for Data Ware house
o OLTP vs. OLAP
o What is BI
o Tools for BI
o Goals of BI
o Dimension and FactTables
o Cube
o Measure
o Surrogate Keys
o Data Warehouse Schemas
  • Star Schema
  • Snow Flake Schema
o Cube Storage
  • ROLAP
  • MOLAP
  • HOLAP
o Data Warehouse vs. Data Marts
  • Introduction to SSIS
o Understand BIDS Components
o DTS vs. SSIS
o Control Flow
o Data Flow
o Event Handlers
o Package Explorer
o Connection Managers etc
  • Introduction to ControlFlow Items
o Containers
    • ForLoop Container
    • ForEachLoop Container
    • Sequential Container
o Predecesor Constraints
o Control Flow Tasks
    • Data Flow
    • Execute SQL Task
    • File System Tasks
    • DBA Related Tasks etc
  • Data Flow Items
o Data Flow Sources
o Data Flow Destinations
o Data Flow Transformations
    • Agregate
    • Audit
    • Sort
    • Merge
    • Merge Join
    • Union Al
    • Lokup
    • Fuzy Lokup
    • Fuzy Grouping
    • Conditonal Split
    • Export Column
    • Import Column
    • Slowly Changing Dimensions (SCD)
    • Derived Column
    • Copy Column
    • Cache Transformation etc,.
  • SIS Variables and Expresions
o System Variables
o Local Variables
o Expresions
o Transactions and Check Points in SIS packages
  • Create, Build and Deploy a package
o Create Package
o Build Package
o Deploy package
    • Ad config files
    • Ad Loging
    • Ad Event Handlers
    • Ad Eror Handling and Debuging
    • Types of Deployments
    • SQL Server
    • File System
    • Schedule SIS Packages
o Introduction to SQL Server Agent Service
o Create a Job to Schedule the Package Execution
o Introduction to MSDB database
o Conect o Integration Server and Execute the Package
o Run the package using DTEXEC cm
SRS Course Content
    • Data Warehouse Concepts
    • Introduction to BI
    • Introduction to SRS
    • SRS Architecture
    • Tols in SRS
  • Report Designer
  • Report Manager
  • Report Builder
    • Tols available in the Market o create Reports
    • Scenarios to use SRS
    • Lifecycle of the Report (Phases in the Report)
    • What is a Report
    • Data Sources
    • Data Sets
    • Shared Vs Embeded Data Sources/Data Sets
    • Steps to create a Report
    • SRS Data Regions
  • Table
  • Matrix
  • List
  • Chart
  • Gauge
  • Image
  • Nested Data Regions
  • Sub Reports
  • Indicator etc
  • Types of Reports
  • Tabular and Matrix Reports
  • Dril Down Reports
  • Dril Thru Reports
  • Parameterized Reports
    • Single value Parameters
    • Multiple Value Parameters
  • Customized Reports using List Control
  • Nested Data Region Reports
  • Document Map Reports
  • Chart, Gauge, Indicator, Image Reports
    • More Features in SRS
      • Use of Row Group and Column Groups
      • Ad Report Header and Report Foter
      • Ad Page Numbers, Execution Time etc in the Foter
      • Expresions in the Reports
      • Conditonal Formating
      • Date and Curency Format
      • Using Sorting
      • Ad Page Breaks Before and After
      • Ad Background Images in the Report
      • Report Format - Changing Style, Font, Color etc
      • Report Performance Tuning
    • Build and Deploy a Report o the Report Server
    • Report Server Configuration
    • View Reports On Line
    • Export Reports to diferent formats – Excel, PDF, Tif, CSV etc,.
    • Introduction to Report Manager
    • Managing Reports
      • Subscriptions (for Report Delivery)
        • Push (Thru E-mail)
        • Pul (Thru Shared Folder)
      • Linked Reports
      • Snapshot of a Report
      • Report Security
      • Cache a Report
      • Report Builder to Create Ad-hoc Reports
    SSAS Course Content
    What Is Microsoft Business Intelligence?
    Define Business Intelligence.
    Understand the Cube Structure.
    Deploy and View a Sample Cube.
    View a Cube by using Excel.
    View a Cube by using SQL Reporting Services.
    OLAP Modeling
    Understand Basic OLAP Modeling (star schema).
    Understand Dimensional Modeling (stars and snowflakes)
    Understand Measure (fact) and Cube Modeling.
    Model with SQL Server Business Intelligence Development Studio (BIDS).
    Intermediate SSAS
    Learn how to Create Key Performance Indicators (KPIs).
    Discover how to Create Perspectives.
    See how to Create Translations for Cubes and Dimensions.
    Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting.
    Cube Storage and Aggregation
    View Aggregation Designs.
    Customize Aggregation Designs.
    Implement Proactive Caching.
    Understand Writeback in Dimensions.
    Review Semi-Additive Measures in OLAP Cubes.
    Understand Basic MDX Syntax
    Understand Basic MDX Syntax.
    CUse the MDX Query Editor in SSMS.
    Understand Common MDX Functions and Tasks.
    Understand Writeback in Dimensions.
    MDX Expressions
    Understand the Calculation Subtab.
    Learn how to add Calculated Members.
    Understand Common MDX Functions and Tasks.
    Explore how to add MDX Script Commands.
    SSAS Administration
    Implement SSAS Security .
    Implement XMLA Scripts in SSMS.
    Deploy and Synchronize Databases.
    Understand SSAS Database Backup and Restore.
    SQL SERVER 2008 R2 for DEVELOPERS
    • Introducing SQL Server 2008 R2
    • What's New in SQL Server
    • SQL Server History and Editions
    • Basics of Database Design
      • Introduction to RDBMS
      • ERD Modelling
      • Normalization and Demoralization
      • Business Integrity
      • Constraints in SQL Server
      • Data Types
      • SQL Server 2008 R2 Architecture
      • Files and File Groups
      • Transaction Logs
    •  T-SQL
      • DDL and DML Commands
      • Operators
      • Variables
        • Local
        • Global
      • Programming Constructs
      • System Functions
    • SELECT Statements
      • Basic Select Statements
        • Using Where Clause
        • Using GROUP BY and HAVING
      • Advanced Select Statements
        • Joins
          • Inner Join
          • Outer Join
    1. Left outer join
    2. Right outer Join
    3. Full Outer Join
    • Cross Join
    • Self Join
    • Sub Queries, Correlated Sub Queries
    • Case Statements
    • UNION and UNION ALL
    • EXCEPT and INTERSECT
    • Cube Operator
    • Rollup Operator
    • Triggers
      • Need
      • Features
      • Types of Triggers
        • After
        • Instead of
      • Creating, Altering, Dropping DML Triggers
      • Magic Tables
      • Recursive and Nested Triggers
    • Views
      • Need
      • Features
      • Types of views
      • View Maintenance
    • Stored Procedures
    • Need
    • Features
    • Types of Stored Procedures
      • User Defined Stored Procedures
      • System Stored Procedures
    • Functions
      • Need
      • Features
      • Types of Functions
    • Indexes
      • What Is An Index?
      • Types Of Indexes
      • Features
      • Tuning Queries for improve Performance
      • Tuning Indexes for improve Performance
    • Transactions
      • Need
      • Features
      • Transaction Properties (ACID)
      • Transactions Types
      • Transaction Logs
      • Checkpoint
      • Save Point
      • Distributed Transactioning
      • Nested Transactions
    • Concurrency and Locks
      • Problems Related to Concurrency
      • Transaction Isolations
      • Locking
      • Lock Hints
      • Lock Escalation
      • Live locks
      • Deadlocks
      • Blocking
    • Advanced Transact-SQL
      • Ranking Functions
      • Cursors
      • Common Table Expression(CTE)
      • PIVOT and Unpivot
      • Exception Handling (Error Handling)
      • Temp Tables
    Posted by at No comments:
    Subscribe to: Posts (Atom)

    Blog Archive