Database Management Course (SQL) in Kubwa, Abuja
Almost every app and business system runs on a database. This course teaches how databases are designed, built and queried.
About this course
Almost every app and business system runs on a database. This course teaches how databases are designed, built and queried.
You design your own database, then create and manage it in MySQL and PostgreSQL using SQL.
What you'll learn
- Explain how relational databases work
- Design databases with entity-relationship diagrams
- Write SQL to create, read, update and delete data
- Use joins, aggregates and subqueries
- Manage users, backups and restores in MySQL and PostgreSQL
Course outline
1 Database concepts
- Tables, rows and keys
- Relational vs non-relational databases
- Normalisation
2 SQL fundamentals
- SELECT, INSERT, UPDATE and DELETE
- Filtering and sorting
- Joins and aggregates
3 Data modelling
- Entity-relationship diagrams
- Relationships and constraints
- Designing a schema
4 MySQL and PostgreSQL
- Installation and tools
- Users and permissions
- Backup and restore
Who this course is for
- Aspiring developers and data analysts
- IT staff who manage business systems
- Students on computing and IT programmes
Tools you'll use
Requirements
Basic computer skills.
Frequently asked questions
Will I learn MySQL or PostgreSQL?
Both. The SQL skills you learn transfer between them.
Who needs database skills?
Developers, data analysts and IT administrators all rely on them daily.
How much does the Database Management Course (SQL) cost?
Send us a message on WhatsApp and we'll reply with the current fee for the Database Management Course (SQL), the available class times and the next start date.
Can I take this course online?
Yes. We offer both in-person classes at our Kubwa centre and live online classes, so you can choose what suits your schedule and location.
Will I get a certificate?
We issue certificates for most of our courses. Ask us when you enrol and we will confirm the certificate for this course.
Ready to start Database Management Course (SQL)?
Message us on WhatsApp and we'll send you the current fee, class times and the next start date.