Course Outline
SQL Server Introduction
- Terminology
- What is SQL Server
SQL Server Management Studio
- How to Use 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 Clause
- 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
This course is delivered using SQL Server 2012.
Suggested Prerequisites
- There are no prerequisites for this course.
Questions? Speak with our team today—email info@workforcecenter.slu.edu or call 314-977-3226.
Certificate Pathway
Want to Earn the Data Analyst I Professional Certificate?
In addition to Introduction to SQL | SQL100, enroll in two of the following electives:
