Posts: 221
Threads: 36
Likes Received: 66 in 33 posts
Likes Given: 30
Joined: Mar 2012
Intro to Relational Databases
ACE Course Number:
SOPH-0047
Organization Course Number:
CS1011
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 relational databases
Description
Objective:
The course objective is for students to learn the basics of databases, including data modeling, SQL statements (DML, DDL and DCL), database administration, and security. Students will explore relational databases such as MariaDB, SQL Server, Oracle or MySQL, including alternative approaches like NoSQL.
Learning Outcomes:
use select-from-where queries to collect information from a single table database
form a single table database using create and insert commands
form a database with multiple tables using primary keys and foreign keys
demonstrate awareness of sub-queries, views, indices, and unions
summarize importance of backing up data
evaluate multiple approaches to securing relational data
explore other methods of enhancing relational table design
explain the purpose and utility of a database
identify the most common database models used today
distinguish between several commercial relational DBMS
explain the purpose of an ERD
explain the purpose of normalization with respect to the relational data model
given an ERD depicting non-normalized data, normalize the data model
use group by, order by, and aggregate functions
alter and update the database table by adding, deleting, or modifying columns
use select-from-where queries to combine information from multiple tables in a database using joins
General Course Topics:
Single table query foundations
Single table construction
Aggregate function queries
Updating a single table
Querying multiple tables
Constructing related tables
Specialized queries
Views
Reliability
Security
Enhancement
Management
Utility
Common database models
Commercial variety
Constraints
Entity-relationship diagram
Normalization
Applied normalization
Instruction & Assessment
Instructional Strategies:
Audio Visual Materials
Computer Based Training
Lectures
Practical Exercises
Methods of Assessment:
Examinations
Quizzes
Minimum Passing Score:
70%
TESU BA June 2018.
Various business certificates still to do.
Posts: 16,210
Threads: 928
Likes Received: 5,295 in 3,988 posts
Likes Given: 0
Joined: Feb 2016
I don't see it in the list of courses I can add... hopefully it'll come out sooner rather than later... so I can complete them before the yearly membership runs out!
Posts: 221
Threads: 36
Likes Received: 66 in 33 posts
Likes Given: 30
Joined: Mar 2012
It usually takes a few days after it appears on ACE's website before it is available to take on Sophia's website.
TESU BA June 2018.
Various business certificates still to do.
•
Posts: 541
Threads: 84
Likes Received: 165 in 95 posts
Likes Given: 82
Joined: Aug 2018
04-08-2021, 11:02 AM
(This post was last modified: 04-08-2021, 11:20 AM by gams007.)
(04-01-2021, 08:08 PM)SDO Wrote: Intro to Relational Databases
ACE Course Number:
SOPH-0047
Organization Course Number:
CS1011
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 relational databases
Description
Objective:
The course objective is for students to learn the basics of databases, including data modeling, SQL statements (DML, DDL and DCL), database administration, and security. Students will explore relational databases such as MariaDB, SQL Server, Oracle or MySQL, including alternative approaches like NoSQL.
Learning Outcomes:
use select-from-where queries to collect information from a single table database
form a single table database using create and insert commands
form a database with multiple tables using primary keys and foreign keys
demonstrate awareness of sub-queries, views, indices, and unions
summarize importance of backing up data
evaluate multiple approaches to securing relational data
explore other methods of enhancing relational table design
explain the purpose and utility of a database
identify the most common database models used today
distinguish between several commercial relational DBMS
explain the purpose of an ERD
explain the purpose of normalization with respect to the relational data model
given an ERD depicting non-normalized data, normalize the data model
use group by, order by, and aggregate functions
alter and update the database table by adding, deleting, or modifying columns
use select-from-where queries to combine information from multiple tables in a database using joins
General Course Topics:
Single table query foundations
Single table construction
Aggregate function queries
Updating a single table
Querying multiple tables
Constructing related tables
Specialized queries
Views
Reliability
Security
Enhancement
Management
Utility
Common database models
Commercial variety
Constraints
Entity-relationship diagram
Normalization
Applied normalization
Instruction & Assessment
Instructional Strategies:
Audio Visual Materials
Computer Based Training
Lectures
Practical Exercises
Methods of Assessment:
Examinations
Quizzes
Minimum Passing Score:
70%
Any idea when Sophia is going to publish this course online??
(04-08-2021, 11:02 AM)gams007 Wrote: (04-01-2021, 08:08 PM)SDO Wrote: Intro to Relational Databases
ACE Course Number:
SOPH-0047
Organization Course Number:
CS1011
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 relational databases
Description
Objective:
The course objective is for students to learn the basics of databases, including data modeling, SQL statements (DML, DDL and DCL), database administration, and security. Students will explore relational databases such as MariaDB, SQL Server, Oracle or MySQL, including alternative approaches like NoSQL.
Learning Outcomes:
use select-from-where queries to collect information from a single table database
form a single table database using create and insert commands
form a database with multiple tables using primary keys and foreign keys
demonstrate awareness of sub-queries, views, indices, and unions
summarize importance of backing up data
evaluate multiple approaches to securing relational data
explore other methods of enhancing relational table design
explain the purpose and utility of a database
identify the most common database models used today
distinguish between several commercial relational DBMS
explain the purpose of an ERD
explain the purpose of normalization with respect to the relational data model
given an ERD depicting non-normalized data, normalize the data model
use group by, order by, and aggregate functions
alter and update the database table by adding, deleting, or modifying columns
use select-from-where queries to combine information from multiple tables in a database using joins
General Course Topics:
Single table query foundations
Single table construction
Aggregate function queries
Updating a single table
Querying multiple tables
Constructing related tables
Specialized queries
Views
Reliability
Security
Enhancement
Management
Utility
Common database models
Commercial variety
Constraints
Entity-relationship diagram
Normalization
Applied normalization
Instruction & Assessment
Instructional Strategies:
Audio Visual Materials
Computer Based Training
Lectures
Practical Exercises
Methods of Assessment:
Examinations
Quizzes
Minimum Passing Score:
70%
Any idea when Sophia is going to publish this course online?? I decide to contact Sophia and they said that the course will be available in May.
they reply me this
"Yes let me check with my academic team to see when it will be available.
So they believe it will be available next month in May"
In progress:
TESU - ASNSM ASBA, UNIR- Master Cyber Security
Completed:
TESU - BA Computer Science
•
Posts: 16,210
Threads: 928
Likes Received: 5,295 in 3,988 posts
Likes Given: 0
Joined: Feb 2016
Awesome, I was thinking at the end of the month. I hope they come out with more before my yearly membership expires in November.
•
Posts: 641
Threads: 34
Likes Received: 426 in 261 posts
Likes Given: 1,440
Joined: Jul 2020
TESU Class of 2024 BSBA-CIS+GM, BSIT, ASNSM-CS+Math, AAS-GEN
Earned credits from Sophia, SDC, ASU ULC, TEEX, Microsoft, Strayer, TESU, Saylor, DSST, CLEP, CompTIA, StraighterLine, and others since starting in April 2020
The following 1 user Likes jch's post:1 user Likes jch's post
• MNomadic
Posts: 11,035
Threads: 153
Likes Received: 5,924 in 3,964 posts
Likes Given: 4,140
Joined: Mar 2018
This one is much, MUCH better than the Web Design one. At first glance, I dare say that it might even be better than Database Management 303 at SDC. It's a shame that this is just a LL course.
In progress:
TESU - BA Computer Science; BSBA CIS; ASNSM Math & CS; ASBA
Completed:
Pierpont - AAS BOG
Sophia (so many), The Institutes (old), Study.com (5 courses)
ASU: Human Origins, Astronomy, Intro Health & Wellness, Western Civilization, Computer Appls & Info Technology, Intro Programming
Strayer: CIS175, CIS111, WRK100, MAT210
Posts: 266
Threads: 41
Likes Received: 134 in 77 posts
Likes Given: 294
Joined: Feb 2021
04-14-2021, 03:35 PM
(This post was last modified: 04-14-2021, 03:55 PM by TINASAM.)
Current Degree Programs:
MA in Social Science (conc. Sociology) - GSU - April 2025
M.Ed in Elementary Education - UoPeople - December 2026
Up Next
Ph.D in Change Leadership in Equity and Inclusion (Higher Education) - UCA
Finished Degrees and Certificates:
AAS Board of Governors - Pierpont Community & Technical College 8/2021
AS Business Administration (cum laude) - Franklin University 9/2022
Grant Writing Certificate- Fort Hays State University - 11/2022
BS Social Science (cum laude) - Franklin University 12/2022
Posts: 11,035
Threads: 153
Likes Received: 5,924 in 3,964 posts
Likes Given: 4,140
Joined: Mar 2018
Awesome! Added them to the wiki. Hopefully, TESU transfers these new courses in.
In progress:
TESU - BA Computer Science; BSBA CIS; ASNSM Math & CS; ASBA
Completed:
Pierpont - AAS BOG
Sophia (so many), The Institutes (old), Study.com (5 courses)
ASU: Human Origins, Astronomy, Intro Health & Wellness, Western Civilization, Computer Appls & Info Technology, Intro Programming
Strayer: CIS175, CIS111, WRK100, MAT210
Posts: 1,229
Threads: 278
Likes Received: 961 in 508 posts
Likes Given: 298
Joined: Mar 2017
Ah man. At the end of last year, I had to choose between the cheap one year subscription and the free three month subscription. I choose the three free months and it looks like I should have bought the year. Hehe.
•
|