What is a Database? & What is a DBMS?

• Database are used to store and manage large amounts of data. DBMS help in retrieving data and manipulating it and then representing the data.

• Today, almost every organization has morphed itself into a data-driven organization.

• This has a direct impact on organization's strategic, tactical and operational business decisions

What is a Database Administration?

• Database administration is the task of maintaining the integrity of a database.

• Data is very important and hence it's even more important to keep it stable and secure

• Monitoring the health of a dedicated storage place is important. As the data is an asset to the company and hence should be available all the time.

Who is a Database Administrator?

Database Administrator is responsible for handling the database and making sure that data is stable and has integrity

What is the need of a Database Administrator?

Database Administrator is an important role as it :

1 Helps in keeping the data stable

2 Makes sure data is always accessible

3 Keeps the data secure

4 Helps in plan future endeavors.

SKILLS REQUIRED

• Knowledge of Structured Query Language.
• Database designing
• Understanding of distributed computing architectures.
• Knowledge of underlying operating system e.g. Windows Server 2003, Solaris, etc.
• Knowledge about the RDBMS itself e.g. Microsoft SQL Server, Oracle, etc.
• Ready to face challenges and solve them quickly.

LIFE AS A DBA

• DBA is expected to be available for 24*7.
• Must be an expert in Database technology.
• DBA is expected to know everything about everything. (i.e.) SQL queries, OS, Network protocols, handling advanced tools, computer hardware, etc,.
• DBA is often blamed if any fault occurs.
• They are forced to prove that database designed by him is not fault.

DATABASE ADMINISTRATION TOOLS

• SQL Server Management Studio is a software application first launched with the Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server.
• Adminer is a tool for managing content in MySQL databases. "Light-weight" - released in a form of a single file, approx160 KB in size. User-friendly interface .