SQL and Database Systems Design - 3
Course emphasizes “best practices” for relational database design (modeling) and the use of Structured Query Language (SQL) for database manipulation. Normalization, data diagramming, concurrency and other key database concepts will be discussed. The use of Microsoft Access, MySQL, Microsoft SQL Server, and other database management systems will be used to demonstrate concepts. Upon successful completion of this course, students will be able to design real world databases and manipulate them using SQL. Recommended: At least one programming language or application that uses formatted data files (COMS B5, B12, B14, B16, B25, B32, B36, B68a). Hours: 54 lect. Offered: F. CCS: Occupational Education. Transferable: CSU and private colleges. Note: Elective credit only.