This guide is used to teach a graduate-level course at the University of Cincinnati and is for education purposes only. The course week-by-week curriculum and syllabus is listed below:
Current Course Syllabus
Week 1
Week 2
Week 3
Week 4
Week 5
A. SQL Server Setup
- Setting Up SQL Server on Local PC
This section is a step-by-step guide to installing SQL Server, setting up a local server instance, and installing the AdventureWorks databases. This option is appropriate if you own a Windows PC.
- Connecting to SQL Server on UC PC
This section is a step-by-step guide to setting up SQL Server on a UC computer. This option is appropriate if you are at a UC lab or connect to a Virtual Lab. This option will also work on your own PC.
- UC Virtual Desktop AdventureWorks Setup Step-by-Step Video
This is a video to install the AdventureWorks Database on a UC virtual desktop. This is the fastest and easiest way I know so far.
B. Intro to SQL
This section is a very high-level overview of SQL. This content is covered during Week 1.
This section introduces the fundamentals of the SQL query. This content is covered during Week 2.
This section introduces the various data types in T-SQL, including number, character, and date types. This section also introduces functions that are useful for working with data. This content is covered during Week 3.
This section introduces operators in T-SQL, including mathematic, comparison, and logic operators. This content is covered during Week 3.
This SQL file teaches the basics of the
CASE
expression. This content is covered during Week 4.
G. UNION
This SQL file teaches the basics of the
UNION
in T-SQL, which joins rows from two or more queries for the same fields. This content is covered during Week 4.
H. JOIN
This SQL file teaches the basics of the
JOIN
in T-SQL, which joins fields from two or more tables for the same primary key (such as an account number). This content is covered during Week 4.
This SQL file demonstrates what a
JOIN
will return when duplicate primary keys exist in one or more of the tables.
This SQL file introduces the concept of nested
SELECT
, which allows you to create queries within queries.
This SQL file demonstrates how to create and manipulate tables in T-SQL, including the very useful temporary, or "temp," table.
L. Importing Excel and Flat-file Data into SQL
- You need to determine whether office is 32-bit or 64-bit. Click here for YouTube video.
- Click here for YouTube video on importing an Excel Workbook.
- Click here for YouTube video on importing via a .CSV or tab-delimited .TXT file.
M. SQL and R
N. SQL and Excel Power Pivot
The YouTube video is here.
O. SQL and Tableau