ITSE 1303 - Introduction to MySQL

3 Credits (2 hrs. lec., 3 hrs. lab.) Introduction to fundamentals of SQL and relational databases. Topics covered include database terminology and concepts; planning, defining, and designing a database; designing and generating tables; devising and processing queries; installing MySQL and troubleshooting syntax. Prerequisite: None
Course Outcomes
1 - Identify database terminology and concepts.
2 - Plan, define, and design a database.
3 - Design and generate tables.
4 - Devise and process queries.
5 - Install and start the MySQL server.
6 - Troubleshoot syntax.