"Information Technology Excellence"
Phone: (310) 317-8704
6 January 2009
Home | Company Profile | Areas Of Specialization | Feedback | E-mail Us
UCLA Student Material
Introduction to Microsoft SQL Server 2000: Hands-On (Part 1)
Architecture, Installation, and Implementation (X418.69)

Course Description, General Administration,
Required Textbook, Optional Reading, and Grading System
Course Syllabus
 REQUIRED READING PRIOR TO FIRST CLASS MEETING 
Chapters 1, 3, 4, 7, 11
Class #1 Lab Assignment Class #4 Lab Assignment
Class #1 Homework Class #4 Homework
Class #2 Lab Assignment Class #5 Lab Assignment
Class #2 Homework Class #5 Homework
Class #3 Lab Assignment Class #6 Lab Assignment
Class #3 Homework Class #6 Homework
SQL Server Suggested Naming Standards
 Download createdb.exe (SELF-EXTRACTING ZIP FILE)

This self-extracting ZIP file, when executed, will unzip a single T-SQL script called "construction.sql." This contains all the needed T-SQL DDL statements to drop and recreate the construction sample database tables and indexes.
 Download usp_load.exe (SELF-EXTRACTING ZIP FILE)

This self-extracting ZIP file, when executed, will unzip a single T-SQL script called "usp_load_construction.sql." This contains the needed T-SQL statements to create the usp_load_construction stored procedure.
 Download p1_lab4.exe (SELF-EXTRACTING ZIP FILE)

This self-extracting ZIP file, when executed, will unzip six (6) T-SQL scripts. These six scripts contain the T-SQL batches you were asked to develop for lab #4.

Introduction to Microsoft SQL Server 2000: Hands-On (Part 2)
System Administration and Support (X418.68A)

Course Description, General Administration,
Required Textbook, Optional Reading, and Grading System
Course Syllabus
Class #1 Lab Assignment Class #4 Lab Assignment
Class #1 Homework Class #4 Homework
Class #2 Lab Assignment Class #5 Lab Assignment
Class #2 Homework Class #5 Homework
Class #3 Lab Assignment Class #6 Lab Assignment
Class #3 Homework -
SQL Server Suggested Naming Standards
 Download usp_SplitString.exe (SELF-EXTRACTING ZIP FILE)

This self-extracting ZIP file, when executed, will unzip a single T-SQL script. This contains the code you were asked to develop for homework #6 from part 1.
 Download claim_database_scripts.exe (SELF-EXTRACTING ZIP FILE)

