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:
Who should attend
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