Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Databases
- Understanding what a database is.
- Exploring types of databases.
- Introduction to relational databases.
- Overview of Database Management Systems (DBMS).
- Functions of a DBMS.
- Popular DBMS software options.
Database Design Fundamentals
- Conceptual, logical, and physical data models.
- Introduction to Entity-Relationship (ER) modeling.
- Creating ER diagrams.
- Entities, attributes, and relationships.
Normalization and Database Design
- Normal forms (1NF, 2NF, 3NF, BCNF).
- Benefits of normalization.
- Practical examples of normalization.
- Denormalization and its applications.
Introduction to SQL
- SQL syntax and structure.
- Data types in SQL.
- CREATE, ALTER, and DROP statements.
- Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL).
SQL Data Manipulation
- INSERT statement.
- Bulk insert operations.
- UPDATE and DELETE statements.
- Using the WHERE clause.
Querying Data with SQL
- SELECT statement.
- Filtering data with the WHERE clause.
- Sorting data with ORDER BY.
- Using LIMIT and OFFSET.
Advanced SQL Concepts
- INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
- Writing subqueries.
- GROUP BY and HAVING clauses.
- Aggregate functions (COUNT, SUM, AVG, MAX, MIN).
Working with Indexes and Views
- Creating and using indexes.
- Pros and cons of indexes.
- Creating and managing views.
- Using views to simplify queries.
Database Security and Transactions
- User roles and permissions.
- Implementing security best practices.
- ACID properties.
- COMMIT and ROLLBACK statements.
Database Optimization and Maintenance
- Analyzing and optimizing SQL queries.
- Using EXPLAIN plans.
- Backup strategies.
- Restoring databases.
Summary and Next Steps
Requirements
- Basic understanding of computer operations.
Target Audience
- Database administrators.
- IT professionals.
21 Hours
Testimonials (3)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
