Demo storeTry this store's admin panel without an account; orders are in test mode.Open the panel
Vitrin
NewWith certificate

SQL: talking to data

Learn to write queries on real sample databases

₺699

Taxes calculated at checkout · Digital delivery — no shipping

It is delivered by e-mail as soon as your payment is confirmed, so there is no right of withdrawal.

If it is faulty, we replace it or refund it.

In stock

Secure checkout

  • Visa
  • Mastercard
  • Troy
  • American Express
  • Cash on delivery
  • Secure checkout · 3-D Secure
  • Easy returns
  • Local support
Description

You learn to get the information you want out of a database: selecting, filtering, sorting, grouping and joining tables. The examples use the made-up data of a bookshop and a courier company.

The exercises run in a query screen in your browser; you do not need to install anything.

SKU: KAM-42-01-150

Product details

InstructorKerem Aydemir — Works with web interfaces and databases; explains queries with everyday examples.
Lessons11 lessons
Total length2 h 30 min of video
LanguageTurkish
Access12 months from the payment confirmation
FormatVideo lessons, PDF notes and exercises
What you needA computer for the exercises (Windows, macOS or Linux); an up-to-date web browser and at least 5 Mbps internet.
PrerequisitesNone; being used to reading tables helps.
Certificate of completionOur certificate of completion (PDF) when you finish; it is not an official diploma or qualification.
Learning outcomesSelect, filter and sort; group and summarise; join tables; write two realistic reports
Sample lessonTables, rows, columns (9 min)
Module 1First queries: Tables, rows, columns (9 min) · Selecting with SELECT (12 min) · Filtering with WHERE (13 min)
Module 2Order and summary: Sorting (10 min) · Counting and summing (14 min) · GROUP BY (15 min)
Module 3Joining tables: How JOIN works (14 min) · Missing matches (13 min) · Subqueries (15 min)
Module 4Practice: A bookshop report (18 min) · A courier report (17 min)

Customer reviews

No reviews of this product yet. Be the first to write one.

Write a review
Write a review

Your review is published once the store has approved it.

Your rating
At least 10 characters.
Never published.
Give the number of an order placed with this email and your review carries the “Verified purchase” badge.
Up to 3 photos; JPEG, PNG or WebP, at most 5 MB each. Photos are published with your review once it is approved; details such as the location are removed.

Questions and answers

No questions about this product yet.

Ask a question
We'll let you know by e-mail when it is answered. Your address is never shown.

You may also like