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-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Thu, October 23, 2014
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:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Retrieving Data From Database Using SQL Language Queries With Inner Joins For Excel And Reports
    Presenter(s): Joel Rosenblum

 
DMCA.com Protection Status