SQL and Databases

Learn SQL, the basic language of reporting and analysis, on a realistic e-commerce database.

Learn SQL, the basic language of reporting and analysis, on a realistic e-commerce database. You practise writing queries, joins and window functions hands-on.

Course details

  • Level: Beginner · Duration: 24 hours
  • Format: Recorded content + weekly mentor Q&A hour
  • Instructor: Dr. Tuna Yücel
  • Fee: 3.400 TRY · Average rating: 4.7/5 (5.180 students)

Curriculum

  • SELECT, WHERE and ordering
  • JOIN types and subqueries
  • Grouping and aggregation
  • Window functions and CTEs
  • Fundamentals of database design

What will you gain in this course?

  • Writing complex queries
  • Automating reporting processes
  • Solving interview-style SQL questions

Prerequisites and purchase

No prerequisites; an interest in analytical thinking is enough. After purchase you access the curriculum and calendar from your student panel; you have an unconditional refund right within 14 days. You can pay by card in 3-9 instalments. Those who complete the course receive a certificate with a verification code.

Support

During the course the student support team replies on weekdays between 09:00 and 21:00; in the mentor Q&A hour you can talk to the instructor one to one.

Curriculum

  • SELECT, WHERE and ordering
  • JOIN types and subqueries
  • Grouping and aggregation
  • Window functions and CTEs
  • Fundamentals of database design

Outcomes

  • Writing complex queries
  • Automating reporting processes
  • Solving interview-style SQL questions

Similar items

Cybersecurity Fundamentals

Learn the attack surface, common vulnerabilities and defence methods hands-on in a controlled lab environment.

Level
Intermediate
Duration
40 hours
Instructor
Ahmet Koray Tan
Format
Live lessons
Average rating (out of 5)
4.7
5,800 ₺

View all — Courses

WhatsApp +90 212 555 60 00 info@kivilcimakademi.com