CNT 262 - Introduction to Databases with SQL

5 Total Credits
This is an introductory course on databases and SQL querying. Students will obtain hands-on experience from setting up the database environment using Cloud-based services to creating your first table to writing your first query. Students will become familiar with Oracle Workbench Tool, AWS LightSail mySQL Instances, AWS EC2 RDS Instances (for my SQL Server). At the end of this course, students will be able to write simple queries related to topics such as dates, string manipulation, and aggregation.

Course Outcomes

Understand terms related to database design and management.
Utilize basic modeling techniques for database design such as the E-R Model.
Understand the relational model and relational database management system (RDBMS).
Implement a relational database with SQL Server, MySQL or similar RDBMS.
Learn the basics of SQL and demonstrate understanding through utilizing SQL to manage a database and query data.
Understand the basics of data management, administration and data security.
Identify and recommend cloud database products that are appropiate for specific tasks and projects.
Apply best practices to design, configure and deploy new relational and non-relational databases in a cloud infrastructure.
Describe the differences between files, relational databases and non-relational databases in the cloud and when to use each to help a customer select the best solutions for their needs.
Apply practical database skills including database design, table structures, database migration, queries, and data visualization.
Import, export, and migrate large datasets to and from one database to another database.