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.
Duration 21 hours
Course Outline
Fundamentals of Databases
- Defining the concept of a database
- Various categories of database systems
- Overview of relational database structures
- Brief overview of Database Management Systems (DBMS)
- Key functions performed by a DBMS
- Leading DBMS software platforms
Core Principles of Database Design
- Conceptual, logical, and physical data modeling
- Introduction to Entity-Relationship (ER) modeling
- Developing ER diagrams
- Defining entities, attributes, and their relationships
Normalization Strategies in Database Design
- Normal forms (1NF, 2NF, 3NF, BCNF)
- Advantages of applying normalization
- Practical demonstrations of normalization
- Denormalization and its practical applications
Getting Started with SQL
- SQL syntax and structural elements
- Available data types in SQL
- Utilizing CREATE, ALTER, and DROP statements
- Applying constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL)
Manipulating Data with SQL
- Using the INSERT statement
- Executing bulk insert operations
- Modifying and removing data with UPDATE and DELETE
- Applying filters with the WHERE clause
Retrieving Data via SQL Queries
- Using the SELECT statement
- Data filtering through the WHERE clause
- Ordering results with ORDER BY
- Limiting and offsetting results with LIMIT and OFFSET
Advanced SQL Methodologies
- Join types: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- Constructing subqueries
- Aggregation using GROUP BY and HAVING
- Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
Managing Indexes and Views
- Creation and application of indexes
- Evaluating the benefits and drawbacks of indexing
- Building and maintaining views
- Leveraging views to streamline complex queries
Database Security and Transaction Handling
- Managing user roles and permissions
- Implementing industry-standard security practices
- Understanding ACID properties
- Controlling transactions with COMMIT and ROLLBACK
Optimizing and Maintaining Databases
- Analysis and optimization of SQL performance
- Interpreting execution plans using EXPLAIN
- Designing effective backup strategies
- Database restoration procedures
Conclusion and Future Directions
Requirements
- Familiarity with basic computer operations
Target Audience
- Database administrators
- IT specialists
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
