This course covers SQL language for data storage and retrieval, as well as concepts of creating and managing SQL databases.
The training is for professional development purposes, and the certificate obtained does not replace the MYK authorization certificate in trainings where the MYK authorization certificate is mandatory.
- Using SQL Server Management Studio
- Database Concepts and Usage
- Backup Strategies
- Table Concept
- Table Design and Creation
- Table Key Concepts
- Normalization
- Using Diagrams and Linking Tables
- Basic DML Commands (SELECT, INSERT, UPDATE, DELETE)
- Basic DDL Commands (CREATE, ALTER, DROP)
- Relational Concepts (JOIN)
- Data Grouping and Summarizing Concepts (GROUP BY, Aggregate Functions)
- SQL Queries
- Stored Procedures, Triggers, User Defined Functions
- Views
Training duration: 30 hours
The training is open to corporate collaboration, and individual applications are not accepted. The training content can be re-planned according to the corporate participant profile and your needs. After mutual discussions, the scope of the training and the method of delivery (In-person, Online) will be determined, and the related processes will be completed. In case of mutual agreement, the suitable days and times for your organization's participants and our instructors, as well as the location of the training, will be determined.