Lecture 01 (Tuesday, March 28): Orientation and Introduction to the Courses, What is a Relational Database, Database Development Lifecycle
Lecture 02 (Thursday, March 30): SQL Basics, SELECT, FROM, WHERE
Lecture 03 (Tuesday, April 4): SQL Sorting, Aggregates, Joining Tables, Data vs Information
Lecture 04 (Thursday, April 6): Relationships, Assignment 1 Workday
  • Classroom Slides
  • In-Class Exercises
    • BIT 275 NO ICE - Assignment 1 Workday
Lecture 05 (Tuesday, April 11): ASSIGNMENT 1 DUE, Transactions and the ACID Test, DML, DDL, Normalization
Lecture 06 (Thursday, April 13): Indexes, Creating Aliases (AS keyword), Distinct, Distinct with Aggregate
Lecture 07 (Tuesday, April 18): Conflicts and Isolation
Lecture 08 (Thursday, April 20): Patterns, Order of Evaluation, Concatenation, Substrings, Trim, Position
Lecture 09 (Tuesday, April 25): CASE, ORDER BY, GROUP BY, HAVING, Subqueries
Lecture 10 (Thursday, April 27): MID-TERM EXAM
Lecture 11 (Thursday, May 4): Set Operations, More Subqueries, Views, Assignment 2 Workday
  • Classroom Slides
  • SQL Server 2012 Assorted Files
    • Link to install SQL Server Express 2014 (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 9): ASSIGNMENT 2 DUE, Intro to SSQL Server, SSMS
  • 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
    • VIDEO: SQL Server for Beginners (Udemy, Free)
    • SQL Subquery: StudentTest.sql.txt (from Lecture 11 Slide Example)
  • In-Class Exercises
  • Solutions: No Solutions Available for ICE 12
Lecture 13 (Thursday, May 11): Microsoft Azure (Reference Only), Virtual Server, SQL Server in the Cloud
Lecture 14 (Tuesday, May 16): Introduction to Stored Procedures
Lecture 15 (Thursday, May 18):Another Look at Stored Procedures (SQL Server), Intro to Visual Studio, User-Defined Functions
Lecture 16 (Tuesday, May 23): More Store Procedures and Functions Revisited, Intro to Transactions, Security Permissions
Lecture 18 (Tuesday, May 30): ASSIGNMENT 3 Workday; More Visual Studio (Optional)
Lecture 19 (Thursday, June 1): Assignment 3 Work Day
Lecture 20 (Tuesday, June 6): ASSIGNMENT 3 DUE, Database Presentation (PowerPoint or PDF)
Lecture 21 (Thursday, June 8): FINAL EXAM
top