I was thinking about drawing a coral reef for this prompt, but with the last-spurt note-taking that I did just now, my brain’s shot. Here’s a soft Corsola from Pokemon. Let’s be comfy.
Key Terms List Triggers Event types (DML, DDL, database start/close, user logon/off) Trigger types (Database, Application) Trigger Status (Enabled, Disabled) User Authentication Database User Object – Acts as an interface between a person/application and the database Default/Temporary Tablespace User Profile (Password Profile): named set of resource limits on database usage. Also manages account stats &Continue reading “Triggers and Creating Users | Review Notes | Year 2-1 | DBAS”
Key Terms List Functions Stored Functions Function Side Effects Packages Components of a Package Package Specification Package Body Bodiless Packages Data Dictionary views: USER_SOURCE, ALL_SOURCE Functions Can accept parameters, be invoked, and return a value Usually used to compute values Must return a value Compared to procedures, which are not required to return a value.Continue reading “Functions and Packages | Review Notes | Year 2-1 | DBAS”
Keywords:– Procedures: A PL/SQL subprogram that can take in parameters– Procedure Header: Contains the procedure’s name and parameters– Procedure Body: Contains the procedure’s PL/SQL Block– Parameters: Used to pass or communicate data between the subprogram and its caller– Formal Parameter: variables declared in a subprogram’s header– Actual Parameter: the values passed into a subprogram fromContinue reading “Procedures | Review Notes | Year 2-1 | DBAS”
Keywords:– PL/SQL: “Procedural Language extension to SQL”: Standard data access for RDBAS developed by Oracle.– Declaration/Executable/Exception Sections: Base sections for PL/SQL blocks– Block: Anonymous, Function, Procedure, etc. Blocks.– Subprogram: A named PL/SQL block that can be called with parameters (Procedures, Functions)– Procedure: Subprogram that does not return a value– Function: Subprogram that must return aContinue reading “Anonymous Blocks and Variables | Review Notes | Year 2-1 | DBAS”
Yay, I’m having midterms this week and in two weeks~ I’m going to start doing review with notes on this site. The posts are going to get a lot more diverse now…
I’m not going to lie, the way I coloured in the hair is really off (not to mention everything else, but…). Midterms, assignment deadlines… I’m really feeling today’s prompt. I’m actually not that swamped, but it’s been feeling strangely hectic and busy for some reason… Just feeling stressed by deadlines I guess. I just wantContinue reading “Inktober | Inktober 2020 | Dizzy | Mood”
There’s this Youtuber I liked and started following two years ago. I found today that she’s probably not going to make any more videos or stream. I only just found out she used to stream too. Feeling a little blue.
Another prompt, another reference. This one’s from a scene from Life is Strange. It’s from the beginning, if I remember correctly. I got really lazy with the shading, the only thing I put some effort into was the lighthouse, and even that isn’t very recognizable…i wonder how to create a blur effect using pens. YetContinue reading “Inktober | Inktober 2020 | Storm | Lazy Nigtmare”
Didn’t really feel like drawing anything related to an actual rocket, so I just decided to try and draw a simplified version of Rocket from Guardians of the Galaxy. Midterms are coming up soon, so this site’s going to see a lot more notes… I hope I can keep up a drawing a day though…Continue reading “Inktober | Inktober 2020 | Rocket | Grumpy Raccoon”