Consulting Training Blog Careers About Us Contact Us
All Classes Will Be Held Virtually – Live Online Intertech's Training Division has been successfully instructing professionals through virtual live online training since the advent of the smartboard. It is a proven form and offers the convenience of live questions, group interaction, and labs with an instructor looking over your shoulder. Because of this, we will continue all classes live but virtually, including Agile and Scrum instruction, so businesses and individual’s seeking professional development can keep moving forward during these unexpected times.

Querying and Processing SQL Server Data with SQL Statements Training

Course ID: ATL-2778
Duration: 2 Days

Upcoming Classes

Click the Get Notified button for priority notification when a class is next 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

2 Free Resources: Missed Issues in Software Estimation and Stakeholder Questionnaire

Free Tutorial: Writing Transact-SQL Statements

X