Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

SQL Server Course Details
 

Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Aug 21st @ 6:00PM

Faculty: Mr. Narayana

Duration : 30 Day's

Fee: 800/-INR + Reg Fee 100/-INR

Location : Maitrivanam, Hyderabad.

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202,
IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.
Ph.No : 09246212143, 80 96 96 96 96, 040-64512786

Syllabus:

  1. Introduction To SQL Server                                                         
  2. Database Management System                                                                               
  3. SQL Server Management Studio                                                              
  4. Server Types, Server Name And Authentication Modes                
  5. Data And Information                                                                                   
  6. Database                                                                                            
    1. What is a database, and types of databases
    2. Master, Model, MSDB, TempDB and ResourseDB
    3. Creating user defined databases.
  7. Database Files, File Groups                                                                         
  8. Database Objects                                                                                           
  9. Data Integrity                                                                                                   
  10. Data Types                                                                                                         
    1. System defined data types
    2. User defined data types
  11. Sub Languages Or Commands                                                   
    1. Data Definition Language(DDL)
    2. Data Manipulation Language(DML)
    3. Data Retrieval Language(DRL)
    4. Data Control Language(DCL)
    5. Transact Control Language(TCL)
  12. Clauses                                                                                                
    1. From , where, group by and having
    2. Distinct, top, order by, cube and roll up
  13. Identity Property                                                                            
  14. Types Of Columns                                                                          
    1. Normal columns
    2. Identity columns
    3. Computed columns
  15. Alias Names                                                                                      
    1. Column level alias names
    2. Table level alias names
    3. Using literals in Select Statement
  16. Types Of Functions                                                                        
    1. System defined functions
      1. Scalar or single valued functions
      2. Group or aggregate functions
    2. User defined functions
  17. Constraints                                                                                        
    1. Not null constraint
    2. Primary key constraint
    3. Unique key constraint
    4. Default constraint
    5. Check constraint
    6. Foreign key constraint
    7. Candidate key, super key, alternative keys
    8. Levels of constraints
    9. Giving names for constraints
  18. Cascading Rules                                                                                               
    1. On DELETE set null/ set default/ cascade/ set no action
    2. On UPDATE set null/ set default/ cascade/ set no action
  19. Operators                                                                                          
    1. Assignment, arithmetic and comparison operators
    2. Logical, special and compound operators
  20. Set Operators                                                                                   
    1. Union all
    2. Union
    3. Intersect
    4. except
  21. Cloning The Tables                                                                         
    1. When destination table is existed
    2. When destination table is not existed
  22. Joins                                                                                                                     
    1. Inner join
    2. Outer joins
      1. Left outer join
      2. Right outer join
      3. Full outer join
    3. Cross join
    4. Self-join
  23. Sub Queries                                                                                      
    1. Normal sub queries
      1. Single value sub queries
      2. Multi value sub queries
    2. Correlated sub queries 
  24. Wild Card Operators                                                                                      
  25. Ranking Functions                                                                          
    1. Row_number()
    2. Rank()
    3. Dense_rank()
    4. Ntile()
  26. Views                                                                                                   
    1. Simple views
    2. Complex views
    3. Working with schema binding, encryption, check option
  1. Indexes                                                                                                                               
    1. What index and purpose of indexes
    2. Clustered indexes
    3. Non clustered indexes
  2. Temp Tables                                                                                     
    1. Purpose of temp tables
    2. Types of temp tables
  3. Table variable                                                                                                   
  4. Merge Statement                                                                                           
    1. What is merge statement and purpose of it
  5. CTE(Common Table Expressions)                                                             
    1. What is CTE and purpose of CTE
  6. Derived Tables                                                                                                 
    1. What is derived table and purpose of it
    2. Differences between normal table and derived tables
  7. Sequence                                                                                                           
  8. Pagination                                                                                                          
  9. Synonyms                                                                                                          
  10. Stored Procedures                                                                                         
    1. What is a stored procedure
    2. Purpose of stored procedures
    3. Working with some system defined SPs
  11. User Defined Functions                                                                                               
    1. When do we go for use defined functions
    2. Purpose of user defined functions
    3. Types of user defined functions
  12. Cursors                                                                                                                
    1. What is a cursor
    2. Disadvantage of cursors
    3. Types and attributes of cursors
  13. Triggers                                                                                                                               
    1. What is trigger and purpose of triggers
    2. Types of triggers and Magic tables
  14. Isolation levels                                                                                                 
    1. Read committed
    2. Read uncommitted
    3. Repeatable read
    4. Serializable
    5. Snapshot
  15. Transactions and locks                                                                                  
    1. ACID Properties
    2. Different types of locks