Microsoft, Cisco, VMWare, CompTIA, and Technical Courses

SQL Server I
Two Days - Instructor-led

This is the first course in a five part SQL development series.

Prerequisites

Before attending this course, students must have taken the SQL Fundamentals course or have the equivalent skills and knowledge.

Course Outline

Basic Queries

  • Single Table Queries
  • Criteria

Viewing Combined Information

  • Inner Joins
  • Outer Joins

Query Strategies

  • Table Aliasing
  • Cross Joins
  • Unmatched Records Query

Data Definition Language

  • Creating Databases
  • Creating Tables

Data Manipulation Language

  • Inserting Data
  • Updating Data
  • Deleting Data
  • Using Scripts

Maintaining Tables

  • Altering Tables
  • Using Bulk Copy Program

Stored Procedures

  • Creating Stored Procedures
  • Using Variables
  • Stored Procedure Parameters

Transaction Control Language

  • Explicit Transactions
  • Table Hints

Data Control Language

  • SQL Logins
  • Granting Permission
  • Revoking and Denying Permission