Final Exam: Systems Analyst
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
Final Exam: Systems Analyst will test your knowledge and application of the topics presented throughout the Systems Analyst track of the Skillsoft Aspire Business Analyst to Data Analyst Journey.
Expected Duration (hours)
0.0
Lesson Objectives Final Exam: Systems Analyst
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
Course Number: it_febada_03_enus
Expertise Level
Intermediate