Skip to main content

FACI Academy

Databases and SQL Fundamentals

Learn to design, query, secure and look after relational databases, and start a career working with data.
0
0 reviews
  • Description
  • Curriculum
  • FAQ
  • Reviews
Databases and SQL Fundamentals thumbnail

Overview

Databases and SQL Fundamentals teaches you how organisations store, protect and use their data. You will learn what a database is and how the relational model works, then write SQL to retrieve, summarise, combine and change data. You will design well-structured databases using keys, constraints and normalisation, and learn how transactions, indexes and query plans keep data correct and fast.

The course also covers the work of a database administrator: users and privileges, backups and recovery, security, monitoring and maintenance. You will compare relational databases with NoSQL options, see how analytics and reporting use SQL, and connect a database to a small Python program safely.

Every lab uses a realistic fictional supermarket chain, runs on free tools (SQLite and MySQL Community Server) and works offline. The capstone has you design, build, populate, query, secure and back up a database for a fictional business, producing a portfolio project with a schema diagram, tested queries and a recovery runbook.

What you will learn

  • Explain what a database and a DBMS are and describe the relational model, tables, keys and relationships
  • Write SQL to select, filter, sort, group and aggregate data and handle NULL correctly
  • Combine data from several tables with joins, subqueries, set operations and common table expressions
  • Use window functions and views for reporting queries
  • Design a normalised schema with appropriate data types, keys and constraints and draw an ER diagram
  • Create and change tables and data safely with DDL and DML
  • Explain ACID transactions, isolation and locking and use transactions correctly
  • Create indexes and read query plans to improve performance
  • Create users, grant least-privilege access and protect data against SQL injection
  • Take, verify and restore backups and describe replication and high availability
  • Compare relational and NoSQL databases and choose appropriately
  • Use SQL for analytics and connect a database to a Python program safely
  • Apply data protection principles to database design and operations
  • Deliver a documented, tested and recoverable database as a portfolio project

Career relevance

Prepares you for roles such as Junior Database Administrator, SQL or Data Analyst, Reporting and BI Assistant, Back-End Developer (junior), Data Support Analyst and QA tester for data-heavy systems, and supports further study toward vendor database and cloud data certifications (exams are separate and paid). Completing the course does not guarantee a job.

Do I need to install MySQL?
No. Every lab has a SQLite path that runs with Python alone. MySQL is used for the administration topics and is optional if your computer cannot run it.
Which SQL will I learn?
Standard SQL first, with clear notes on where MySQL and SQLite differ. The skills transfer to PostgreSQL, SQL Server and Oracle.
Is this a data science course?
No. It is about storing, querying, designing and administering data. SQL is the core skill that data analysis and data science build on.
Is the certificate accredited?
The completion certificate confirms you finished the FACI Academy course. It is not a vendor accreditation.
Course details
Duration 70 hours
Lectures 31
Quizzes 9
Level Beginner

Recent Posts

    Recent Comments

    No comments to show.