SQLite logo is a trademark of SQLite at https://www.sqlite.org/
SQLite logo is a trademark of SQLite at https://www.sqlite.org/

Training slides for SQLite. Please feel free to use. Also, if you do use, please cite me and other sources noted in the slides. As these presentations refer to the “SQL Quickstart Guide” by Walter Shields, please consider a purchase of his book to receive the database (sTunes) as described in these presentations (Amazon, etc.).

Let me know if there are any changes/modifications.

Module 1 of 9: https://www2.slideshare.net/highervista/sq-lite-module1

Module 2 of 9: https://www2.slideshare.net/highervista/sq-lite-module2

Module 3 of 9: https://www2.slideshare.net/highervista/sq-lite-module3

Module 4 of 9: https://www2.slideshare.net/highervista/sq-lite-module4

Module 5 of 9: https://www2.slideshare.net/highervista/sq-lite-module5

Module 6 of 9: https://www2.slideshare.net/highervista/sq-lite-module6

Module 7 of 9: https://www2.slideshare.net/highervista/sq-lite-module7

Module 8 of 9: https://www2.slideshare.net/highervista/sq-lite-module8

Module 9 of 9: https://www2.slideshare.net/highervista/sq-lite-module9


Image for post
Image for post

Software Development Life Cycle Assessment

Due to the increasing volume of cybersecurity incidents caused by bad actors, organizations, there is a pressing demand for organizations to protect their information systems and networks. One type of cybersecurity attack that has caused havoc on organizational information systems and networks is the ransomware attack, where organizational information and data assets are locked up and held for ransom by an attacker. To address this type of attack on the critical infrastructure, a plan to address ransomware that includes its prevention, mitigation strategies, and procedures to restore system services if an attack was successful. A business continuity plan (BCP) must be detailed to include a network diagram of the critical systems, incident response planning that includes incident reporting procedures, encryption policies, and disaster recovery procedures. …


Image for post
Image for post
Source: SyncFab (url: https://www.coinspeaker.com/syncfab-manufacturing-blockchain-bolsters-auto-supply-chain-relations/)

by Prudence Calabrese, MAI and Ron McFarland, Ph.D.

Artificial Intelligence in the Manufacturing Supply Chain

Individually, Artificial Intelligence (AI) and blockchain are two disruptive technologies. Each offers advantages to a wide array of technology, financial, healthcare, business, and the manufacturing supply chain sectors. AI provides the promise of building software and machines that are capable of performing tasks that involve more computation and applied intelligence. In the meantime, blockchain can be considered a new file system for storing information in an encrypted form on a distributed ledger format (Marr, 2018).

Combined, AI and blockchain will lead to both a technical and economic revolution, especially in terms of the manufacturing supply chain. Gartner (2018) indicates that four percent of CIOs have implemented both AI systems and blockchain technologies at their organizations and another 46 percent developing plans to do so. In terms of the manufacturing sector, manufacturing contributes to about 11.7% of the GDP (Mire, 2019), and the push to infuse AI and Blockchain technology in the manufacturing supply chain to support efficiencies has only increased (Osbourne, 2017). …


Image for post
Image for post

A key aspect of database technology is that security of data that resides on databases is at continual risk from hackers. The landscape of database technology has rapidly changed over the past decade. Database technology has morphed into many variants, which serve to better express how data is managed in the organization. The rapid changes and the increased ways that data is managed creates a swelling risk for database security. In this brief article, please find a summary of a few popular database types, as a prelude to future discussions on database security. …


Image for post
Image for post

By Ron McFarland, Ph.D.

June 1, 2019

The largest problem with open source solutions is that there is generally no vetting process for much of the open source communities in terms of cybersecurity efficacy. For example, the Equifax hack was as a result of an open source java component being used in a framework that afforded attackers to exfiltrate consumer PII. I recently read that over 1,000 downloads per day occur in the software development space for open source modules. …


Data Leakage & Application Programming Risk Mitigation: A starter for the Java Programming Language

Image for post
Image for post

by Ron McFarland, Ph.D.

Risk mitigation continues to evolve in the cybersecurity space. A key observation that speaks to the shifting sands of risk mitigation is noted in the Hewlett Packard Enterprise Cyber Risk Report of 2016. HP researchers indicated that attackers have shifted their focus from servers and operating systems directly to applications (Enterprise, 2016). For application development teams, this shift places even greater emphasis on the development of secure code and the protection of code once deployed. …


Image for post
Image for post
Digital Forensics

A few years back, I earned the CCFP Computer Forensics certification from ISC2. ISC2 (isc2.org) is a highly reputable certification organization, but they decided to pull back from the forensics certification as a business decision. They have since expired the CCFP certification.

The CCFP was a recognized certification and, at the time, covered the essential aspects of Computer Forensics. The intent of the certification was noted on the ISC2 website: “The CCFP exam covers a number of domains including legal and ethical principles, investigations, forensic science, digital forensics, and hybrid and emerging technologies. The examination, which costs $549, is a multiple-choice test with scenario-based questions.” …


Image for post
Image for post
FUNCTION POINT ANALYSIS — A PRIMER

by Ron McFarland, Ph.D.

As a Software Development Project Manager, with the help of my team, I must size up the cost of doing a software development project. At the onset of the ‘costing’ effort, one of the common tools that a Project Manager has available is the Function Point Analysis (FPA) method. The FPA is not a distinct estimation effort but is a generic broad estimate on the cost and effort that can be used as a first pass to true software development costs. FPA considers the relationship between the size (scope) of the functional requirements and the amount of relative effort to build the requirement out (Balraj, 2018). …


Image for post
Image for post

By Ron McFarland, Ph.D.

Introduction to the GDPR

The General Data Protection Regulations (GDPR) in the European Union took effect on May 25th, 2018. The formation of the GDPR regulations started in January 2012 when the European Commission proposed a comprehensive reform to existing data protection rules. Even though GDPR was invoked over 6 months ago, a recent survey conducted by Sage found that 91 percent of US businesses lack awareness surrounding the details of the GDPR, and 84 percent don’t understand the GDPR’s implications for their business (Harris, 2018). …


Image for post
Image for post

As network security professionals, we work to mitigate traffic between the untrusted network (think of the Internet as one example), the firewall (or a series of firewalls), the “Demilitarized Zone (DMZ)” and the trusted network. This is life in the balance for a network security professional.

For the budding network security professional, the firewall is one essential element that must be studied in detail. This blog is a simple starter post into the exploration of the firewall. …

About

Ron McFarland

Dr. Ron McFarland, CISSP, PMP guest blogger at Highervista, LLC (email: highervista@gmail.com)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store