This course is intended for people that are relatively new to relational and non-relational databases and want to gain an understanding of what types of databases are available on AWS. Gain a comprehensive understanding of the different types of managed NoSQL databases on AWS.Understand the characteristics of NoSQL databases and how they can be used for application development.Learn about non-relational databases and how they can be used.Gain a general understanding of databases within AWS.
If you have any feedback relating to this course, feel free to contact us at Learning Objectives It includes an overview and the characteristics of non-relational databases as well as what NoSQL means and why it’s important to application development. It covers relational and non-relational databases, how they work, their strengths, and what workloads are best suited for them. Nonsubversion-It must not be possible to bypass the integrity rules defined through the database language by using lower level languages.Īlternatives to the relational database model include the hierarchical model, network model, and object model.This course provides a high-level overview of the managed database offerings available from AWS. Distribution independence-Application programs and ad hoc requests are logically unaffected when data is first distributed or when it is redistributed.ġ2. They must be stored in the online catalog and they cannot be bypassed.ġ1. Integrity independence-The database language must be capable of defining integrity rules. Logical data independence-Application programs and ad hoc programs are logically unaffected, to the extent possible, when changes are made to the table structures.ġ0. Physical data independence-Application programs and ad hoc programs are logically unaffected when physical access methods or storage structures are altered.ĩ. Set-level insertion, update, and deletion- The DBMS supports not only set-level retrievals but also set-level inserts, updates, and deletes.Ĩ. View updating rule-All views that are theoretically updatable can be updated through the system.ħ. It must support data definition, manipulation, integrity rules, authorization, and transactions.Ħ. Comprehensive data sublanguage-At least one supported language must have a well defined syntax and be comprehensive. Active online relational catalog-The description of the database and its contents are represented at the logical level as tables and can therefore be queried using the database language.ĥ. Systematic null value support- The DBMS provides systematic support for the treatment of null values (unknown or inapplicable data), distinct from default values and independent of any domain.Ĥ. Guaranteed access- Every value in a relational database is guaranteed to be accessible by using a combination of the table name, primary key value, and column name.ģ.
Information rule- All information in a relational database (including table and column names) is represented explicitly as values in tables.Ģ. A relational DBMS must be able to manage databases entirely through its relational capabilities.ġ. Codd defined thirteen standards that must be met before a database can be considered a relational database:Ġ. (Ted) Codd first developed the concept of a relational database in A Relational Model of Data for Large Shared Data Banks in 1970.ĭr. Relational database technology allows databases to be larger, faster, and more efficient.ĭr. This is accomplished through the use of keys, which are database fields used to uniquely identify specific records in a table. These relationships enable DBAs to combine data from several tables for querying and reporting. It then allows Data Base Administrators (DBAs) to define relationships between these tables. A relational database stores data in separate tables instead of placing all data in one large table.