Videos uploaded by user “Michael Fudge”
Conceptual Data Modeling Explained
This video explains conceptual data modeling. We'll explore the purpose of concepual data modeling and then show how to create crow's foot entity-relationship diagrams from your data semantics.
Views: 39992 Michael Fudge
Learn Programming in Java - Lesson 03 : More Variables / Type Casting
In this screen cast we pick up where we left off with variables and discuss how to parse strings into int and double types, as well demonstrate implicit and explicit type casting of expressions. Along the way we'll discuss the difference between syntax and semantic programming errors.
Views: 75312 Michael Fudge
SQL: Understanding the JOIN clause in the SELECT statement
This screencast introduces table joins, including differences between SQL 89 and SQL 92 join syntax. The various join types such as natural (inner) joins and left/right/full outer joins, and cross joins.
Views: 134227 Michael Fudge
SQL: Views
This SQL screen cast will introduce the viewer to SQL views. You will learn how to create your own views in SQL, find them in the INFORMATION_SCHEMA, and alter their contents. Querying the view using the select statement will be demonstrated.
Views: 90661 Michael Fudge
Quick introduction to Jupyter Notebook
This this video we provide a quick overview of Jupyter Notebook. We'll explain the purpose of this web-based notebook programming environment and demonstrate how to write code in it as well as manage it.
Views: 53802 Michael Fudge
Learn Programming in Java - Lesson 16: Exceptions
In this video we will walk you through the basics of Java exceptions and how you use them to handle errors in your program code. We'll talk about the different types of errors you can encounter in your program and over how you can catch those errors using exceptions. The goal is not cover this topic in depth, but introduce enough of the key concepts so that we can build upon what we've learned in later lessons.
Views: 61238 Michael Fudge
SQL: Learning the basics of the SELECT statement
This screencast will take you thought the in's and out's of the SQL SELECT statement, including using the FROM, WHERE and ORDER BY clauses. Additional topics such as the TOP and DISTINCT keywords, column aliasing with AS, and date/time functions are also covered
Views: 42662 Michael Fudge
How to install Oracle 11g on Windows Server 2008 R2
This video walks you through an install of Oracle 11g Enterprise 64 bit on Windows Server 2008 R2, from downloading the product from Oracle's website through setting it up and connecting to Enterprise Manager.
Views: 53301 Michael Fudge
Learn Programming in Java - Lesson 01 : Java Programming Basics
IMPORTANT: If you're going this this tutorial, from start to finish please begin with lesson 00. It explains how to get setup and where to find the source code. https://www.youtube.com/watch?v=B8gMEV8GKbg This first lesson covers the basic anatomy of a java program. We'll write a simple "Hello World" program and then improve upon it so that it prompts for our name and then says hello to us. Along the way we'll touch upon statements, blocks, objects, variables, classes, the main() method, System.out and literal strings.
Views: 234000 Michael Fudge
Learn Programming in Java - Lesson 04 : Introducing Objects
In this lesson we introduce objects, classes, properties and methods. We'll only use objects and classes at this time as we will learn to create classes in a future lesson. Along the way we'll learn how to use various classes found in the JDK and discover how useful JavaDocs can be for figuring how how to use a class.
Views: 76573 Michael Fudge
Learn Programming in Java - Lesson 12 : Arrays
In this lesson we introduce arrays. We'll explain their purpose and why you want to use them. Through examples, we will demonstrate how to declare, index and enumerate over arrays of basic data types and well as complex arrays of objects.
Views: 32984 Michael Fudge
Learn Programming in Java - Lesson 06 : Custom Classes
This the lesson where we'll learn to create and use our own classes. We'll talk about constructors, overloading methods, public and private members and the importance of encapsulation to control the state of objects in your class. In our example we will create a dice roller in Java.
Views: 59611 Michael Fudge
Learn Programming in Java - Lesson 02 : Variables, Data Types and Assignment.
In this lesson we cover variables, datatypes and the assignment statement. We also take a look at arithmetic operators and the ternary operator. In Netbeans I'll show you how to step through your code a line at a time and set watches on variables.
Views: 133718 Michael Fudge
Learn Programming in Java - Lesson 17: File Input/Output
In this lesson we cover how to read data from and write data to files. We'll discuss the two common file formats, text and binary and how to perform basic file operations on them. We will learn object serialization and de-serialization techniques to make our objects persistent and read and write collections of objects to/from disk.
Views: 218790 Michael Fudge
Learn Programming in Java - Lesson 05 : Methods / Functions
In this lesson we cover the ins and outs of creating your own methods / functions in Java. We'll discuss the basic anatomy of a method declaration, return types, public/private/static members, and parameters. Code examples will demonstrate calling methods, how arguments are passed by value and variable scope.
Views: 111077 Michael Fudge
Learn Programming in Java - Lesson 10 : For Loops
This lesson introduces iterative structures focusing on the for loop. We'll start with concepts like incrementing, loop control variables and exit conditions and finish up the lesson with a series of examples which use the for loop in various ways. I trace through the examples a line at a time so you can see the repetitive nature of the loop!
Views: 27733 Michael Fudge
Learn Programming in Java - Lesson 00 : Getting Set-up for Learning Java
In this first video in the series which will teach you how to program in Java, we will walk through getting your computer setup with Java and Netbeans. We'll also download the sample exercises and take a quick tour of the Netbeans development environment. Links from the video: Java Standard Edition (SE) Developer's Kit (JDK) http://www.oracle.com/technetwork/java/javase/downloads Netbeans Integrated Development Environment (IDE) https://netbeans.org/downloads Source Code Examples https://github.com/mafudge/LearnJava (Web) https://github.com/mafudge/LearnJava.git (GIT Clone Url) PLEASE NOTE: the githib clone Url is case sensitive: LearnJava.git
Views: 257400 Michael Fudge
Learn Programming in Java - Lesson 14: ArrayList and Collections
In this lesson, we explore Java collections, specifically the ArrayList. We'll discuss the similarities / differences between the Array and ArrayList, and provide code examples demonstrating use of method to add, remove, index and enumerate the objects in a collection.
Views: 108064 Michael Fudge
How to install SQL Server 2008 Management Studio Express on Windows 7
This video has been updated, and can be found here: http://youtu.be/cZagPD7ySow The new version demonstrates how to install SQL Server 2012 and includes an explanation of the various editions! Enjoy! m This video demonstrates how to install Microsoft Sql Server 2008 Management Studio express on Windows 7
Views: 202304 Michael Fudge
SQL: Data Manipulation Language INSERT / UPDATE / SELECT / DELETE
This screencast will demonstrate how to use the SQL DML statements to manipulate the data in your tables: INSERT / UPDATE / DELETE and SELECT. Watch this screencast and take the fearsome out of the "fearsome foursome"
Views: 24684 Michael Fudge
SQL: stored procedures
In this SQL screen cast you will learn how to encapsulate business logic into your databases using stored procedures. The CREATE PROCEDURE statement will be used to create the procedure, and then it will be executed using the EXEC command.
Views: 85069 Michael Fudge
SQL Basics: Table creation and inserting data
This SQL Screencast will demonstrate the basics of table creation and inserting data into tables using SQL. - create table (s) - set primary key (s) - add constraints - add foreign keys - insert data - read data from the table
Views: 190509 Michael Fudge
Learn Programming In Java - Lesson 19: Interfaces and Inheritence.
In this lesson we will cover the important object-oriented programming (OOP) concepts of interfaces and inheritance. No only will we define these terms, but we'll demonstrate how each approach works and more importantly explain when it is appropriate to use each one.
Views: 31227 Michael Fudge
Learn Programming in Java - Lesson 08 : If-Else statement
We'll introduce the if-else statement in this lesson. First we will cover how the statement is used to branch the execution of your code. Next we'll code an example which places bounds on user input. We'll finish this episode utilizing everything we've learned so far to create a program to simulate player-monster combat in a dungeon hack style game.
Views: 36584 Michael Fudge
SQL: Group By,  Having, Min, Max Sum
Learn to summarize yoru data using the SQL Aggregates such as count and sum and the GROUP BY and HAVING clauses of the SELECT statement
Views: 138202 Michael Fudge
How to install SQL Server 2012 (various editions explained)
This video explains how to install SQL Server 2012 and includes a discussion of the various editions including express and developer. If you're trying to get started with figuring out which version is right for you and then installing SQL server 2012 on your windows computer, then you need to watch this video!
Views: 92153 Michael Fudge
How to install SQL Server 2012 on Windows Server 2008 R2
I have a newer version where I explain the various SQL server editions and explain all the options in the installation here: http://youtu.be/cZagPD7ySow This video walks you through an install of Microsoft SQL Server 2012 on Windows Server 2008 R2. It assumes you have access to the SQL Server media or have downloaded the trial version.
Views: 20908 Michael Fudge
Learn Programming in Java - Lesson 18: GUI Programming with Java Swing
In this lesson we introduce the basics of Graphical Users Interface (GUI) programming using the Java Swing toolkit. During the lesson you'll see that GUI programming is not that different from the programming you've done so far in the course. We'll learn how to design our GUI forms with drag and drop and then view the code Netbeans generates for us to complete the program.
Views: 91465 Michael Fudge
Learn Programming in Java: Lesson 15 - Sorting and Searching
This lesson introduces sorting and searching of collections. We'll briefly discuss the how's and why's of sorting and searching and cover both writing your own algorithms and well as using java.Util.Collections. In our examples we will sort and search integers and the student class, implementing custom comparators to sort the data in different ways.
Views: 51327 Michael Fudge
Learn Programming in Java - Lesson 20: Web Services
In this lesson we put everything we've learned together and create a program which will read earthquake data from a website and display it to the console. Along the way will discuss API's, where you can locate them for use in your own programs, and how you can parse data into your Java objects.
Views: 35854 Michael Fudge
SQL: custom scalar functions
This screen cast will demonstrate how to create custom scalar functions. These functions can be used in SELECT statements, VIEW creation and table design as calculated columns.
Views: 8178 Michael Fudge
Learn Programming in Java - Lesson 07 : JavaDoc and Unit Tests
In this lesson we continue our exploration of objects and classes. We'll learn how to use the JavaDoc comment syntax to document our class methods as we implement a class which simulates playing cards. We'll also introduce automated or unit testing - focusing on how it can be used to help you reduce the semantic errors in your code.
Views: 44471 Michael Fudge
5 Minute Overview of Git
This video explains the essentials of git source code control in approximately 5 minutes. It was designed specifically for students of my programming course who must commit and push their code changes to GitHub. I'm certain others will find it useful as a gentle introduction to git especially for single user, single device scenairos.
Views: 1351 Michael Fudge
Learn Programming in Java - Lesson 09 : Switch  / If-Else Ladder
This lesson, a continuation of lesson 08 explores two more branching structures in Java: the switch statement and the if-else ladder. In the example from this lesson we write a program which converts a date like 2/23 into a string like "February 23rd." In the second half of the episode we'll cover enumerations, explaining the benefits of making your own data type and values.
Views: 29427 Michael Fudge
Learn Programming in Java - Lesson 11 : While Loops
Lesson 11 pick up where lesson 10 left off - exploring iterative structures in Java. This time we look at the while loop first by comparing / contrasting it to the for loop, and then by showing you its flexibility. We'll demonstrate the three common loop patterns the pre-test, post-test and mid-test by writing the same program 3 different ways.
Views: 24019 Michael Fudge
SQL Database Transactions Part I
This video helps you understand database transactions in Microsoft T-SQL It is part I of a 2 part series.
Views: 14592 Michael Fudge
Let's Learn Hadoop !
This video covers my new Learn Hadoop video series
Views: 801 Michael Fudge
SQL: Programming Basics with T-SQL
This screencast demonstrates basic programming logic with Microsoft T-SQL Download the source SQL code here: http://classes.ischool.syr.edu/ist359fudge/Content/03/fudgemart-sql-v2.zip
Views: 20610 Michael Fudge
End-To-End-Example: Data Analysis with Pandas
In this end to end example we web scrape the HTML of this class schedule off of this website: https://ischool.syr.edu/classes/ into a pandas dataframe. From there we extract a feature column for which classes are Undergraduate versus Graduate, then we finish by finding the Undergraduate classes on Fridays or at 8AM. Like all End-To-End examples the program is written organically piece by piece until complete. I make mistakes and figure things out as I go. You can download the code for this example on GitHub: https://github.com/IST256/learn-python/tree/master/content/lessons/12/End-To-End-Example
Views: 2256 Michael Fudge
Learn Programming in Java - Lesson 13: Multidimensional Arrays
In this lesson we take a look at multidimensional arrays. You'll see how to declare, index, and enumerate multidimensional arrays, and no doubt notice they''re not much more difficult than traditional arrays. We'll introduce an implementation of the classic game Tic-Tac-Toe as a sample program.
Views: 27548 Michael Fudge
The "Fudgemart" Database Schema
This SQL How-to video discusses the Fudgemart database schema. Fudgemart is a sample database (very) loosely based on a popular brick-n-mortar retailer. You can follow along and download the SQL to create the fudgemart schema here http://bit.ly/fudgemart-sql
Views: 3861 Michael Fudge
Blackboard Building Block: Starting a Building Block
In this video I walk you through getting started with creating your own building block. We do this by using the B2 Starter kit to make an initial setup for our Building Block
Views: 3285 Michael Fudge
SQL: Using Information Schema to query table metadata
this screencast demonstrates how to use the INFORMATION_SCHEMA special objects in your SQL database to query metadata, such as tables, columns, keys and constraints.
Views: 9627 Michael Fudge
End-To-End Example: Variables and Types
This is the first end to end example in the learn Python series. End of end examples walk through the process of solving real-world problems in the Python programming language. The goal is to help you understand the process of coding a solution. End to end examples are minimally edited. Things will go wrong, you'll get to watch me fail as I write code. This example uses jupyter-notebook You can download the code you see in this example here: https://github.com/IST256/learn-python/tree/master/content/lessons/03/End-To-End-Example
Views: 1502 Michael Fudge
The annoying orange tribute
This video was uploaded from an Android phone.
Views: 2300 Michael Fudge
Watch.Mike.Code: Class Design and Unit Testing in Java
The first video in the Watch.Mike.Code. series. Videos in this series are raw, unedited code demonstrations - usually front of a live audience. In this video I cover the basics of Java class design and the how's and why's of unit testing. I do this by creating a very simple class to manage a checking account. If you're new to java classes or unit testing this might be the video for you. In the video, I used the NetBeans IDE and JUnit for testing. You can download the source code in the video from github: https://github.com/mafudge/watchmikecode
Views: 4026 Michael Fudge
End-To-End Example: Files
In this end to end example we use Python's file I/O commands to read a list of beers names and calories from a file. We then use that code in a program to seach for a beer by name and report back the number of calories in a 12 oz serving. Along the way we discuss delimiters, how to handle FileNotFoundErrors and ways to deal with searches which find no beer names in the file. While trying to figure out which string methods to use we will revisit the help() function which allows you to explore the Python docs. The code for this end-to-end example can be found on github here: https://github.com/IST256/learn-python/tree/master/content/lessons/08/End-To-End-Example
Views: 484 Michael Fudge
What is Remote Lab?
This video explains how Syracuse University School of Information Studies' Remote Lab works.
Views: 908 Michael Fudge
How To Open The Windows Command Prompt Inside Your Git Repository Folder
This video demonstrates how to open the Windows command prompt from inside your git repository folder. This is necessary so that you can enter git commands.
Views: 1978 Michael Fudge
End-To-End Example: Web Apis
In this end-to-end example we use the requests module to consume web api's to write a program which asks the user to enter a location like "Tampa, FL" and then tell you the current weather conditions at that location. To complete the program we will need to use two different web APIs: Google's geolocation API takes a location and returns back JSON data containing the global position of that location (latitude and longitude). We will use the request.json() method function to decode the json result from the API into a Python object. The second API is a weather forecaster courtsey of darksky.net. This API required a set of coordinates (latitude and longitude) and returns back JSON data containing the current weather conditions and the 7 day forecast. Like all end-to-end examples I solve the problem step-by-step as I would if I were writing the code for the first time and thinking it through from scratch. The source code for this example can be found on GitHub here: https://github.com/IST256/learn-python/tree/master/content/lessons/11/End-To-End-Example
Views: 690 Michael Fudge