Final Exam: Systems Analyst

WHAT YOU WILL LEARN

• 

  Visualize your data in the form of a column chart
  

  set up a combo chart with multiple visualizations for the same data
  

  recognize what triggers are, implement an insert trigger, and observe its working mechanism
  

  create and use an update trigger, which is executed after updates to a mariadb table
  

  use plotly to render information about geographical regions by shading regions based on the value of a variable
  

  execute commands from the dbeaver environment
  

  portray the flow of data from a source to a destination using a sankey chart
  

  perform basic cross and inner joins using select-from-where queries
  

  view the distribution of values in a field by plotting a histogram
  

  create a plot with two charts by rendering them within subplots
  

  install and launch mariadb on macos, then connect to it from the terminal
  

  plot a material chart to visualize the same data viewed with a column chart
  

  analyze the detailed distribution of numeric values in a field by creating a violin plot in plotly
  

  recognize the different data formats that can be loaded into chart studio
  

  demonstrate how google charts can be customized using several properties in an options object
  

  plot locations on a map, which can include satellite, street, or terrain information
  

  load one of the example charts in chart studio to recognize the features available to visualize data
  

  use the like, not like, in, and not in keywords work
  

  override the default on delete behavior of foreign key constraints in mariadb tables to implement cascading delete
  

  run a few basic select-from-where queries
  

  use plotly to visualize the proportional contribution of various categories that have a hierarchical relationship
  

  install and launch mariadb on microsoft windows, then connect to it from the command prompt
  

  assemble the pieces required to construct a simple chart using google charts
  

  constrain a child table from having any values in a column that are not in a specified column of the parent table using foreign key constraints
  

  recognize how default on delete behavior of foreign key constraints in mariadb works and perform a three-way join
  

  render a pie chart to analyze the proportion of contributions from various categories
  

  use a chart editor to enable users to pick the best chart to visualize a dataset
  

  merge related plots into a single page using a dashboard in plotly
  

  install and launch dbeaver as a user interface for mariadb on microsoft windows
  

  share your plotly chart studio plots and data with viewers and collaborators
• 

  configure the axes of a plot to make them more prominent and make your charts easier to read
  

  view the relationship between two variables in your dataset by plotting them in a scatter plot
  

  set up an interactive chart with control within a google charts dashboard
  

  recognize different aggregate functions within group by queries and work with the having clause to filter results of group by operations
  

  use the falcon client to integrate chart studio with the results of a query against a relational database
  

  illustrate the basic usage of the distinct and group by keywords
  

  plot the variations in the price of a tradeable asset using candlestick charts in plotly
  

  visualize a series of data using an area chart
  

  use the following constraints: not, null, and unique
  

  install and launch dbeaver as a user interface for mariadb on macos
  

  combine related plots into a single page using a dashboard in plotly
  

  convey details about geographical regions using an atlas map in plotly
  

  convey the relationship between two fields in your dataset using a scatter chart
  

  represent multiple dimensions of data in your scatter plot by configuring the points that are rendered
  

  recognize and use the between, limit, and order by keywords
  

  illustrate the different ways in which a data table can be created and populated using the datatable class
  

  share your plotly chart studio plots
  

  illustrate the various customizations available for a treemap
  

  visualize the distribution of numeric values in a field by rendering a box plot using plotly
  

  render the data present in a file on google drive in a google chart
  

  define a column chart with multiple series stacked on top of one another to recognize their individual and aggregate impact
  

  customize the appearance and the data displayed in a google chart
  

  define a chart studio table using data and formatting information set in a file
  

  use the join keyword to perform cross joins, inner joins, left outer joins, and right outer joins
  

  convey information related to countries by using a geo chart
  

  convey hierarchical information in your data using a treemap visualization
  

  use the some, all and any keywords to link subqueries to outer queries
  

  use unique constraints in an in-depth and applied way
  

  visualize preexisting data in a chart studio data grid in the form of a bar chart
  

  log in to the plotly chart studio web console and create a new data grid