Final Exam: Systems Analyst
1 Video | 30m 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
analyze the detailed distribution of numeric values in a field by creating a violin plot in Plotlyassemble the pieces required to construct a simple chart using Google Chartscombine related plots into a single page using a dashboard in Plotlyconfigure the axes of a plot to make them more prominent and make your charts easier to readconstrain a child table from having any values in a column that are not in a specified column of the parent table using foreign key constraintsconvey details about geographical regions using an atlas map in Plotlyconvey hierarchical information in your data using a treemap visualizationconvey information related to countries by using a geo chartconvey the relationship between two fields in your dataset using a scatter chartcreate and use an update trigger, which is executed after updates to a MariaDB tablecreate a plot with two charts by rendering them within subplotscustomize the appearance and the data displayed in a Google chartdefine a Chart Studio table using data and formatting information set in a filedefine a column chart with multiple series stacked on top of one another to recognize their individual and aggregate impactdemonstrate how Google Charts can be customized using several properties in an options objectexecute commands from the DBeaver environmentillustrate the basic usage of the DISTINCT and GROUP BY keywordsillustrate the different ways in which a data table can be created and populated using the DataTable classillustrate the various customizations available for a treemapinstall and launch DBeaver as a user interface for MariaDB on macOSinstall and launch DBeaver as a user interface for MariaDB on Microsoft Windowsinstall and launch MariaDB on macOS, then connect to it from the terminalinstall and launch MariaDB on Microsoft Windows, then connect to it from the command promptload one of the example charts in Chart Studio to recognize the features available to visualize datalog in to the Plotly Chart Studio web console and create a new data gridmerge related plots into a single page using a dashboard in Plotlyoverride the default ON DELETE behavior of foreign key constraints in MariaDB tables to implement cascading deleteperform basic cross and inner joins using SELECT-FROM-WHERE queriesplot a material chart to visualize the same data viewed with a column chartplot locations on a map, which can include satellite, street, or terrain information
plot the variations in the price of a tradeable asset using candlestick charts in Plotlyportray the flow of data from a source to a destination using a Sankey chartrecognize and use the BETWEEN, LIMIT, and ORDER BY keywordsrecognize different aggregate functions within GROUP BY queries and work with the HAVING clause to filter results of GROUP BY operationsrecognize how default ON DELETE behavior of foreign key constraints in MariaDB works and perform a three-way joinrecognize the different data formats that can be loaded into Chart Studiorecognize what triggers are, implement an insert trigger, and observe its working mechanismrender a pie chart to analyze the proportion of contributions from various categoriesrender the data present in a file on Google Drive in a Google chartrepresent multiple dimensions of data in your scatter plot by configuring the points that are renderedrun a few basic SELECT-FROM-WHERE queriesset up a combo chart with multiple visualizations for the same dataset up an interactive chart with control within a Google Charts dashboardshare your Plotly Chart Studio plotsshare your Plotly Chart Studio plots and data with viewers and collaboratorsuse a chart editor to enable users to pick the best chart to visualize a datasetuse Plotly to render information about geographical regions by shading regions based on the value of a variableuse Plotly to visualize the proportional contribution of various categories that have a hierarchical relationshipuse the Falcon client to integrate Chart Studio with the results of a query against a relational databaseuse the following constraints: NOT, NULL, and UNIQUEuse the JOIN keyword to perform cross joins, inner joins, left outer joins, and right outer joinsuse the LIKE, NOT LIKE, IN, and NOT IN keywords workUse the SOME, ALL and ANY keywords to link subqueries to outer queriesuse UNIQUE constraints in an in-depth and applied wayView the distribution of values in a field by plotting a histogramview the relationship between two variables in your dataset by plotting them in a scatter plotvisualize a series of data using an area chartvisualize preexisting data in a Chart Studio data grid in the form of a bar chartvisualize the distribution of numeric values in a field by rendering a box plot using Plotlyvisualize your data in the form of a column chart
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.