This self-extracting ZIP file, when executed, will unzip 5 T-SQL scripts. Four of the five scripts will create stored procedures to load the claim database tables. The fifth is for creating the database (and it's tables), and should be executed first. Review the T-SQL code once you have extracted the scripts for details (see my comments in the code).
Download lab5_queries.exe (SELF-EXTRACTING ZIP FILE)

This self-extracting ZIP file, when executed, will unzip 3 T-SQL scripts. These are the 3 T-SQL scripts needed for the first part of lab 5. They provide the queries to run so you can view the execution plans generated using Query Analyzer.

Building ASP.NET Applications And Web Services (Part 1)

General Administration, Required Textbook, and Grading System
Course Syllabus
 SUGGESTED READING PRIOR TO FIRST CLASS MEETING 
Please review the syllabus for details.
Class #1 Lab Assignment Class #4 Lab Assignment
Class #2 Lab Assignment Class #5 Lab Assignment
Class #3 Lab Assignment Class #6 Lab Assignment

-
Download VB.NET Sample Code Download C#.NET Sample Code
 Download Lab #2 Files (ZIP File)  Download Lab #2 Files (ZIP File)
 Download Lab #3 Files (ZIP File)  Download Lab #3 Files (ZIP File)
 Download Lab #4 Files (ZIP File)  Download Lab #4 Files (ZIP File)
 Download Lab #5 Files (ZIP File)  Download Lab #5 Files (ZIP File)
 Download Lab #6 Files (ZIP File)  Download Lab #6 Files (ZIP File)
  The Microsoft ASP.NET Roadmap

Building ASP.NET Applications And Web Services (Part 2)

General Administration, Required Textbook, and Grading System
Course Syllabus
 SUGGESTED READING PRIOR TO FIRST CLASS MEETING 
Please review the syllabus for details.
Class #1 Lab Assignment Class #4 Lab Assignment
Class #2 Lab Assignment Class #5 Lab Assignment
Class #3 Lab Assignment Class #6 Lab Assignment

-
Download VB.NET Sample Code Download C#.NET Sample Code
Download Lab #1 Files (ZIP File) Download Lab #1 Files (ZIP File)

NOTE: Lab #2 involved working with the web.config files of multiple sub-webs (configuration). The work for this lab involved the XML tags in each of the web.config files, and almost no ASP.NET page code. Because of this there is no real value to having two versions (C# and VB) of the lab files. The self-extracting file contains the sample index pages for all sub-webs using C# as the coding language.

 Download Lab #2 Files (ZIP File)
 Download Lab #3 Files (ZIP File)  Download Lab #3 Files (ZIP File)
 Download Lab #4 Files (ZIP File)  Download Lab #4 Files (ZIP File)
 Download Lab #5 Files (ZIP File)  Download Lab #5 Files (ZIP File)
 Download Lab #6 Files (ZIP File)  Download Lab #6 Files (ZIP File)

Object Oriented Programming Fundamentals For The Microsoft .NET Framework (Part 1)

General Administration, Required Textbook, and Grading System
Course Syllabus
 SUGGESTED READING PRIOR TO FIRST CLASS MEETING 
Please review the syllabus for details.
Class #1 Lab Assignment Class #4 Lab Assignment
Class #1 Homework Class #4 Homework
Class #2 Lab Assignment Class #5 Lab Assignment
Class #2 Homework Class #5 Homework
Class #3 Lab Assignment Class #6 Lab Assignment
Class #3 Homework  

  Need to convert Visual Studio 2003 projects to Visual Studio 2002?
Check out this utility that does exactly that.
Here is the link to get more info along with the actual source code or just the utility itself.
http://www.codeproject.com/macro/vsconvert.asp
Download VB.NET Sample Code Download C#.NET Sample Code
Download Lab #1 Files (ZIP File) Download Lab #1 Files (ZIP File)
 Download Lab #2 Files (ZIP File)  Download Lab #2 Files (ZIP File)
 Download Lab #3 Files (ZIP File)  Download Lab #3 Files (ZIP File)
 Download Lab #4 Files (ZIP File)  Download Lab #4 Files (ZIP File)
 Download Lab #5 Files (ZIP File)  Download Lab #5 Files (ZIP File)
 Download Lab #6 Files (ZIP File)  Download Lab #6 Files (ZIP File)

Object Oriented Programming Fundamentals For The Microsoft .NET Framework (Part 2)

General Administration, Required Textbook, and Grading System
Course Syllabus
 SUGGESTED READING PRIOR TO FIRST CLASS MEETING 
Please review the syllabus for details.
Class #1 Lab Assignment Class #4 Lab Assignment
Class #2 Lab Assignment Class #5 Lab Assignment
Class #3 Lab Assignment Class #6 Lab Assignment

-
Download VB.NET Sample Code Download C#.NET Sample Code
Download Lab #1 Files (ZIP File) Download Lab #1 Files (ZIP File)
 Download Lab #2 Files (ZIP File)  Download Lab #2 Files (ZIP File)
 Download Lab #3 Files (ZIP File)  Download Lab #3 Files (ZIP File)
 Download Lab #4 Files (ZIP File)  Download Lab #4 Files (ZIP File)
 Download Lab #5 Files (ZIP File)  Download Lab #5 Files (ZIP File)
 Download Lab #6 Files (ZIP File)  Download Lab #6 Files (ZIP File)

© 2002 Right-Click Consulting, LLC. All rights reserved. Terms of use.