Course Description
Short Course | 18 hours | 1.8 CEUs | $1,695
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.
SQL100 is taken as part of the Data Analyst I Professional Certificate. To complete the certificate students will also enroll in BID615, TAB100, & PYT100. Click on each course link for more details and to add to cart.
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
- Creating Tables
Additional Information
This 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
- Data Analyst I Professional Certificate : Required
*Academic Unit eligibility to be determined by college/university in which you are enrolled in a degree seeking program.