This training is aimed at professional development, and the certificate obtained does not replace the MYK certification required for certain trainings.

SQL Basic Training

Training Duration: 5 Days (09:00–12:00 Theory, 13:00–16:00 Practice)
Participant Profile: Students and professionals who want to learn database concepts and gain fundamental knowledge of data management using SQL language

Prerequisites

• Basic computer knowledge
• Logical thinking and analytical skills
• Familiarity with mathematical expressions and table logic

Curriculum Topics

Day 1:

• What is a database, introduction to database management systems (DBMS) and SQL Server
• SQL Server Management Studio (SSMS) interface and basic components
• Concepts of database, table, column, row, data types

Day 2:

• Introduction to SQL queries: SELECT, FROM, WHERE
• Comparison and logical operators (AND, OR, NOT, BETWEEN, LIKE)
• Sorting and filtering (ORDER BY, DISTINCT, TOP)

Day 3:

• Inserting, updating, deleting data (INSERT, UPDATE, DELETE)
• Primary key (PRIMARY KEY), foreign key (FOREIGN KEY) concepts
• Simple data relationships and referential integrity

Day 4:

• Working with multiple tables (JOIN types: INNER, LEFT, RIGHT, FULL)
• Grouping and aggregate functions (GROUP BY, HAVING, SUM, AVG, COUNT)
• Subqueries

Day 5:

• Mini project: Database design for a Student Information System
• Creating relationships between tables, query scenarios
• Data backup, basic security and access management

Training Outcomes

• Ability to create, manage, and query databases in SQL Server
• Learn basic data modeling and relationship logic
• Apply CRUD operations on a real-world scenario

Who Should Attend?

• Students or beginners who want to learn database fundamentals
• Those seeking to pursue careers in software development, data analysis, or system administration
• Developers working with data in ASP.NET, C#, Python, or similar languages

Advanced: Database Management Systems Training (MSSQL)

Training Duration: 5 Days (09:00–12:00 Theory, 13:00–16:00 Practice)
Participant Profile: Individuals with basic SQL knowledge who wish to specialize in performance, security, stored procedures, and data integrity management

Prerequisites

• Basic SQL query and database structure knowledge
• Familiarity with SQL Server Management Studio (SSMS)

Curriculum Topics

Day 1:

• Database design principles (Normalization, 1NF–3NF)
• Index structures and performance analysis (Clustered, Non-Clustered)
• Execution plan analysis and query optimization

Day 2:

• Advanced SQL queries: Nested Queries, CTE (Common Table Expressions)
• Creating Views, Stored Procedures, and Functions
• Parameterized queries and secure coding practices

Day 3:

• Triggers (AFTER, INSTEAD OF), automated process management
• Transaction management (BEGIN TRAN, COMMIT, ROLLBACK)
• Error handling (TRY...CATCH) and logging

Day 4:

• Authorization, user roles, database security
• Backup strategies (Full, Differential, Transaction Log)
• SQL Server Agent and automated job scheduling

Day 5:

• Mini project: “Sales and Stock Management” database — Full structure with Trigger, procedure, index, view, and user roles
• Performance testing and backup planning
• Project presentation and evaluation

Training Outcomes

• Ability to design and manage advanced databases in MSSQL
• Professional application of stored procedures, triggers, views, and transaction management
• Optimization of performance, security, and data integrity processes
• Ability to design real-world database projects with enterprise logic

Who Should Attend?

• Developers with basic SQL knowledge who want to specialize
• Those interested in becoming a Database Administrator (DBA) or system expert
• Professionals working in data management for ASP.NET, data analysis, ERP, or enterprise applications

This training is available for corporate collaboration (as a package for institutions/companies). Individual applications are not accepted. The content of the training can be customized according to the participant profile and the company's needs. After mutual discussions, the scope and method of the training (In-person, Online) are determined, and relevant processes are completed. If an agreement is reached, suitable days and times for your company’s participants and our instructors, as well as the location of the training, are set.