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.
Struttura del corso
Introduction to Databases
- What is a database?
- Types of databases: relational, hierarchical, NoSQL
- When and why to use databases
Database Management Systems (DBMS)
- Overview of DBMS architecture
- Popular systems (SQL Server, MySQL, PostgreSQL, Oracle)
- Responsibilities of a DBMS
Data Modeling and Design
- Entities, attributes, and relationships
- Entity-Relationship (ER) diagrams
- From models to tables
Relational Model and Normalization
- Tables, rows, and columns
- Primary and foreign keys
- 1NF, 2NF, 3NF and denormalization
Basic SQL for Data Access
- SELECT, INSERT, UPDATE, DELETE
- Filtering, sorting, and joins
- Aggregate functions and subqueries
Database Security and User Management
- User roles and permissions
- Authentication and access control
- Securing data in transit and at rest
Backup, Recovery, and Maintenance Basics
- Data backup strategies
- Disaster recovery considerations
- Routine maintenance and monitoring
Summary and Next Steps
Requisiti
- An understanding of general IT concepts
- Experience with using computers and navigating file systems
- Basic knowledge of data and file organization
Audience
- IT systems support personnel
- Database administrators
- Developers or analysts transitioning into data-related roles
40 ore
Recensioni (5)
Nel complesso una buona formazione che risponde alle mie esigenze. Ho ricevuto anche informazioni su Oracle VM VirtualBox che mi hanno permesso di continuare la pratica da solo.
Liviu
Corso - Oracle SQL LP - Fundamentals
Traduzione automatica
Ho imparato funzioni complesse e come applicarle
Ana Alexandrescu - DB Global Technology
Corso - Oracle SQL Advanced
Traduzione automatica
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Corso - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.
David Lambaerts - Estee Lauder BV
Corso - ORACLE PL/SQL Fundamentals
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.
