\n
\n
Create tables in a database and ALTER columns in the table.<\/div>\n<\/div>\n<\/li>\n
\n
\n
Know what data type to use in various situations, and use functions to manipulate date, number and string data values.<\/div>\n<\/div>\n<\/li>\n
\n
\n
Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.<\/div>\n<\/div>\n<\/li>\n
\n
\n
JOIN two or more tables together, finding missing data.<\/div>\n<\/div>\n<\/li>\n
\n
\n
INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.<\/div>\n<\/div>\n<\/li>\n
\n
\n
Create constraints, views and triggers<\/div>\n<\/div>\n<\/li>\n
\n
\n
Use UNION, CASE, MERGE, procedures and error checking<\/div>\n<\/div>\n<\/li>\n
\n
\n
Apply ranking and analytic functions, grouping, geography and geometry database<\/div>\n<\/div>\n<\/li>\n
\n
\n
Create sub-queries and CTEs, PIVOTs, UDFs, APPLYs, synonyms.<\/div>\n<\/div>\n<\/li>\n
\n
\n
Create reports and\u00a0 Subscriptions<\/div>\n<\/div>\n<\/li>\n
\n
\n
Extract , Transform, and Load data from different sources<\/div>\n<\/div>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n
Requirements<\/h2>\n
- \n
  \n
  You need to know how to use a computer, and hopefully know how to use a spreadsheet.<\/div>\n<\/div>\n<\/li>\n
- \n
  \n
  No prior knowledge of SQL Server required.<\/div>\n<\/div>\n<\/li>\n
- \n
  \n
  The course software cannot be installed on a Mac computer. A windows PC or laptop is required with windows 10 OS or later.<\/div>\n<\/div>\n<\/li>\n
- \n
  \n
  Why not have a look at the curriculum on the next tab and see what you can learn?<\/div>\n<\/div>\n<\/li>\n<\/ul>\n
  Description<\/strong><\/h2>\n
  SQL (S<\/strong>tructured\u00a0Q<\/strong>uery\u00a0L<\/strong>anguage) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like\u00a0business intelligence\u00a0<\/strong>and\u00a0big data<\/strong>\u00a0become more familiar, businesses will need more people to learn the SQL language and in-depth reporting skills.<\/p>\n
  This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.<\/p>\n
  It will teach you how to create reports using T-SQL, SQL Server Reporting Services (SSRS) including dashboards with interactive visualizations objects.<\/p>\n
  It will teach you how to integrate data from different sources, combine them into one location, clean them and organize them accordingly using Microsoft Visual Studio (SSIS).<\/p>\n
  It will teach you how to read and interpret technical requirements and be able to deliver effective solutions.<\/p>\n
  It will teach you about most of the tools that are currently being used by companies.<\/p>\n
  You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems and links to reading or video materials to help reinforce what you learn in the video tutorials.<\/p>\n
  <\/p>\n","protected":false},"excerpt":{"rendered":"
  Who this course is for: Anyone looking to start or change a career Anyone who wants to learn skills that will earn them six figures! Anyone who works with data, … <\/p>\n","protected":false},"featured_media":1391,"comment_status":"closed","ping_status":"closed","template":"","course_category":[33],"course_tag":[],"class_list":["post-1390","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-dataanalytics","course"],"_links":{"self":[{"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/lp_course\/1390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/types\/lp_course"}],"replies":[{"embeddable":true,"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/comments?post=1390"}],"version-history":[{"count":1,"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/lp_course\/1390\/revisions"}],"predecessor-version":[{"id":1579,"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/lp_course\/1390\/revisions\/1579"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/media\/1391"}],"wp:attachment":[{"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/media?parent=1390"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/course_category?post=1390"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/lolikacademy.com\/wp-json\/wp\/v2\/course_tag?post=1390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}