Microsoft SQL Server and SQL Language (SQL101) Course

4,6 (120 voting)
 Last update date 02/2025
 Türkçe

Chimney Installation, Maintenance, and Cleaning Development Program check out our education.

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.

Comments

You are allow cookie by using us website. ENTER