Search This Blog

Saturday, December 24, 2011

Mind map....

This is about oracle DBA...

Top 5 things need to know about database as beginners

1. SQL Forms the Core of Relational Databases

2. Selecting Primary Keys is an Extremely Important Decision

3. NULL Is Not Zero or the Empty String

4. Converting Spreadsheets to Databases Saves Time

5. All Database Platforms Are NOT Created Equal

Another DBA~~~

Phil Mcmillan
IT Specialty:
Database Administration
Job Title:
Database Systems Administrator
Major Insurance Company
B.S. in Finance and finishing M.S. in Information Technology
Q.  How does someone go about getting a job in this field?
A. Typically a degree in Computer Science/Information Technology is required, although there are some exceptions to that. I would recommend taking as many data and database classes as possible. In my particular position, one would need to have some experience, but there are many database-related entry-level positions that would be good stepping stones. My past experience was mostly in the arena of data design. But, experience with general technical support and operating systems is also valuable.
Q.  What are ways to advance in your field?
A. Experience is probably the most important element. But, technical certifications are also looked upon favorably. It shows that you are taking initiative and striving to expand your base of knowledge and expertise. In my arena, IBM offers a range of database certifications. 3.  What is the most enjoyable thing about your job? There are new challenges every day. Seldom does a day go by that I don’t learn something new.
Q.  What is the biggest challenge regarding your job?
A. In our area, we deal with a lot of different areas, networking, scripters, etc. That can become difficult as various areas use different terminology and have different perspectives.
Q.  What are your daily tasks like?
A. There are two distinct aspects to my job. One is the service aspect. That would be dealing with problems as they arise. Here I would be troubleshooting problems, talking to business areas experiencing problems, and discussing issues with IBM. The second aspect pertains to project work. This involves working on future upgrades of the DB2 database system, helping business areas improve current functionality, and build new functionality. So a typical day would involve a blend of those activities. Some days are more oriented toward project work. On other days, I’m entirely involved in dealing with current issues and problems.
Q.  What skills do you use at work?
A. I use both technical skills and people skills. I must be able to troubleshoot complex problems and build new solutions for business problems; those things require technical skills. I also must work with various areas in and out of IT. This requires people skills.
Q.  What percentage of your day do you spend working independently or in a group?
A. In my position, I spend approximately 60% of my time working independently and 40% of my time working collaboratively.
Q.  What is one thing you didn’t know about your field before getting into it that you wish you had known?
A. I think in IT, generally, you can never have too much technical knowledge. In my area, specifically, I wish had known more about how applications interact with DB2. We spend a lot of time dealing with application errors that are encountered when accessing the databases. 

DO you know who is Ryan Austin?

Ryan Austin
IT Specialty:
Database Administration
Job Title:
Database Administrator/Database Developer
Tribune Media Services
Bachelor of Arts in Computer Science and Mathematics
Q. How long have you had your degree?
A. 7 years.
Q. Do you feel your degree adequately prepared you for your technology career?
A. Definitely
Q. How many years have you been in the IT field?
A. 1 year in school help desk position, plus 7 years since.
Q. Have you ever worked in a field outside IT? If so for how many years and in what other fields have you worked? A. Farming, 13 years. Life guard, 12 months (summer job). Construction/Roofing/Landscaping, 12-15 months (summer jobs).
Q. In what way did working in other fields prepare you for the IT field?
A. Learn to work hard and with a good work ethic. Learn how to comply with the people in charge.
Q. What personality traits and skills do you possess that you feel help you in your specific IT field?
A. Good team work skills. Able to get a long well with anyone and communicate effectively. Desire to be successful in everything.
Q. What steps does someone go through to get a job in this field?
A. I have always found it easy to find a job through internet job finding services. and are good places to start. I have, also, tried to use IT recruiter agencies with limited success.  My last two positions were found on
Q. What are ways to advance in your field?
A. I've found that experience is the best asset when looking for a new job.  Being willing to be versatile and learn new technologies is a good way to advance yourself in current positions.  More education is never a bad thing.
Q. What is the most enjoyable thing about your job?
A. Solving problems and making things better. Discovering new technology that replaces/fixes previous, troublesome bugs that required workarounds.
Q. What is the biggest challenge regarding your job?
A. Keeping up with the ever-changing technology.
Q. What are your daily tasks like?
A. Monitor production database server logs and status email. Create and test new implementations. Coordinate with development teams for database access. In some cases code as part of the development team. Create software solutions to make maintenance easier.
Q. What skills do you use at work?
A. Communication, Research, Programming Language(s) Coding and Scripting.  (Java, SQL, Perl, C, XML), Software installation and configuration, Email
Q. What percentage of your day do you spend working independently or in a group?
A. 75% solo, 25% team
Q. What is one thing you didn’t know about your field before getting into it that you wish you had known?
A. Experience is very valuable. Learn/try lots of programming languages. Linux is important, learn to use it.
Q. If you were a person getting ready to choose an IT major for college, what advice/guidance would you give them to help them decide between all the fields?
A. Try everything and pick the one thing that you feel you are the best at and enjoy most. Then keep getting better at that one thing. You should fine that there will be many other IT skills that you will pick up and become better at in parallel with that. 

