Thursday, 22 December 2011

Knowing Database

Many of you have heard about database but do you actually know the meaning of database? what is database?how many type of databases? all this i will answer in my blog.. Ok first i will start by introducing what is databases.
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 that is:

figure 1:bibliographic

  • bibliographic (a list of writings relating to a given subject)
  • full text
  • numeric
  • image
A database is a structured collection of records or data that is stored in a computer system.

 To be functional: i) Databases must not only store large amounts
                               of records well, but be accessed easily.
                            ii)New information and changes can be easily to
                            iii) All databases that are created should be built 
                               with high integrity and the ability to recover data if hardware fails.

Database Management System(DBMS) - program that manage the queries and information
                                                                                 stored on the system.
Now i will tell you about types of databases.There are many type of databases but i will discuss about the several type of databases in this blog.Each databases have its own model and uniqueness.
They include - Flat Model,
                    -  Hierarchical Model
                    - Relational Model
                    - Network Model

- There is a two dimensional (flat structure) array of data. 
-  A flat model database includes only zip codes. Within the database, there is only one column and
  each new row within that one column will be a new zip code.
figure 2: flat model database
 Hierarchical Model Database
resembles a tree like structure
 each upward link is nested in order to keep data organized in a
   particular order on a same level list.
- example like folder and files.

-A record is stored with a link to other records in effect networked

 most popular type of database and an extremely powerful tool, not 
    only to store information, but to access it as well.
 organized as tables.
Relational databases use a program interface called SQL (Standard Query Language). SQL is currently
  used on practically all relational databases
figure 3: the network model database
easy to customize to fit almost any kind of data storage.
Relations can easily be created for items for sale, employees in a company, etc

figure 4: relational model database

figure 5:hierarchical model database

Thats all for the type of databases.for more understanding about relational type database i will provide a video that will can help you all to understand how the relational type database work.

Income for database$$ kaching2!

Many people don't realize the work as a database administrator. This is because database administrator is not a popular job that graduated student want to apply. They prefer a more famous job like software engineer. Many people ask what do database administrators do? why do they exist? did they have a high salary? All this question must have pop up in your mind sometime because in world nowdays people don't want to take risk to apply a job that they seldomly heard about. Now i will tell you a little bit about what do database administrators actually do.

Database administrators is people that use database management software to determine the most efficient ways to organize and access a company's data. They also responsible for maintaining database security and backing up the system.

Database administrators is a fast-growing industry.  Database administrators can expect to earn an annual salary of $48,000 to $85,000.

so student that takes computer science in database system should not worry about finding a job because now days there are a lot of company that want to hire an database administrators.

skills that needed to be database administrators:

  • strong organizational skills
  • strong logical and analytical thinking
  • ability to concentrate and pay close attetion to detail
  • ability to think broadly and consider impacts across system annd within the organization.
A database administrator's activities can be listed as below:
  • Transferring Data
  • Replicating Data
  • Maintaining database and ensuring its availability to users
  • Maintaining the data dictionary
  • Controlling privileges and permissions to database users
  • Monitoring database performance
  • Database backup and recovery
  • Database security Stop
In 2008 there were about 120,400 database administrators.
Database administrators work in every sector of economy. Many work for internet service provider, web search portal and data processing firm.

The number of database administrators is expected to grow much faster than the average for all occupations through 2018. This is because the Internet and e-commerce will continue to expand, resulting in a continuing need to build and maintain databases. Also, the increasing importance being placed on "cyber security"—the protection of electronic information—will require workers skilled in information security.

Job growth will not be as rapid as during the previous decade. The information technology sector will begin to mature and routine work will increasingly be outsourced overseas.
Those having a college or graduate degree in computer science or a related field will have a good chance of getting a job. Those having a lot of related work experience will also have a good chance.


 so how?? kagum kan ??? =)

Tuesday, 13 December 2011

hoi hai guys...this is camtasia tutorial.


hello guys.. i think most of you already "pernah kena" shorcut virus.. once u get dis virus will say"ayaaa die la...cannot make any backup lo..."hahahha lol! seriously from what i experince this virus quite easy to KILL! i have sum few simple steps that will turn all your shortcut into original folder.

followed this step kayh!

1) press button start and r .
2)type cmd inside the run space.
3) after that you must check ur pendrive is in what alphabet eg, g:
4)next you type into the cmd like this
     --> attrib -s -h -r /s /d g:*.*

5)then press enter .and tada!!! you got your folder back ..easy right???

learn photoshop

so i have something to show to you all..basically it just a video for those who interest to learn photoshop..have yall!

Thursday, 1 December 2011

many of us dont know what the suitable work when you learn database..
so here i give some info for you guys bout money you can get using your database knowladge
Database Administrators use database software to store and manage information. They will often set up database systems and are responsible for making sure those systems operate efficiently (usually referred to as database performance tuning). They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access. Ensuring the data is available, by maximizing database uptime, is also an important function of the database administrator.

Education Needed for Database Administrators

Database Administrators often have a 4 year degree in Computer Science or Management Information Systems (MIS). Knowledge of business functions is also important, as is the ability to communicate with other employees in the company in both technical and non-technical roles.
Database administrators will also often hold a certification for a specific database software program. Oracle database certifications are very popular database certification programs, high in demand with employers. Another popular certification is for the Microsoft Certified Database Administrator or MCDBA. The MCDBA is also one of the highest paying technical certifications.

Becoming a Database Administrator

The best way to become a DBA is to take the relevant classes and familiarize yourself with the specific, popular databases that are in demand. Becoming certified in a specific database program is a good way to show your skill level. Internships are often a great start to a Database Administrator career. Other technical support roles, such as System Administrators and Network Administrators, may easily transition into a Database Administration role by becoming certified as a Database Administrator.

Database Administrator Career Path

Database administrators often promote to a senior database administrator and then into a strategic management role within the company, such as a MIS Manager and eventually even on to a Chief Technology Officer role. Some DBAs specialize in a certain area, such as database security, and become experts in that particular area.