Loading...

Course Description

In this course students learn to use Management Studio and build basic and advanced Structured Query Language (SQL) statements to retrieve and update data in a database. Topics include how to use Management Studio, retrieving data from one or more tables, Joins, Subqueries, Insert, Update and Delete, Data Types, and SQL Server Functions.  SQL DDL commands for creating databases, tables, indexes and views are also covered. Special emphasis is given to Functions, Joins, and Subqueries. Management Studio and its capabilities and tools are also explored. 

Course Outline

  • SQL Server Introduction
    • Terminology
    • What is SQL Server
  • How to use the Management Studio
  • SQL Basics, retrieving data from one table
    • Basic SELECT Statements
    • SELECT list
    • FROM clause
    • WHERE clause
    • ORDER BY clause
  • Summary  Queries
    • GROUP BY and HAVING clause
  • Joins, retrieving data from two or more tables
  • Subqueries
  • Manipulating Data
    • Insert
    • Update
    • Delete
  • SQL Data Types
  • Functions
  • DDL Commands
    • Creating Tables
      • CREATE TABLE
      • Constraints
      • Indexes
      • ALTER TABLE
    • Creating Views

Additional Information

This 3-day/ 6-night hands-on course is delivered using SQL Server 2012.

Prerequisites

There are no prerequisites for this course.

Duration

18 Hours | 3 Days or 6 Nights

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Introduction to SQL
Type
Instructor-Led
Days
T, Th
Time (Central Time)
5:30PM to 8:30PM
Dates
Aug 16, 2022 to Sep 01, 2022
Schedule and Location
# of Course Hours
18.0
Delivery Option
Course Fee(s)
Rate non-credit $1,695.00
Potential Discount(s)
Section Title
Introduction to SQL
Type
Instructor-Led
Days
M, W
Time (Central Time)
5:30PM to 8:30PM
Dates
Oct 31, 2022 to Nov 16, 2022
Schedule and Location
# of Course Hours
18.0
Delivery Option
Course Fee(s)
Rate non-credit $1,695.00
Potential Discount(s)
Required fields are indicated by .
*Academic Unit eligibility to be determined by college/university in which you are enrolled in a degree seeking program.