We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

SQL Server 2012
  • Introduction to SQL Server
  • SQL Server Databases
    • Types of Databases
      • System Databases
      • User Databases
    • User Databases
      • Creating Databases using Object Explorer
      • Creating Databases using Query Editor
  • DDL, DQL, DML, TCL, DCL Commands
  • Data Integrities
    • Types of Integrities
      • Pre defined integrities
      • Entity Integrities
      • Domain Integrities
      • Referential Integrities
    • User defined integrities
  • Operators in SQL Server
    • Arithmetic operators
    • Logical operators
    • Comparison operators
    • Range operators
    • List operators
    • Null operator
    • String operators
    • Modified comparison operators
  • Functions in SQL Server
    • Types of Functions
      • Library Functions
      • User defined Functions
  • JOINS
    • Types in Joins
      • Inner join
        • Equi join
        • Non Equi join
      • Outer join
        • Left Outer join
        • Right Outer join
        • Full Outer join
      • Cross / Cartesian join
      • Self join and Natural joins
    • VIEWS
      • Types of Views
      • Creating Views
      • Altering Views
      • Dropping Views
    • SUB QUERIES
      • Nested Sub queries
      • Co-related sub queries
    • Transactions and Locks
      • Types of Transactions
        • Implicit Transactions
        • Explicit Transactions
      • Types of Locks
        • Shared lock
        • Exclusive lock
        • Update lock
T-SQL Programming or Sql server programming
  • STORED PROCEDURES
    • Types of Stored procedures
      • System Stored Procedures
      • User Stored Procedures
        • Creating Stored Procedures
        • Altering Stored Procedures
        • Dropping Stored Procedures
  • TRIGGERS
    • Types of Triggers
      • DML Triggers
      • DDL Triggers
        • Creating Triggers
        • Altering Triggers
        • Dropping Triggers
    • CURSORS
      • Types of Cursors
        • Defining Cursors
        • Fetching rows from Cursor
        • Close Cursor
        • Deallocate cursor
    • INDEXES
      • Types of indexes
        • Clustered indexes
        • Nonclustered indexes
          • Creating indexes
          • Dropping Indexes
    • User Defined Functions (UDF)
      • Types of User Defined Functions
        • Scalar Valued Functions
        • Inline Functions
        • Table Valued Functions
Reviews
Be the first to write a review about this course.
Write a Review

SV Soft Solutions is a premier IT Training and Placement Institute. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. Our online training institute is the best place for you to brush up your technical leading  and build a good career ahead in IT related technologies.  Our main assets are our Trainers who have minimum 8 years of experience in IT. Our training takes place with well prepared training materials. We provide excellent documentation and preparation materials for learners.

Online Learning Course Benefits

  • Industry Expert Trainer
  • Real time Scenario
  • Doubt session Support
  • Topic to Topic Assignments
  • Resume Preparation
  • Interview Q/A
  • Record Sessions
  • Detailed Study Material
  • 24/7 Support
Courses Offered: 


Data warehousing :

1)Informatica Online Training

2)Cognos Online Training

3)MicroStrategy Online Training

4)Qlikview Online Training

5)MSBI Online Training

6)Teradata Online Training

 

SAP Modules :

1)SAP HANA Online Training

2)SAP ABAP Online Training

3)SAP BASIS Online Training

4)SAP BO Online Training

5)SAP BODS Online Training

6)SAP BW Online Training ...

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.