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
Getting Started with Databases
- Definition and purpose of a database
- Various database types
- Overview of relational databases
- Introduction to Database Management Systems (DBMS)
- Key functions of a DBMS
- Leading DBMS software solutions
Foundations of Database Design
- Conceptual, logical, and physical data modeling
- Basics of Entity-Relationship (ER) modeling
- Constructing ER diagrams
- Understanding entities, attributes, and relationships
Normalization Strategies
- Normal forms (1NF, 2NF, 3NF, BCNF)
- Advantages of applying normalization
- Practical normalization case studies
- Denormalization and its applicable scenarios
Getting to Know SQL
- SQL syntax and structural elements
- SQL data types
- Using CREATE, ALTER, and DROP commands
- Defining constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL)
Data Manipulation in SQL
- The INSERT command
- Executing bulk insertions
- UPDATE and DELETE operations
- Applying WHERE clauses
Retrieving Data via SQL
- The SELECT command
- Data filtering using WHERE clauses
- Data sorting with ORDER BY
- Utilizing LIMIT and OFFSET
Advanced SQL Techniques
- INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
- Formulating subqueries
- Using GROUP BY and HAVING clauses
- Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
Managing Indexes and Views
- Index creation and application
- Evaluating the benefits and drawbacks of indexes
- Building and managing views
- Leveraging views to streamline queries
Security and Transaction Handling
- Configuring user roles and permissions
- Adhering to security best practices
- Understanding ACID properties
- Executing COMMIT and ROLLBACK statements
Performance Tuning and Maintenance
- Reviewing and optimizing SQL queries
- Utilizing the EXPLAIN plan
- Developing backup strategies
- Database restoration processes
Wrap-up 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.
