Home About Courses Schedule Services Webinars Contact Search

SQL Server SQL Essentials

SEE SCHEDULE

Duration: 3 Days

Method: Instructor led, Hands-on workshops

Price: $1800.00

Course Code: SS1003



Audience

Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in SQL Server.

Description

Come prepared to master Structured Query Language (SQL) as used on the Microsoft SQL Server platform in this fast paced and hands on course. The course begins with a discussion of relational database concepts and terminology. A review of normalization design and table creates takes place and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. All topics have a slant on performance, and each topic is reinforced with hands-on workshops. Microsoft SQL Server Management Studio 2017 is used for all workshops. Students will come away from this class with a clear understanding of the SQL Server relational database and SQL programming and ready to be productive.

Objectives

Upon successful completion of this course, the student will be able to:

  • Write good efficient SQL code to retrieve data
  • Understand database design, integrity, and data manipulation
  • Translate and code business problems in SQL
  • Understand SQL Joins and table relationships
  • Understand indexable vs non-indexable predicates
  • Understand the role of the optimizer and the approaches to access path selection

Prerequisites

None

Topics

  1. Relational Database Concepts
    • The Relational Model
    • Relational Terminology
    • Normalization
    • Table Relationships (PKs and FKs)
    • Intro to SQL and Transact-SQL
    • Table Creates
    • The SQL Server Optimizer
  2. Basic Data Retrieval
    • SELECT Statement
    • Using SELECT
    • Projecting Columns Onto the Result
    • Basic Predicates
    • Expressions in the SELECT Clause
    • Expressions in the WHERE clause
  3. Intermediate Data Manipulation
    • Compound Conditions
    • Other WHERE Clause Operators
      • BETWEEN
      • IN
      • LIKE
      • IS NULL
    • Using DISTINCT
    • ORDER BY Clause
  4. Built-in Functions
    • Working with Datatypes and Casting
    • Functions Involving NULLs
    • CASE Statements
  5. Aggregation
    • SUM, AVG, MIN, MAX & COUNT Functions
    • Grouping Results with GROUP BY
    • Filtering Groups with HAVING
  6. Joins
    • Inner Equi-Join
    • Join Classification
    • Cartesian Products
    • Inner Joins of More than 2 Tables
  7. Data Modification
    • INSERT
    • UPDATE
    • DELETE
    • COMMIT and ROLLBACK