Enterprise database and SQL

Catalog description

4 0 This course covers a broad overview of the multi-user, enterprise relational database paradigm. Topics covered include Structured Query Language (SQL) instruction for data definition, data manipulation, and data retrieval. Develops knowledge and skills required to install commercial and/or opensource enterprise databases, model and create new databases, manage users, authentication, and stored procedures, and develop backup/restore strategies. New paradigms in database management will also be covered including NoSQL and cloud database types. Students will be able to: List terms related to database design and management; Explain the objectives of data and information management; Apply the database development process; Explain the relational model and relational database management system; Assess data and information requirements; Construct conceptual data models; Develop physical data models for relational database management systems; Implement relational databases using a RDBMS; Demonstrate the retrieval of data using SQL; Apply techniques to identify and mitigate database performance issues; Demonstrate the basics of data management and administration; Explain the basics of data warehousing; Work as a valuable member of a database design and implementation team.