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
Foundations of Databases
- Definition and purpose of a database
- Categorization of database types
- Overview of relational databases
- Introduction to Database Management Systems (DBMS)
- Core functions of a DBMS
- Overview of widely used DBMS software
Core Principles of Database Design
- Conceptual, logical, and physical data modeling
- Introduction to Entity-Relationship (ER) modeling
- Construction of ER diagrams
- Defining entities, attributes, and relationships
Normalization in Database Architecture
- Normal forms (1NF, 2NF, 3NF, BCNF)
- Advantages of applying normalization
- Real-world examples of normalization
- The role and application of denormalization
Getting Started with SQL
- SQL syntax and command structure
- SQL data types
- Use of CREATE, ALTER, and DROP commands
- Defining constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL)
Data Manipulation in SQL
- Executing INSERT commands
- Performing bulk insert operations
- Using UPDATE and DELETE commands
- Applying conditions with the WHERE clause
Retrieving Data via SQL
- Using the SELECT command
- Data filtering through the WHERE clause
- Ordering results with ORDER BY
- Implementing LIMIT and OFFSET for pagination
Complex SQL Techniques
- Join types: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- Constructing subqueries
- Aggregating data with GROUP BY and HAVING
- Applying aggregate functions (COUNT, SUM, AVG, MAX, MIN)
Utilizing Indexes and Views
- Creation and application of indexes
- Trade-offs associated with indexing
- Development and management of views
- Leveraging views for query simplification
Ensuring Security and Transaction Integrity
- Managing user roles and access permissions
- Adhering to security best practices
- Understanding ACID properties
- Using COMMIT and ROLLBACK to manage transactions
Optimizing and Maintaining Databases
- Analysis and optimization of SQL queries
- Interpreting EXPLAIN plans
- Developing backup strategies
- Processes for database restoration
Recap and Future Pathways
Requirements
- Familiarity with fundamental computer operations
Target Audience
- Database administrators
- IT professionals
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.