Loading...

Course Description

In this digital landscape, SQL and relational databases form the backbone of virtually all critical infrastructure in the United States. The organization and security of those databases, however, is dependent on the manner of their construction, which determines how data is accessed and protected. Your team’s ability to construct and manage a database effectively is therefore critical.

In this course, you will approach database design from a perspective focused on data security and integrity. You will go from learning how to approach general security to understanding how to properly execute modifications so that data integrity is preserved. Along the way, you will discover how to systematically design, build, and manage databases while prioritizing data integrity and security, which will maximize their utility for your organization.

The following courses are required to be completed before taking this course:

  • Exploring Data
  • Integrating Data From Multiple Tables
  • Extracting Insights From Data

Faculty Author

Shawn Mankad

Benefits to the Learner

  • Incorporate security and access rights into database design
  • Convert one type of data to another, making them usable for deeper analysis
  • Troubleshoot database design issues using entity diagrams
  • Modify database design to create new fields or tables

Target Audience

  • Business analysts
  • Professionals who work with databases or data warehouses
  • Managers using data insights to make business decisions
  • Marketing analysts
  • Product analysts

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
Jun 19, 2024 to Jul 02, 2024
Total Number of Hours
24.0
Course Fee(s)
Contract Fee $0.00
Section Notes

IMPORTANT COURSE INFORMATION

  • During this program, you will need to download SQLite from the course onto your computer. Once the course has become available, you can find installation instructions in the section labeled “Course Resources” in your module list. Please be prepared to install SQLite as indicated in the context of the first course.
  • Please note that the content in our “Data Management in SQL” course curriculum was developed to be completed in sequential order, as course concepts build throughout the program. With this in mind, please be sure you are scheduled to complete or have completed “Exploring the Data” prior to “Integrating Data From Multiple Tables,” “Integrating Data From Multiple Tables” prior to “Extracting Insights From the Data,” and so on.
Type
2 week
Dates
Aug 28, 2024 to Sep 10, 2024
Total Number of Hours
24.0
Course Fee(s)
Contract Fee $0.00
Section Notes

IMPORTANT COURSE INFORMATION

  • During this program, you will need to download SQLite from the course onto your computer. Once the course has become available, you can find installation instructions in the section labeled “Course Resources” in your module list. Please be prepared to install SQLite as indicated in the context of the first course.
  • Please note that the content in our “Data Management in SQL” course curriculum was developed to be completed in sequential order, as course concepts build throughout the program. With this in mind, please be sure you are scheduled to complete or have completed “Exploring the Data” prior to “Integrating Data From Multiple Tables,” “Integrating Data From Multiple Tables” prior to “Extracting Insights From the Data,” and so on.
Type
2 week
Dates
Nov 06, 2024 to Nov 19, 2024
Total Number of Hours
24.0
Course Fee(s)
Contract Fee $0.00
Section Notes

IMPORTANT COURSE INFORMATION

  • During this program, you will need to download SQLite from the course onto your computer. Once the course has become available, you can find installation instructions in the section labeled “Course Resources” in your module list. Please be prepared to install SQLite as indicated in the context of the first course.
  • Please note that the content in our “Data Management in SQL” course curriculum was developed to be completed in sequential order, as course concepts build throughout the program. With this in mind, please be sure you are scheduled to complete or have completed “Exploring the Data” prior to “Integrating Data From Multiple Tables,” “Integrating Data From Multiple Tables” prior to “Extracting Insights From the Data,” and so on.
Required fields are indicated by .