Computer Science 204: Database Programming
- Course type: Self-paced
- Available Lessons: 96
- Average Lesson Length: 8 min
-
Eligible for Certificate:
Certificate completed
Yes
Certificates show that you have completed the course. They do not provide credit.
-
Watch a preview:
chapter 1 / lesson 1What is a Relational Database? - Elements, Design & Advantages
Course Summary
This Computer Science 204: Database Programming course provides you with thorough and easy-to-understand lessons you can access on any computer or mobile device at any time. Use this course to refresh your professional knowledge or assist you in your studies.To Start This Course Today
Try it risk-free for 30 days
11 chapters in Computer Science 204: Database Programming
Course Practice Test
Check your knowledge of this course with a 50-question practice test.- Comprehensive test covering all topics
- Detailed video explanations for wrong answers
About This Course
We've outlined key topics related to database programming in this Computer Science 204 course. A series of engaging lessons cover areas such as database security, manipulating data in databases and relational database management systems. You can work at your own pace as you review the short video lessons, going back as many times as needed to work through more challenging topics. Our experts are available through the Dashboard if you have any questions along the way. The lesson quizzes and comprehensive chapter tests are a helpful way to keep tabs on your progress and make sure you're understanding what you're learning.
Our informative and professionally designed course is suitable for a variety of educational purposes and can be of help to students, teachers, professionals and laypeople alike. Whether you're studying for a test, writing your own curriculum, boosting your confidence on the job or just want to learn more about computer science, this course is for you.
Course Topics
Category | Objectives |
---|---|
Intro to Relational Database Management Systems | Describes database applications and queries, designing database schemas and basic SQL commands in database management systems (DBMS) |
Creating & Managing Database Tables | Explores data definition language (DDL), primary and foreign keys in SQL and different SQL data types |
Populating & Retrieving Data in Databases | Discusses basic and advanced SQL query syntax, SQL functions and sorting the results of a SQL query |
Manipulating Data in Databases | Outlines data manipulation language (DML), the UPDATE and DELETE statements in SQL and how to control transactions in SQL |
Data Queries in Multiple Tables Using Joins | Explains SQL joins, including inner joins, full outer joins, left and right joins and self-joins, plus aliases in SQL |
Data Queries in Multiple Tables Using Subqueries | Details SQL subqueries and correlated subqueries, plus EXISTS, NOT EXISTS and WITH |
Views & Indexes in Databases | Defines SQL views, database indexes, indexes in SQL and the CREATE index in SQL |
Modifying Tables in Databases | Covers modifying tables using SQL, SQL DROP columns and rows, as well as DROP tables, indexes and databases |
Manipulating Large Data Sets in Databases | Identifies concepts of SET operators in database management, UNION vs. JOIN, manipulating data using subqueries and multi-table inserts in databases |
Developing & Using Regular Expressions in Databases | Provides information about regular expressions and how they are implemented in Oracle databases, MySQL databases and SQL server databases |
Database Security | Identifies database administration and security, database security using SQL, advanced database security and database encryption |
Earning College Credit
Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.
Research Schools, Degrees & Careers
Get the unbiased info you need to find the right school.
Browse Articles By Category
Browse an area of study or degree level.
- Agriculture
- Architecture
- Biological and Biomedical Sciences
- Business
- Communications and Journalism
- Computer Sciences
- Culinary Arts and Personal Services
- Education
- Engineering
- Legal
- Liberal Arts and Humanities
- Mechanic and Repair Technologies
- Medical and Health Professions
- Physical Sciences
- Psychology
- Transportation and Distribution
- Visual and Performing Arts
Recommended Articles
- Computer Science Masters Degree Programs with Course Info
- Personal Computer Training Programs and Courses
- Online Computer Science Courses, Classes and Schools
- Computer Science Courses in Utah with School Overviews
- Computer Science Schools in Alabama with Course Overviews
- Associates Degrees in Computer Science with Course Information
- Online IT Computer Courses Overview
- Business Computer Applications Courses and Training Programs
- Computer Programming Schools in Washington with Course Info
- Computer Programming Schools in Texas with Course Summaries
- Answers and detailed explanations to each question
- Video lessons to explain complicated concepts