Final Exam: Systems Analyst
- 1 Video | 32s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
visualize your data in the form of a column chartset up a combo chart with multiple visualizations for the same datarecognize what triggers are, implement an insert trigger, and observe its working mechanismcreate and use an update trigger, which is executed after updates to a MariaDB tableuse Plotly to render information about geographical regions by shading regions based on the value of a variableexecute commands from the DBeaver environmentportray the flow of data from a source to a destination using a Sankey chartperform basic cross and inner joins using SELECT-FROM-WHERE queriesView the distribution of values in a field by plotting a histogramcreate a plot with two charts by rendering them within subplotsinstall and launch MariaDB on macOS, then connect to it from the terminalplot a material chart to visualize the same data viewed with a column chartanalyze the detailed distribution of numeric values in a field by creating a violin plot in Plotlyrecognize the different data formats that can be loaded into Chart Studiodemonstrate how Google Charts can be customized using several properties in an options objectplot locations on a map, which can include satellite, street, or terrain informationload one of the example charts in Chart Studio to recognize the features available to visualize datause the LIKE, NOT LIKE, IN, and NOT IN keywords workoverride the default ON DELETE behavior of foreign key constraints in MariaDB tables to implement cascading deleterun a few basic SELECT-FROM-WHERE queriesuse Plotly to visualize the proportional contribution of various categories that have a hierarchical relationshipinstall and launch MariaDB on Microsoft Windows, then connect to it from the command promptassemble the pieces required to construct a simple chart using Google Chartsconstrain a child table from having any values in a column that are not in a specified column of the parent table using foreign key constraintsrecognize how default ON DELETE behavior of foreign key constraints in MariaDB works and perform a three-way joinrender a pie chart to analyze the proportion of contributions from various categoriesuse a chart editor to enable users to pick the best chart to visualize a datasetmerge related plots into a single page using a dashboard in Plotlyinstall and launch DBeaver as a user interface for MariaDB on Microsoft Windowsshare 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 readview the relationship between two variables in your dataset by plotting them in a scatter plotset up an interactive chart with control within a Google Charts dashboardrecognize different aggregate functions within GROUP BY queries and work with the HAVING clause to filter results of GROUP BY operationsuse the Falcon client to integrate Chart Studio with the results of a query against a relational databaseillustrate the basic usage of the DISTINCT and GROUP BY keywordsplot the variations in the price of a tradeable asset using candlestick charts in Plotlyvisualize a series of data using an area chartuse the following constraints: NOT, NULL, and UNIQUEinstall and launch DBeaver as a user interface for MariaDB on macOScombine related plots into a single page using a dashboard in Plotlyconvey details about geographical regions using an atlas map in Plotlyconvey the relationship between two fields in your dataset using a scatter chartrepresent multiple dimensions of data in your scatter plot by configuring the points that are renderedrecognize and use the BETWEEN, LIMIT, and ORDER BY keywordsillustrate the different ways in which a data table can be created and populated using the DataTable classshare your Plotly Chart Studio plotsillustrate the various customizations available for a treemapvisualize the distribution of numeric values in a field by rendering a box plot using Plotlyrender the data present in a file on Google Drive in a Google chartdefine a column chart with multiple series stacked on top of one another to recognize their individual and aggregate impactcustomize the appearance and the data displayed in a Google chartdefine a Chart Studio table using data and formatting information set in a fileuse the JOIN keyword to perform cross joins, inner joins, left outer joins, and right outer joinsconvey information related to countries by using a geo chartconvey hierarchical information in your data using a treemap visualizationUse the SOME, ALL and ANY keywords to link subqueries to outer queriesuse UNIQUE constraints in an in-depth and applied wayvisualize preexisting data in a Chart Studio data grid in the form of a bar chartlog in to the Plotly Chart Studio web console and create a new data grid
IN THIS COURSE
1.Systems Analyst33sUP NEXT
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platformDigital badges are yours to keep, forever.