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
Foundations of Databases
- Defining what constitutes a database
- Classifications of databases
- Overview of relational databases
- Database Management Systems (DBMS) introduction
- Key functions of a DBMS
- Notable DBMS platforms
Principles of Database Design
- Conceptual, logical, and physical data modelling
- Intro to Entity-Relationship (ER) modelling
- Constructing ER diagrams
- Understanding entities, attributes, and relationships
Normalization in Database Design
- Normal forms (1NF, 2NF, 3NF, BCNF)
- Advantages of normalisation
- Practical illustrations of normalisation
- Denormalisation and its applications
Introduction to SQL
- SQL syntax and structural elements
- Data types within SQL
- CREATE, ALTER, and DROP commands
- Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL)
Manipulating Data with SQL
- INSERT command
- Bulk insertion processes
- UPDATE and DELETE commands
- Applying the WHERE clause
Data Retrieval via SQL
- SELECT command
- Data filtering using the WHERE clause
- Data ordering using ORDER BY
- Utilising LIMIT and OFFSET
Sophisticated SQL Methodologies
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- Constructing subqueries
- GROUP BY and HAVING clauses
- Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
Utilising Indexes and Views
- Creating and applying indexes
- Trade-offs associated with indexes
- Building and managing views
- Simplifying queries through views
Database Security and Transaction Management
- User roles and access permissions
- Adhering to security best practices
- ACID properties
- COMMIT and ROLLBACK commands
Database Performance and Upkeep
- Evaluating and refining SQL queries
- Interpreting the EXPLAIN plan
- Backup methodologies
- Database restoration processes
Conclusions and Future Directions
Requirements
- Familiarity with basic computer operations
Intended Audience
- Database administrators
- IT professionals
21 Hours
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.
