Applying SQL to Real-World Problems
Find tables, store and manage new tables and views, and write maintainable SQL code to answer business questions.
Kurs Kostenlos Starten4 Stunden13 Videos47 Übungen27.670 LernendeLeistungsnachweis
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.Trainierst du 2 oder mehr?
Versuchen DataCamp for BusinessBeliebt bei Lernenden in Tausenden Unternehmen
Kursbeschreibung
Now that you’ve learned the basic tools of SQL you are ready to synthesize them into practical, real-world skills. In this course, you will work with a database of a fictional movie rental company. The size and complexity of this database will allow you to experience the challenges of working with databases firsthand. Throughout this course, you will use SQL to answer business-driven questions. You will learn new skills that will empower you to find the tables you need. You will then learn how to store and manage this data in tables and views that you create. Best of all you will also learn how to write code that not only clearly conveys your intent but is also legible.
Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.In den folgenden Tracks
SQL für Business Analysten
Gehe zu Track- 1
Use Real-World SQL
KostenlosYou 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.
- 2
Find Your Data
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.
Find the right table50 xpLIMITing your search100 xpWhich table to use?50 xpWhat tables are in your database?100 xpDetermine the monthly income100 xpJoin the correct tables50 xpWhat columns are in your database?100 xpA VIEW of all your columns100 xpTesting out your new VIEW50 xpThe average length of films by category100 xpComplex joins50 xpBuild the entity relationship diagram100 xpWhich films are most frequently rented?100 xp - 3
Manage Your Data
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.
Store your data50 xpStoring new data100 xpUsing existing data100 xpTABLE vs VIEW50 xpUpdate your data50 xpWhat should you modify?50 xpUpdate the price of rentals100 xpUpdated based on other tables100 xpDelete your data50 xpDeleting all table data50 xpDelete selected records100 xpA family friendly video store100 xp - 4
Best Practices for Writing SQL
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.
Convey your intent50 xpHow to convey our intent50 xpClarify the intent of this query50 xpFix this query - intent100 xpWrite readable code50 xpHow to make code easier to read50 xpMake this query easier to read - Part I100 xpMake this query easier to read - Part II100 xpAvoid common mistakes50 xpWhat are the don'ts of writing SQL code?50 xpApply best practices to your code100 xpRecap50 xp
Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.In den folgenden Tracks
SQL für Business Analysten
Gehe zu TrackDmitriy Gorenshteyn
Mehr AnzeigenLead Data Scientist at Memorial Sloan Kettering Cancer Center
Was sagen andere Lernende?
Melden Sie sich an 15 Millionen Lernende und starten Sie Applying SQL to Real-World Problems Heute!
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.