Data Analysis
Collect, clean and analyse data with spreadsheets and Python so you can answer business questions.
Database Management training
Learn to design, build, secure and maintain databases that applications depend on.
Course overview
Learn how to design, build, secure and maintain databases that applications depend on. You will work with relational databases, backups, performance and access control.
Requirements
- Basic SQL knowledge helps
- A computer
- Comfort with organised data
What you will learn
- Design a database from requirements
- Create and manage tables and relationships
- Back up, restore and secure a database
- Improve query and database performance
Practical projects
- Design and build a school or inventory database
- Create a backup and recovery plan
Skills you will gain
- Database design
- MySQL administration
- Backups and recovery
- Access control
- Performance tuning basics
Career and application opportunities
- Database administrator (junior)
- Database support
- Backend developer support
- Data operations roles
Curriculum
1Database fundamentals
- What a database management system does
- Relational and non-relational databases
- Installing MySQL
- Using database tools
2Database design
- Gathering requirements
- Entities and relationships
- Normalisation
- Creating the schema
3Working with data
- Creating tables and keys
- Inserting and updating data
- Joins and views
- Stored procedures overview
4Administration
- Users and permissions
- Backups and restore
- Monitoring a database
- Data integrity
5Performance and security
- Indexes
- Optimising queries
- Protecting data
- Capstone project
Related courses
Data Science
Combine programming, statistics and visualisation to turn raw data into insight and predictions.
Machine Learning
Train and evaluate models that learn from data, using Python and standard machine learning libraries.