Questions? Feedback? powered by Olark live chat software

Class Schedule

Vendor

Certification/Course

Location

Schedules

Schedules

SELECT RAW.CourseSID, RAW.CourseName, RAW.CourseID, RAW.CourseTrainingTypeID, RAW.CourseStartDate, RAW.CourseEndDate, RAW.CourseGuaranteedToRun, RAW.CourseTimeZone, CSDD.StartTime, CSDD.EndTime, VEND.VendorID, VEND.VendorDescription AS VendorName, CP.ClassSection, CP.LocationName, CP.LocationCode, CP.ListPriceInclusive, dbo.CourseLOTDelivery(RAW.CourseID) AS LOT, dbo.IsCourseScheduleByDeliveryPartner(RAW.CourseSID) AS DeliveryPartner FROM ( SELECT iRPSD.CourseSID, iRPSD.CourseName, iRPSD.CourseID, iRPSD.CourseTrainingTypeID, iRPSD.CourseStartDate, iRPSD.CourseEndDate, iRPSD.CourseGuaranteedToRun, iRPSD.CourseTimeZone FROM wwwRawPackageScheduleData iRPSD INNER JOIN ( /* begin MAGIC */ SELECT TOP (30) ONE.CourseSID, ONE.CourseStartDate FROM ( SELECT TOP (58 * 30) * FROM ( SELECT bqRPSD.CourseSID, bqRPSD.CourseStartDate FROM wwwRawPackageScheduleData bqRPSD INNER JOIN ( SELECT sid FROM wwwCoursePrice WHERE ( ISNULL(ListPriceInclusive, 0) > 0 ) GROUP BY sid ) bqCP ON bqCP.sid = bqRPSD.CourseSID /* place holder */ WHERE ( bqRPSD.CourseTrainingTypeID IN ('A','B','P') ) AND ( bqRPSD.CourseStartDate > GETDATE() ) AND ( 1 = 1 /* place holder*/ ) ) AS BQ ORDER BY CourseStartDate ) AS ONE ORDER BY CourseStartDate DESC /* end MAGIC */ ) AS iTWO ON iTWO.CourseSID = iRPSD.CourseSID ) RAW INNER JOIN ( SELECT CourseSID, MIN(StartTime) AS StartTime, MAX(EndTime) AS EndTime FROM wwwStaticCourseScheduleDailyDetails GROUP BY CourseSID ) CSDD ON CSDD.CourseSID = RAW.CourseSID INNER JOIN ( SELECT CourseID, VendorID, VendorDescription FROM vwCourseVendorMap ) VEND ON VEND.CourseID = RAW.COURSEID INNER JOIN wwwCoursePrice CP ON CP.sid = RAW.CourseSID ORDER BY RAW.CourseStartDate, RAW.CourseName
 « Previous   1   2   3  . . .  56   57   58   59   60   61   62   63   Next » 
DATE(S) VENDOR COURSE TIMES PRICE LOCATION ENROLL
Nov 26, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm EST $2,945 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm CST $2,945 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm EST $2,945 New York City, NY (or Attend Online) Enroll »
Nov 26, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm EST $2,945 Washington, DC (20006) (or Attend Online) Enroll »
Nov 26, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm EST $2,945 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm EST $2,945 New York City, NY (or Attend Online) Enroll »
Nov 26, 2018Nov 29, 2018
Microsoft - Technical 9:00am – 5:00pm CST $2,150 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm EST $2,945 New York City, NY (or Attend Online) Enroll »
Nov 26, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm CST $2,945 Online Class Enroll »
Nov 26, 2018Nov 28, 2018
Microsoft - Application 9:00am – 5:00pm EST $1,767 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Microsoft Dynamics 8:00am – 6:00pm CST $2,699 Online Class Enroll »
Nov 26, 2018Nov 29, 2018
Autodesk 9:00am – 5:00pm CST $1,999 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Cisco 9:00am – 5:00pm EST $4,395 Online Class Enroll »
Nov 26, 2018Nov 28, 2018
Cisco 9:00am – 5:00pm CST $2,695 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Cisco 9:00am – 5:00pm CST $3,795 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Cisco 9:00am – 5:00pm CST $3,295 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Cisco 9:00am – 5:00pm CST $3,795 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
Cisco 9:00am – 5:00pm CST $3,795 Online Class Enroll »
Nov 26, 2018Nov 27, 2018
Google 9:00am – 5:00pm EST $999 Online Class Enroll »
Nov 26, 2018Nov 30, 2018
ISACA 9:00am – 5:00pm CST $4,495 Online Class Enroll »
Nov 26, 2018Nov 28, 2018
ITIL 9:00am – 5:00pm CST $1,995 Online Class Enroll »
Nov 26, 2018Dec 01, 2018
Oracle 8:00am – 6:00pm CST $4,199 Online Class Enroll »
Nov 27, 2018Nov 29, 2018
Microsoft - Technical 8:00am – 6:00pm PST $2,800 Las Vegas, NV (or Attend Online) Enroll »
Nov 27, 2018Nov 29, 2018
Cisco 9:00am – 5:00pm CST $3,895 Online Class Enroll »
Nov 28, 2018Nov 30, 2018
Google 9:00am – 5:00pm EST $1,499 Online Class Enroll »
Nov 28, 2018Nov 30, 2018
Cisco 9:00am – 5:00pm CST $3,695 Online Class Enroll »
Nov 29, 2018Nov 30, 2018
Microsoft - Technical 9:00am – 5:00pm EST $1,178 Online Class Enroll »
Nov 29, 2018Nov 30, 2018
Adobe 10:00am – 6:00pm EST $1,195 Online Class Enroll »
Nov 29, 2018Nov 30, 2018
Adobe 10:00am – 6:00pm EST $1,195 Online Class Enroll »
Nov 29, 2018Nov 30, 2018
Cisco 9:00am – 5:00pm CST $1,995 Online Class Enroll »
 « Previous   1   2   3  . . .  56   57   58   59   60   61   62   63   Next »