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
Relational Database Management Systems (RDBMS)
Relational Operations
SQL as a Declarative Query Language
SQL Syntax Standards
SQL Sublanguages: DQL, DML, DDL, and DCL
Data Query Language (DQL) Components
- SELECT statement structure
- Column aliasing techniques
- Table aliasing conventions
- Date data types and associated functions
- Aggregate group functions
- Table joining methodologies
- JOIN clause implementations
- UNION operator applications
- Nested query structures
- Correlated subqueries for government data processing
Data Manipulation Language (DML) Summary
- Row insertion via INSERT commands
- Row insertion using subqueries
- Row updates via UPDATE commands
- Row deletion via DELETE commands
Data Definition Language (DDL) Summary
- Object creation, modification, and removal (CREATE, ALTER, DROP)
- Table generation through subquery execution (CREATE TABLE AS SELECT...)
Constraint Management Overview
- NULL and NOT NULL specifications
- Explicit CONSTRAINT clause usage
- ENUM data type applications
- SET data type applications
- PRIMARY KEY enforcement
- UNIQUE value requirements
- FOREIGN KEY relationships
- DEFAULT value assignments
Transaction Control Overview
- COMMIT operations for permanent changes
- ROLLBACK procedures for data reversal
- SAVEPOINT management
- Implicit and explicit transaction handling
SQL Dialect Comparisons Overview
- MySQL characteristics
- Microsoft Access and SQL Server features
- Oracle and PostgreSQL implementations for government systems
Requirements
Proficiency in fundamental computer operations is required for government personnel.
14 Hours
Testimonials (7)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
The way in which it was organized on virtual machines, easily accessed by the trainer
Alexandru Tudorache
Course - SQL Fundamentals
Providing information and knowledge of the training topic
Patryk Pietrzyk - Nacomi Group
Course - SQL Fundamentals
Learned new things and advanced myself with knowledge
Todor - MYPOS TECHNOLOGIES
Course - SQL Fundamentals
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
style, knowledge
Cristina - Banca Transilvania
Course - SQL Fundamentals
He had a lot of patience with all the students.
