Lecture 01 (Tuesday, March 27): Orientation and Introduction to the Courses, What is a Relational Database, Database Development Lifecycle
Lecture 02 (Thursday, March 29): SQL Basics, SELECT, FROM, WHERE
Lecture 03 (Tuesday, April 3): SQL Sorting, Aggregates, Joining Tables, Data vs Information
Lecture 04 (Thursday, April 5): Relationships, Assignment 1 Workday / ICE Make-Up Day
Lecture 05 (Tuesday, April 10): ASSIGNMENT 1 DUE, Transactions and the ACID Test, DML, DDL, Normalization
Lecture 06 (Thursday, April 12): Indexes, Creating Aliases (AS keyword), Distinct, Distinct with Aggregate
Lecture 07 (Tuesday, April 17): Conflicts and Isolation
Lecture 08 (Tuesday, April 24): Patterns, Order of Evaluation, Concatenation, Substrings, Trim, Position
Lecture 09 (Thursday, April 26): CASE, ORDER BY, GROUP BY, HAVING, Subqueries
Lecture 10 (Tuesday, May 1): MID-TERM EXAM
Lecture 11 (Thursday, May 3): Set Operations, More Subqueries, Views, Assignment 2 Workday
  • NO CLASS TODAY (May 3): INSTRUCTOR OUT SICK. REMINDER: ASSIGNMENT2 due on Tuesday, May 8, uploaded to Student Tracker by midnight.
  • Classroom Slides
  • SQL Server 2012 Assorted Files
    • Link to install SQL Server Express 2014(after selecting, on next page scroll down and select ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe)
    • INSTRUCTIONS FOR INSTALLING NORTHWIND DATABASE FROM AN SQL SCRIPT:
      • Download the instnwnd.sql.txt script (right-click on link and select Save Target As... or Save Link As...)

      Open it in Notepad or Notepad++ and do a select all (Ctrl + A) then copy (Ctrl + C)

      Start SQL Server from SQL Server Management Studio, and Connect button

      Click on New Query from the menu bar

      Paste the instnwnd.sql.txt script you previously copied (Ctrl + V)

      Click on Execute from the menu bar

      The Northwind database should now been added to the Databases folder in the left-hand column

      NOTE: FYI - The following lines (lines 24-26) have been commented out of the above script so it will work with newer versions of SQL Server:

      exec sp_dboption 'Northwind','trunc. log on chkpt.','true'
      exec sp_dboption 'Northwind','select into/bulkcopy','true'
      GO

  • In-Class Exercises
    • BIT 275 NO ICE (Assignment 2 Work Day)
Lecture 12 (Tuesday, May 8): ASSIGNMENT 2 DUE, Intro to SSQL Server, SSMS
  • REVIEW / INFO: MySQL/MariaDB Tutorial
  • Classroom Slides
  • SQL Server Assorted Files
    • INSTRUCTIONS FOR INSTALLING NORTHWIND DATABASE FROM AN SQL SCRIPT:
      • Download the instnwnd.sql.txt script (right-click on link and select Save Target As... or Save Link As...)
      • NOTE: In Programajama, download the northwind.zip file and extract the northwind database locally.
      • Open it in Notepad or Notepad++ and do a select all (Ctrl + A) then copy (Ctrl + C)
      • Start SQL Server from SQL Server Management Studio, and Connect button
      • Click on New Query from the menu bar
      • Paste the instnwnd.sql.txt script you previously copied (Ctrl + V)
      • Click on Execute from the menu bar
      • The Northwind database should now been added to the Databases folder in the left-hand column
    • NOTE: FYI - The following lines (lines 24-26) have been commented out of the
      above script so it will work with newer versions of SQL Server:

      exec sp_dboption 'Northwind','trunc. log on chkpt.','true'
      exec sp_dboption 'Northwind','select into/bulkcopy','true'
      GO
    • TUTORIAL: Microsoft SQL Server (Step-Through, from Tutorialspoint)
    • SQL Subquery: StudentTest.sql.txt (from Lecture 11 Slide Example)
  • In-Class Exercises
  • Solutions: No Solutions Available for ICE 12
Lecture 13 (Thursday, May 10): Microsoft Azure (Reference Only), Virtual Server, SQL Server in the Cloud
Lecture 14 (Tuesday, May 15): Introduction to Stored Procedures
Lecture 15 (Thursday, May 17):Another Look at Stored Procedures (SQL Server), Brief Look at Try-Catch
Lecture 16 (Tuesday, May 22): More Store Procedures and Functions Revisited, Intro to Transactions, Security Permissions
  • Classroom Slides
  • Examples Files
  • In-Class Exercises
    • BIT 275 ICE Make-Up Day (to be used to work on ICEs you have not yet completed)
    • NEXT ICE: You will create a small MUSIC COLLECTION database in SQL Server from scratch with auto-incrementing Primary Keys and Foreign Keys.
Lecture 18 (Tuesday, May 29): ASSIGNMENT 3 Workday; JUST FOR FUN: More Visual Studio (Optional)
Lecture 19 (Thursday, May 31): Assignment 3 Work Day
Lecture 20 (Tuesday, June 5): ASSIGNMENT 3 DUE, Database Presentation (PowerPoint or PDF)
Lecture 21 (Thursday, June 7): FINAL EXAM
top