Database

Oracle 10G

Oracle 10g D2K How We Provide Topics

Oracle D2K is the frontend in oracle to develop forms and the backend database oracle would be storing information and d2k will be displaying it. XPERT INFOTECH provides oracle 10g d2k training according to the current requirement of IT industry. Oracle Developer Suite is a suite of development tools released by the Oracle Corporation. A database management system, or DBMS, database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.

Oracle 10g D2k Training provided by Real time Oracle Developer of our company, has more than 4 years of domain experience.
  • We will provide real time project training with code explanation and implementation.
  • Our training modules are completely designed according to current IT market.
  • After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
  • Student will go through the training of Sql as a complimentary package before starting of oracle 10g D2K.
  • We offer regular, fast track and weekend training in oracle 10g D2K course.
  • Study material is provided with the course which consist of concepts, examples and real time examples.
Download Required Software:
  • Oracle 10g D2K Software
SQL
Relational Database Concepts
  • What is an Oracle Database
  • Relational Database Structures
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Supported Datatypes
  • The Data Dictionary
Using SQL*Plus
  • What is SQL*Plus
  • Getting Started
  • Entering and Executing SQL Statements
  • Editing SQL Statements
  • Creating, Editing and Executing SQL Files
Using SQL Developer
  • What is Oracle SQL Developer
  • Starting SQL Developer
  • Configure a Connection
  • Navigation Tabs
  • SQL Worksheet
Retrieving Data with the SELECT Statement
  • The SELECT Statement
  • The SELECT and FROM Clauses
  • Conditions and the WHERE Clause
  • Other Conditional Operators
  • Logical Operators
  • The ORDER BY Clause
  • Column Aliases
  • Arithmetic Expressions
  • Precedence of Operators
Aggregate Functions
  • Overview of Built In Aggregate Functions
  • The GROUP BY Clause
  • The HAVING Clause
Joining Tables
  • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins
  • Set Operators
Numeric, Character and Date Functions
  • Function Types
  • Using the Table dual to try out Functions
  • Numeric Functions
  • Character Functions
  • String Concatenation
  • Date Arithmetic and Date Functions
Conversion and Miscellaneous Functions
  • Conversion Functions
  • The NVL and NVL2 Functions
  • The DECODE Function
  • CASE Expressions
  • The COALESCE and NULLIF Functions
SQL*Plus Parameters
  • Command Line Substitution Parameters
  • The Accept Command
  • The Define and Undefine Commands
Using Subqueries
  • In-Line Views
  • Top-N Queries
  • Complex Subqueries
  • Multi Column Subqueries
  • Correlated Subqueries
  • Subquery Rules
  • Using the ANY, ALL and SOME Operators
Managing Data
  • Inserting Rows
  • Updating Rows
  • Deleting Rows
  • Verifying Updates
  • Transaction Control
  • Commit and Rollback
  • Savepoints
  • Commits and Constraints
  • Amending Data in SQL Developer
Managing Tables
  • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables
Managing Indexes and Views
  • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views
Managing Sequences and Synonyms
  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms
PL/SQL Fundamental
  • What is PL/SQL?
  • Basic Elements
  • Variables and Constants
  • Data Types
  • Initialising Variables and Assigning Values
  • Using SQL Statements in Code
  • Generating Output to SQL or SQL Developer
Program Logic
  • IF THEN ELSIF ELSE Statements
  • CASE Statements
  • The Basic Loop Construct
  • WHILE and FOR Loops
  • Nested and Labelled Loops
  • The GOTO Statement
  • The CONTINUE Statement
Using Cursors
  • What is a Cursor?
  • Implicit and Explicit Cursors
  • Cursor Operations
  • Declaring, Opening and Closing Cursors
  • Fetching Rows
  • Status Checking
  • Using Cursors FOR UPDATE
  • The Cursor FOR Loop
  • Parameterised Cursors
Exceptions and Nested Blocks
  • The EXCEPTION Section
  • Types of Exception
  • Handling Named System-Raised Exceptions
  • Handling Un-named System-Raised Exceptions
  • User-Declared Exceptions and Application Errors
  • WHEN OTHERS THEN NULL
  • Nested and Labelled Blocks
  • Propagation of Exceptions
  • Scope of Variables and Cursors
  • Scope of Goto Statements

SQL Server 2008

What is SQL Server? How We Provide Topics

