Category:

Oracle 9i Exception Handling

This week tutorial covers Oracle Exception Handling and the different types in it with sample SQL scripts along with the screen shots. Topics covered in this week, Introduction to Exception Handling – Propagation of Errors Types of Exceptions – Named System Exceptions; Unnamed System Exceptions; User-Defined Exceptions. Exceptions An Exception is an error situation, which arises during program execution. When an error occurs exception is raised, normal execution is stopped and control transfers to exception-handling part. Exception handlers are routines written to handle the exception. The exceptions can be internally… Read More

MSAS – Applying OLAP Cubes

This tutorial covers the types of changes that impact on cubes and Synchronization OLAP and data warehouse data. Multidimensional cubes are created out of the data stored in the data warehouse. Numerical measures are also summarized into pre-aggregated values when cubes are constructed. These cubes are then stored in multidimensional structures that are designed for rapid query. The pre-aggregated information is combined with raw fact data to respond to a wide variety of queries. Types of changes that impact on cubesSince cubes contain summarized data from the data warehouse, any… Read More

Understanding OLAP Models

This tutorial covers the different types of OLAP models like Relational Online Analytical Processing mode( ROLAP), Multidimensional Online Analytical processing mode(MOLAP) and Hybrid Online Analytical Processing mode or HOLAP. Cubes in a data warehouse are stored in three different modes. A relational storage model is called Relational Online Analytical Processing mode or ROLAP, while a Multidimensional Online Analytical processing mode is called MOLAP. When dimensions are stored in a combination of the two modes then it is known as Hybrid Online Analytical Processing mode or HOLAP.MOLAPThis is the traditional mode… Read More

Designing the Dimensional Model and Preparing the data for OLAP

This tutorial covers Designing the Dimensional Model, Dimensional Model schemas like Star Schema, Snowflake Schema, Optimizing star schema and Design of the Relational Database, OLAP Cubes and Data mining tools, Security considerations, metadata and backup and recovery plans.Preparing the data for OLAP The global issues out of the way, the enterprise must begin to focus on the granular design issues. The data in the data warehouse must be prepared for the application of Online Analytical Processing (OLAP) solutions and such preparations will be driven by the business needs of the… Read More

Design of the data warehouse: Kimball Vs Inmon

This tutorial covers the basic design concepts, The top down approach, The Bottom-Up Approach , Hybrid Approach and Federated approach.Ralph Kimball and Inmon, the co-founders of the data warehouse, significantly had their own differences in the design and architecture of the data warehouse. Inmon advocated a “dependent data mart structure” whereas Kimball advocated the “data warehouse bus structure”. The Dependent Data Mart structure:The top down approachBill Inmon saw a need to transfer data from diverse OLTP systems into a centralized place where the data could be used for analysis. He… Read More

Oracle 9i Cursors

In this week tutorial 10 as part of Oracle 9i SQL and PL/SQL training explains about the Introduction to Cursors, different types and the Cursors and Loops with sample code and screen shots. CURSOR For every SQL statement execution certain area in memory is allocated. PL/SQL allow you to name this area. This private SQL area is called context area or cursor. A cursor acts as a handle or pointer into the context area. A PL/SQL program controls the context area using the cursor. Cursor represents a structure in memory and… Read More

Defining OLAP Solutions and Data Warehouse design

This tutorial covers OLAP solutions used by Data warehouses and understanding Data Warehouse design. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. It must begin with a conviction that a data warehouse would really help its business and the return on investment will make it worth it.Defining OLAP Solutions The data warehouse offloads data from a multitude of sources. The cleaned, validated and loaded data is voluminous and daunting. This data needs to be organized, categorized and arranged… Read More

Oracle 9i PL/SQL Control Structures

Exforsys
This tutorial teaches about how to structure flow of control through a PL/SQL program. The control structures of PL/SQL are simple yet powerful. Control structures in PL/SQL can be divided into selection or conditional, iterative and sequential. Control Structures This chapter teaches about how to structure flow of control through a PL/SQL program. The control structures of PL/SQL are simple yet powerful. Control structures in PL/SQL can be divided into selection or conditional, iterative and sequential. Conditional Control (Selection): This structure tests a condition, depending on the condition is true… Read More