Delphi Database

Delphi is a high-level, compiled, strongly typed language that supports structured and object-oriented design. Delphi language is based on Object Pascal. Today, Delphi is much more than simply “Object Pascal language”.
Pascal language supported dynamic data structures; i.e., data structures which can grow and shrink while a program is running.  The language was designed to be a teaching tool for students of programming classes. This was further developed into Turbo Pascal 1.0, having development environvments and tools wherein an Integrated Development Environment (IDE) was developed where you could edit the code, run the compiler, see the errors, and jump back to the lines containing those errors. Turbo Pascal compiler has been one of the best-selling series of compilers of all time, and made the language particularly popular on the PC platform.
Delphi is the latest version of turning Pascal into a visual programming language completely transforming the Turbo Pascal into an object-oriented application development language, complete with a truly visual environment and superb database-access features: Delphi.
Delphi language has the benefit of having easy to read code, quick compilation and the use of multiple unit files for modular programme. This language can be used for creating Windows Applications including Integrated Development Environment (IDE) and Object Pascal Language. Using this database, we can work with Tables and Queries, handle Database Exception and create reports etc.
Delphi Database has the benefits of High Performance applications wherein no VM/ Runtime Environment is required.
This Database has the ability to connect to many data sources. This could easily create Data-driven appliications like queries, user interface and database access. This delivers high performance and scalable /portable database solutions. This has the benefit of Data Editing Tool (Delphi Database application). It can be easily changed and adaptable with the changing application requirements. Delphi Database has the flexibility of backup and restoration needs.
Delphi Database develop fast,user friendly and flexible softwares for suiting all business needs.
Delphi Database can be used for database programming and architecture services like :
  • Writing Database components,
  • Client / Server with dbExpress,
  • Multitier DataSnap Applications,
  • Access Data using ActiveX Data Objects (ADO),

5 techniques to build prospect database

The old-fashioned cold call is a surefire way to build a database of leads. But don't stop there. Remember that every time a person on your staff comes in contact with a prospect, his or her information should be added to your leads database.

Join prominent community organizations: chambers of commerce, convention and visitors' bureaus, and charitable groups. Participate in community events where you can reach your target market.

Cross-pollinate with businesses that target similar markets. Some examples include: a hair salon and a clothing boutique, or an accounting business and a law firm. Share lists, swap brochures and promotional materials, offer discounts to each other's customers, or cosponsor events, such as an educational seminar for clients of both businesses.

Provide registration cards at events, and conduct periodic surveys. These are also good ways to beef up your prospect list.

Business card fish bowls at trade shows and other registration tactics are other ways to capture information on prospects.


Database administrators average salary and salary data for other jobs by Online Degrees

DBA career path....~~~

Database administrators average salary and salary data for other jobs by Online Degrees

The Black Packet-Google and The Future Database, Who knows what?

DBA???What is this??

Actually DBA is Database Administrator. This is one of the career path that you can choose if you are a database student.
I let you know more about database administrator career path.

(“In today's environment, IS [information systems] components are business critical, and the key part of every process is data."
--Robert Omerza, president of the International DB2 Users Group and a longtime database administrator for a major courier service)- I got this from technology-college.

