It is only the beginning of our learning experience in MIS 330, but we have hit the ground running. MIS 330 “Database Administration” provides an introduction to relational database management systems with a focus on database analysis, design, and implementation. Practical experience with data modeling and database management tools will be used to illustrate these techniques in real-world business scenarios. MySQL Workbench and Microsoft SQL Server Management Studio will be used to gain hands-on experience with constructing and querying databases. Daily readings in “Modern Database Management” and “Querying Microsoft SQL Server 2012 Training Kit” strongly reinforce concepts as we delve into databases.
Course objectives include but are not limited to:
- Understand the role of the database in the software development lifecycle and its impact on the overall implementation of an information system.
- Develop entity relationship diagrams to illustrate the database design based on business requirements.
- Identify potential data integrity concerns in business environments and construct a database design that will address those concerns.
- Implement data models in a relational database management system such as SQL Server.
- Design queries to interact with the database and extract information in a relevant format to address business inquires.
Currently, we are in the first progression of this class. This first of three progressions is meant to provide a fundamental understanding of Database Concepts, and Database Analysis and Design with Basic SQL Queries. We have our first assignment due today, which is a compilation of creating our first database in SQL, and a book review of basic database terminology. There is no better way to reinforce the information we are learning than to be applying that information as we learn it, and that is exactly what we are doing. Not only are we expected to learn the definition of course material, but actually create these things as we learn what they are. That is the true value of this course. Not only will we have a sound grounding in what a relational database management system is, we will be able to analyze, design, and implement a relational database management system up to industry standards.