Aqua Data Studio

Building SQL Server Queries and Working with Data

One of the most important parts of SQL Server is being able to use the data as well as using the functionality that SQL Server offers to query data and get your questions answered. It may be the data already exists in the database and you want to know tips and tricks to manipulate the data or you may just want to know how to write better queries to make things run faster. In addition, sometimes you need to import or export data to add additional supporting data or provide the results in Excel or some other format.

In this webinar we will cover the following topics:

  • Tips and tricks for writing better queries

  • Using subqueries effectively

  • Using temporary tables and CTEs

  • Understanding when and how indexes are used

  • Grouping and rolling up data

  • Union, Intersect, Except and Merge queries

  • How to check for query improvements using execution plans and IO and Time statistics

  • Overview of ways you can import and export data

Speaker: Eric Blinn has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.

Webcast Form

  • You can always update your communications preferences later.
    AquaFold may share your information with its subsidiaries and its partners. For further details on how your data is used and stored, please review our Privacy Policy
  • Note: By registering, you confirm that you agree to the processing of your personal data by AquaFold, Inc. - AquaFold as described in the Privacy Statement. AquaFold, Inc. - AquaFold is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.