Embedded Files
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 ()
;
Report abuse