MS SQL Developer eğitimi boyunca, SQL dilini temel seviyeden başlayarak kapsamlı bir şekilde öğrenme şansı buldum. Eğitim sürecinde, Select, Insert, Update, Delete gibi temel SQL cümleleri ile veritabanı sorgulamayı etkili bir biçimde gerçekleştirebilmeyi öğrendim.
Ayrıca, Create, Alter, Drop gibi DDL komutlarını nasıl kullanacağımı öğrenmenin yanı sıra, ilişkisel veritabanı mantığı ve mimarisini de detaylı bir şekilde kavradım. Öğretim yöntemleri, iç içe select (subquery) kullanımı, Index, View, Procedure, Function gibi kavramları gerçek veri ve senaryolar üzerinde uygulayarak öğrenmemi sağladı.
İçerikler
Temel SQL Cümleleri: Select, Insert, Update, Delete gibi temel SQL cümlelerini etkili bir şekilde kullanmayı öğrenin.
DDL Komutları: Create, Alter, Drop gibi DDL komutlarını nasıl kullanacağınızı öğrenin.
İlişkisel Veritabanı Mantığı: Veritabanı tasarımı ve ilişkisel veritabanı mantığını kavrayın.
Öğretim Yöntemleri: İç içe select (subquery) kullanımı, Index, View, Procedure, Function gibi kavramları gerçek veri ve senaryolar üzerinde uygulayarak öğrenin.
MSSQL Platformu
🔍 SELECT: Retrieve information from the database.
🗂️ FROM: Specify where to look for the info.
🎯 WHERE: Filter and find specific stuff.
👥 GROUP BY: Organize similar things together.
🔀 ORDER BY: Arrange your info in a specific order.
🤝 JOIN: Combine info from different places.
➕ INSERT INTO: Add new stuff to the database.
🔄 UPDATE: Modify existing info.
🗑️ DELETE FROM: Remove things (careful with this one!).
🔧 ALTER TABLE: Make changes to the structure of your database.
1-CUSTOMERS
SCENARIO 1
SCENARIO 2
1- Creating Database Tables
2- Insert Customers
3- Insert Cities
4- Insert Districts
5- Queries
Query 1: Select the customers that names starts with 'A'
Query 2: Select the male customers that starts with 'A'
Query 3: Select the customers that born between 1990 and 1995
Query 4: With 'JOIN' command, select the customers who live in İSTANBUL
Query 5: With subquery, select the customers who live in İSTANBUL
Query 6: Write the query that shows how many customers are in which city and order them in desending
Query 7: Write the query that shows cities have more than 10 customers and order them in descending
Query 8: Write the query that shows how many female and male customers are in which city
Query 9: Add new columns called AGEGROUP in customers table. Type should be varchar(50)
Query 10: Update AGEGROUP as 20-35, 36-45, 46-55, 56-65, 65+
Query 10-1: Write the query that shows how many customers are in which group without using AGEGROUP
Query 11: Write the query that shows customers live in Istanbul but district is not 'Kadıköy'
Query 11-1: Write the query that shows customers whose city table's is null
Query 12: Write the query that shows customers phones operators as OPERATOR1 and OPERATOR2
Query 13: Here, write the query that will provide information about how many customers we have from which operator
Query 14: Write the query that shows total customers of district and order them in descending
Query 15: Write the query that shows customer birth date as a weekday
Query 15-1: Write the query that shows customer birth date is today
2-HUMAN-RESOURCES
1- Creating Database Tables
2- Insert DEPARTMENTS
3- INSERT DATA IN PERSONS TABLE
4- INSERT DATA IN POSITIONS TABLE
5- Queries
Select persons who still working (OUTDATE is null) in the company
Select total women and men who is stil working for each department
Select total women and men who is stil working for each department (as column)
Select min, max and average salary for 'PLANLAMA ŞEFİ'
Write a query that shows total person who still working and them average salary for each position
Write a query that shows total recruitment male and female for each year
Write the query that shows how many months each employee has worked.
Write the query that shows total shortnames
Write the query that shows departments ordinary salary greater than 5500
Write the query that shows person nanme, position, manager and manager position for each person
Write the query that captures the average seniority of the departments
