online tutorials www.ekalasala.com/twitter
eamcet mock tests icet results
online training,online tutoring
ekalasalaORACLEmock tests
 
ORACLE

Oracle 10g Syllabus 

Module 1: Installation.

  • • Installing SQL Server 2005.
  • • Authentication Modes.
  • • Windows Authentication Mode.
  • • Mixed Mode.
  • • The sa Account.

Module 2: Database Creation.

  • • Microsoft SQL Primary Settings.
  • • The master Database.
  • • The tempdb Database.
  • • The model Database.
  • • The msdb Database.

Module 3: Creating a New Database.

  • • Naming the Database.
  • • Creating a Database Using Wizard.
  • • Creating a Database Using Code.
  • • Deleting a Database.
  • • Namespaces and Schemas.
  • • The Database Owner.

Module 4: Security:

  • • Security Options.
  • • Creating and Managing Logins in SQL Server

Authentication Mode.

  • • Creating and Managing Logins in Windows

Authentication Mode.

Module 5: Security-Cont:

  • • Roles.
  • • Fixed Server Roles.
  • • Database Roles.
  • • Application Roles.
  • • Schemas:Creating a Schema.

Module 6: SQL Variables and DataTypes.

  • • Introduction to Code and SQL.
  • • Comments.
  • • The Print Word.
  • • The Select Statement.
  • • Variables.
  • • DataTypes.
  • • Boolean.
  • • Binary.
  • • Integers.
  • • Decimals.
  • • Currency.
  • • Date and Time.
  • • Character.
  • • Image.
  • • XML.
  • • TimeStamp.
  • • UniqueIdentifier.
  • • Program DataTypes.
  • • Table.
  • • SQLVariant. 

Module 7: Statements, Expressions,Operators.

  • • Conditional Statements.
  • • Begin...End.
  • • Case... When...Then.
  • • While.
  • • Boolean Constants.
  • • True and False.
  • • Null.
  • • Is Operator.
  • • Not Operator.

Module 8: System Functions.

  • • Casting.
  • • Converting.
  • • IsDate.
  • • IsNull.
  • • IsNumeric.

Module 9: ErrorHandling.

  • • RAISEERROR.
  • • Try..Catch. 

Module 10: Built In Functions.

  • • Sting Functions
  • • Ascii.
  • • Char.
  • • Left.
  • • Lower.
  • • Len.
  • • LTrim.
  • • Right.
  • • RTrim.
  • • SubString.
  • • Upper.
  • • Replace.
  • • Arithmetic Functions.
  • • Sign.
  • • Abs.
  • • Ceiling.
  • • Floor.
  • • Exp.
  • • Power.
  • • Log.
  • • Log10.
  • • Sqrt.
  • • DateTime Functions.
  • • GetDate.
  • • DateAdd.
  • • DateDiff.
  • • DatePart. 

Module 11: Creating Tables.

  • • Creating Tables Using Object Explorer.
  • • Creating Tables Using Database Diagrams.
  • • Creating Tables Using T_SQl.
  • • Defining Columns.
  • • Column Properties:
  • • Null and Not Null.
  • • Identity Columns.
  • • Computed Columns:
  • • Defining Integrity and Constraints:
  • • Domain Integrity.
  • • Entity Integrity.
  • • Referential Integrity.
  • • Primary Key Constraint.
  • • Unique Constraint.
  • • Foreign Key Constraint:
  • • Casecading Referential Integrity.
  • • Check Constraint.
  • • Dropping Constraints.
  • • Disabling Constraints.
  • • Modifying Tables.
  • • Dropping Tables.
  • • Temporary Tables 

Module 12: Data Manipulation.

  • • The Insert Statement.
  • • The Update Statement.
  • • The Delete Statement.

Module 13: Data Selection.

  • • The Select Statement.
  • • Using Where.
  • • Using Order By.
  • • Set ROWCOUNT.
  • • Top n.
  • • Top n Percent.
  • • The Like Operator.
  • • The Aggregate Functions.
  • • Count.
  • • Sum.
  • • Avg.
  • • Min.
  • • Max.
  • • The Group By Clause.
  • • Using Having. 

Module 14: Joins and Nested Queries.

  • • Inner Join.
  • • Left Outer Join.
  • • Right Outer Join.
  • • Full Outer Join.
  • • Self Joins.
  • • Advanced Queries.
  • • Unions.

Module 15: Views.

  • • Defining Views.
  • • Creating Views.
  • • Using Views to Change Data.
  • • Dropping Views.
  • • Schema Binding.

Module 16: Indexes.

  • • Clustered Indexes.
  • • NonClustered Indexes.
  • • Creating Indexes.
  • • Disabling Indexes.
  • • Dropping Indexes.

 Module 17: Stored Procedures.

  • • Defining and Creating Stored Procedures.
  • • Parameters.
  • • Recomplie.
  • • Encryption.
  • • The As Keyword.
  • • Executing Stored Procedures.
  • • Modifying Stored Procedures.
  • • Using The Table DataType in a Stored Procedure.

Module 18: Triggers.

  • • DML Triggers.
  • • Creating DML Triggers.
  • • Deleted and Inserted Logical Tables.
  • • DDL Triggers.
  • • Dropping Triggers.
  • • EVENTDATA().
  • • Instead Of Triggers. 

Module 19: Reporting Services.

  • • Understanding Reporting.
  • • Reporting Scenarios .
  • • Reporting User Communities.
  • • The Enterprise Reporting Life Cycle.
  • • Building Your First Report.
  • • Starting a New Report.
  • • Connecting to a Data Source.
  • • Getting Data for the Report.
  • • Structuring Data in the Report.
  • • Placing Data in the Report Structure.
  • • Finishing the Report Wizard.
  • • Checking the Report Layout.
  • • Correcting Report Layout Issues.
  • • Publishing a Report.
  • • Managing a Report.

Module 20: Database Backups and Recovery.

  • • Transactions and The Transaction Log.
  • • Backup Strategies.
  • • Full Backup.
  • • Differential Backup.
  • • Transaction Log Backup.
  • • Restoring the Database.

                              Duration: 30 Days (3 Hours Daily)

exam results,exam notifications   exam notifications,exams news
 
 
www.ekalasala.com www.ekalasala.com Demo Class www.ekalasala.com
 
>>More
 
www.ekalasala.com online training
 
 
 
Dial a Loan India
eamcet eamcet

Educational Institutions

Consultancies
 
 
 
eamcet

Misscellneous

 
 
 
 
Copyright © 2010 ekalasala India PvtLtd. All Rights Reserved