Sayısal verileri ve metinleri dönüştür

Bu egzersizde 2006'dan önce yayımlanan filmler için %50 indirim kampanyası planlıyorsun. Bu kampanyaya hazırlık için, kampanyaya uygun filmleri döndürmen gerekiyor; başlıkların okunmasını kolaylaştırmak için hepsini küçük harfe çevireceksin. Ayrıca hem original_rate hem de sale_rate değerlerini de döndürmelisin.

Bu egzersiz

SQL'i Gerçek Dünyadaki Sorunlara Uygulama

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Filmlerin titlelarını LOWER ile küçük harfe çevirerek döndür.
rental_ratei 0.5 ile çarparak orijinal rental_rate ve %50 indirimli sale_rate değerlerini döndür.
Bu kampanya için yalnızca 2006 öncesindeki filmlerin dikkate alındığından emin ol.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT ___ AS title, 
  ___ AS original_rate, 
  ___ * ___ AS sale_rate 
FROM film
-- Filter for films prior to 2006
___;

Kodu Düzenle ve Çalıştır

Bu egzersiz

SQL'i Gerçek Dünyadaki Sorunlara Uygulama

kursunun bir parçasıdır

IntermediárioNível de habilidade

4.9+

Kursa Ücretsiz Başlayın

You will review some of the most commonly used SQL commands to ensure you are prepared to tackle both real-world problems as well as every exercise covered in this course.

Exercise 1: Temel SQL Exercise 2: Temelleri gözden geçir Exercise 3: Temelleri pekiştir Exercise 4: Sonuçlarını dönüştürme Exercise 5: Sayısal verileri ve metinleri dönüştür

Geçerli Egzersiz

Exercise 6: İhtiyacın olanı çıkar Exercise 7: Toplama (aggregate) fonksiyonlarıyla çalışmak Exercise 8: Finansları birleştirme Exercise 9: Metinleri bir araya getirme Exercise 10: Hangi tablolar?

How do you find the data you need in your database in order to answer real-world business questions? Here you will learn how to use system tables to explore your database. You will use these tables to create a new tool that contains a list of all tables and columns in your database. Finally, you will create an Entity Relationship Diagram (ERD) which will help you connect multiple tables.

Exercise 1: Find the right table Exercise 2: LIMITing your search Exercise 3: Which table to use?Exercise 4: What tables are in your database?Exercise 5: Determine the monthly income Exercise 6: Join the correct tables Exercise 7: What columns are in your database?Exercise 8: A VIEW of all your columns Exercise 9: Testing out your new VIEW Exercise 10: The average length of films by category Exercise 11: Complex joins Exercise 12: Build the entity relationship diagram Exercise 13: Which films are most frequently rented?

Working with SQL to solve real-world problems will oftentimes require you to do more than retrieve the data you need, oftentimes you will need to manage the data in your database. This includes creating data, updating it and, when necessary, deleting it.

Exercise 1: Store your data Exercise 2: Storing new data Exercise 3: Using existing data Exercise 4: TABLE vs VIEW Exercise 5: Update your data Exercise 6: What should you modify?Exercise 7: Update the price of rentals Exercise 8: Updated based on other tables Exercise 9: Delete your data Exercise 10: Deleting all table data Exercise 11: Delete selected records Exercise 12: A family friendly video store

How do you ensure that the SQL scripts you write will be easy to understand for anyone who needs to read them? This chapter will cover approaches you can leverage to ensure that your code clearly conveys your intent, is readable by others and follows best practices.

Exercise 1: Convey your intent Exercise 2: How to convey our intent Exercise 3: Clarify the intent of this query Exercise 4: Fix this query - intent Exercise 5: Write readable code Exercise 6: How to make code easier to read Exercise 7: Make this query easier to read - Part I Exercise 8: Make this query easier to read - Part II Exercise 9: Avoid common mistakes Exercise 10: What are the don'ts of writing SQL code?Exercise 11: Apply best practices to your code Exercise 12: Recap