The field of information technology is fluid and dynamic, rapidly changing in short periods of time.
As such, the coursework, content, and technoligies present in courses such as IS-130 are subject to change.
Fundamentally, IS-130 seeks to both broaden and delve deeper into the learning you have performed in IS52/52L.
What does this look like?
You will be exposed to the following:
Excel PivotTables
Microsoft Power Business Intelligence
Encryption & Decryption
Tableau
Excel PivotTables/PowerBI:
Excel pivot tables, such as the one displayed above, allow Excel spreadsheets to be easily converted into digestible visuals within the Excel Software.
PowerBI is a software developed by Microsoft that manipulates and visualizes data into easy-to-read charts
The best way to learn how to manipulate excel spreadsheets using PivotTables and PowerBI is to practice.
To create sample excel data to practice on, the best method I found is to use ChatGPT.
Log on or create an account with ChatGPT (you won't be able to save excel sheets without doing so)
Ask it to create a sample excel data sheet that you wish to use to practice on using PivotTables/PowerBI.
You may tweak your prompts to better fit a certain type of example you want.
Download the generated excel spreadsheet and begin to manipulate!
SQL Commands Example -- SQL Command Walk-Through Explained
DDL: CREATE TABLE table_name << the CREATE function creates the table, you provide the "table_name"
(
Column1 datatype (size), << name your columns, choose your datatype (character, variable character, number, etc) and dictate the size (how many characters are allowed to be entered).
column2 datatype (size),
);<< lastly end with ";" for syntax
>> The example below demonstrate the template with valid entries for table name, column name, datatype, and size.
CREATE TABLE Users << table name "Users"
(
UserID Varchar(256) <<column name "UserID", type "Varchar" size "256"
Name Varchar(256)<< column name "Name", type "Varchar" size "256"
);<< ending ";" for syntax
Encryption & Decryption:
Encryption & Decryption is a topic briefly covered in IS-130. Your professor will give you an encrypted message and a decryption key to convert the message from ciphertext to plain text.
SQL Commands:
SQL commands perform a variety of tasks in relation to data and databases. Their categories, as demonstrated above, can be summarized below.
DDL- Data Definition Language
Commands used to define, alter and delete database structures like tables, indexes, and schemas.
DML- Data Manipulation Language
Commands used to manipulate data present in the database
DCL- Data Control Language
Used to grant and revoke rights and privledges of access to data in the database of users
TCL- Transaction Control Language
Transactions are a sequence of SQL statements executed as a single unit of work.
TCL is used to start, save, undo. and established savepoints within transactions.
SQL Commands Example (DML- Insert)
DML INSERT INTO Users (UserID, Name,) <<"Users" is the aforementioned table we created, where we are inserting new records with values in the "UserID" and "Name" Columns
VALUES <<Syntax for the following values being inserted
('022',' Jerry'), <<syntax dictates the new record) 'syntax dictates the value of "UserID" (Order "inserted" does matter, separated by commas (,)
('023','George'), <<next record, next line, next parenthesis ()
;