1. Aprende
    2. /
  2. Proyectos
    3. /
  3. Applying SQL to Real-World Problems
  • 1

    Use Real-World SQL

    Gratuito

    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.

  • 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.

  • 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.

  • 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.

Initializing

Ejercicio

What columns are in your database?

Just like pg_catalog.pg_tables can be incredibly helpful for listing all the tables in your database, information_schema.columns can be used to list the columns of these tables. In this exercise, you will combine these system tables to get a list of all of the columns for all your tables (in the 'public' schema).

Note: These system tables are specific to PostgreSQL but similar tables exist for other databases (see slides).

Instrucciones 1/2

undefined XP
    1
    2

View all of the data in the information_schema.columns table by SELECTing all the columns within it.