-
-
- Transfer Credit
- Online Learning
- Events
-
-
-
- Academic Services
- Course and Program Information
- Student Aid
-
-
-
Berkeley Global
In this course, students learn the principles of effective database design and gain a general overview of database management systems (DBMS). The emphasis is on relational and NoSQL database management systems which have a variety of applications in modern website development, software development, and data science. Students learn dimensional, object-oriented, and object-relational architectures, along with best practices for managing data integrity and security.
Prerequisites:
There are no prerequisites for this course. Prior knowledge of SQL or experience querying databases is helpful but not required.
Course Outline
Expand or collapse section
What You Learn
- Database fundamentals and history
- Database components
- Traditional relational databases
- NoSQL databases
- Forms-based queries (using Microsoft Access as an example)
- SQL fundamentals
- Database lifecycle
- Normalization
- Star schema design
- Data and process modeling using patterns
- Physical design of relational databases
- Indexing
- Deployment on cluster servers
- Connecting databases to the Web and to applications
- NoSQL database implementations: unstructured, columnar, document, key-value, graph
- Database security and encryption
- Cursor processing
- Transaction management
- Alternative data structure: XML, JSON
- Object-oriented database management
- Data warehouses
- Data marts
Is This Course Right for You?
The course is recommended for anyone trying to build a foundation in database design and management, whether for personal or professional use. The course is designed specifically for those who are new or relatively new to database technology; however, those requiring a refresher should also find the course material valuable. Specifically, the following individuals will find the course helpful for improving their understanding of databases:
- The novice new to database design and query languages such as SQL
- The analyst or manager who wants a better understanding of how to design, implement and access databases
- The data analyst or database administrator who wants to learn more about database design
- The QA engineer or technical support professional who must understand database design in order to validate database applications
- The software engineer who wishes to better understand how application designs and database designs can work together to solve business problems
Learner Outcomes
After successfully completing this course, you will be able to:
- Choose applicable database architectures for typical business use cases.
- Create a relational database schema, including data structures (tables and related components), load data into the tables, and perform various queries using the database schema.
- Write basic queries for document and graph databases.
- Create database designs that support business transactions as well as the reporting of historic data.
- Choose appropriate physical database architectures for a variety of database applications.
- Choose indexing strategies for relational database tables.
- Choose implementation strategies for various NoSQL database architectures.
- Specify security requirements and techniques to protect the assets contained in the database.
- Create an implementation specification for database applications, including:
- Cursor processing options
- Transaction management methods to ensure database consistency
- Incorporation of alternative data structures
- Design data warehouse schemas and implementation plans.
- Design data mart schemas and implementation plans.
Loading...
Sections
Spring 2025 enrollment opens on October 21!