In today's economy..DBA career path is seen as a growing up demand in job field. It is expected to continue as it is a secure job field. In today's economy, it is very hard to find a secure job. DBA can provide this for you.

DBA is responsible for many aspects for example initial set up/design, setting parameter to maximize performance, and troubleshooting problem.While they also need to maintain, manage, and help develop new ways to organize information.

IT itself...

Information Technology is the study, design, development, implementation, support or management of computer-based information systems, particularly software applications and computer hardware.” IT deals with the use of electronic computers and computer software to convert, store, protect, process, transmit, and securely retrieve information.

information technology (IT) or information and communication technology (ICT) is the technology required for information processing. In particular the use of electronic computers and computer software to convert, store, protect, process, transmit, and retrieve information from anywhere, anytime.
Computer science, in every school I’ve ever seen, is programming. So its the study of algorithms, data structures, complexity theory, all the way down to learning what makes an operating system work. Its the science of computing, not the electrical engineering of the hardware, as some seem to think. That’s an entirely different topic.
Information technology is learning to use computers in business or in any practical application. While most schools require at least some basic programming courses for information technology, they don’t become programmers. It is simply so they understand, at a very basic level, what is involved behind the scenes.

Conclusion, information technology is learning to use technology in business.

CS again??

This post will only introduce about computer science or most known as CS.

Computer science is interpreted broadly so as to include algorithms, data structures, computational complexity theory, distributed computation, parallel computation, VLSI, machine learning, computational biology, computational geometry, information theory, cryptography, quantum computation, computational number theory and algebra, program semantics and verification, automata theory, and the study of randomness. Work in this field is often distinguished by its emphasis on mathematical technique and rigor.

Computer science (academically, CS, CSC or compsci) encompasses a variety of topics that relates to computation, like abstract analysis of algorithms, formal grammars, and subjects such as programming languages, program design, software and computer hardware. A computer is one that computes, where com- (with, together) joins putare (Latin root, to reckon, to think, or section as in to compare pieces), so by definition, computer science (Latin: scientia, knowledge) is the accumulated knowledge through scientific methodology by computation or by the use of the computer. Computer scientists study what programs can and cannot do (see computability), how programs can efficiently perform specific tasks (see algorithms and complexity), how programs should store and retrieve specific kinds of information (see data structures and databases), how programs might behave intelligently (see artificial intelligence), and how programs and people should communicate with each other (see human-computer interaction and user interfaces). Most research in computer science has focused on von Neumann computers or Turing machines (computation models that perform one small, deterministic step at a time). These models resemble, at a basic level, most real computers in use today. Computer scientists also study other models of computation, which includes parallel machines and theoretical models such as probabilistic, oracle, and quantum computers.


Computer science has roots in electrical engineering, mathematics, and linguistics. In the last third of the 20th century computer science emerged as a distinct discipline and developed its own methods and terminology. The first computer science department in the United States was founded at Purdue University in 1962, while the first college entirely devoted to computer science was founded at Northeastern University in 1980. Prior to this, CS was taught as part of mathematics or engineering departments, for instance at the University of Cambridge in England and at the Gdansk University of Technology in Poland, respectively. Cambridge claims to have the world’s oldest taught qualification in computing. Most universities today have specific departments devoted to computer science, while some conjoin it with engineering, with applied mathematics, or other disciplines.

Conclusion, computer science is learning to program applications

Computer science?? Information technology??

Most of us have been confused about computer science (CS) and information technology (IT). Many thought that computer science and information system are the same thing. Actually, there are two different things. Computer science is learning to program applications and the theory behind that. Information technology is learning to use technology in business. 

“Computer Science” is the mixture and application of “Applied Mathematics”, “Electrical Engineering”, and “Complexity Theory/Algorithms” to understand and/or model information. In otherwords, the “field of computation”.

“Information Technology” is the mixture and application of “Programming”, “Hardware Administration”, “Software Administration”, “Networking”, “Network Security” and “Technical Support”. In otherwords, the “management of computers”.

