Databases and SQL

Catalog description

Relational database technology revealed the power of a simple data model coupled with the nonprocedural Structured Query Language (SQL) that enabled data independence and unleashed the power of computing applications. Despite the growing importance of other data models, like schema-free and distributed-data models, the relational data model still reigns supreme in many application domains. The overwhelming majority of business data is still stored in relational databases, and any business analyst needs to understand how to extract data from them. This course provides thorough coverage of SQL. The course also covers data warehousing concepts, as analysts will need to design data warehouses for end users to perform their data analysis. Another important topic in the course is database design. While business analysts might not design databases for mission critical processes, they might be called upon to design departmental databases. This will require an understanding of database design diagrams. With this in mind, the course also covers the use of Entity Relationship Models for database design.