{"id":715,"date":"2020-05-06T23:04:16","date_gmt":"2020-05-06T15:04:16","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=715"},"modified":"2020-05-06T23:07:42","modified_gmt":"2020-05-06T15:07:42","slug":"getting-started-with-sql-data-analysis","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/getting-started-with-sql-data-analysis\/","title":{"rendered":"Getting started with SQL Data Analysis"},"content":{"rendered":"<p>To create an analysis table from a data set using <a href=\"https:\/\/www.yohz.com\/sda_details.htm\">SQL Data Analysis<\/a>, here are the basic steps to follow:<\/p>\n<h2>Connect to your database<\/h2>\n<p>Click on the Run SQL query item from the <a href=\"https:\/\/www.yohz.com\/sda_details.htm\">SQL Data Analysis<\/a> main screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-705\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01.png\" alt=\"\" width=\"931\" height=\"667\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01.png 931w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01-300x215.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01-768x550.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01-624x447.png 624w\" sizes=\"(max-width: 931px) 100vw, 931px\" \/><\/p>\n<p>Click on the <strong>Connect to a database<\/strong> item in the <strong>Database Connections<\/strong> panel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-717 alignnone\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps01.png\" alt=\"\" width=\"567\" height=\"320\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps01.png 567w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps01-300x169.png 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/p>\n<p>Enter the connection details in the <strong>Connect to Database<\/strong> window and click <strong>Connect<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-718 alignnone\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps02.png\" alt=\"\" width=\"426\" height=\"541\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps02.png 426w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps02-236x300.png 236w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/p>\n<h2>Run your SQL query<\/h2>\n<p>Enter the query you want to run in the SQL editor window for your connection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-721\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps05.png\" alt=\"\" width=\"920\" height=\"307\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps05.png 920w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps05-300x100.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps05-768x256.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps05-624x208.png 624w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/p>\n<p>Click on the <strong>Execute query<\/strong> button to run your query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-722\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps06.png\" alt=\"\" width=\"920\" height=\"307\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps06.png 920w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps06-300x100.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps06-768x256.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps06-624x208.png 624w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/p>\n<p>Once the data set has been retrieved, click on the <strong>Add data sets<\/strong> button to create an analysis table using that data set.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-723\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps07.png\" alt=\"\" width=\"920\" height=\"549\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps07.png 920w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps07-300x179.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps07-768x458.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_steps07-624x372.png 624w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/p>\n<p>See also:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.yohz.com\/blogs\/2020\/05\/06\/using-analysis-tables\/\">using analysis tables<\/a><\/li>\n<li><a href=\"http:\/\/www.yohz.com\/blogs\/2020\/05\/06\/connecting-to-your-database-in-sql-data-analysis\/\">supported database engines in SQL Data Analysis<\/a><\/li>\n<li><a href=\"http:\/\/www.yohz.com\/blogs\/2020\/05\/06\/697\/\">running queries on the used\/internal data sets<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/getting-started-with-sql-data-analysis\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/getting-started-with-sql-data-analysis\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>To create an analysis table from a data set using SQL Data Analysis, here are the basic steps to follow: Connect to your database Click on the Run SQL query item from the SQL Data Analysis main screen. Click on the Connect to a database item in the Database Connections panel. Enter the connection details [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[86],"tags":[97,98,87],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/715"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=715"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/715\/revisions"}],"predecessor-version":[{"id":726,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/715\/revisions\/726"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}