Introduction to relational databases and the Structured Query Language (SQL). Course uses SQL to create, manipulate, and query databases. Covers the fundamentals of a relational database, basic selection queries, sub-queries, multiple table queries, joins, aggregate calculations, updating data, SQL database administration, data definition and manipulation, views, sorting, triggers, constraints, indexes and basic introduction to PL/SQL.

Upon completion of this course, the student will be able to:

1. Summarize the fundamentals of relational database design.
2. Create, manipulate and query databases.
3. Explain complex Structured Query Language (SQL) queries, multi-table queries and joins.
4. Implement SQL fundamentals consisting of single table queries, sorting and updating data.
5. Explain database administration issues.
6. Analyze database indexes, triggers and constraints.
7. Use PL/SQL database routines.

1. Implement SQL fundamentals consisting of single table queries, sorting and updating data.
2. Analyze database indexes, triggers and constraints.
3. Create, manipulate and query databases..

This is a ZTC (Zero Textbook Cost) class which has not textbook of software costs. Canvas has full set of videos/webcast and you have access to muliple web-based database using the open source standard interface PHPMyAdmin.

Course grades this is a tuition-free noncredit class, grades are not assigned. All assignments and quizzes will be available the entire course, however to master advance concepts such as SQL, you have to work at a steady pace and perfect beginning skills before attempting intermediate tasks. Both submit and canvas will list point values, if you wish I can calculate a grade for you. Academic Integrity is critical at this college. Failure to abide by academic integrity can result in a failing grade. For information on academic integrity consult UCSD Professor Elkan's detailed description. and CIM site policy. All students are required to have their Saddleback E-mail forwarded to an account that they frequently use. When sending me e-mails, make sure you include MySQL or CIS 405 in the subject line.

It is the student's responsibility to officially withdraw (drop) from the class through Admission and Records or MySite. However, Instructor may drop, "No-Show" students under any of the following conditions:

1. Students who have not completed at least 1 assignments two days before the drop without W grade.
2. By the last date to add with APC code, you must login to canvas, complete the orientation quiz and any corresponding assignment.
3. Students who have been emailed a drop warning and don't attempt the stated work.
4. Students who have not completed at least 50% of the work  by two days before the drop with W grade.
5. When in-class sessions are present, students who miss 2 or more class sessions

Consult current schedule for exact dates.

Sometimes you get a grade that you don't like, usually for one of the following reasons:

1. There was a clerical error  (i.e., the points were added up wrong).
2. You think you did something right, and I think you did it wrong.

If you discover a clerical error, tell me immediately. The following Statute of Limitations will apply: You have one week from the day any graded assignment or test is returned to you to appeal the grade you received. After one week, I will assume that you believe the grade you got is the correct one. After one week, grades are unchangeable, fixed, and permanent

Students with disabilities are entitled to appropriate accommodations.  This course meets the requirements set forth in the accessibility checklist and universal design grid provided by Special Services. The Web pages, video presentations, textbooks and class materials used in this course are accessible to students with disabilities. If you have specific disabilities requiring accommodations, let your instructor know the first 10 days of the semester so that your learning needs may be met and for referral to the Special Services office where documentation of your disability will be provided to receive services and accommodations.  The Special Services Office is in Student Services Center, Room 113.

Student Services - General student service information is available at the Saddleback College Website. General, academic and service information can be obtained by accessing the Counseling Division and Financial Web sites. Individual and small group counseling information such as academic planning and review of transcripts is available by appointment. All other student services are available on campus during normal business hours.

This is an on on-line - distance educational course.

The weekly Canvas announcement will concisely summarize what you need to complete each week. The assignment page provides a detailed course guide. Work on all assignments one at a time, in the order they are listed. At the start of the course both an assignment page link and the weekly welcome announcement will be sent to your Saddleback e-mail address. For a due date summary of the entire course consult the schedule.

Regular effective contact between the Professor and student is required for success. This class we will have weekly videos, web-casts and frequent emails (several per week), will post threaded discussion on important e-mails. In the past students seem to prefer the email communication over discussion board. The assignment page is very detailed on purpose it specifically address many of the questions raised in the past. When required actual phone calls will be made. Note both the IMC lab bgs248 and instructor offer in-person help. In addition to in-person help we have 24/7 access to web-casting software. With web-casting software instructor/student can share screen and provides VOIP (Voice over IP - Internet) interactive connections.

For additional help: Canvas, login and/or general.

Complete class by following canvas modules, first module is labeled read me first. Assignment page is your detailed course code, work on it top down. Try to maintain a steady pace through the class. You can repeat this course. Schedule gives you a quick one page view of the desired course requirement.

Netiquette is Internet manners, online etiquette, and digital etiquette all rolled into one word. Basically,netiquette is a set of rules for behaving properly online. Students are to comply with the following rules of netiquette: (1) identify yourself, (2) include a subject line, (3) avoid sarcasm, (4) respect others' opinions and privacy, (5) acknowledge and return messages promptly, (6) copy with caution, (7) do not send spam or junk mail, (8) be concise, (9) use appropriate language, (10) use appropriate emoticons (emotional icons) to help convey meaning, and (11) use appropriate intensifiers to help convey meaning [do not use ALL CAPS or multiple exclamation marks (!!!!)].

Other than Disabled Students Programs and Services (DSPS) directed auxiliary aids and academic accommodations, the use of any electronic listening or recording device in any classroom is prohibited without the explicit prior consent of the instructor (CA Ed Code Sec. 78907). It is in violation of South Orange County Community College District (SOCCCD) policies (BP 5401 & AR 5401) which address student conduct. It is also a crime to record any private communication, such as a classroom lecture, without the consent of all parties to the conversation (Cal. Penal Code § 632). Violation of such rules may result in disciplinary action.