Software 101 – Database Part 1

<!– wp:acf/accordion { "id": "block_5fd8c02e17d45", "name": "acf/accordion", "data": { "items_0_title": "Column", "_items_0_title": "field_5ef0c2cabd397", "items_0_description": "A column is the smallest unit of storage in a relational database. A column represents one piece of information about an object. Every column has a name and a data type. Columns are grouped into rows, and rows are grouped into tables. In Figure 1.1, the shaded area depicts a single column.rnrn“, “_items_0_description”: “field_5ef0c2d6bd398”, “items_1_title”: “Comment”, “_items_1_title”: “field_5ef0c2cabd397”, “items_1_description”: “A description or comment you might leave for yourself or someone else. You need to use a double dash (–) to trigger a comment. Comments will appear in green text.rnrn“, “_items_1_description”: “field_5ef0c2d6bd398”, “items_2_title”: “Inner Join”, “_items_2_title”: “field_5ef0c2cabd397”, “items_2_description”: “An advanced action where you can join all rows from multiple participating tables as long as there is a match between the columns. For example you can join the Company table with the Folder table because the CompanyID column appears in both.rnrn“, “_items_2_description”: “field_5ef0c2d6bd398”, “items_3_title”: “Insert”, “_items_3_title”: “field_5ef0c2cabd397”, “items_3_description”: “The Insert is an advanced action where a SQL command is used to add a new record to a table within a database.“, “_items_3_description”: “field_5ef0c2d6bd398”, “items_4_title”: “Null”, “_items_4_title”: “field_5ef0c2cabd397”, “items_4_description”: “The Null SQL keyword is used to represent a missing value.“, “_items_4_description”: “field_5ef0c2d6bd398”, “items_5_title”: “Query”, “_items_5_title”: “field_5ef0c2cabd397”, “items_5_description”: “A query is a type of command that retrieves data from the server.rnrn“, “_items_5_description”: “field_5ef0c2d6bd398”, “items_6_title”: “Row”, “_items_6_title”: “field_5ef0c2cabd397”, “items_6_description”: “A row is a collection of column values. Every row in a table has the same shape (in other words, every row is composed of the same set of columns). If you are trying to model a real-world application, a row represents a real-world object.rnrn“, “_items_6_description”: “field_5ef0c2d6bd398”, “items_7_title”: “Stored Procedure”, “_items_7_title”: “field_5ef0c2cabd397”, “items_7_description”: “Stored Procedure is a set of SQL statements stored within a database server and is generally used as it contains ‘guard rails’ to allow the End User Operations team make Updates without potentially breaking something.rnrn“, “_items_7_description”: “field_5ef0c2d6bd398”, “items_8_title”: “Table”, “_items_8_title”: “field_5ef0c2cabd397”, “items_8_description”: “A table is a collection of rows. A table usually has a name, although some tables are temporary and exist only to carry out a command. All the rows in a table have the same shape (in other words, every row in a table contains the same set of columns).rnrn“, “_items_8_description”: “field_5ef0c2d6bd398”, “items_9_title”: “Update”, “_items_9_title”: “field_5ef0c2cabd397”, “items_9_description”: “The Update is a SQL command used to edit/update existing records in a database table. Tier 1 End User Ops reps don’t have access to do this. Some Tier 2 and 3 reps have more access to make updates to existing records in the database. rnrn“, “_items_9_description”: “field_5ef0c2d6bd398”, “items”: 10, “_items”: “field_5ef0c2adbd396”, “theme”: “light”, “_theme”: “field_5ef3632662671”, “background_color”: “”, “_background_color”: “field_5ef363a95a6d4” }, “align”: “wide”, “mode”: “edit” } /–>