Consulting Training Blog Careers About Us Contact Us

Querying and Processing SQL Server Data with SQL Statements Training

Course ID: ATL-2778
Duration: 2 Days

Upcoming Classes

Sorry, nothing scheduled right now. Click the Get Notified button below to be alerted when a class is scheduled.

Get Notified

On Site/Private

Can't find a class that fits right for you? Contact us to inquire about scheduling your own private class

Contact Us

Description

This two-day, hands-on course covers everything database administrators and developers need to know to query SQL Server databases using SELECT statements ranging from simple to complex, and use INSERT, UPDATE and DELETE statements to modify and maintain data. Creating and using of VIEWS is also covered, along with accessing data through stored procedures and user-defined functions.

Bring This Course To You

For groups of 5 or more, let Intertech bring this course to your location. Customized versions tailored towards your objectives are also available.

Learn More

Audience

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Course Outline

1. Tools and Techniques

  • Motivation
  • Tools
  • Connection Settings

2. Basic SELECT Queries

  • SELECT as Foundation
  • WHERE
  • ORDER BY
  • Delimiters and Symbols
  • Working with NULL
  • Multi-Part Names

3. Expressions

  • What Are Expressions
  • Data Types
  • Working with Character Strings
  • Working with Dates
  • The CASE Operator

4. JOIN and UNION

  • What is a Join?
  • Equi-Joins
  • Primary and Foreign Keys
  • Multiple Table Joins
  • Left and Right Outer Joins
  • Self-Joins
  • UNION
  • EXCEPT and INTERSECT

5. Updating

  • Experimenting?Do No Damage!
  • INSERT
  • UPDATE
  • DELETE
  • Updating over JOIN

6. Aggregations

  • Scaler Aggregates
  • Vector Aggregates (GROUP BY and HAVING)
  • COMPLETE, ROLLUP and CUBE

7. Advanced Queries

  • The Singleton
  • Sub-Queries with the IN Function
  • The EXISTS Operator

8. Working with Views

  • Nature and Purpose of Views
  • Creating and Modifying Views
  • Using Views
  • Updating Views

9. Import Export with SSMS

  • The Import Wizard
  • Working with Excel
  • The Export Wizard
  • SQL Server Integration Services (SSIS)

Free Resources from Intertech

Free On-Demand Videos: SSRS Report Builder Tips

Free eBook: Multidimensional Expressions (MDX)

Free Guide: Tips For A Virtual Development Environment

X