ASP.NET Web Forms Controls

Exforsys
Working with Web Forms Controls and C# covers Introduction to Web Forms Controls, Simple Input Controls, HyperLinks and Button Controls and List Controls Introduction: In this tutorial we will introduce some of the most commonly used controls used in Asp.net web programming. We will see all the different types of controls and their behavior. I will not talk about complex, data bound or template controls in this tutorial since we are going to look at that in later tutorials. Web Form Controls: As in the previous tutorial I explained that… Read More

Data Warehouse database and OLTP database

In this tutorial we will learn about the differences between Data Warehouse database and OLTP database and the objectives of a Data warehouse and Data flow. The data warehouse and the OLTP data base are both relational databases. However, the objectives of both these databases are different. The OLTP database records transactions in real time and aims to automate clerical data entry processes of a business entity. Addition, modification and deletion of data in the OLTP database is essential and the semantics of the application used in the front end… Read More

Introduction to Data Warehousing

This tutorial starts with the introduction to Data Warehousing, Definition of OLAP, difference between Data warehouse and the OLTP Database, Objectives of data warehousing and data flow. Computerization of business processes; technological advances in transmission and storage of data; and powerful database management tools have opened up new possibilities of data manipulation and analysis. Business managers are eager to explore the repositories of current and historical data to identify trends and patterns in the wrap and hoof of business. They hope to mine data and use them for taking intelligent… Read More

Microsoft Analysis Services Training

  Microsoft Analysis Services Training   We are glad to let you know that we are starting with Microsoft Analysis Services Training in the following topics. We will be publishing the tutorials as we complete. Please use discussion board if you have any questions and would like to discuss any. We will be providing step by step screen shots and the sample code. 1: Introduction to Data Warehousing and OLAP Introducing Data Warehousing Defining OLAP Solutions Understanding Data Warehouse Design Understanding OLAP Models Applying OLAP Cubes 2: Introducing Analysis Manager… Read More

Introduction to ASP.NET with C#

Exforsys
Introduction: In this tutorial we will introduce the new technology for building websites. This new technology is known as ASP.Net. ASP.Net allows the developer to build applications faster. This is achieved due to the fast that ASP.Net makes use of the rich class libraries provided by Microsoft. net framework. Topics Introduction Classic ASP ASP.Net Web Applications Use of Controls HTML Controls HTML Server Controls Web Server Controls Special Note Language Options Caching features Tools ASP.Net Web Services References Classic ASP: Asp, which is now more commonly known as Classic Asp… Read More

ASP.NET with C# Training Course Outline

Exforsys
This article contains list of topics covered in ASP.NET with C# training series.ASP.NET with C# Training Course Outline Introduction to ASP.NET with C# A Review of Classic ASP ASP.NET Web Applications Rendering HTML with Server Controls Using ASP.NET to Deliver XML Web Services Working with Web Forms Controls and C# Introduction to Web Forms Controls Simple Input Controls HyperLinks Button Controls List Controls Validating User Input with C# Overview of ASP.NET Validation Controls Client-Side Validation Server-Side Validation Required Field Validator Summarizing Results with the ValidationSummary Control Using Rich Server Controls… Read More

ASP.NET with C# Training Launch

Exforsys
ASP.NET with C# training series is packed with skill enhancing, step-by-step tutorials to help you successfully build database-driven Web applications and Web services. ASP.NET with C# training provides Sample Code along with articles links from external sites (if any). Please use Discussion Board if you have any questions. ASP.NET Training Prerequisites At least one year of consistent object-oriented or object-based development experience in Java, C++, Visual Basic, or another modern object-oriented or object-based language and solid knowledge of HTML and should know SQL and relational databases. ASP.NET Features and Advantages… Read More

Building PL/SQL Blocks in Oracle 9i

Exforsys
This Week we will be learning about Creating PL/SQL Blocks which includes Declaration Section, Variables, Scope of Variables, Constants Records, Manipulating Data in PL/SQL and Using DML in PL/SQL . PL/SQL is a procedural extension for Oracle’s Structured Query Language. PL/SQL is not a separate language rather a technology. Mean to say that you will not have a separate place or prompt for executing your PL/SQL programs. PL/SQL technology is like an engine that executes PL/SQL blocks and subprograms. This engine can be started in Oracle server or in application… Read More

