MS-SQL Server and PostgreSQL Database Programming

This training aims to provide participants with detailed knowledge of database programming techniques. Topics such as creating, managing, and processing data in databases will be covered in detail.

This training is intended for professional development, and the certificate obtained does not replace the MYK authorization certificate in training that requires an MYK authorization certificate.

• What is a Database?
• Database Management Systems
• Basic Features of Database Management System Software
• How to Design a Database?
• Relational Database Approach
• Basic Operations on Databases
• Creating Data Environment (DDL) Statements
• Installing and Configuring MSSQL Server
• Installing and Configuring PostgreSQL
• Basic Features of T-SQL
• MSSQL Data Types
• PostgreSQL Data Types
• Creating Tables (Create Table)
• Querying Data (Basic Select Statements)
• Basic Querying Operations in PostgreSQL
• MSSQL Basic Querying Operations
• MSSQL Functions
• PostgreSQL Functions
• PostgreSQL and MSSQL Control Statements
• PostgreSQL and MSSQL Administrative Operations

This training is available for corporate collaboration (in a package for institutions/companies) and individual applications are not accepted. Based on the profile of corporate participants and their needs, the training content can be re-planned. After mutual discussions, the scope and method of the training (In-person, Online) will be determined, and related processes will be completed. If an agreement is reached, suitable dates and times for your organization's participants and instructors will be decided, and the location of the training will be set.