Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"

Fazile Moser

+ Follow
since Apr 20, 2011
Cows and Likes
Total received
In last 30 days
Total given
Total received
Received in last 30 days
Total given
Given in last 30 days
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Fazile Moser

K. Tsang wrote:I haven't got this cert. Are you familiar with the old exam (v5.5)? If so you may able to use the old study guide and learn the new features.

No I am not familar with old exam. The study guide from old exams is from 2005. More than 8 years old.
what preparation book do you recommend me?

I can't afford the training "MySQL for Developers" (US$ 2,400).

MySQL Architecture

Use MySQL client programs to interface with the MySQL Server interactively and in batch
Describe SQL Modes and their impact on behavior of MySQL
Identify characteristics which have session scope

General MySQL Syntax

Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words
Identify MySQL data type properties and appropriate usage
Recognize and use common functions and expressions for all MySQL data types
Identify and use comment syntax
Describe and utilize prepared statements
Describe transactions and transaction isolation levels and the impact they have on database behavior

Creation and Design of MySQL Schema Objects

Design and create normalized databases
Create and modify tables using appropriate data types and indexing
Describe and create table constraints enforcing data integrity
Creating and modifying views
Identify and use various methods to obtain metadata for MySQL database objects
Creation, Design and Use of MySQL Stored Programs
Describe and use triggers
Create and execute stored procedures
Create and use stored functions
Implement error handling within stored procedures

Querying for Data

Execute a basic SELECT statement
Limit rows returned by a SELECT statement
Limit columns returned by a SELECT statement
Apply sorting to SELECT statement results
Execute SELECT statements which aggregate and group data

Modifying Data

Describe and execute INSERT statements
Describe and execute REPLACE statements
Describe and execute UPDATE statements
Describe and execute TRUNCATE statements
Describe and execute LOAD DATA statements
Describe and execute DELETE statements

Joins, subqueries and UNION

Identify, describe and use JOINs in MySQL commands
Describe and utilize subqueries in MySQL commands
Perform operations using UNION clause

MySQL Application Development

Identify key characteristics, features and options for PHP, Java and .NET development using MySQL standard drivers
Write a basic Java application that uses MySQL
Write a basic PHP application that uses MySQL
Write a basic .NET application that uses MySQL
Interpret MySQL error messages
Collect available diagnostic information

Basic Optimizations

Identify statements requiring optimization
Recognize and create optimal indexes for query optimization
Recognize and fix sub-optimal SQL commands
Identify appropriate optimization strategies for InnoDB usage
Optimize performance through data normalization

exam is new on the market
Passed also 1Z0-052 [Oracle Database 11g: Administration I]

Will receive the certificate "Oracle Database 11g Administrator Certified Associate"

Was really hard / difficult.
6 years ago

koilraj abraham wrote:Please have a look at

I clicked everywhere "no knowledge" and received at least 110 Hours. Is that enought? I only have SQL skills.

Thanks for using EPractize Labs Time Estimator for 1Z0-803 - Oracle Certified Associate, Java SE 7 Programmer certification preparation.
You require at least 110 Hours to prepare for your exam.

which study guide for this exam?

which study guide for "XML Master Basic" exam?

Tim Moores wrote:Not sure what you mean by "the correct one" -correct for which purpose?- but there is one other XML certification I'm aware of:

IBM exam is obsolete.

I am planning XML Master Basic Examination.

Which study guide?

a. Overview of XML

XML features
Purpose of XML

b. Overview of related XML technologies

Names for and overview of XML-related technologies defined by the W3C or other standards organizations(XPath, XLink, XQuery, XPointer, DOM, SAX, SOAP, XHTML etc.)
Names for and overview of applicable XML specifications defined according to industry or purpose by the W3C or other standards organizations
Purpose of schema definition language defining XML structure
Differences in defined content and functions of XML Schema and DTD

Section 2 - Creating XML Documents

a. Syntax

Naming rules, usable characters defined within an XML document
Methods for coding XML documents utilizing tags
Rules for coding declarations, elements, comments, character references, and processing commands comprising an XML document
Methods for coding character data and markups (tags, references, comments, etc.) comprising an XML document
The role of an XML processor (XML parser)

