CS660 - Unit 1 - Live Chat Slides (pdf)
DownloadUnit 2 - Live Chat Slides (Updated) (pptx)
DownloadCS660 - Unit 3 - Live Chat Slides (pdf)
DownloadUnit 4 - Live Chat Slides (pdf)
DownloadCS660 - Unit 5 - Live Chat Slides (pdf)
DownloadVisio Demonstration (pdf)
DownloadCS660 APA Project File Template (docx)
DownloadCS660_Sample_Project_File (pdf)
DownloadAll CS660 Worked Examples (zip)
DownloadSQL Demo (zip)
DownloadSQL Notes for Professionals (pdf)
DownloadSQL Commands for Begginers (pdf)
DownloadSQL2019-SSEI-Expr (zip)
DownloadSQL2022-SSEI-Expr (zip)
Download
These sites have good articles on database design, and you may find them useful.
https://www.datanamic.com/support/lt-dez005-introduction-db-modeling.html
Some online free ER Diagram Tools:
These sites have good articles on basic entity relationship modeling and you may find it useful.
These items can help explain how to convert your ER Diagram into a database schema:
Data Definition Language
Data Manipulation Language
I found this site that explains how to run this application on an Apple computer.:
Pivot / Crosstab Queries
Online SQL Editors
Download SQL Server Management Studio
These two sites have good videos on database administration that you may find it useful.
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.
This site talks about references lists:
Here are some additional resources for those trying to understand transaction management. Try looking at these sites which gives some good information on transaction management:
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS.
Structured Query Language - or SQL, is a language that communicates with databases. Learn what SQL is, and why it is an important language to learn in the era of big data.
Good video that explains the importance of transactions in the relational database.
This database tutorial will help beginners understand the basics of database management systems. We use helpful analogies to explain a high-level overview of spreadsheets, tables, and database management systems. The logic and concepts in this tutorial will make it easier to understand the more technical aspects of database architecture and Entity Relationship Diagrams (ERD).
This link is to a video I made showing how to create an ER Diagram in Microsoft Visio.
Copyright © 2023 Dr. John C Conklin - All Rights Reserved.
Take a look around to see what information I have to share. Please contact me if you have any questions or need help.