{"id":33907,"date":"2024-01-29T18:07:35","date_gmt":"2024-01-29T16:07:35","guid":{"rendered":"https:\/\/xebia.com\/academy\/nl\/?post_type=course&p=33907"},"modified":"2024-01-30T15:25:01","modified_gmt":"2024-01-30T13:25:01","slug":"sql-for-data-analysis","status":"publish","type":"course","link":"https:\/\/xebia.com\/academy\/nl\/training\/sql-for-data-analysis\/","title":{"rendered":"SQL for Data Analysis"},"content":{"rendered":"\n
\n\t\t\n\t\t\t
\n\t\t\t\n
\n\t\t
\n\t\t
\n\t\n\t
\n\t\t\t\t\t
\n\t\t\t\t<\/linearGradient><\/linearGradient><\/linearGradient><\/defs><\/svg>\t\t\t<\/div>\n\t\t\n\t<\/div>\n<\/div>\t<\/div>\n\t
\n\t\t\n\n
\n\t\t\n\t\t\t
\n\t\t\t\n
\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t\n\tSQL for Data Analysis<\/strong><\/strong><\/h1>\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t

\n\t\t\t\t\t\n\t\t\t\t\t<\/span> \t\t\t\t\t<\/span>\n\t\t\t\t<\/p>\n\t\t\t\t

\n\t
\n\t\n\t\t
\n\t\t\t\n\t\t\t\t\t\t\t\tSQL\t\t\t<\/span>\n\t\t<\/div>\n\n\t\t\n\t\n\t<\/svg><\/i>\n\t\n\t<\/button>\t
\n\t\t
\n\t\t\t<\/span>\n\t\t\t\n\t\n\t<\/svg><\/i>\n\t\n\t<\/button>\t\t<\/div>\n\t<\/div>\n<\/div><\/div>

\n\tUnlock the power of data with SQL \u2013 the ultimate data management system! Learn to wield SQL like a pro, querying your data to unveil invaluable insights. Our course takes you on a journey through essential querying and data analysis techniques, empowering you to navigate databases effortlessly. Elevate your data analysis game and master the intricacies of SQL. Join us for a transformative experience in boosting your skills and confidence!<\/p>\t\t\t\t

\n\t\t\t\t\t\n\t\t\n\n\t\n\t\n\t\n<\/picture>\n\tTrainer Title<\/h2>\t<\/a>\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t
\n\t\n\t\t\t<\/a>\n<\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t
\n\t\t\t\t
\n\t\n\t
\n\t\t\n\tLooking to upskill your team(s) or organization?<\/strong><\/h2>

\n\tDiego will gladly help you further with custom training solutions.<\/p>

\n\t\t\n\n\t\n\t\n\t\n<\/picture>\t\t\n\tDiego Teunissen<\/strong>
Data and AI Training Advisor<\/h2>\t\t

\n\t+31 6 1591 4440
<\/a><\/a>Diego.Teunissen@xebia.com<\/a>
linkedin.com\/in\/diego-teunissen\/<\/a><\/p>\t<\/div>\n\t\n\t\t\tGet in touch<\/span>\n\t\n\t<\/a>\t<\/div>\n<\/div>\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n<\/div>\t\t<\/div>\n\t<\/div>\n\n\n\n

\n\t\t\n\t\t\t
\n\t\t\t\n
\n\t\n\t<\/div>\n\t\t<\/div>\n\t<\/div>\n\n\n\n
\n\t\t\n\t\t\t
\n\t\t\t\n
\n\t\n\n
\n\t\n\n
\n\t\t\n\t\t\t
\n\t\t\t\n
\n\t\n\tWhat will you learn?<\/h2><\/div>\n\t\t<\/div>\n\t<\/div>\n\n\n\n
\n\t\t\n\t\t\t
\n\t\t\t\n
\n\t\t\t

\n\tAfter the training, you will be able to:<\/p>\t

\n\t\t\n\n
\n\t\n\t<\/svg><\/i>

\n\tExplain what a SQL is as language and database management system<\/p><\/div>\n\n\n\n

\n\t\n\t<\/svg><\/i>

\n\tPerform different kinds of joins – such as LEFT JOIN and INNER JOIN – to combine data from different locations<\/p><\/div>\n\n\n\n

\n\t\n\t<\/svg><\/i>

\n\tQuery data using statements such as SELECT, WHERE, GROUP BY and CASE WHEN, to gather key insights from data <\/p><\/div>\n\n\n\n

\n\t\n\t<\/svg><\/i>

\n\tApply efficient SQL practices – such as common table expressions (CTEs) – to improve code readability and workflow<\/p><\/div>\n\n\t<\/div>\n<\/div>\n\t\t<\/div>\n\t<\/div>\n\n<\/div>\n\n<\/div>\n\t\t<\/div>\n\t<\/div>\n\n\n\n

\n\t\t\n\t\t\t
\n\t\t\t\n
\n\t\n\n
\n\t\n\n
\n\t\t\n\t\t\t
\n\t\t\t\n
\n\t\n\tProgram<\/h2><\/div>\n\t\t<\/div>\n\t<\/div>\n\n<\/div>\n\n\n\n
\n\t\n\n
\n\t\t\n\t\t\t
\n\t\t\t\n\n\t\t\n\n
\n\t