{"id":5360,"date":"2019-04-09T16:26:46","date_gmt":"2019-04-09T08:26:46","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=5360"},"modified":"2020-03-16T14:59:52","modified_gmt":"2020-03-16T06:59:52","slug":"learning-sql-to-get-started-with-finereport-faster","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/learning-sql-to-get-started-with-finereport-faster.html","title":{"rendered":"Learning SQL to Get Started with FineReport Faster"},"content":{"rendered":"\r\n\r\n<a href=\"http:\/\/www.finereport.com\/en\/\">FineReport<\/a>\u00a0adopt a simple drag-and-drop operation mode. If you know how to use Excel, you have a basic grasp of the operation of FineReport. The beginners can quickly create a web report without additional learning or code base. However, if you&#8217;re looking to advance your career as a database developer, administrator or analyst, SQL (Structured Query Language) skills are a necessity.\r\n\r\n\r\n\r\n\r\n<div id=\"toc_container\" class=\"toc_transparent no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#1What_is_SQL\">1.\u00a0What is SQL?<\/a><\/li><li><a href=\"#2_Why_do_you_need_to_learn_a_little_about_SQL\">2. Why do you need to learn a little about SQL?<\/a><\/li><li><a href=\"#3_How_to_learn_SQL_by_yourself\">3. How to learn SQL by yourself?<\/a><ul><li><a href=\"#1_Watch_Tutorials\">1) Watch Tutorials<\/a><\/li><li><a href=\"#2_Install_a_SQL_Database\">2) Install a SQL Database<\/a><\/li><li><a href=\"#3_Practice\">3) Practice<\/a><\/li><\/ul><\/li><li><a href=\"#Tips\">Tips:<\/a><\/li><li><a href=\"#Reference\">Reference<\/a><\/li><li><a href=\"#Related_Articles\">Related Articles<\/a><\/li><\/ul><\/div>\n<h2 id=\"id-190409-\u5b98\u7f51-LearningSQLtoGetStartedwithFineReportFaster-En-1.WhatisSQL?\"><span id=\"1What_is_SQL\"><strong>1.\u00a0What is SQL?<\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n\r\nSQL\u00a0(Structured Query Language)\u00a0is a\u00a0domain-specific language\u00a0used in programming and designed for managing data held in a\u00a0relational database management system, or for stream processing in a\u00a0relational data stream management system.\u00a0It is particularly useful in handling\u00a0structured data\u00a0where there are relations between different entities\/variables of the data.\r\n\r\n\r\n\r\n\r\n\r\nSQL was initially developed by IBM and Relational Software, Inc. (now Oracle) in the early 1970s. It became an ANSI standard in 1986 and an ISO standard in 1987. Now the SQL standard has evolved to include an increasing number of features.\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019040901A.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n\r\nSQL is designed for a specific purpose: to query\u00a0data\u00a0contained in a\u00a0relational database.\u00a0First, it introduced the concept of accessing many records with one single command; and second, it eliminates the need to specify\u00a0how\u00a0to reach a record, e.g. with or without an\u00a0index.\r\n\r\n\r\n\r\n\r\n<h2><span id=\"2_Why_do_you_need_to_learn_a_little_about_SQL\"><strong>2. Why do you need to learn a little about SQL?<\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n\r\nFineReport connects data sources through various channels. It supports the mainstream relational databases such as Oracle, SQL Server, My SQL, DB2, Sybase, Access, Derby, Postgres, Informix, as well as SQL data sheets or views, or stored procedures, so if you want to do some underlying data processing, you need to know about the database knowledge SQL.\r\n\r\n\r\n\r\n\r\n\r\nSQL is a universal coding language which doesn\u2019t require prior programming experience. But there\u2019re so many resources available for beginners to learn SQL, where should we get started?\r\n\r\n\r\n\r\n\r\n<h2 id=\"id-190409-\u5b98\u7f51-LearningSQLtoGetStartedwithFineReportFaster-En-3.HowtolearnSQLbyyourself?\"><span id=\"3_How_to_learn_SQL_by_yourself\"><strong>3. How to learn SQL by yourself?<\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n\r\nHere are a few steps you can take to start learning SQL by yourself.\r\n\r\n\r\n\r\n\r\n<h3 id=\"id-190409-\u5b98\u7f51-LearningSQLtoGetStartedwithFineReportFaster-En-1)WatchTutorials\"><span id=\"1_Watch_Tutorials\"><strong>1) Watch Tutorials<\/strong><\/span><\/h3>\r\n\r\n\r\n\r\n\r\nFirst, we need to spend some time on looking what SQL is and understand how it works.\u00a0Interactive online courses are a fast and cheap way to start SQL, and you don\u2019t have to install anything on your local workstation.\u00a0<a href=\"https:\/\/www.w3schools.com\/sql\/default.asp\">W3Schools<\/a>,\u00a0<a href=\"https:\/\/sqlzoo.net\/\">SQLZOO<\/a>\u00a0and\u00a0<a href=\"https:\/\/www.codecademy.com\/learn\/learn-sql\">Codecademy<\/a>\u00a0guide you through SQL syntax and basic SQL concepts. They also offer interactive tutorials that let you manage data and build queries to test your SQL knowledge.\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019040902A.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n\r\nYou may learn the basics of database fundamentals: tables, queries, aggregate functions, constructing advanced database queries and more.And we recommend that you focus on the most commonly used SQL commands to query a table in a database and using SQL to\u00a0perform calculations during a query, in order to start learning FineReport as soon as possible.\r\n\r\n\r\n\r\n\r\n\r\nHere we introduce some SQL query syntax that will be commonly used in FineReport. The query is the most common operation in SQL. It makes use of the declarative SELECT statement. SELECT retrieves data from one or more tables, or expressions.\r\n\r\n\r\n\r\n\r\n\r\n<strong>SELECT<\/strong>\u00a0is the most complex statement in SQL, with optional keywords and clauses that include:\r\n\r\n\r\n\r\n\r\n<ul>\r\n \t<li><strong>FROM<\/strong>: indicates the table(s) to retrieve data from.<\/li>\r\n \t<li><strong>WHERE<\/strong>: includes a comparison predicate, which restricts the rows returned by the query.<\/li>\r\n \t<li><strong>GROUP BY<\/strong>: projects rows having common values into a smaller set of rows.<\/li>\r\n \t<li><strong>HAVING<\/strong>: includes a predicate used to filter rows resulting from the GROUP BY clause.<\/li>\r\n \t<li><strong>ORDER BY<\/strong>: identifies which column[s] to use to sort the resulting data, and in which direction to sort them.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p class=\"has-drop-cap\">The following example of a\u00a0SELECT\u00a0query returns a list of expensive books. The query retrieves all rows from the\u00a0Book\u00a0table in which the\u00a0price\u00a0column contains a value greater than 100.00. And the result is sorted in ascending order by\u00a0title.<\/p>\r\n\r\n\r\n\r\n\r\n<strong>SELECT<\/strong>\u00a0*\r\n\r\n\r\n\r\n\r\n\r\n<strong>FROM<\/strong>\u00a0Book\r\n\r\n\r\n\r\n\r\n\r\n<strong>WHERE<\/strong>\u00a0price &gt; 100.00\r\n\r\n\r\n\r\n\r\n\r\n<strong>ORDER BY<\/strong>\u00a0title;\r\n\r\n\r\n\r\n\r\n<h3><span id=\"2_Install_a_SQL_Database\"><strong>2) Install a SQL Database<\/strong><\/span><\/h3>\r\n\r\n\r\n\r\n\r\nLearning SQL online has the advantage of a quick head start. But next you need to install a database and create tables to write some SELECT queries. The installation and setup is definitely a tough part for beginners.\r\n\r\n\r\n\r\n\r\n\r\nAnyway, for further practice, you need to download and install a free copy of popular databases like\u00a0SQL Server in your machine.\u00a0Now let\u2019s dig into what\u2019s available to help us install a SQL database quickly.\u00a0There are some step-by-step installation guides of MS SQL Server.\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019040903A.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n\r\nHow to\u00a0<a href=\"https:\/\/www.sqlshack.com\/step-by-step-installation-of-sql-server-2017\/\">install SQL Server 2017<\/a>\u00a0and\u00a0<a href=\"https:\/\/www.sqlshack.com\/sql-server-management-studio-step-step-installation-guide\/\">SQL Server Management Studio<\/a>?\r\n\r\n\r\n\r\n\r\n<h3 id=\"id-190409-\u5b98\u7f51-LearningSQLtoGetStartedwithFineReportFaster-En-3)Practice\"><span id=\"3_Practice\"><strong>3) Practice<\/strong><\/span><\/h3>\r\n\r\n\r\n\r\n\r\nWhen you have successfully installed the database,\u00a0you can continue your SQL journey.\u00a0\u00a0We will share some of the\u00a0best Microsoft SQL Server learning resources for both beginners and intermediate developers.\r\n\r\n\r\n\r\n\r\n<ul>\r\n \t<li><a href=\"https:\/\/mva.microsoft.com\/product-training\/sql-server#!lang=2052\">SQL Server Training Courses<\/a><\/li>\r\n \t<li><a href=\"https:\/\/www.tutorialspoint.com\/ms_sql_server\/\">MS SQL Server Tutorial<\/a><\/li>\r\n \t<li><a href=\"https:\/\/www.essentialsql.com\/learn-sql-server\/\">Here is What You\u2019ll Need to Learn SQL Server<\/a><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 id=\"id-190409-\u5b98\u7f51-LearningSQLtoGetStartedwithFineReportFaster-En-Tips:\"><span id=\"Tips\"><strong>Tips:<\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n<ul>\r\n \t<li>You don&#8217;t need to remember too much SQL syntax at first. For beginners, you can query the syntax in practice, and you will naturally master it later.<\/li>\r\n \t<li>Don&#8217;t spend too much time learning SQL before learning FineReport. Using FineReport doesn\u2019t require us to be very proficient in SQL, we can just learn some query syntax.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n\r\nWhether you&#8217;re a marketer or a developer, knowing how to program with SQL proves you can develop and maintain complex database and information solutions, and it will help you gofurther on your career path. The most important thing is that learning SQL can help you\u00a0<a href=\"http:\/\/www.finereport.com\/en\/about-finereport\/learning-path-for-finereport-beginners.html\">get started with FineReport<\/a>\u00a0faster. Let&#8217;s hurry to begin the first step!\r\n\r\nEnjoy this reading material, and we hope you\u2019ll discover the SQL ninja hidden inside you. If you have any questions, you can follow <a class=\"external-link\" href=\"https:\/\/www.facebook.com\/finereport\/\" rel=\"nofollow\">FineReport Reporting Software<\/a> on Facebook for further contact with us!\r\n\r\n\r\n\r\n\r\n<h2 id=\"id-190409-\u5b98\u7f51-LearningSQLtoGetStartedwithFineReportFaster-En-Reference\"><span id=\"Reference\"><strong>Reference<\/strong><\/span><\/h2>\r\n\r\n\r\n\r\n\r\n<a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL\">Wikipedia-SQL\u00a0<\/a>\r\n\r\n\r\n\r\n\r\n\r\n<a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL_syntax\">Wikipedia-SQL syntax<\/a>\r\n<h2 id=\"id-190409-\u5b98\u7f51-LearningSQLtoGetStartedwithFineReportFaster-En-RelatedArticles\"><span id=\"Related_Articles\"><strong>Related Articles<\/strong><\/span><\/h2>\r\n<a class=\"external-link\" href=\"http:\/\/www.finereport.com\/en\/about-finereport\/learning-path-for-finereport-beginners.html\" rel=\"nofollow\">Learning Path for FineReport Beginners<\/a>\r\n\r\n\r\n\r\n\r\n\r\n&nbsp;\r\n\r\n","protected":false},"excerpt":{"rendered":"<p>We will show you how to learn SQL by yourself to get started with FineReport faster and provides some SQL learning resources.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"yst_prominent_words":[185,204,209,207,199,203,210,202,208,206,205,214,215,211,197,212,200,198,213,201],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/5360"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=5360"}],"version-history":[{"count":10,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/5360\/revisions"}],"predecessor-version":[{"id":8631,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/5360\/revisions\/8631"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=5360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=5360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=5360"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=5360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}