{"id":50003,"date":"2022-09-28T00:07:38","date_gmt":"2022-09-27T23:07:38","guid":{"rendered":"https:\/\/www.trucnet.com\/?p=50003"},"modified":"2022-09-28T00:07:38","modified_gmt":"2022-09-27T23:07:38","slug":"101-requetes-pour-maitriser-sql","status":"publish","type":"post","link":"https:\/\/www.trucnet.com\/en\/101-requetes-pour-maitriser-sql\/","title":{"rendered":"101 queries to master SQL"},"content":{"rendered":"

With this course, you will learn SQL and how databases work, create and manage a MySQL database, and perform CRUD and complex SELECT queries. You can also download 40 algorithmic exercises (pseudo-code)<\/a>.
\nThese courses are intended for and important for computer science students or future students, web developers (or not), self-taught developers and other developers.<\/p>\n

You will begin by taking a look at the basics:<\/strong>
\n\u2013 Define basic queries using the keywords SELECT and FROM
\n\u2013 Add filters to our queries using the WHERE clause
\n\u2013 Perform calculations using the functions provided by MySQL
\n\u2013 String manipulation using MySQL functions<\/p>\n

Perform joins on multiple tables<\/strong>
\n\u2013 Use of external joins (LEFT JOIN \/ RIGHT JOIN)
\n\u2013 Grouping information using the keywords GROUP BY and HAVING
\nNested query application<\/p>\n

You will learn how to manage the database using:<\/strong>
\n\u2013 Scheduling management queries: create\/modify\/delete
\n\u2013 Queue management queries: insert\/update\/delete<\/p>\n

\n

Format:<\/strong><\/span> MP4
\nLanguage :<\/strong><\/span>\u00a0French
\nDuration :<\/strong><\/span> 3 hours
\nSize<\/span> :<\/strong> 1.37 GB<\/p>\n

\n

101 queries to master SQL<\/strong><\/h4>\n

<\/i> DOWNLOAD Uptobox server<\/small><\/span><\/a><\/p>\n

<\/i> DOWNLOAD Server 1File<\/small><\/span><\/a><\/p>\n

<\/i> DOWNLOAD Uploadrar Server<\/small><\/span><\/a><\/p>\n

<\/i> DOWNLOAD Krakenfiles Server<\/small><\/span><\/a><\/p>","protected":false},"excerpt":{"rendered":"

With this course, you will learn SQL and how databases work, create and manage a MySQL database, and perform CRUD and complex SELECT queries. You can also download 40 algorithmic (pseudocode) exercises. These courses are designed for and are essential for computer science students or prospective students, developers [\u2026]<\/p>","protected":false},"author":1,"featured_media":50007,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"no","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[25],"tags":[9557,9558,9559,9560],"class_list":["post-50003","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-astuces-infos","tag-apprendrez-sql","tag-cours-sql","tag-formation-base-de-donnees","tag-requetes-de-base"],"aioseo_notices":[],"modified_by":"Auteur","_links":{"self":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/posts\/50003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/comments?post=50003"}],"version-history":[{"count":0,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/posts\/50003\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/media\/50007"}],"wp:attachment":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/media?parent=50003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/categories?post=50003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/tags?post=50003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}