CIMW 105 WEB DEVELOPMENT AND DB - INTRO SQL AND MYSQL

3 Units 2 hours lecture 3 hours lab
Transfers: CSU
Introduction to databases, web server-side databases and the Structured Query Language (SQL). Course uses MySQL or MariaDB to create, manipulate, and query databases. Covers the fundamentals of a relational database, basic selection queries, sub-queries, multiple table queries, joins, aggregate calculations, updating data, MySQL database administration, data definition and manipulation, views, sorting, triggers, constraints, indexes and basic introduction to PL/SQL. Course also discusses cloud database services of SQL, NoSQL, big data and caching.
Grading Method: GR - Letter Grade or Pass/No Pass
NR