My Shopping Cart
There are no items in your shopping cart.

Retrieving Data From Database Using SQL Language Queries With Inner Joins For Excel And Reports (SQLO40C)

Presented by: Joel Rosenblum
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
60 minutes
Event Description

Learn How To Create SQL Queries And Statements

The data you need to import into an Excel Worksheet is often found in a database such as Microsoft Access, SQL Server, Oracle MySQL or Database. How do you import that data into Excel and create a business friendly meaningful report?

Typically, the data that you need is scattered in multiple tables, and requires that you develop a SQL language query, or SELECT statement, to retrieve it. This webinar by Joel Rosenblum will help you learn how to create a SQL query and retrieve the data using a SELECT statement with an inner join. An inner join is similar in concept to an Excel VLOOKUP function, but is created using the SQL language SELECT statement.

In this program, you will learn:

  • How relational databases are structured and where to find the data you need
  • How to connect to the external data source in Excel
  • How a SQL query, or SELECT statement, simplifies your work
  • How do you build a basic SELECT statement and filter it with a WHERE clause
  • How to build the SQL query using INNER JOINS and use external data found in the database fields in Excel and reports
  • Relate tables together without using VLOOKUPs and select the fields you need from all the tables together in one field list
  • How you can add additional calculated columns or tables of data from other sources, and blend the data together to create Data Mashups or Business Intelligence Reports

Who should attend

  • Business analysts
  • Data analysts
  • Report writers
  • Excel power users
  • Database analysts
  • Excel data analysts
About Our Speaker(s)

Joel Rosenblum, Excel Advanced Tutorial ExpertJoel Rosenblum
Joel Rosenblum is a Principal Consultant with Techinsight, based in Denver, Colorado. He is a well-respected speaker, trainer and consultant with over 25 years’ real-world experience which includes many Microsoft and Oracle desktop and server products. With a Master’s degree in Engineering, Joel has de... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Retrieving Data From Database Using SQL Language Queries With Inner Joins For Excel And Reports
    Presenter(s): Joel Rosenblum

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team