Sunday, 25 December 2011

~Negative Perception on IT Career~

Database is not as familiar as other like Software Engineering. Based on our survey, we have discover some negative perceptions:

  • Database related career is not directly communicate with others.
  • People has less interest to explore and less famous inventor in this aspect.
  • People don't know the concept of database and its important role in our daily life.
  • Database related career is not promoted well in our country.
  • People don't know the career path of database, etc.
Database is very important in our daily life. We can do many things based on database. We can buy things online(online shopping) and so on. Database make our life easier. Hopefully, database can be well promote in our country.

~Our group Survey~

Our group have conduct a survey about familiarity of social to IT fields and its career~So nice^^
To view the survey, please click => Database Survey

~How to become a database expert~

In my opinion, in order to become a database expert, we have to manage a few important soft skill:

  • Social skills- make us communicate with employer, clients and also can contribute presentation easily.
  • basic computer skill- we can handle and solve tasks or problems based on these knowledge easily.
    • C,C++
    • Cisco
    •  Java
    •  Linux
    • Oracle
    • PHP
    • SAP
    • SQL/SQL Server , etc.

~Database Developer~

Job Description:

  • Provide database programming support and troubleshooting to multiple IT projects.
  • They review process design and stored procedures,backups and restores and implement database upgrades.
  • Develop and maintain web interfaces to database info to permit the viewing and modification of database contents from browser-based clients.
  • Design, develop and implement complex database systems, programs and applications.
Working Description:
  • Works regular hours in offices or depending on the nature of their employer.

Monday, 12 December 2011

*Database Architect*

Job Description:
  • create and implement a design for the storage and maintenance of data or to improve an existing system(Database Management System (DBMS).
  • coordinating internal computer-based systems
  • combining data from multiple systems into coherent summaries, making provisions for missing and conflicting data.
  • decide when the data can be summarized or when it must be displayed in full.
  • evaluating the physical environment that affects data systems such as areas of operation, hardware design and storage devices used.
Working Hours:
  • regular hours, but may work longer hours to meet deadlines. 
  • work weekends and late nights if they need to visit building sites and clients' homes.

*Database Analyst*

Job Description:
  • analyzes, researches, queries, reviews data with the goal of finding useful information, insight, trends
  • importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes.
  • presenting data in charts, graphs, tables, designing and developing relational databases for collecting data and in some organizations it also includes building or designing data input or data collection screens.
  • write Data Definition Language or Data Manipulation Language SQL commands, be responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using statistical tools like Microsoft Excel, SAS, SPSS and others.
Working Hours:
  • Database analysts usually work a 40-hour week. 
  • Overtime is often part of the job as deadlines and user requirements must be met.

Sunday, 11 December 2011

*Database Administrator*

Job Description:
  • Database administrators work with database software to find ways to  store, organise, and manage data.
  • They are responsible for the performance, integrity, backup and security of a database.
  • They identify user needs, set up computer databases, and test systems. They ensure that systems perform as they should and add people to the system as needed. 
  • They also plan security measures. 
  • They also need some additional role requirements  that are:

    • planning
    • troubleshooting
    • development
  • The database approach incorporates the following principles:
    • data remains consistent across the database;
    • data is clearly defined;
    • users access data concurrently, in a form that suits their needs;
    • there is provision for data security and recovery control (all data is retrievable in an emergency).

Working Hours:
  • Working hours typically include regular unsocial hours. 
  • Overnight and weekend work is often necessary as maintenance and development work needs to be undertaken during periods of low usage. 
  • Often on call if a critical problem occurs.

*Introduction of Database-video*

This video shows us what is database.
According to the video, database is a collection of table as well as data or informations.

Sunday, 4 December 2011

*Introduction of Database*

What is Database??

•A database is an organised collection of data for one or more purposes, usually in digital form.
 •The term "database" may be narrowed to specify particular aspects of organised collection of data  and may refer to the logical database, to physical database as data content in computer data storage or to many other database sub-definitions
 •In computing, databases are sometimes classified according to their organisational approach. The most prevalent approach is the relational database, a tabular database in which data is defined so that it can be reorganised 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 catalogues and inventories, and customer profiles.
•Information from

*Computer Science*

Computer science majors program computer systems, maintain communications networks and develop the core digital technologies that influence our lives.
Computer science can be separate into:
~ Network and Security
~Software Engineering
~Database System
~Bio Information System
~Graphic Design
and so on...