{"id":6435,"date":"2024-05-29T11:32:24","date_gmt":"2024-05-29T11:32:24","guid":{"rendered":"https:\/\/www.turkticaret.net\/blog\/?p=6435"},"modified":"2024-11-29T07:14:38","modified_gmt":"2024-11-29T07:14:38","slug":"sql-nedir-2025-sql-kullanim-alanlari","status":"publish","type":"post","link":"https:\/\/www.turkticaret.net\/blog\/sql-nedir-2025-sql-kullanim-alanlari\/","title":{"rendered":"SQL Nedir? 2025 SQL Kullan\u0131m Alanlar\u0131"},"content":{"rendered":"

SQL<\/strong> nedir sorusuna verebilece\u011fimiz cevaba, modern d\u00fcnyada verinin \u00f6nemi her ge\u00e7en g\u00fcn art\u0131yor \u015feklinde c\u00fcmleye ba\u015flayabiliriz. Veriler, \u015firketlerin karar alma s\u00fcre\u00e7lerinden, g\u00fcnl\u00fck ya\u015fam\u0131m\u0131z\u0131 kolayla\u015ft\u0131ran uygulamalara kadar bir\u00e7ok alanda hayati rol oynar. Bu verileri etkili bir \u015fekilde y\u00f6netmek ve i\u015flemek i\u00e7in kullan\u0131lan en yayg\u0131n dillerden biridir. Peki, SQL nedir ve ne i\u015fe yarar? Bu blog yaz\u0131s\u0131nda bu sorulara yan\u0131t bulaca\u011f\u0131z.<\/p>\n

SQL Nedir?<\/strong><\/h2>\n

SQL (Structured Query Language), ili\u015fkisel veritabanlar\u0131n\u0131 y\u00f6netmek ve manip\u00fcle etmek i\u00e7in kullan\u0131lan standart bir programlama dilidir. 1970’lerin ba\u015f\u0131nda IBM taraf\u0131ndan geli\u015ftirilen SQL, g\u00fcn\u00fcm\u00fczde bir\u00e7ok veritaban\u0131 y\u00f6netim sistemi (DBMS) taraf\u0131ndan desteklenmektedir. MySQL, PostgreSQL, Microsoft SQL Server, Oracle Database gibi pop\u00fcler veritaban\u0131 sistemleri, SQL’i temel al\u0131r.<\/p>\n

SQL’in Temel \u0130\u015flevleri<\/strong><\/h2>\n

Veritabanlar\u0131yla etkile\u015fim kurmak i\u00e7in kullan\u0131lan g\u00fc\u00e7l\u00fc ve esnek bir dildir. Ba\u015fl\u0131ca i\u015flevleri \u015funlard\u0131r:<\/p>\n

    \n
  1. Veri Sorgulama<\/strong>: Veritaban\u0131ndan belirli verileri sorgulamak i\u00e7in kullan\u0131l\u0131r. \u00d6rne\u011fin, belirli bir m\u00fc\u015fterinin sipari\u015flerini listelemek i\u00e7in sorgular\u0131 yaz\u0131labilir: SELECT * FROM Orders WHERE CustomerID = 1;<\/u><\/span><\/li>\n
  2. \u00a0Veri Manip\u00fclasyonu<\/strong>: Veritaban\u0131na veri eklemek, g\u00fcncellemek veya silmek i\u00e7in komutlar\u0131 kullan\u0131l\u0131r.INSERT INTO Customers (Name, Email) VALUES (‘xyz’, ‘xyz@example.com’);<\/u><\/span><\/u>UPDATE Customers SET Email = ‘john.new@example.com’ WHERE CustomerID = 1;<\/u><\/span>DELETE FROM Customers WHERE CustomerID = 1;<\/u><\/span><\/li>\n
  3. Veritaban\u0131 Y\u00f6netimi:<\/strong> Veritaban\u0131 \u015femalar\u0131n\u0131 olu\u015fturmak, de\u011fi\u015ftirmek veya silmek i\u00e7in kullan\u0131l\u0131r. Tablo olu\u015fturma, de\u011fi\u015ftirme ve silme i\u015flemleri bu kapsamda yer al\u0131r.CREATE TABLE Customers (<\/u><\/span>\u00a0\u00a0\u00a0 CustomerID int,<\/u><\/span>\u00a0\u00a0\u00a0 Name varchar(255),<\/u><\/span>\u00a0\u00a0\u00a0 Email varchar(255)<\/u><\/span>);<\/u><\/span>ALTER TABLE Customers ADD Phone varchar(20);<\/u><\/span>\n

    DROP TABLE Customers;<\/u><\/span><\/li>\n

  4. Veri Kontrol\u00fc:<\/strong> Kullan\u0131c\u0131lar\u0131n veritaban\u0131na eri\u015fimlerini kontrol etmek ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak i\u00e7in kullan\u0131l\u0131r. Kullan\u0131c\u0131 yetkilendirme ve veri do\u011frulama i\u015flemleri bu kapsamdad\u0131r.GRANT SELECT, INSERT ON Customers TO ‘username’;<\/u><\/span>REVOKE INSERT ON Customers FROM ‘username’;<\/u><\/span><\/li>\n<\/ol>\n

    <\/u>SQL’in Avantajlar\u0131<\/strong><\/h2>\n