Final Exam: Systems Analyst

Google | Plotly | MariaDB    |    Intermediate
  • 1 video | 32s
  • Includes Assessment
  • Earns a Badge
Likes 5 Likes 5
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.


  • 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



Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.