Welcome to ecourse.org: the Information Infrastructure for Education in the information age! This system allows instructors from any school or college (including home schools and training programs) to teach either onsite or online courses . It allows students to manage all their ongoing school works and past academic records at one location.
Our mission is to redefine the model of learning and re-engineer its process by providing innovative administrative and instructional technologies. Click here for our beliefs.
What is your opinion?
Could another species someday replace us as Earth's dominant intelligent life and, if so, which species?
(Oracle Client Setup and Account Admin) (by Liping Liu) Oracle Data Access Component for Database Programming
If you need to connect to Oracle in Visual Studio to program Oracle databases, you just need to download Oracle... more >>
(641 Week 7 Outline) (by Liping Liu) Warm-Up Queries:
Find the employment year of each employee
Find the departments in Dallas
Find the salesmen who were hired after 1980
--Find menagers whose name ends with M
select enamefrom empwhere job = 'MANAGER' and ename like '%M';
--Give salesman 100 commission
update empset comm = comm + 100where job = 'SALESMAN';
--handle missing values
upate empset comm = 0where comm is null;
select 12*sal + commfrom empgroup by empno;
--use nvl(comm, 0)
update empset comm = nvl(comm, 0) + 100where job = 'SALESMAN';
Lecture 1: Intermediate SQL Programming: Join is to merge two table so that the result will have all the columns and rows from both tables; matching records from the two tables are merged into one record in the pool, but the non-matching records are added to the pool with missing values for the columns of the other table... more >>
This system is designed and developed by Professor Liping Liu with financial support from Southern Illinois University at Carbondale. It evolved from a prior version called CourseWeb (for courses prior to Year 2000) and UXTEND.COM and www.e-course.org.
