Database Managers are primarily responsible for creating new databases or upgrading existing databases for large or small companies. They perform maintenance on databases, check data accessibility and troubleshoot problems with new systems as needed.
Database Managers are primarily responsible for creating new databases or upgrading existing databases for large or small companies. They perform maintenance on databases, check data accessibility and troubleshoot problems with new systems as needed. Database Managers ensure the safety of stored data by implementing security programs.
These personnel will need an understanding of database languages, the most common of which is Structured Query Language (SQL). While there are a variety of database management systems that use SQL, this certificate will focus primary on relational database systems.
Successful Database managers possess highly refined analytical, problem solving and organizational skills. Detail-oriented, logical thinkers who understand project scheduling, time management and leadership concepts can excel in this position. Basic verbal and written communication and technical skills are essential for Database Managers. In addition to these qualities, it is important that Database Managers possess the following abilities.
Assessing data storage and access needs
Creating and maintaining databases
Upgrading database systems and software as needed
Developing emergency data storage and retrieval plans
Managing data backup operations
Key Program Topics
Learn how to use the Structured Query Language (SQL) to create, manipulate, and generate reports
from database tables
Learn to design and implement database management systems
EER modeling, data warehousing, client/server & internet database environments
Perform transaction processing and distributed data management
Develop technical expertise in cloud computing architecture using Amazon Web Services (AWS)
Elective options include web frameworks, UNIX/Linux systems, MongoDB, and LEAN Thinking concepts
At UC San Diego Division of Extended Studies, we believe great social and economic prosperity comes from integrating the collective knowledge of the university, community leaders and professionals. Division of Extended Studies strives to combine local impact with national reputation and global reach.
This course introduces HBase – a NoSQL store on top of Hadoop.  The course is intended for developers who will be using HBase to develop applications,  and administrators who will manage HBase clusters.
We all work with data every day. SQL makes it easy to work with data and make more informed strategic and operational decisions. Used in data science, analytics, and engineering, it’s a helpful skill for anyone working with data (even in non-tech roles).
You will learn how to complete of an application schema definition by creating database objects such as relational views, sequences, synonyms, indexes and others to compliment the table definitions.
In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.
This course provides an Oracle developer or administrator the necessary skills to be able to read and manipulate data within an Oracle database. This course is hands-on and includes lab exercises.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy