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
- What is a database?
- Types of databases
- Introduction to relational databases
- Database Management Systems (DBMS) overview
- Functions of a DBMS
- Popular DBMS software
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 uses
Introduction to SQL
- SQL syntax and structure
- Data types in SQL
- CREATE, ALTER, DROP statements
- Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL)
SQL Data Manipulation
- INSERT statement
- Bulk insert operations
- UPDATE and DELETE statements
- Using WHERE clause
Querying Data with SQL
- SELECT statement
- Filtering data with WHERE clause
- Sorting data with ORDER BY
- Using LIMIT and OFFSET
Advanced SQL Concepts
- INNER JOIN, LEFT JOIN, RIGHT JOIN, 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 plan
- Backup strategies
- Restoring databases
Summary and Next Steps
Requirements
- Basic understanding of computer operations
Audience
- Database administrators
- IT professionals
21 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.
David Lambaerts - Estee Lauder BV
Course - ORACLE PL/SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
