Introduction to Relational Databases

<p>Upon completion of the course, the student will be able to:<br></p> <ul><li>Use Select-From-Where queries to collect information from a single table database.</li><li>Form a single table database using Create and Insert commands.</li><li>Use Group By, Order By, and aggregate functions.</li><li>Alter and update the database table by adding, deleting, or modifying columns.</li><li>Use Select-From-Where queries to combine information from multiple tables in a database using Joins.</li><li>Form a database with multiple tables using primary keys and foreign keys.</li><li>Demonstrate awareness of sub-queries, views, indices, and unions.</li><li>Summarize the importance of backing up data.</li><li>Evaluate multiple approaches to securing relational data.</li><li>Explore other methods of enhancing relational table design.</li><li>Explain the purpose and utility of a database.</li><li>Identify the most common database models used today.</li><li>Distinguish between several commercial relational DBMS.</li><li>Explain the purpose of an ERD.</li><li>Explain the purpose of normalization with respect to the relational data model.</li><li>Given an ERD depicting non-normalized data, normalize the data model.</li><li>Adapt RDMS use to business considerations.</li></ul>