There's a lot thing that make computer science and information technology differ from each other. So, don't make assumption, ok? You have to know that the words itself have its own meaning. Therefore, we cannot assume anything without a proper search about these. We have to take a closer look and understand  what it is mean by CS and IT.

~Here is a link that some student talk about CS and IT. you may also learn that there's people who still confused about CS and IT. Follow this link:

Database concepts..

This section discusses a number of database concepts and is primarily intended for those who have had little or no experience of computer-based databases.


A database is structured collection of data. Thus, card indices, printed catalogues of archaeological artefacts and telephone directories are all examples of databases. Databases may be stored on a computer and examined using a program. These programs are often called `databases', but more strictly are database management systems (DMS). Just as a card index or catalogue has to be constructed carefully in order to be useful, so must a database on a computer. Similarly, just as there are many ways that a printed catalogue can be organised, there are many ways, or models, by which a computerised database may be organised. One of the most common and powerful models is the `relational' model (discussed below), and programs which use this model are known as relational database management systems (RDMS).
Computer-based databases are usually organised into one or more tables. A table stores data in a format similar to a published table and consists of a series of rows and columns. To carry the analogy further, just as a published table will have a title at the top of each column, so each column in a database table will have a name, often called a field name. The term field is often used instead of column. Each row in a table will represent one example of the type of object about which data has been collected. Table 1(a) (p. [*]) is a an example of a table from a database of English towns. Each row, in this case a town, is an entity, and each column represents an attribute of that entity. Thus, in this table `population' is an attribute of `town.'
One advantage of computer-based tables is that they can be presented on screen in a variety of orders, formats, or according to certain criteria, all the towns in Hertfordshire, or all towns with a cathedral.
p/s:I get this from

This is video from youtube about SQL Database...Let's watch this

More database??

In my last post, I get the info form this website. I give u link to this website..hope it can help you to know more about database..~~This website can help u to know about database design, analysis,  SAAS solutions, master data solutions, careers, data consulting and a lot more.p/s:I find this blog is very useful.This is the link- Expert Database Solutions

Database in business???

Some says that database is life-blood of every business.Most of us does not know what is the use of database.Database is important if you want to become a successful businessman/woman...Actually database can provide a lot of things for us for example  it can provide business analysis.Database design, database development, database analysis, data validation and data conversion services are also provided by database in business. If want to make a decision regarding your company, you need to take a look at the data that you have. You need to know that, data that you have is valid and when you make a decision, it won't harm your company.

Usually, people experienced problem with their database system. Either their system run too slow, or too old to use for storing data. Other problems are data appears differently in different system or screens, their database system are not available for twenty-four hours. This cause people to lost trust to their data. There are solutions to these problems. That it requires analysis of database structures, data relationships, sql queries, stored procedures and data. Analysis of data can be through analysis of data itself and also analysis of system that access data in database.

Large business need a lot of data and it tends to become duplicated in disparate data silos. This will result in redundancy, questionable of data validity and lead to unforgivable and unfavourable decisions in economy and also to the company. Therefore, integrated and clean view of data will increase insight and trust in data. It will also eliminate the need of manual data compilation. It's such an old fashion.. 

I got this info from Expert Database Solutions

Saturday, November 26, 2011

Do you know what is database?Let's check it out...

A database is a collection of information that is organized so that it can easily be accessed, managed and updated.In one view, databases can be classified according to types of content: bibliography, full-text, numeric, and images.

In computing, databases are sometimes classified according to their organizational approach. The most prevalent approach is the relational database, a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. A distributed database is one that can be dispersed or replicated among different points in a network. An object-oriented programming database is one that is congruent with the data defined in object classes and subclasses.
Computer databases typically contain aggregations of data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. Typically, a database manager provides users the capabilities of controlling read/write access, specifying report generation, and analyzing usage. Databases and database managers are prevalent in large mainframe systems, but are also present in smaller distributed workstation and mid-range systems such as the AS/400 and on personal computers. SQL (Structured Query Language) is a standard language for making interactive queries from and updating a database such as IBM's DB2, Microsoft's SQL Server, and database products from Oracle, Sybase, and Computer Associates.

p/s:I got this from can take a look at the website.Please give me your comment or opinion about databases.Thank for reading it and for leaving comment.Here is the link