More Oracle 9i Database Objects

Exforsys
This week we will be learing about Sequences, Synonyms, Indexes, Views, Data Dictionary View, Controlling Database Objects, GRANT, REVOKE Roles and Privileges. COMMIT, ROLLBACK and SAVEPOINT SQL*PLUS has a facility to automatically commit all the work, without explicitly issuing the commit command i.e. SET AUTOCOMMIT ON — Enables autocommit feature. SET AUTOCOMMIT OFF — Is the default and disables the automatic committing Note: Certain actions automatically force a commit. DDL Commands CREATE, DROP, ALTER and DCL commands EXIT, GRANT, REVOKE, CONNECT, DISCONNECT, AUDIT and NOAUDIT are example for this. (i.e.… Read More

XML Unit Testing tools Series 1

Avignon allows for true test-first design by letting users express test cases in XML prior to the start of unit development. Avignon is an acceptance test system that allows you to write executable tests in a language that you define.  It uses XML to define the syntax of the language but, if you choose to extend the language, leaves the semantics of the tests up to you.FeaturesRunning Tests : Avignon is implemented in Java, and is configurable for many different forms of test execution.Requirement: Junit, HTTPUnit, JAXP, Xalan Avignon is… Read More

Oracle 9i Tables and Constraints

In week 6 of our Oracle 9i training course we will be learning about Data types with the differences between different Oracle versions, creating tables, altering tables, dropping tables, Integrity constraints supported by Oracle, Inserting records, Modifying the records and deleteting the records. If you can’t see the screen shots, please save them on to your hard disk. Table: Tables are basic units of data storage. A table is defined as intersection of rows and columns. Data is stored in rows and columns. Oracle Data Types: CHAR: Char data type… Read More

Finding Your First Job – Adjusting to a New Job

The first few weeks of a new job are always difficult. You want to impress your co-workers as a hard-working, honest, intelligent team member. You want to show your boss that you are competent and talented. And all the while, you can’t remember which cabinet holds the office supplies, you’ve forgotten at least two officemates’ names, and your computer seems to be haunted.  by ResumeEdge.com – The Net’s Premier Resume Writing and Editing Service Even seasoned professionals say starting a new job is rough – it’s even harder if you’re… Read More

Few tips and strategies for getting job

There are some common strategies when seeking employment in the high-tech industry.  Certainly, if you have any personal contacts that work in the industry, don’t hesitate to call upon them! Many jobs are found through personal references.     Resumes Certainly, you must present yourself in a professional manner, beginning with your resume. Study books on resume writing for examples of how to write a resume that will appeal to the "high-tech" industry. One tip is to make sure your resume includes a "buzzword" section near the beginning. This would include every type… Read More

Oracle 9i Software Installation, SQL, PLSQL and SQL *Plus References

Exforsys
Before we actually start with the lessons, we need to install and setup Oracle on your pc to be able to practice. I would recommend all of you to install Oracle before you start with any of our lessons in the following weeks. Please use discussion board for any questions you might have in this Learning Series. That helps other users answering the same questions. Next week we will be starting with our first lesson. In the mean time please setup your pc with Oracle Software. Follow the link to… Read More

Introduction to Oracle 9i SQL, PLSQL, and SQL *Plus

Exforsys
We are excited to let you know that we are launching shortly The New Technology Learning Series. We will be starting with Oracle 9i: SQL, PLSQL, and SQL *Plus. Below is the course schedule by week. Please let us know if you have suggestions. Oracle 9i: SQL, PL SQL, and SQL *Plus Course Description: This course introduces students to data server technology, and explores the concepts of relational databases and the powerful SQL and PL/SQL programming languages. Students will learn and practice how to create and maintain database objects. You… Read More

Importance of Body language in interviews

Interpreting your body language: Body language is one of the very powerful ways of communicating. When it comes to your career, especially while attending interviews, every small movement you make will amplify and suggest what’s going on in your mind. You might unknowingly minimize the chances of getting into a job that fits your profile because of faulty actions. Lets look at a few ‘wrongful actions’ commonly committed during interviews so that you can try to avoid them in your next interview. Face is the index of mind. Your face… Read More

Tips on How to face an Interview!

Author: Kamal, Bangalore Freshers. A JOB interview can be a nerve-wracking experience if you are not prepared and lack self-confidence. We present a few tips that will help you to brush up on your interview skills and come out as a winner from your next interview! 1. Plan to arrive 10 minutes early. This will give you ample time to catch your breath, gather your thoughts and make a quick trip to the washroom to give your appearance one final check. To avoid unnecessary stress, choose your interview attire the… Read More

Benefits of Oracle Certification

Exforsys
Benefits of Oracle Certification Beyond OCA, by becoming an Oracle Certified Professional (OCP) you demonstrate your understanding of the full range of skills required by Oracle professionals in your chosen job role. An OCP is in high demand in today’s marketplace. The level of demand continues to grow with each new installation of Oracle technologies around the world. An OCP Certification raises your visibility and increases your access to the industry’s most challenging opportunities. The demand for professionals in the information technology (IT) industry is high, and the competition for… Read More

Technical Support Position Interview Questions

Exforsys
Please find Technical Support Position Interview Questions. If you have any from your experience please send them to us. We will update this article. These questions can be found in EFS Repository in PDF format. Technical Support Position Interview Questions (74 Questions) Programming 1) What is a stored procedure?2) What is a trigger? Novell (server)1) How do you see different Novell servers from a Console prompt?2) What is the autoexec.ncf?3) What is RIP/SAP?4) How do you bind the IPX protocol to a card? IP protocol? Novell(client) 1) What utility would… Read More

