Training in SQL Server Querying

Key Information

Course Learning Skills: SQL

Brief

Objectives

– This course will enable delegates to query a SQL Server 2016 database. This includes querying joined tables in Transact-SQL. The course will cover the structure of a SQL Server 2016 database. Delegates will be able to basic and advanced querying technique. They will also insert, update and delete data in tables.  They will cover the new features in SQL Server 2016 that are not available in SQL Server 2012.

Duration:

2 Days

Audience

This course is designed for those who are responsible for querying database objects and programming SQL Server databases by using Transact-SQL.

Prerequisites

An understanding of basic relational database concepts, including:

  • Logical and physical database design
  • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, many-to-many)
  • How data is stored in tables (rows and columns)

5 Top Takeaways from the Course

  1. Improve database design
  2. Improve query performance
  3. Create complex queries across multiple tables
  4. Transform raw data to meaningful information
  5. Program databases for resilience and growth

Module 1: SQL Server 2016 Overview

  1. SQL Server 2016 Components and Architecture
  2. SQL Server 2016 Developer Tools
  3. SQL Server 2016 Security Implementation

Module 2: Language Features

  1. SQL Server Programming Tools
  2. Elements of Transact-SQL
  3. SQL Server Object Names
  4. Additional Language Elements
  5. Local Variables
  6. Operators
  7. Functions
  8. Ways to Execute Transact-SQL Statements
  9. New Transact-SQL (T-SQL) Features in 2016

Module 3: Basic Query Techniques

  1. Using SELECT to retrieve rows and columns
  2. Grouping rows
  3. Retrieving Specific Rows of Data Using the WHERE Clause
  4. Filter Data by Using Logical Operators

Module 4: Advanced Query Techniques

  1. Using Aggregate Functions Native to SQL Server
  2. Sub Queries
  3. Creating Pivot Queries
  4. Writing and Reading XML

Module 5: Querying Multiple Tables

  1. Inner Joins
  2. Left Outer Join
  3. Right Outer Join
  4. Full Outer Join
  5. Cross Join

Module 6: Inserting Data into Tables

  1. Inserting a Single Row into a Table
  2. Inserting Multiple Rows into a Table
  3. Differentiating Various INSERT Statements
  4. Importing Data to Tables

Module 7: Updating Data in Tables

  1. Updating a Single Row into a Table
  2. Updating Multiple Rows into a Table
  3. Updating Rows Based on Data in Other Tables

Module 8: Deleting Data from Tables

  1. Deleting Rows from a Table
  2. Truncating a Table
  3. Deleting Rows Based on Data in Other Tables

 

Register your interest in a Talk-IT Course

Course Interest

Do a short survey to tell us what you think about training?

Click here to take the survey, it’ll only take a few minutes!

Scroll to Top