Patrick J. Wasson

Hi Class, I realized I had 2 assignments due on 11/14, so I have extended the due date for the SQL Queries to 11/21.

Thanks,

Pat

Why do we store data in separate tables and not in one big table?  Explain to me how we take an ERD and translate boxes and lines in the ERD into a SQL statement.    What is needed in order to design an ERD? Wha […]

Hi Class,

Last night we continued our Database coverage and moved onto using MySQL Workbench, writing SQL queries, designing a database architecture and working within a db architecture.

Next week we will […]

What did you learn about how applications work in our coverage of C#?  Research another programming language similar to C# and describe how it is similar/different!

Hi Class,

As a reminder this week will be conducted via a pre-recorded webex that I will be posting under Schedules and Materials for Week 10.

This week we will cover Application Development, which included […]

Hi Class,

Last night we moved onto Application Software and covered an overview of web servers and applications.  Additionally, we went through a hands-on breakthrough of IIS and Visual Studio.

Next week we […]

We looked at two different types of applications last night: Forms Apps and Web Apps.  What is the difference between the two?  What are the advantages/disadvantages of each?

Hi Class,

Just a heads up: Our Week 10 class on 10/31/18 will be a virtual class held via a pre-recorded webex.

I will post the webex in Week 10 and you can view it any time you would like during the […]

Last night we spent a decent amount of time discussing the database level of  a database server as well as the operating system level of a database server.  Why do you think we spent so much time discussing t […]

Hi Class, last night we moved onto Database Administration and Auditing.  This included a comprehensive overview of Relational Database Architecture as well as a hands on demonstration of a MySQL installation and […]

After last night, which do you prefer?  What are the benefits/drawbacks of a graphical user interface? What are the benefits/drawbacks of a command line interface?  Why do you think understanding the command li […]

Hi Class,

Good work last night.  To recap: we covered a comprehensive review of the windows command line.

Next week: We will review any system administration/command line topics still outstanding and then […]

Why do we care about domains?  Why is it ok for you to not be on a domain at home, but at work your company makes your work pc join their domain?  What’s the point?

How does any of this relate to your fut […]

Hi Class,

Good work last night!  To recap: We moved onto Systems Administration and began our coverage of managing technology resources within and organization, which included domains, domain controllers, and […]

After last night do IP Addresses mean anything more to you than before?  We knew that they were your identity on the internet, but what else do they say about you?  Understanding now the vast number of network c […]

Good work last night!  To recap: We covered the fundamental concepts of computer networking and built a small networks using pcs, ethernet cables and switches/routers.  We configured the routers using t […]

Last night we talked about a variety of storage components and how they all technically worked at a very detailed level.  While you may never work in a factory that manufactures hard drives, as an IT Auditor why […]

Hi Class,

Good work last night.  To recap: We covered various Storage components including RAM, hard drives, flash drives, dvds and back-up tapes.  We concluded by going through an activity involving auditing a […]

Why do you all think I am asking you to install multiple virtual machines with different operating systems using 2 different types of virtual machines hosting technology?  Doesn’t it seem like a lot of work to ha […]

Hi Class,

Good work last night.  To re-cap: We covered Operating System concepts, and went through the key aspects of the task manager, performance monitor and file directories of the windows OS.  In a […]