Relational Database Implementation and Applications
- Offered byCoursera
Relational Database Implementation and Applications at Coursera Overview
Duration | 29 hours |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Relational Database Implementation and Applications at Coursera Highlights
- Earn a certificate from Illinois Tech
- Add to your LinkedIn profile
- 12 quizzes, 1 assignment
Relational Database Implementation and Applications at Coursera Course details
- What you'll learn
- Implement relational database and usage of indexes, views, triggers, temporary tables, functions, and stored procedures.
- Develop database-driven applications using programming languages, such as Java, Python or C/C++ and frameworks.
- Describe transaction and concurrency control concepts in relational databases.
- In today's data-driven world, the ability to work with relational databases is an essential skill for professionals in various fields
- This course is designed to equip you with the knowledge and practical skills needed to become proficient in database management and application development
- Whether you are pursuing a career as a database administrator, software developer, or data analyst, this course provides you with a strong foundation to excel in your chosen field
Relational Database Implementation and Applications at Coursera Curriculum
Module 1: Indexes, Views, Functions, and Stored Procedures
Course Introduction
Instructor Introduction
Module 1 Introduction
Indexes, Views, Triggers, Stored Procedures and Functions
Video Demonstration
Course Welcome
Syllabus
Module 1 Introduction - Project Timeline
Select a Real-World DB Application
Deliverable #1
Indexes, Views, Functions, and Stored Procedures
Practice Activity: Indexes, Views, Temporary Tables, Triggers, Functions and Stored Procedures
Deliverable #2
Module 1 Summary
Indexes, Views, Functions, and Stored Procedures Quiz
Summative Module 1 Assessment
Meet and Greet Discussion
Visual Studio Code Lab
Module 2: Advanced Window Functions and OLAP Queries in SQL
Module 2 Introduction
Advanced Window Functions and OLAP Queries
Demonstration
Advanced Window Functiosn and OLAP Queries in SQL
Practice Activity: SQL Advanced Window Functions & OLAP Queries
Deliverable #3
Module 2 Summary
Advanced Window Functions and OLAP Queries in SQL Quiz
Summative Module 2 Assessment
Visual Studio Code Lab
Module 3: Database Application Development
Module 3 Introduction
Database Application Development
Video Demonstration
Database Application Development
Practice Activity: SQL Advanced Window Functions & OLAP Queries
Deliverable #4
Module 3 Summary
Database Application Development Quiz
Summative Module 3 Assessment
Visual Studio Code Lab
Module 4: Indexing and Hashing
Module 4 Introduction
Indexing and Hashing
Indexing and Hashing
Module 4 Summary
Indexing and Hashing Quiz
Summative Module 4 Assessment
Visual Studio Code Lab
Module 5: Transaction Concepts
Module 5 Introduction
Transactions
Demonstration
Transactions Processing Concepts
Module 5 Summary
Transactions Processing Concepts Quiz
Summative Module 5 Assessment
Visual Studio Code Lab
Module 6: Concurrency Control
Module 6 Introduction
Concurrency Control
Concurrency Control
Module 6 Summary
Concurrency Control Quiz
Summative Module 6 Assessment
Visual Studio Code Lab
Summative Course Assessment
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?