Database Management System (Udemy)
What you'll learn
- understanding data, information, databases, dbms
- understanding the life cycle of the relational database
- understanding data modelling w.r.t. ER modelling and Relational Modelling
- Willingness to learn
- programming language basics
- relational algebra basics
Although user interfaces hide details of access to a database, and most people are not even aware they are dealing with a database, accessing databases forms an essential part of almost everyone’s life today.
On completion of this course, the participant will be able to understand data which forms the back-bone of any and every organisation.
It will aid in direct or indirect user access to databases.
Who this course is for:
As it is a basic level course, the audience can be from any stream.
Trick: Apply the Udemy promo code right away at the checkout page to get the biggest discounts!
Database Foundations: Database Management (Linkedin)
In the realm of relational databases, the table is the main event, the showstopper, the lead singer, the king. However, there are several other components of databases that are just as vital to a fully functioning system. In this course—the third part of his Database Foundations series—Adam Wilbert turns the spotlight on the supporting cast of database management characters. He covers topics like view objects, query performance, transactions, and stored procedures, and shows how each is an integral part of database management. Adam also includes challenges designed to test your skills as the course advances. As Adam illustrates, knowledge of these elements of database management can enhance your system performance and lead to a more consistent end-user experience.
Trick: Remember to use the Linkedin coupon to get the biggest discount right now!
Relational Database Management Systems (Edx)
The Relational Database Management Systems course provides you with a basic understanding of relational databases. You will create databases and gain real-world experience with several popular database technologies and systems. Furthermore, you will learn how to create database tables and store information in them – while developing a foundational understanding of various database design and schema topics to help decrease data retrieval.
What you'll learn
- How to implement databases in multiple database management systems.
- Create database tables with the appropriate columns and data types.
- Ensure data integrity with foreign keys.
- Increase performance with indexes.
- Create stored procedures.
- Create database triggers.
- Establish database backups and restores.
Who can take this course?
Unfortunately, learners residing in one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. edX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.
Trick: To receive the greatest savings, apply the Edx coupon code straight away at the checkout page! Avoid missing out.
Database Management Essentials (Coursera)
Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle, MySQL, or PostgreSQL to execute SQL statements and a database diagramming tool such as the ER Assistant or Visual Paradigm to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle, MySQL, or PostgreSQL.
SKILLS YOU WILL GAIN
- Database (DB) Design
- Entity–Relationship (E-R) Model
- Database (DBMS)
Trick: Use the Coursera discount code for fantastic discounts!
Top comments (0)