Relational Database Management Systems
Master the essentials of database creation and management with hands-on experience in popular database technologies, focusing on DDL and DML implementations.
Master the essentials of database creation and management with hands-on experience in popular database technologies, focusing on DDL and DML implementations.
This comprehensive course provides a foundational understanding of relational database management systems. Students will gain practical experience with various database technologies, learning to create and manage database tables effectively. The curriculum covers essential concepts including data definition language (DDL) for database creation and data manipulation language (DML) for data operations. Through hands-on practice, students will master table creation, data storage, foreign key implementation, indexing strategies, stored procedures, and database triggers. The course also emphasizes important aspects of database maintenance including backup and restore procedures.
4
(7 ratings)
Instructors:
-1746721442565.webp&w=3840&q=75)
English
English
Powered by
What you'll learn
Implement databases across multiple database management systems
Create optimized database tables with appropriate columns and data types
Implement data integrity using foreign keys
Optimize database performance through effective indexing
Develop and manage stored procedures
Create and maintain database triggers
Skills you'll gain
This course includes:
PreRecorded video
Graded assignments, Exams
Access on Mobile, Tablet, Desktop
Limited Access access
Shareable certificate
Closed caption
Get a Completion Certificate
Share your certificate with prospective employers and your professional network on LinkedIn.
Created by
Provided by
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 5 modules in this course
The course delivers a comprehensive introduction to relational database management systems through practical, hands-on learning. Students begin with fundamental concepts of database design and progress to implementing databases across multiple management systems. The curriculum covers essential topics including table creation, data types, column management, foreign key constraints, indexing for performance optimization, stored procedures, and database triggers. Special emphasis is placed on both theoretical understanding and practical application, including important maintenance tasks such as database backup and restoration techniques.
Database Implementation Fundamentals
Module 1
Database Table Design
Module 2
Database Performance
Module 3
Advanced Database Features
Module 4
Database Administration
Module 5
Fee Structure
Instructors
-1746721442565.webp&w=256&q=75)
6 Courses
Distinguished Leadership in Information Systems and Cybersecurity Education
Dr. C. Augusto Casas serves as a Senior Lecturer in the Online MS program at the University of Maryland Baltimore County (UMBC), bringing over two decades of higher education teaching experience in information systems and computer science. His career uniquely combines academic excellence with extensive industry experience, having worked on Supervisory Control and Data Acquisition (SCADA) systems for major oil and power utility companies across the Americas, the Middle East, and Southeast Asia. At UMBC, a designated Center for Academic Excellence in Cybersecurity, he specializes in cloud security and teaches courses focused on Amazon Web Services (AWS) and secure system deployment. His academic credentials include a PhD in Information Systems from Nova Southeastern University, with research focus in computational finance, and an MBA from the University of Connecticut. As a Certified Financial Planner (CFP®), he also brings expertise in financial technology (FinTech) to his teaching. His student-centered teaching philosophy emphasizes active learning techniques and effective online teaching methods, particularly in cybersecurity education where he helps prepare qualified professionals to address the increasing challenges of cyberattacks facing organizations globally.
3 Courses
Distinguished Leadership in Information Systems and Software Engineering
Dr. Michael Brown serves as a Professor of Practice in the Department of Information Systems at the University of Maryland Baltimore County (UMBC), bringing over two decades of industry experience to academia. His career began at Sun Microsystems as a Java Engineer before founding Valhalla Data Systems, which secured contracts with major government agencies. His professional journey includes significant work at the NASA/WVU Software Research Laboratory and technical management positions in business process automation at federal law enforcement agencies. As an educator, he has demonstrated exceptional teaching abilities across 14 universities over 20 years, earning the distinction of being the only person to receive two Effective Practice Awards from the Online Learning Consortium. His research focuses on artificial intelligence and software engineering, with over 30 published research papers. Dr. Brown's academic credentials include a PhD in Computer Science from Nova Southeastern University, along with both a Master's and Bachelor's degree in Computer Science and Mathematics from Shippensburg University. He is currently recognized as a Senior Member in both IEEE and ACM, and his contributions to academia were further acknowledged with a Fulbright grant in 2019, which led to research at General Tadeusz Kosciuszko Land Forces Military University in Wroclaw, Poland.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.