b. Elements, attributes, entities

Coding elements that include attributes
Types of entities
Handling entities and references using an XML processor
Usage of character references
Usage of Predefined entities
Method for referencing entities

c. Valid XML documents, well-formed XML documents

Well-formed XML document coding methods
Coding methods to ensure valid XML documents
Differences between valid XML documents and well-formed XML documents
Creating valid XML documents for defined DTDs
Creating valid XML documents for defined XML Schema

d. Special characters/ character codes, encoding/ normalizing XML documents

Character references
XML declarations and text declarations
Handling white spaces
End-of-line handling in XML documents
Normalizing attribute values

Section 3 - DTD

a. Basics

Document type declarations
Methods for coding DTD internal subsets and external subsets
Differences between DTD internal subsets and external subsets
Internal entities and external entities, Parsed entities and unparsed entities

b. Content model/element type declarations/attribute-list declarations/actual processing/entity declarations

Element type declarations
Content model definitions for elements
Attribute-list declarations
Attribute types
Attribute defaults
Entity declarations

Section 4 - XML Schema

a. Basics

XML Schema document structure
XML Schema Namespace
Mapping between XML documents and XML schema documents

b. Data types/ coding methods/ actual processing

XML Schema embedded data types
Simple type and complex type
Type extensions and restrictions
Element definitions
Attribute definitions

Section 5 - XSLT, XPath

a. Basics

Purpose of XSLT
Application use of XSLT
XSLT stylesheet structure
XSLT Namespace

b. Elements/ templates/ character encoding/ actual transformation processing

Coding methods and related functions for well-known XSLT elements
Template rules and templates
Pattern coding and matching patterns and nodes
Output processing using XSLT

c. Coding XPath expressions within a stylesheet

Basic operators
Basic functions
Basic coding methods for location paths (designating tree structure nodes)

Section 6 - Namespace

a. XML namespaces

XML namespace defined content
Application use of XML namespace
XML namespace coding methods
XML namespace scope (effective scope)

I have no previous knowledge in Java. My only programming skills is Oracle SQL (passed 1Z0-051 SQL Fundamentals I).

What's the time effort for passing Oracle Certified Associate, Java SE 7 Programmer 1Z0-803? From zero to exam? Hours?
I passed SQL Fundamentals I yesterday. Was a hard nut.
6 years ago

Does anybody have more information about "Android Application Engineer Certifications Basic [OA0-002]". When I google find only trash sites.

Is there a study guide and official site? Objectives?
there will be another study guide for Oracle Certified Associate (OCA): Java SE 7 Programmer (1Z0-803) exam

Java SE 7 Programming Essentials

Publication Date: November 6, 2012 | ISBN-10: 1118359100 | ISBN-13: 978-1118359105 | Edition: 1
Learn core programming concepts and technologies on the leading software development language

This full-color book covers fundamental Java programming concepts and skills for those new to software development and programming. Taking a straightforward and direct approach,Java SE 7 Programming Essentials provides a solid foundational knowledge of programming topics. Each chapter begins with a list of topic areas, and author Michael Ernest provides clear and concise discussion of these core areas. The chapters contain review questions and suggested labs, so the reader can measure their understanding of the chapter topics.

Covers topics such as working with Java data types, using operators and decision constructs, creating and using arrays, and much more

Includes additional learning tutorials and tools

Puts the focus on Oracle's new Oracle Certified Associate (OCA): Java SE 7 Programmer (1Z0-803) exam

This must-have resource offers new programmers a solid understanding of the Java SE 7 programming language.

Paperback: 400 pages
Publisher: Sybex; 1 edition (November 6, 2012)
Language: English
ISBN-10: 1118359100
ISBN-13: 978-1118359105
Product Dimensions: 11.2 x 8.9 x 5.8 inches

do you recommend me pre ordering this study guide?
7 years ago
Hi Cameron Wallace McKenzie

when your study guide will be released?

Cameron Wallace McKenzie wrote:How close do you think you'll get to the Aug. 22nd launch date posted on Amazon? I'm running a tad behind myself.

I second that question!
7 years ago