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
  • University of the People
    • Databases 2
    • Programming 1
    • Python Programming
    • Web Programming 1
    • Web Programming 2
  • 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
    • University of the People
      • Databases 2
      • Programming 1
      • Python Programming
      • Web Programming 1
      • Web Programming 2
    • 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
  • University of the People
    • Databases 2
    • Programming 1
    • Python Programming
    • Web Programming 1
    • Web Programming 2
  • Colorado Technical Univ.
    • Database Systems
    • Data Warehouses
    • Distributed Databases
    • Advanced Database Systems
  • Downloads
    • Downloads
    • Python Programs
  • Cybersecurity
  • Khan Academy

Databases Course LIVE CHAT SLIDES & resources

Click on a file to download.


APA Flowchart

 APA Citation Flow Chart - Google Slides 

CS660 - Unit 1 - Live Chat Slides (pdf)

Download

Unit 2 - Live Chat Slides (Updated) (pptx)

Download

CS660 - Unit 3 - Live Chat Slides (pdf)

Download

CS660 - Unit 4 - Live Chat Slides (Updated 10_30_2024) (pdf)

Download

CS660 - Unit 5 - Live Chat Slides (pdf)

Download

Visio Demonstration (pdf)

Download

CS660 APA Project File Template (docx)

Download

CS660_Sample_Project_File (pdf)

Download

All CS660 Worked Examples (zip)

Download

SQL Demo (zip)

Download

SQL Notes for Professionals (pdf)

Download

SQL Commands for Begginers (pdf)

Download

SQL2019-SSEI-Expr (zip)

Download

SQL2022-SSEI-Expr (zip)

Download

helpful links

Data Modeling and Concepts

 

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:

  • dbdiagram.io: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#dbdiagramio
  • draw.io: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#drawio
  • Lucidchart: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#lucidchart
  • SQLDBM: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#sqldbm
  • QuickDBD: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#quickdbd

 

SQL Statements

 

These sites have good articles on basic entity relationship modeling and you may find it useful.

  • https://www.guru99.com/er-diagram-tutorial-dbms.html
  • https://beginnersbook.com/2015/04/e-r-model-in-dbms/
  • https://www.tutorialspoint.com/dbms/er_model_basic_concepts.htm


These items can help explain how to convert your ER Diagram into a database schema:

  • https://www.learndb.com/databases/how-to-convert-er-diagram-to-relational-database
  • http://www.opentextbooks.org.hk/ditatopic/25280


Data Definition Language

  • https://docs.microsoft.com/en-us/sql/t-sql/statements/statements?view=sql-server-2017
  • https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Transact-SQL%20Data%20Definition%20Language%20-%20DDL-%20Reference.pdf


Data Manipulation Language

  • https://codingsight.com/tutorial-on-sql-ddl-dml-on-the-example-of-ms-sql-server-dialect/
  • https://ramkedem.com/en/sql-server-dml/


I found this site that explains how to run this application on an Apple computer.:

  • https://database.guide/how-to-install-sql-server-on-a-mac/


Pivot / Crosstab Queries

  • https://www.youtube.com/watch?v=RWfuT1_p4Cw


Online SQL Editors

  •  Create a new SQL program - myCompiler: https://www.mycompiler.io/new/sql
    Online 
  • SQL Editor - Online SQL Scripting - Practice SQL Online (jdoodle.com): https://www.jdoodle.com/execute-sql-online/
  • SQL Editor (sqltutorial.org): https://www.sqltutorial.org/seeit/ 


Download SQL Server Management Studio

  • https://aka.ms/ssmsfullsetup

Database Administration

 These two sites have good videos on database administration that you may find it useful.


  • Video: https://www.youtube.com/watch?v=rPfncf8W1MA


  • Video: https://channel9.msdn.com/Series/dbfundamentals/05

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

Transaction Management

 

Additional Resources

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:


  • https://www.guru99.com/dbms-transaction-management.html


  • https://www.tutorialspoint.com/dbms/dbms_transaction.htm


  • https://docs.oracle.com/cd/B19306_01/server.102/b14220/transact.htm


VideoS

SQL In 4 Hours - Full Course

 In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. 

What is SQL?

 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.  

Transactions in DBMS

Good video that explains the importance of transactions in the relational database.

Database Tutorial for Beginners

 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).
 


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