Skip to main content

Introduction to Database & Database Administrator roles

Database:
A database is an organized collection of data, generally stored and accessed electronically from a computer system. 
Where databases are more complex they are often developed using formal design and modeling techniques.

The database management system (DBMS) is the software that interacts with end users, applications, 
and the database itself to capture and analyze the data. The DBMS software additionally encompasses 
the core facilities provided to administer the database. The sum total of the database, the DBMS and 
the associated applications can be referred to as a "database system". Often the term "database" 
is also used to loosely refer to any of the DBMS, the database system or an application associated with the database.

Database Admin:

 A database administrator (DBA) is a specialized computer systems administrator who maintains a successful database environment
by directing or performing all related activities to keep the data secure. The top responsibility of a DBA professional is to maintain data integrity.
This means the DBA will ensure that data is secure from unauthorized access but is available to users.

A database administrator will often have a working knowledge and experience with a wide range of database management products such as MySQL,MongoDB,PpostgreSQl and SQL Server.

Responsibilities Of Database Administrator

Starting, Stopping and Configuring MySQL
Security-Related Configuration
MySQL Database Creation
Using Client Programs for MySQL DBA Work
Setting up Character Set Support
Locking
Using Storage Engines, including the MyISAM and InnoDB engines
Table Maintenance
Obtaining Data from the Information_Schema Database
Backup and Recovery, including Exporting (mysqldump) and Importing (mysqlimport
Using Stored Procedures and Triggers for Database Administration Tasks
User Management
Securing the Server
Upgrade-Related Security Issues
Optimizing Queries
Optimizing Schemas
Optimizing the Server
The Event Scheduler
Partitioned Tables
Interpreting Error Messages
Optimizing the MySQL Environment
Scaling MySQL, including Replication

Comments

Post a Comment

Popular posts from this blog

Mongodb online Training course Agenda

  Goal:   In this module, you will get an understanding of NoSQL databases, design goals, requirement of NoSQL database/ MongoDB, MongoDB® architecture and introduction to JSON and BSON among others. This module will also cover the installation of MongoDB® and associated tools. Skills Understand NoSQL databases and  advantages Install MongoDB on Windows and Linux platform Security Enable and high availability Objectives After completing this module, you will  be able knowledge ed on SQL and noSQL Database usages and difference between these MongoDB design and architecture  MongoDB GUI tools Describe JSON and BSON Install MongoDB on Windows, Linux, MAC OS etc.  Setup MongoDB environment Topics • Understanding the basic concepts of a Database • Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS  • Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property • CAP Theorem, implementing NoSQL and what is MongoDB?  • O...
Post a Comment
Read more

MySQL Architecture -Client Server Architecture

Client/Server Overview The MySQL database system operates using a client/server architecture. The server is a central program that manages database contents, and client programs connect to the server to retrieve or modify the data. MySQL also includes non-client utility programs and scripts. MySQL Server:   This is the mysqld program that manages database and tables. Most users choose binary MySQL distribution that includes a server ready to run with the capabilities they need, but it's also possible to compile MySQL from source. Client Programs:  These are programs that communicate with the server by sending requests to it over a network connection. The server acts on each request and returns a response to the client. For example you can use the mysql client to send queries to the server, and the server returns the query results. A client program can connect locally to a server running on the same machine or remotely to a server running on a different mac...
Post a Comment
Read more

Mysql Server Installation on Windows

Pre Requisite s : Microsoft .NET Framework 4.5.2 MySQL 8.0 Server requires the Microsoft Visual C++ 2015 Redistributable Package to run on Windows platforms. Users should make sure the package has been installed on the system before installing the server. The package is available at the Microsoft Download Center.   Additionally, MySQL debug binaries require Visual Studio 2015 to be installed. URL : MySQL Downloads @ https://dev.mysql.com/downloads/mysql/                    @ http://dev.mysql.com/downloads/installer/ Microsoft Visual C++ 2015 @ https://www.microsoft.com/en-us/download/default.aspx Installing Mysql on windows are two types           1. Using MySQL Installer           2. Using MySQL Binaries Method -1 : Using MySQL Installer           MySQL installer is the easiest way. MySQL installer provides you with an easy-to-...
Post a Comment
Read more