Microsoft-SQL

Microsoft-SQL copied to clipboard

Necmettin Erbakan University 3nd year Database Systems lecture notes and assignments. This course is covered with Microsoft SQL, I will write the SQL codes according to this database.

• [x] Microsoft SQL server, Azure Data Studio and DBeaver installation

• [x] Running Microsoft SQL Server in Azure and connecting from personal computer

• [x] Lessons and Quiz

  • [x] Lesson1 (CREATE, INSERT, UPDATE, DELETE, SELECT)

  • [x] Lesson2 (Data types)

  • [x] Lesson3 (Advanced SELECT queries)

  • [x] Lesson4 (Clustering Functions, GROUP BY, HAVING and practice questions)

  • [x] Lesson5 (Relational database and normalization)

  • [x] Lesson6 (FOREIGN KEY, Inner Join)

  • [x] Lesson7 (FOREIGN KEY, Inner Join, DECLARE, VIEW, PROCEDURE)

  • [x] Lesson8 (TRIGGER and TSQL)

  • [x] Lesson9 (String Functions)

  • [x] Quiz

• [x] Projects

  • [x] SQL queries on products pulled from Amazon.com with Python Selenium

  • [x] Moving the .csv file to Microsoft SQL Server