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.
Plan Szkolenia
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
Wymagania
- 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 godzin
Opinie uczestników (3)
Sposób prowadzenia przez Łukasza
Damian - Sygnity
Szkolenie - Oracle SQL - advanced
ćwiczenia i sposób ich tłumaczenia
Marcin Lipiec - Izba Administracji Skarbowej w Rzeszowie
Szkolenie - Wprowadzenie do Neo4j - grafowej bazy danych
Pełny profesjonalizm wykładowcy + doskonale przygotowane przykłady
