This course offers students the opportunity to learn to create basic and advanced database queries with ease, how to prepare data structures, how to simplify reports with huge data sets, learn how to protect data by performing backup and restore. This will be made possible through the use of various database tools and techniques such as Microsoft SQL Server.

The course is targeted at students and professionals who want to learn Microsoft SQL and want better understand how databases work as well as become professionals on SQL who will become Database Administrators.

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in organizations. The role also includes architecting, building and scaling databases for future data growth. They are also responsible for security, performance and availability of data to users.

Pre-requisite:

  • No prior technical experience is required! All you need a computer with internet access!
  • A basic knowledge of computers, how to operate a computer system

 

Month 1: Introduction to Database Concepts and SQL

Week 1-2: Fundamentals of Databases

  • Understanding the role of databases in modern applications
  • Types of databases: relational, NoSQL, and others
  • Introduction to database management systems (DBMS)

Week 3-4: Relational Database Design and Modeling

  • Entity-Relationship Diagrams (ERD)
  • Normalization and denormalization
  • Data integrity and constraints

Month 2: SQL Fundamentals

Week 5-6: Basic SQL Queries

  • SELECT statement and filtering data
  • Sorting and grouping data
  • Joins and subqueries

Week 7-8: Advanced SQL Concepts

  • Aggregation functions (SUM, AVG, COUNT, etc.)
  • Stored procedures and functions
  • Triggers and transactions

Month 3: Database Administration Basics

Week 9-10: Introduction to Database Administration

  • Role and responsibilities of a database administrator (DBA)
  • Installing and configuring database servers
  • Security and user management

Week 11-12: Performance Tuning and Optimization

  • Indexing and query optimization
  • Monitoring and troubleshooting database performance
  • Backups, recovery, and disaster planning

Month 4: Advanced Database Administration Topics

Week 13-14: High Availability and Scalability

  • Clustering and replication
  • Load balancing and sharding
  • Scaling strategies for databases

Week 15-16: Data Security and Compliance

  • Data encryption and masking
  • Auditing and compliance requirements
  • Best practices for securing databases

Final Project:

  • Design and implement a database solution
  • Performance tuning and optimization of queries
  • Database administration tasks and security implementation

Additional Topics Throughout the Course:

  • Introduction to NoSQL databases (e.g., MongoDB, Cassandra)
  • Database migration and version control
  • Cloud-based database services (e.g., AWS RDS, Azure SQL Database)