Dr. John C Conklin

Dr. John C ConklinDr. John C ConklinDr. John C Conklin
  • Home
  • APUS
    • INFO221 Relational DB
    • INFO222 DATABASE SYSTEMS
    • INFO331 MGMT INFO SYSTEMS
    • INFO400 MONGO DB & PYTHON
    • WEBD121 Web Dev Fund.
    • WEBD300 User Interface
    • WEBD321 WEB eCOMMERCE DEV
    • WEBD323 SEO
  • Colorado Technical Univ.
    • Database Systems
    • Data Warehouses
    • Distributed Databases
    • Advanced Database Systems
  • Downloads
    • Downloads
    • Python Programs
  • Cybersecurity
  • Khan Academy
  • More
    • Home
    • APUS
      • INFO221 Relational DB
      • INFO222 DATABASE SYSTEMS
      • INFO331 MGMT INFO SYSTEMS
      • INFO400 MONGO DB & PYTHON
      • WEBD121 Web Dev Fund.
      • WEBD300 User Interface
      • WEBD321 WEB eCOMMERCE DEV
      • WEBD323 SEO
    • Colorado Technical Univ.
      • Database Systems
      • Data Warehouses
      • Distributed Databases
      • Advanced Database Systems
    • Downloads
      • Downloads
      • Python Programs
    • Cybersecurity
    • Khan Academy

Dr. John C Conklin

Dr. John C ConklinDr. John C ConklinDr. John C Conklin
  • Home
  • APUS
    • INFO221 Relational DB
    • INFO222 DATABASE SYSTEMS
    • INFO331 MGMT INFO SYSTEMS
    • INFO400 MONGO DB & PYTHON
    • WEBD121 Web Dev Fund.
    • WEBD300 User Interface
    • WEBD321 WEB eCOMMERCE DEV
    • WEBD323 SEO
  • Colorado Technical Univ.
    • Database Systems
    • Data Warehouses
    • Distributed Databases
    • Advanced Database Systems
  • Downloads
    • Downloads
    • Python Programs
  • Cybersecurity
  • Khan Academy

INFO221: Relational Database Concepts

This course is an introduction to the concepts, management issues, and advantages of relational database management systems. Topics include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. 

Find out more

Course resources

Click on a file to download.


APA Flowchart

 APA Citation Flow Chart - Google Slides 

Visio Demonstration (pdf)

Download

sqlite-dll-win-x64-3470000 (zip)

Download

helpful links

Relational Database Concepts

 

What are relational databases?:  https://cloud.google.com/learn/what-is-a-relational-database


The relational database model: https://www.ionos.com/digitalguide/hosting/technical-matters/relational-databases/


 DBMS Tutorial—Learn Database Management System:  https://www.geeksforgeeks.org/dbms/


SQLite:  https://sqlite.org/lang.html


APA Format and Style

 

If you are struggling with APA formatting of references and how to cite sources you can take a look at this site for some assistance.

  • https://apastyle.apa.org/


This site talks about references lists:

  • https://blog.apastyle.org/apastyle/2011/02/whats-a-reference-list-for.html

VideoS

Relational Database Concepts

 Relational Databases have been a key part of application development for fifty years. In this video, Jamil Spain with IBM, explains what a relational database is, how it works, how to maximize performance and query your data. 

relational vs. non-relational databases

 In this video, Aisha Syed compares relational and non-relational databases and explains the strengths and weaknesses of each. 

100 seconds of sql

 Learn the fundamentals of Structured Query Language SQL! Even though it's over 40 years old, the world's most popular databases still run on SQL. 

Create an ER Diagram

This link is to a video I made showing how to create an ER Diagram in Microsoft Visio.


 https://screencast-o-matic.com/watch/cr1vbaV15yH 

Open Video
  • Home
  • Resume
  • Contact Me
  • Downloads

Dr. John C Conklin

602.796.5972

Copyright © 2023 Dr. John C Conklin - All Rights Reserved.

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

DeclineAccept

Welcome

Take a look around to see what information I have to share.  Please contact me if you have any questions or need help.

Learn more