Advance Your Database Administration Skills

Database administrators manage and maintain databases. The role may include installation, configuration, management, performance monitoring, security, data recovery, and more. In this learning path, discover database basics, explore data structures, and learn critical database management skills.

Learn key database administration skills.
Manage databases for improved performance.
Explore how databases integrate with applications.

Syllabus

Courses under this program:
Course 1: Database Foundations: Intro to Databases
-Learn the basics of building databases in a platform agnostic way so you can continue on to other platforms later. Explore database setup, servers, GUIs, tables, objects, and more.

Course 2: Database Foundations: Data Structures
-Learn how to properly structure your data tables to develop well-formed databases that adhere to time-tested standards.

Course 3: Database Foundations: Database Management
-Part three of the Database Foundations series focuses on data management.

Course 4: Database Foundations: Administration
-Discover the most current techniques and best practices for securing, backing up, and restoring databases.

Course 5: Database Foundations: Application Development
-This capstone to the Database Foundations series demonstrates how the RDBMS fits into the wider world of app development, as well as what it means to be a full-stack developer.

Course 6: SQL Server Fundamentals: Master Basic Query Techniques
-This course provides a straightforward, concise resource for non-developers to learn enough about relational databases and SQL syntax to write simple queries.

Course 7: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
-Learn the fundamental concepts underlying database system design, including applications using databases and the implementation techniques used in database systems.

Course 8: Advanced SQL for Query Tuning and Performance Optimization
-Learn how to analyze query execution plans and use data modeling strategies to boost query performance.

Course 9: Advanced SQL Project: Design and Manage a Database
-Learn how to design and manage databases using ETL processes and SQL. Discover how to conceptualize, normalize, and optimize databases, develop robust data pipelines, and more.

Course 10: Cloud Architecture: Core Concepts
-Build your cloud computing skill set by learning the business and tech-related basics of creating a cloud architecture.

Course 11: NoSQL Essential Training
-Get a high-level view of the basics of NoSQL, from how it differs from relational databases to its pros and cons.