-
-
- Sciences, Mathematics
and Biotechnology - Biology
- Chemistry and Physics
- Clinical Laboratory Science
- Health Advising
- Life Science Business and Biotechnology
- Mathematics and Statistics
- Online Sciences Courses
- See the full list
- Technology and
Information Management - Writing, Editing and
Technical Communication
- Transfer Credit
- Online Learning
- Events
- Career Services
- Custom Programs
- Sciences, Mathematics
-
-
-
- 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:
Recommended
- Ability to program in at least one high-level programming language such as Python, Java, Ruby, JavaScript, C or C++. Need to fulfill this prereq? Take a course in:
- Introduction to Computers and Programming COMPSCI X444.4
- Programming Python COMPSCI X434
- First Course in Java EL ENG X429.9
- JavaScript and jQuery: An Introduction COMPSCI X452.1
- Introduction to C Language Programming EL ENG X24
Course Outline
Expand or collapse section
Course Objectives
- Define the primary components of relational, hierarchical, network, object-oriented, object-relational, dimensional, and NoSQL databases, along with the fundamental differences between them.
- Use forms-based tools and SQL statements to define, maintain and retrieve data from DBMS products.
- Create normalized database designs for those intended to support business transaction processing.
- Create star schema designs for databases intended to support historical reporting and analytics (i.e., business intelligence applications).
- Create data models, including the ability to recognize and use common data structure patterns.
- Translate logical database designs into physical implementations, including specifications for network-connecting the database, indexing, deployment on a cluster server, and accessing the database using various programming languages.
- Understand the security ramifications when implementing databases and implement security and data access controls.
- Design data warehouse and data mart schemas for use in business intelligence applications.
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
How You Learn
- Reading assignments
- Discussion assignments
- Writing assignments and quizzes
- Online midterm exam
- Proctored final exam
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
- Based on the fundamental properties that all database systems share and the architectures of prevalent database models, 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
Fall enrollment opens on June 20!