CSCC 477 – Advanced Database Querying and Reporting (3)
This competency takes a deeper look at database design and database queries. The competency addresses storage, indexes, query processing, and query optimization. You will learn advanced table creation and how to use controls to enhance forms and improve functionality. You will optimize queries, download and install a SQL server, and gain extensive experience using hands-on exercises. You will also implement data security and data management and learn about concurrent access, locking, replication, and fragmentation.
Upon successful mastery of this competency, you will be able to:
- Employ query language to create, update and delete tables for a given database.
- Develop queries which use aggregate functions and commands.
- Install and configure a relational database server.
- Implement security strategies, groups and policies to secure data on a database server.