Resume Preparation Tips

Resume Preparation Tips: I am getting some emails and phone calls, in which the people are asking questions like : 1)can you provide some tips for resume preparation ? 2)whether can we put experience in resume. It will create any problem for us? 3)why we are not getting any interview calls even if we put some experience in our resume? So i came up with this article, which might be helpful for students/experienced professionals who were looking for job/change in job. When coming to resume preparation, Our(Job seeker) target is… Read More

How to prepare for an Interview

How to prepare for an Interview – 2004/07/19 01:29  Pls. find some interview preparation tips given below, which may helpful for you. Point 1 : You need to prepare all the skills mentioned in your resume. Point 2 : Come up with the priority for all the skills that you need to prepare. If you are not sure, ask us. Point 3 : Make a time plan based on the skills priority. Point 4 : Go thru our interview questions package so that you will get some idea what types… Read More

Expertise – Oracle RAC

Exforsys
Home Expertise Oracle RAC Oracle Real Application Clusters Consulting Oracle Real Application Clusters Support Oracle Remote DBA Support Oracle RAC Administration Read More
Uncategorized

Expertise – Oracle and BI

Exforsys
Home Expertise Oracle and BI Oracle Business Intelligence Solution Business Intelligence & Data Warehousing Oracle Services Oracle Business Intelligence Workshop & Training Read More
Uncategorized

Exforsys Expertise

Exforsys
Home Expertise Exforsys Expertise SQL Server Database and BI SQL Server Administration SQL Server Database Support and Maintenance MS SQL Server QA/Testing Remote DBA Database Development Database Architecture Designing Microsoft Development expertise MS WinForms Development expertise MS ASP.NET, MVC & .NET Web Application Development MS Application Development expertise .NET System Designs C# .Net Development Microsoft Access Development expertise Mobile Development Android Apps Development Blackberry Apps Development iPhone Apps Development iPad Apps Development Windows Mobile Apps Development Mobile Web Apps Development Oracle and BI Oracle Business Intelligence Solution Business Intelligence &… Read More
Uncategorized

Exforsys Services

Exforsys
Home Services Exforsys Services ERP Solutions Implementation Solutions Upgrade Solutions Support and Maintenance Solutions Custom Solutions Training and Mentoring Web Solutions Production Support Architecture Designing Independent Validation and Testing Services Infrastructure Management Read More
Uncategorized