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.

• Microsoft SQL server, Azure Data Studio and DBeaver installation

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

• Lessons and Quiz

  • Lesson1 (CREATE, INSERT, UPDATE, DELETE, SELECT)

  • Lesson2 (Data types)

  • Lesson3 (Advanced SELECT queries)

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

  • Lesson5 (Relational database and normalization)

  • Lesson6 (FOREIGN KEY, Inner Join)

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

  • Lesson8 (TRIGGER and TSQL)

  • Lesson9 (String Functions)

  • Quiz

• Projects

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

  • Moving the .csv file to Microsoft SQL Server