Advanced Database Management

(View Complete Item Description)

This course will focus on advanced techniques and concepts in database management. Emphasis will be on Structured Query Language (SQL) and current industry best practices for utilizing data and databases. This course will be using hands-on exercises and real-world case studies for topics such as database optimization, database scalability, performance tuning, and concurrency control. Learning Objectives Choose appropriate data models for projects. Implement data design in a relational database. Use query language (SQL) to create, access, update, and delete. Articulate how to collect and handle data Visualize and present data in ways that are easy to communicate with others Write efficient SQL statements Practice and implement database modeling and design Utilize and implement industry best practices for security and data standards Program a complex project using industry standard techniques. Describe the issues related to database performance. Show the advantages and disadvantages of various database types.

Material Type: Full Course

Author: Adrianna Holden-Gouveia

Introduction to Data

(View Complete Item Description)

This is an introductory course in data literacy and databases. The course includes aspects of database design including entity relationship modeling, tables, and queries. Students will utilize database applications and Structured Query Language (SQL). Data science including data collection, modeling, and visualization will be discussed. Best practices for data security and privacy in regards to current regulations around the world will be emphasized in this course. Learning Objectives Classify a diverse variety of data and construct usable data models Identify and apply industry best practices Demonstrate how to effectively use data within your job/industry Articulate how to collect and handle data Visualize and present data in ways that are easy to communicate with others Write efficient SQL statements Practice and implement database modeling and design Utilize and implement industry best practices for security and data standards

Material Type: Full Course

Author: Adrianna Holden-Gouveia