Microsoft SQL Server is a powerful relational database management system catering to high-end users with advanced needs which developed by Microsoft. Nimact provides sql server training according to the current requirement of IT industry. It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). They all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner. As its full name (Structured Query Language) implies, SQL is responsible for querying and editing information stored in a certain database management system. A variety of established database products support SQL, including products from Oracle and Microsoft SQL Server. It is widely used in both industry and academia, often for enormous, complex databases. There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time).

SQL Server Training provided by Real time SQL Developer of our company, has more than 4 years of domain experience.
  • We will provide real time project training with code explanation and implementation.
  • Our training modules are completely designed according to current IT market.
  • After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
  • Student will go through the training of knowledge of database as a complimentary package before starting of SQL Server.
  • We offer regular, fast track and weekend training in SQL Server course.
  • Study material is provided with the course which consist of concepts, examples and real time examples.
Download Required Software:
  • SQL Software
An Overview of SQL Server 2008
  • SQL Server 2008 Architecture
  • Available Features and Tools
  • New Capabilities
  • SQL Services
  • Product Licensing
  • Product Editions
Installing SQL Server 2008
  • Preparing for Installation
  • Installing SQL Server 2008
Configuring SQL Server 2008
  • Registering Servers
  • Using Metadata Views to Obtain Object Properties
  • Using Object Explorer
  • Configuring a SQL Server Instance
  • Configuring Object Properties
  • Using the Query Window
  • Creating Transact SQL Projects
  • Managing Services
  • Configuring Server Network Connections
  • Configuring Client Connections and Aliases
  • Configuring the Surface Area of SQL Server
  • Configuring Policy-Based Management
  • Creating a Central Management Server
  • Using the Dedicated Administrator Connection
  • Configuring Data Replication
  • Creation and Maintenance of Full-Text Catalogs
  • Describing Full-Text Search
Using SQL Server 2008 Management Tools
  • SQL Server Management Studio
  • SQL Server Configuration Manager
  • SQL Server Books Online
  • SQLCMD
Creating and Configuring a Database
  • Creating Databases
  • Creating Tables
  • Specifying Data Types
  • Creating Indexes
  • Describing Data File Structure
  • Describing Log File Structure and Function
  • Creating Filegroups
  • Configuring Filestream Storage
  • Creating and Using Database Snapshots
  • Moving a Database to Another SQL Server
Monitoring Data Structures
  • Creating DDL Triggers
  • Creating Event Notifications
  • Configuring SQL Server Audit
Monitoring SQL Server Performance
  • Using the Windows Performance Tool to Detect the Cause of a Bottleneck
  • Using SQL Server Profiler
  • Using Dynamic Management Functions
  • Interpreting Management Studio Reports
  • Using Activity Monitor
Optimizing SQL Server Performance
  • Describing Index Structures
  • Clustered Indexes
  • Nonclustered (NC) Indexes
  • Choosing Appropriate Clustered Index
  • Choosing Appropriate NC Indexes
  • Detecting Index Fragmentation
  • Rebuilding and Reorganizing Indexes
  • Using the Database Engine Tuning Advisor
  • Generating and Interpreting Query Plans
  • Configuring the Resource Governor
Securing SQL Server
  • SQL Server Security Architecture
  • Defining Principals and Securables
  • Using the Security Hierarchy
  • Applying Password Policies to SQL Logins
  • Creating Roles
  • Granting Permissions
  • Using SQLCMD to Test Permissions
  • Creating and Using Certificates
  • Setting Execution Context
  • Encrypting Data
  • Encrypting Databases
Automating Tasks
  • Creating Maintenance Plans
  • Job Creation and Execution
  • Creating Schedules for Jobs
  • Creating and Using Proxies
  • Configuring Alerts
  • Creating and Using Operators
  • Configuring and Using Database Mail
Importing and Exporting Data
  • Using bcp and BULK INSERT
  • Using the Import/Export Wizard
  • Using Integration Services to Import Data
Backing Up and Restoring Databases
  • Choosing Appropriate Database Recovery Model Option
  • Describing Automatic Recovery
  • Choosing an Appropriate Backup Strategy
  • Determining Backup File Contents
  • Designing a Database Recovery Plan
  • Using Backup Compression
  • Use of Filegroups in a Backup Strategy
  • Restoring the Master Database
  • Rebuilding System Databases
Maintaining Data Reliability
  • Maintaining Data Integrity
  • Creating Constraints
  • Describing and Using DML Triggers
  • Configure Data Compression
  • Setting Transaction Isolation Levels
  • Capturing Changed Data
Maintaining High Availability of Data
  • Purpose of Windows Clustering
  • Implementing Database Mirroring
  • Use of Log Shipping
×