{"@id":"https://credentialengineregistry.org/resources/ce-788f678c-e730-411f-a1bf-9b1c9f11cd96","@type":"ceterms:Certificate","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-788f678c-e730-411f-a1bf-9b1c9f11cd96","ceterms:name":{"en-US":"Oracle SQL and PL/SQL Developer"},"ceterms:ownedBy":["https://credentialengineregistry.org/resources/ce-644275b9-0d5b-4088-a46a-88ec3c7328e5"],"ceterms:requires":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Entry Conditions"},"ceterms:creditValue":[{"@type":"ceterms:ValueProfile","schema:value":120.0,"ceterms:creditUnitType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CreditUnit","ceterms:targetNode":"creditUnit:ContactHour","ceterms:frameworkName":{"en-US":"Credit Unit"},"ceterms:targetNodeName":{"en-US":"Contact Hour"},"ceterms:targetNodeDescription":{"en-US":"Credit that is issued or accepted as being related to one or more temporal hours of instruction presented to students."}}]}],"ceterms:description":{"en-US":"There are no prerequisites for this course; however, some prior programming language knowledge is helpful."}}],"ceterms:offeredBy":["https://credentialengineregistry.org/resources/ce-644275b9-0d5b-4088-a46a-88ec3c7328e5"],"ceterms:identifier":[{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"Program_System_ID"},"ceterms:identifierValueCode":"9640"},{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"1 - Adams County Workforce \u0026 Business Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"11 - Pueblo Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"1 - Adams County Workforce \u0026 Business Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"2 - Arapahoe/Douglas Works!"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"3 - Broomfield Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"4 - \"Denver Workforce Center - Office of Economic Development, Divison of Workforce Development\""},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"5 - Larimer County Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"6 - Employment Service-Weld County"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"7 - Jefferson County Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"8 - Workforce Boulder County"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"9 - Pikes Peak Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"10 - Mesa County Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"11 - Pueblo Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"12 - Mountain - Rural Resort"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"13 - Northwest Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"14 - Upper Arkansas Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"15 - Southwest Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"16 - Western Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"17 - Southeast Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"18 - Eastern Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"19 - Southcentral Region - Colorado Rural Workforce Consortium"}],"ceterms:inLanguage":["en"],"ceterms:availableAt":[{"@type":"ceterms:Place","ceterms:name":{"en-US":"Primary Address"},"ceterms:latitude":39.7179974,"ceterms:longitude":-104.8026662,"ceterms:postalCode":"80011","ceterms:addressRegion":{"en-US":"Colorado"},"ceterms:streetAddress":{"en-US":"16000 E CentreTech Parkway"},"ceterms:addressCountry":{"en-US":"United States"},"ceterms:addressLocality":{"en-US":"Aurora"}},{"@type":"ceterms:Place","ceterms:name":{"en-US":"Lowry Campus"},"ceterms:latitude":39.7274199,"ceterms:longitude":-104.8790752,"ceterms:postalCode":"80230","ceterms:addressRegion":{"en-US":"Colorado"},"ceterms:streetAddress":{"en-US":"710 Alton Way"},"ceterms:addressCountry":{"en-US":"United States"},"ceterms:addressLocality":{"en-US":"Denver"}}],"ceterms:description":{"en-US":"This online course will teach you how to use SQL to build applications or generate business reports and will help you master SQL using an Oracle database. You will also learn how to use the PL/SQL extension language to write sophisticated queries against an Oracle database.    This course will prepare you to enter the job market as an entry-level Oracle SQL Developer or take on more responsibility within your current career. Designed for those new to writing SQL queries, this course is perfect for those who love to learn and like working with data.    What you will learn    Build applications or generate business reports using Structured Query Language (SQL)  Master SQL using an Oracle database  Use PL/SQL extension language to write sophisticated queries against an Oracle database"},"ceterms:estimatedCost":[{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":995.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://www.ccaurora.edu","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:Tuition","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Tuition"},"ceterms:targetNodeDescription":{"en-US":"Cost for teaching and instruction."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":995.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://www.ccaurora.edu","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:AggregateCost","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Aggregate Cost"},"ceterms:targetNodeDescription":{"en-US":"Sum of direct costs."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":0.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://www.ccaurora.edu","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:ProgramSpecificFee","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Program Specific Fee"},"ceterms:targetNodeDescription":{"en-US":"Additional cost for participation with a specific program or course of study such as engineering, business, and nursing."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":0.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://www.ccaurora.edu","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:MixedFees","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Mixed Fees"},"ceterms:targetNodeDescription":{"en-US":"The sum of fees that are not identified individually."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":0.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://www.ccaurora.edu","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:LearningResource","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Learning Resource"},"ceterms:targetNodeDescription":{"en-US":"Cost for one or more learning resources."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":0.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://www.ccaurora.edu","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:OptionalCharges","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Optional Charges"},"ceterms:targetNodeDescription":{"en-US":"Cost for additional fees, other services, equipment, or facilities that are not required."}}}],"ceterms:occupationType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://www.onetcenter.org/taxonomy.html","ceterms:targetNode":"https://www.onetonline.org/link/summary/15-1141.00","ceterms:codedNotation":"15-1141.00","ceterms:frameworkName":{"en-US":"Standard Occupational Classification"},"ceterms:targetNodeName":{"en-US":"Database Administrators"},"ceterms:targetNodeDescription":{"en-US":"Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases."}}],"ceterms:subjectWebpage":"https://www.ccaurora.edu","ceterms:audienceLevelType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/AudienceLevel","ceterms:targetNode":"audLevel:PostSecondaryLevel","ceterms:frameworkName":{"en-US":"Audience Level"},"ceterms:targetNodeName":{"en-US":"Post-Secondary Level"},"ceterms:targetNodeDescription":{"en-US":"Intended for those who have completed secondary level school programs or equivalent."}}],"ceterms:estimatedDuration":[{"@type":"ceterms:DurationProfile","ceterms:exactDuration":"PT120H"}],"ceterms:credentialStatusType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CredentialStatus","ceterms:targetNode":"credentialStat:Active","ceterms:frameworkName":{"en-US":"Credential Status"},"ceterms:targetNodeName":{"en-US":"Active"},"ceterms:targetNodeDescription":{"en-US":"Awards of the credential are ongoing."}},"ceterms:learningDeliveryType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/Delivery","ceterms:targetNode":"deliveryType:OnlineOnly","ceterms:frameworkName":{"en-US":"Delivery Type"},"ceterms:targetNodeName":{"en-US":"Online Only"},"ceterms:targetNodeDescription":{"en-US":"Delivery is only via the Internet."}}],"ceterms:instructionalProgramType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://nces.ed.gov/ipeds/cipcode/Default.aspx?y=56","ceterms:targetNode":"https://nces.ed.gov/ipeds/cipcode/cipdetail.aspx?y=56\u0026cip=11.0802","ceterms:codedNotation":"11.0802","ceterms:frameworkName":{"en-US":"Classification of Instructional Programs"},"ceterms:targetNodeName":{"en-US":"Data Modeling/Warehousing and Database Administration"},"ceterms:targetNodeDescription":{"en-US":"A program that prepares individuals to design and manage the construction of databases and related software programs and applications, including the linking of individual data sets to create complex searchable databases (warehousing) and the use of analytical search tools (mining). Includes instruction in database theory, logic, and semantics; operational and warehouse modeling; dimensionality; attributes and hierarchies; data definition; technical architecture; access and security design; integration; formatting and extraction; data delivery; index design; implementation problems; planning and budgeting; and client and networking issues."}}]}