CS 155A MySQL Databases (3)
Credit, Degree Applicable
A course in the use of the MySQL database management system to create, query, and update database tables. The course covers both the syntax and the logic of the major features of the MySQL language. The course includes a brief introduction to the programming aspects of MySQL.
After successful completion of this course, students will be able to:
- Outcome 1: Describe the basic concepts of databases, tables, relationships, and normalization.
- Outcome 2: Analyze business requirements, designing and implementing queries that satisfy those requirements and using all of the major components of the SQL language for accessing data, including inner and outer joins, aggregate queries and subqueries, and a variety of the intrinsic functions supplied by MySQL
- Outcome 3: Manipulate a MySQL database using client software to create and modify database objects such as tables, constraints, relationships, and views following a database design and design and implement simple user-defined functions.
- Outcome 4: Create queries that will manipulate data in the database using Data Manipulation Language statements