Database management refers to the actions an organization takes to manipulate and control data to meet necessary conditions throughout the data lifecycle. A database management task is any task that protects data, prevents legal and compliance risks, and keeps data-intensive applications performing as needed. These tasks can include performance monitoring and tuning, storage and capacity planning, backup and recovery, data archiving, partitioning, replication, masking, and retirement.With this in mind, we’ve compiled this list of the best database management courses and online training to consider if you’re looking to grow your data management skills for work or play. This is not an exhaustive list, but one that features the best database management courses and online training from trusted online platforms. We made sure to mention and link to related courses on each platform that may be worth exploring as well.
…
Platform: Coursera
Description: In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle, MySQL, or PostgreSQL to execute SQL statements and a database diagramming tool such as the ER Assistant or Visual Paradigm to create ERDs.
Platform: ed2go
Description: A number of powerful tools are available to help you build databases and database applications. However, if you do not apply a systematic, structured approach to the use of those tools, you will probably produce systems that fail to meet user needs. Many projects bog down or are never completed for lack of a disciplined approach to development. This course will guide you step-by-step through all the phases of a system development project to guarantee that the resulting product will not only work as it was designed to work, but also that the design truly responds to user needs.
Platform: edX
Description: This course is an introduction to the basic concepts, organization, and implementation models of databases, with an emphasis on the relational model. Among the topics covered are the development of simple queries that retrieve and mutate the data in a database. Data Manipulation Language (DML) is a subset of SQL that is used by database developers to create, maintain, and query facts in the database.
Related paths/tracks: Advanced Database Queries, Structured Database Environments with SQL, Relational Database Basics, Databases: Relational Databases and SQL
Platform: LinkedIn Learning
Description: Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
Related paths/tracks: Relational Databases Essential Training, Database Foundations: Database Management
Platform: Mindmajix
Description: Develop skills to transform yourself as a certified AWS Database professional with hands-on lectures and real-time projects. You will explore the fundamentals of cloud databases, various cloud database services available on AWS cloud, database tools and features, and much more through practical examples. Enroll now and get certified.
Platform: Udacity
Description: This course is a quick, fun introduction to using a relational database from your code, using examples in Python. You’ll learn the basics of SQL (the Structured Query Language) and database design, as well as the Python API for connecting Python code to a database. You’ll also learn a bit about protecting your database-backed web apps from common security problems.
Related path/track: Database Systems Concepts & Design
Platform: Udemy
Description: Using the latest best practices in SQL, database management, and database design, this course is focused on efficiency. The curriculum is very hands-on as instructors walk you from start to finish of working with databases and SQL, all the way into learning how to scale databases, how to manage them, and even bonus material on working with big data, caching using Redis, and connecting PostgreSQL to a Node.js server.
Related paths/tracks: Database Management System from scratch – Part 1, Database Management Systems – MySQL, MySQL Database Administration: Beginner SQL Database Design
This article was written by Tim King on October 17, 2022
Tim is Solutions Review’s Executive Editor and leads coverage on data management and analytics. A 2017 and 2018 Most Influential Business Journalist and 2021 “Who’s Who” in Data Management, Tim is a recognized industry thought leader and changemaker. Story? Reach him via email at tking@solutionsreview dot com.
Solutions Review brings all of the technology news, opinion, best practices and industry events together in one place. Every day our editors scan the Web looking for the most relevant content about Endpoint Security and Protection Platforms and posts it here.
© 2012-2023 Solutions Review. All rights reserved.