{"@id":"https://credentialengineregistry.org/resources/ce-e0e1a2fe-162f-4943-9382-95c0c3d00746","@type":"ceterms:OpenBadge","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-e0e1a2fe-162f-4943-9382-95c0c3d00746","ceterms:name":{"en-US":"SQL for Data Analytics"},"ceterms:image":"https://api.badgr.io/public/badges/JgHs4wIZRBu9w2YUdj4epQ/image","ceterms:ownedBy":["https://credentialengineregistry.org/resources/ce-c15645f2-d333-42cc-8c9a-67f13425e731"],"ceterms:requires":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Open Badges Criteria"},"ceterms:description":{"en-US":"The criteria for earning the badge includes completion of reading, labs, and discussion related to the following topics. Students who earn a C or higher on the hands-on exercises and case study will be awarded the badge.\n\n*Querying data from single and multiple tables using Structure Query language.\n*Applying aggregation functions(SUM, AVG, COUNT, MAX, MIN) and GROUP BY clauses to summarize and analyze data.\n*Use subqueries to perform complex data analysis.\n*Completion of a case study that demonstrates applying SQL skills to real-world data analysis scenarios. This assessment evaluates a student's ability to effectively use SQL queries, ranging from simple to advanced, including JOINs, Group By, and subqueries to solve the case study problem and provide insightful interpretations of the results. Points are awarded for effective use SQL for data manipulation and analysis, documentation, overall presentation and the effectiveness of communicating findings."},"ceterms:targetCompetency":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:targetNode":"https://talentneuron.com/","ceterms:codedNotation":"TN-20946","ceterms:frameworkName":{"en-US":"TALENT_NEURON"},"ceterms:targetNodeName":{"en-US":"Database applications"},"ceterms:targetNodeDescription":{"en-US":"A competency related to this credential"}}]},{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Requires 'LearningOpportunity': Data Analytics"},"ceterms:description":{"en-US":"To earn this credential, candidates must complete the learning opportunity: Data Analytics"},"ceterms:targetLearningOpportunity":["https://credentialengineregistry.org/resources/ce-f76261b7-1f79-4112-9067-0cce9af2e386"]}],"ceterms:offeredBy":["https://credentialengineregistry.org/resources/ce-c15645f2-d333-42cc-8c9a-67f13425e731"],"ceterms:inLanguage":["en-US"],"ceterms:description":{"en-US":"Earners of the SQL for Data Analytics badge are familiar with the fundamentals of Structured Query Language (SQL). They have acquired essential skills to use SQL queries to retrieve, manipulate and transform data making them well-equipped to perform data analytics tasks and extract valuable insights from relational databases."},"ceterms:credentialId":"https://api.badgr.io/public/badges/JgHs4wIZRBu9w2YUdj4epQ","ceterms:dateEffective":"2024-02-21","ceterms:isRequiredFor":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Is Required For"},"ceterms:targetLearningOpportunity":["https://credentialengineregistry.org/resources/ce-f76261b7-1f79-4112-9067-0cce9af2e386"]}],"ceterms:subjectWebpage":"https://api.badgr.io/public/badges/JgHs4wIZRBu9w2YUdj4epQ","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:usesVerificationService":["https://credentialengineregistry.org/resources/ce-d3f98c17-c2f5-496b-8968-7979964edefc"]}