• Database objects:
  • table
  • view
  • sequence
  • Index
  • synonym
  • stored procedure

Will be continued

From: http://sitestree.com/?p=4967
Categories:40
Tags:
Post Data:2011-09-05 21:55:20

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

• OCP:Application Developer:1Z0-007:topics
• PL/SQL:OCP:Application Developer:1Z0-001:topics
• SQL Expert:OCP:Application Developer:1Z0-047:topics
• Program with PL/SQL:topics
• Oracle Forms:Certification:Topics

From: http://sitestree.com/?p=4895
Categories:40
Tags:
Post Data:2010-12-18 23:31:34

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

• All oracle certifications
• Oracle Certification Programs
• Oracle Certifications Overview
• Oracle 10g OCM Syllabus

From: http://sitestree.com/?p=4894
Categories:40
Tags:
Post Data:2013-02-05 17:50:27

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Oracle Database ObjectsSchema Objects

• Clusters
• Constraints
• Database links
• Database triggers
• Dimensions
• External procedure libraries
• Index-organized tables
• Indexes
• Indextypes
• Java classes, Java resources, Java sources
• Materialized views
• Materialized view logs
• Object tables
• Object types
• Object views
• Operators
• Packages
• Sequences
• Stored functions, stored procedures
• Synonyms
• Tables
• Views

Nonschema Objects

• Contexts
• Directories
• Parameter files (PFILEs) and server parameter files (SPFILEs)
• Profiles
• Roles
• Rollback segments
• Tablespaces
• Users

What are schema objects?
A collection of logical structures of data, or schema objects. In Oracle, each user owns a single schema and the schema is named after the user.

Non-schema Objects:
Other types of objects stored in the database but not part of any schema.

Both can be manipulated using SQL

From: http://sitestree.com/?p=4813
Categories:40
Tags:
Post Data:2012-08-12 22:08:43

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Oracle Process architecture
Oracle processes running simultaneously in the background

• archiver processes (ARCn)
• checkpoint process (CKPT)
• database writer processes (DBWn)
• dispatcher processes (Dnnn): multiplex server-processes on behalf of users
• memory-manager process (MMAN): used for internal database tasks such as Automatic Shared Memory Management
• job-queue processes (CJQn)
• log-writer process (LGWR)
• logical standby coordinator process (LSP0): controls Data Guard log-application
• media-recovery process (MRP): detached recovery-server process
• memory-monitor process (MMON)
• memory-monitor light process (MMNL): gathers and stores Automatic Workload Repository (AWR) data
• process-monitor process (PMON)
• process-spawner (PSP0): spawns Oracle processes
• queue-monitor processes (QMNn)
• recoverer process (RECO)
• remote file-server process (RFS)
• shared server processes (Snnn): serve client-requests
• system monitor process (SMON)

From: http://sitestree.com/?p=4812
Categories:40
Tags:
Post Data:2010-06-23 15:17:48

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Canada: Employment Laws: Check Here

Another good source of information

From: http://sitestree.com/?p=4811
Categories:41
Tags:
Post Data:2011-08-19 00:41:29

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Similar to the way you use crystal report for report creation in Visual Studio. The following web-pages and videos demonstrate how to use crystal reports in eclipse IDE [for Java] for report creation. Creating reports using tools like this may be faster and more efficient than creating reports with Java/JSP coding solely. Modification to existing reports also becomes much more easy. Just like to change a column title or to change the font size, you will not require to dig into codes

• Video: demonstrates the basics how to use crystal report in Eclipse environment
• Other videos on how to use Crystal Report for Eclipse

Crystal report for Java can be used with other environments like

IBM Rational Application Developer
IBM WebSphere Studio
BEA WebLogic Workshop
Borland JBuilder

For details on how to, please check:Crystal Report for Java: Environments From: http://sitestree.com/?p=4814
Categories:42
Tags:
Post Data:2007-01-04 15:30:14

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Enterprise integration involves integration of different IT software and systems to provide integrated business operations/processes. Enterprise integration facilitates the following:

• Information aggregation
• Single point of data entry
• Process efficiency
• Web channel integration
• Supplier integration and supply chain optimization

How to asses that you need integration?
Ask yourself the following questions:

• Do you need to collect information from different systems for a business process?
• Do the different IT systems need to communicate with each other?
• Do you need to input the same data in different IT systems?
• Do you find it difficult to extract data from different IT systems?
• Do you have data inconsistency across different IT systems?
  If your answers to these questions are Yes, then you may need integration.

  Levels of Integration

  1. Process Integration
  2. Service Integration
  3. Application Integration
  4. Data Integration
  5. Presentation Integration

  Challenges in Enterprise Integration
  Technical Challenges

  • Stand-alone design
  • Internalised data models
  • Heterogeneous technologies
  • Legacy engineering
  • Lack of interfaces
  • Semantic mismatch
  • Unclear business processes
  • Standards
  • Security

  Management Challenges

  • New collaborations
  • Project scoping
  • Continued stakeholder support
  • Data ownership
  • Time constraints
  • Cost constraints
  • Migration
  • Expertise

  Reference: Enterprise Architecture and Integration: Methods, Implementation and Technologies, by Wing Lam and Venky Shankararaman (eds)

From: http://sitestree.com/?p=5150
Categories:43
Tags:
Post Data:2011-05-31 14:11:13

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

• “Pareto s 80/20 rule, as applied to the SDLC, is in the process of being drastically altered. In the past, approximately 20% of the SDLC was spent on analysis and design activities with the remaining 80% spent on systems development and implementation”
• “In this new paradigm, approximately 80% of the SDLC is spent on analysis and design activities with the remaining 20% spent on systems development and implementation”
• “We want to develop software by integration rather than code writing. The software market is rapidly moving in this direction; component-ware and related methodologies are maturing day by day.”
• “More recently, enterprise resource planning (ERP) solutions, such as SAP and Peoplesoft, which involve replacing existing systems with a suite of interconnected modular systems from a single vendor, were seen as the answer to systems integration (Davenport, 1998). However, organizations soon realized that no single ERP system could address all the requirements of an organization (Hong & Kim, 2002).”
• “With SOA, the issue of integration is no longer problematic so long as every system conforms to the SOA model and is able to offer its functionality through a set of defined services. That, unfortunately, is the point where SOA suffers the same adoption problems as Web services” [as industries have invested much on legacy systems and have to live with them]

Reference: Enterprise Architecture and Integration: Methods, Implementation and Technologies, by Wing Lam and Venky Shankararaman (eds)

From: http://sitestree.com/?p=5148
Categories:43
Tags:
Post Data:2010-03-14 22:27:08

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>