262362.pdf - Palm Beach State College Course Syllabus...

This preview shows page 1 - 4 out of 8 pages.

The preview shows page 2 - 4 out of 8 pages.
Palm Beach State CollegeCourse SyllabusGeneral Class and Course InformationCourse ID:COP2700Course Subject:COPCourse Number:2700Course Title:Introduction to Database (AA)Reference Number:262362Credits/ Clock Hours:3.00Term/Date:Fall 2019 ; 2019-08-22 - 2019-12-18Days:ONLINERoom:*** ***Course Description:This course provides students with a solid foundation in SQL,which provides a means for accessing and manipulating databases. Students will befamiliarized with the structure of databases and introduced to the relational databasemodel. Students will learn the fundamentals of the SQL language, including how tocreate and design tables, how to carry out queries, how to add and delete data from adatabase, how to create views, and how to handle security.Prerequisite/Corequisite:Prerequisite: COP1000 or CGS1543Instructor's InformationName:Uzma AmiruddinOffice Location:CRB 2201Telephone:(561) 993-1195Faculty Webpage:Email:[email protected]Information on REQUIRED textbooksOracle 12c: SQL978-1-305-25103-8Joan Casteel3rd EditionYour Campus bookstore offers a Price Match guarantee. If you find our class texts oraccess codes cheaper at Booksmart, Barnes & Noble, or Amazon the campus bookstorewill match the price at the time of purchase, or for up to 7 days after purchase. Searchyour course materials by the ISBN provided in this syllabus to assure that your pricematch is acceptable.Course Learning OutcomesCreate database objects including tables, views, and indexes.Define SQL and general applications.Differentiate between and use SQL statements to manage views.Explain the relation between SQL and database operations.Explain various database architectures.
Outline the various SQL commands.Use SQL statements to manage users and set data security.Use SQL statements to populate tables.Use various forms of the SELECT statement to query the database including FROM,WHERE, GROUP BY, and ORDER.Use various forms of the SELECT statement to update the database includingFROM, WHERE, GROUP BY, and ORDER.Assignments, Tests, Quizzes and Final Exam Schedule, withpercentage/points of gradeCOP2700 Course Tentative ScheduleDateChapterAssignmentDue Date22-AugOracle InstallationOracleInstallation08/28 @ 11:59PM29-AugCh 1Ch1-Exercises,Quiz09/04 @ 11:59PM5-SepCh 2Ch2-Exercises,Quiz09/11 @ 11:59PM12-SepCh 3Ch3-Exercises,Quiz09/[email protected] 11:59PM19-SepCh 4Ch4-Exercises,Quiz09/25 @ 11:59PM26-SepExam - 109/26 @ 11:59PM3-OctCh 5Ch5-Exercises,Quiz10/09 @ 11:59PM10-OctCh 6Ch6-Exercises,Quiz10/16 @ 11:59PM17-OctCh 7Ch7-Exercises,Quiz10/23 @ 11:59PM24-OctCh 8Ch8-Exercises,Quiz10/30 @ 11:59PM31-OctExam-210/31 @ 11:59PM7-NovCh 9Ch9-Exercises,Quiz11/13 @ 11:59PM14-NovCh 10Ch10-Exercises,Quiz11/[email protected] 11:59PM21-NovCh 11Ch11-Exercises,Quiz12/05 @ 11:59PM
28-NovThanksgivingHoliday5-DecCh 12Ch12-Exercises,Quiz12/11 @ 11:59PM12-DecExam-312/12 @ 11:59PMGradingCompositionAssignmentWeightQuizzes20%Assignments20%Exams60%Discussions10%GradingLetterGradeValueA100 - 90%B89 - 80%C79 - 70%D69 - 60%F59 - 0%Attendance Policy

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 8 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
MARTIN
Tags
Academia, Academic dishonesty, Palm Beach State College

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture