sql-uc-fall2019

Week 1

Intro

1. Course Introduction

   • Syllabus
   • Blackboard
   • About Me
   • About You

2. GitHub Introduction

Set-up SQL Server Management Studio (SSMS)

1. AdventureWorks Setup
2. Intro to Object Explorer, Connections, etc.

3. View your first query and table with Right Click -> Select Top 1000 Rows.

   • Records vs. Fields.

Break

The SQL Query

1. Lectures

   • Intro to SQL (intro-to-sql.pptx)
   • Intro to the SQL Query (intro-to-the-query.pptx)

2. SQL Practice

   • SELECT clause intro (select-clause.sql)