Description: Stored data can be used to derive all kinds of information. And the proper storage and use of data can contribute to better business decisions. Use this course to learn how to use a relational database management system (RDBMS) to retrieve vital information.
Explore the purpose of an RDBS. Examine various databases in the marketplace, taking an in-depth look at the history and features of the most popular ones, like Oracle and SQL Server. Work with MySQL Workbench, observing how records relate to tables and how tables are connected.
Discover primary database terminology. Learn about organizing data and using normalization to make data retrieval easier. And find out about E.F. Codd's contribution to database evolution.
Upon completion, you'll know how to glean new information from data stored in an RDBMS.
Target Audience:
Duration: 01:05
Description:
Most businesses are unable to function without a database, even if it's just a filing cabinet. With more and more data coming from multiple sources comes an increased demand for secure and well-performing databases with adequate storage. Take this course to get a firm understanding of what exactly data means and why a database management system (DBMS) is so important for data management. Examine the origins of data and how it's stored and manipulated. Discover the different DBMS types. And learn about the roles and responsibilities involved in using a DBMS. Furthermore, find out how a DBMS can contribute to providing sound and reliable data. Navigate the MySQL Workbench to see the capabilities of an RDBMS (relational database management system) firsthand. After taking this course, you'll be able to recognize the features and capabilities of a reliable DBMS.
Target Audience:
Duration: 00:44