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
Testimonials (3)
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
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.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
