Basic: Database Management Systems (MSSQL) Training

42 (25 voting)
 Last update date 11/2025
 Türkçe
egitim.kurumsalbasvuru

Foundations of Artificial Intelligence and Corporate Transformation: Strategy, Compliance, and Future Vision check out our education.

📞 Contact: Bursa Uludağ University SEM 📧 E-mail: usem@uludag.edu.tr

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 basic SQL data management skills

Prerequisites

  • Basic computer knowledge
  • Logical thinking and analytical ability
  • 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, and 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:

  • Data insertion, updating, deletion (INSERT, UPDATE, DELETE)
  • Primary Key and Foreign Key concepts
  • Basic data relationships and referential integrity

Day 4:

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

Day 5:

  • Mini Project: Student Information System database design
  • Creating relationships between tables, query scenarios
  • Data backup, basic security and access management

Training Outcomes

  • Gains the ability to create, manage and query databases in SQL Server.
  • Learns the logic of basic data modeling and relationships.
  • Applies CRUD operations in a real scenario.

Who Should Attend?

  • Students and beginners who want to learn database fundamentals
  • Those who want to move into software, 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: Participants with basic SQL knowledge who want to specialize in performance, security, procedures and data integrity management

Prerequisites

  • Knowledge of basic SQL queries and database structure
  • Ability to use 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 View, Stored Procedure and Function
  • Parameterized queries and secure coding

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 task scheduling

Day 5:

  • Mini Project: “Sales and Inventory Management” database — full structure with Trigger, Procedure, Index, View and user roles
  • Performance tests and creating a backup plan
  • Project presentation and evaluation

Training Outcomes

  • Can perform advanced database design and management on MSSQL.
  • Applies professional-level procedure, trigger, view and transaction management.
  • Optimizes performance, security and data integrity processes.
  • Can build real-world database projects with corporate logic.

Who Should Attend?

  • Developers with basic SQL knowledge who want to specialize
  • Those who want to become a Database Administrator (DBA) or system specialist
  • Professionals working with data in ASP.NET, data analysis, ERP or corporate applications

Comments

Add a comment
More
Share:
Basic: Database Management Systems (MSSQL) Training
egitim.kurumsalbasvuru

You are allow cookie by using us website. ENTER