Sqlcourse2.com Website Review

Make info private

Sqlcourse2.com receives about 51207 visitors in one month. That could possibly earn $256.04 each month or $8.53 each day. Server of the website is located in the United States. Sqlcourse2.com main page was reached and loaded in 0.69 seconds. This is a good result. Try the services listed at the bottom of the page to search for available improvements.

Traffic and Value

Is sqlcourse2.com legit?
Website Value	$4609
Alexa Rank	353656
Monthly Visits	51207
Daily Visits	1707
Monthly Earnings	$256.04
Daily Earnings	$8.53

Click Here for Full Review

Sqlcourse2.com Server Location

Country: United States
Metropolitan Area: Not defined
Postal Reference Code: Not defined
Latitude: 37.751
Longitude: -97.822

The United States is a good location for your server if your website will be receiving most or at least decent part of visitors from Northern America. If you are planning to target mostly other regions you should consider using CDN or changing your server location.

Summarized Content

more advanced easy-to-follow SQL Instruction and the ability to practice what you learn on-line with immediate feedback! You will receive immediate results on a web page after submitting your SQL Commands. This continuation course will provide you with critical need-to-know advanced features and clauses of the SELECT statement that weren't supported in the previous SQLCourse.com site. Everything you learn here will be ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. If you're already familar with the basics of SQL, you can still use this as a refresher, and practice some SQL statements. ADVERTISER DISCLOSURE: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.

Sqlcourse2 Main Page Content

HTML Tag	Content	Informative?
Title:	SQLCourse2 - Advanced Online SQL	Could be improved
Description:	SQLCourse.com: an interactive online training course for SQL	Could be improved
H1:	SQL Command Executed+responseText+); window.scrollTo(0, 0); } function bu

Do you own sqlcourse2 website?

We've noticed that you have issues with some content elements on the main page:
• Title contains 41 characters. We think that you could improve this tag by adding more relevant information or keywords.
• Description tag could contain more content. We detected that this tag contains 71 characters and this is a small volume for a description.
• Take a look at the headings; there might be too little information. Headings are important for usability and search engine optimization.

Other Helpful Websites and Services for Sqlcourse2

Results will appear here

Pingdom - Web transfer-speed test from Pingdom
Run diagnostic transfer-rate tests on each page or individual page components (JS, .img, and HTML code) with Pingdom for sqlcourse2.com
Google’s Web Analytics Google provides many analytical tools for the web that will help you find out the number of visitors, their locations and activities when logging onto sqlcourse2.com
Alexa - sqlcourse2.com on Alexa Traffic Rank Data
Alexa provides a charting service that shows global position by audience, engagement, and time spent on sqlcourse2.com
Majestic Backlinks - Lookup other webpages that have hyperlinks leading to sqlcourse2.com.
Google Index - Which of the pages is Google.com indexing?
Find out which pages from sqlcourse2.com have made it into Google.com’s listings. You can find out with the "site:" query.
Website on this IP by Bing - All sites on the same 70.42.23.51 IP
View a list of websites with an IP matching that of sqlcourse2.com from Bing.com

Internal Pages

/intro2.html:
Title	Introduction \| SQLCourse - Advanced Online SQL Training
Description	This Intermediate/Advanced SQL Tutorial will cover the SELECT statement in great detail. The SELECT statement is the core of SQL, and it is likely that the vast majority of your SQL commands will be SELECT statements. Due to the enormous amount of options available for the SELECT statement, this entire tutorial has been dedicated to it.
H1	SQL Command Executed+responseText+); window.scrollTo(0, 0); } function buildAjaxForm(){ var options = { beforeSubmit: showRequest, success: showResponse }; jQuery('div#content form').ajaxForm(options); } window.qs={consent:{ready:false,service:{dfp:{dc:false},krux:{dc:false,al:false,tg:false,cd:false,sh:false,re:false},ml:{dc:false}}},dfp:{ready:false},krux:{dn:'',jf:'',dr:'',ir:'',noer:''}};function gDFPC(e){var n=e+=;var ca=do ent.cookie.split(';');for(var i=0;i;}var e=t+-+a;var r= ;if(d){r+=d;}r+= googletag.display('+e+'); ;if(c){r+=#+e+_ad_container { height: 0px; } ;}return r;} console.log('QS: Evidon Code'); (function (id) { function append(scriptid, url, async) { var d = do ent, sn = 'script', f = d.getElementsByTagName(sn)[0]; if (!f) f = d.head; var s = d.createElement(sn); s.async = true; s.id = scriptid; s.src = url; f.parentNode.insertBefore(s, f); } function getRootDomain() { var parts = window.location.hostname.split('.'); if (parts.length === 2) rootDomain = parts[0]; else if (parts.length > 2) { // see if the next to last value is a common tld var part = parts[parts.length - 2]; if (part === 'com' \|\| part === 'co') { rootDomain = parts[parts.length - 3]; // go back one more } else { rootDomain = part; } } return rootDomain; } window.evidon = {}; window.evidon.id = id; var cdn = '//c.evidon.com/', rootDomain = getRootDomain(), noticecdn = cdn + 'sitenotice/'; append('evidon-notice', noticecdn + 'evidon-sitenotice-tag.js', false); append('evidon-location', cdn + 'geo/country.js', true); append('evidon-themes', noticecdn + id + '/snthemes.js', true); if (rootDomain) append('evidon-settings', noticecdn + id + '/' + rootDomain + '/settings.js', true); window.evidon.priorConsentCallback = function () { // add the tags which need to wait for prior consent // here. This should be all your advertising tags and // probably most of your social and tracking tags. // QS globals window.qs.consent.ready = true; } window.evidon.closeCallback = function () { // this is executed when a user closes a UI element (banner/barrier) without // providing consent. // QS globals window.qs.consent.ready = true; } window.evidon.consentWithdrawnCallback = function () { // this is exeucted if the user withdraws consent and elects to // no longer allow technologies to run on the site. // QS globals window.qs.consent.ready = true; } window.evidon.consentDeclinedCallback = function () { // this is executed if the user explicitly declines giving consent by // using a Decline on // QS globals window.qs.consent.ready = true; }})(704); window.qs.krux.dn=gDFPC('dn'),window.qs.krux.jf=gDFPC('jf'),window.qs.krux.dr=gDFPC('dr'),window.qs.krux.ir=gDFPC('ir'),window.qs.krux.noer=gDFPC('noer'); console.log('QS: Krux Interchange Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments);}).q=[]);(function(){function retrieve(n){var k='kx'+''+n,ls=(function(){try{return window.localStorage;}catch(e){return null;}})();if(ls){return ls[k]\|\|'';}else if(navigator.cookieEnabled){var m=do ent.cookie.match(k+'=([^;])');return (m&&unescape(m[1]))\|\|'';}else{return '';}}Krux.user=retrieve('user');Krux.segments=retrieve('segs')?retrieve('segs').split(','):[];})(); console.log('QS: Krux Control Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments)}).q=[]);(function(){var k=do ent.createElement('script');k.type='text/ ascript';k.async=true;k.src=(location.protocol==='https:'?'https:':'http:')+'//cdn.krxd.net/controltag/Jd_NLuX7.js';var s=do ent.getElementsByTagName('script')[0];s.parentNode.insertBefore(k,s);}()); console.log('QS: Krux Data Layer'); var kruxDataLayer={page:{domain:www.sqlcourse2.com,section:intro2.html,category:intro2.html,keywords:database professional sql dba interactive online beginners training,url_path_1:http://www.sqlcourse2.com/intro2.html},user:{dn:'',jf:'',dr:'',ir:'',noer:''}};if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof window.qs.krux.dn!='undefined'&&window.qs.krux.dn!='null'){kruxDataLayer.user.dn=window.qs.krux.dn;}if(typeof window.qs.krux.jf!='undefined'&&window.qs.krux.jf!='null'){kruxDataLayer.user.jf=window.qs.krux.jf;}if(typeof window.qs.krux.dr!='undefined'&&window.qs.krux.dr!='null'){kruxDataLayer.user.dr=window.qs.krux.dr;}if(typeof window.qs.krux.ir!='undefined'&&window.qs.krux.ir!='null'){kruxDataLayer.user.ir=window.qs.krux.ir;}if(typeof window.qs.krux.noer!='undefined'&&window.qs.krux.noer!='null'){kruxDataLayer.user.noer=window.qs.krux.noer;}} console.log('QS: Krux Consent Tag'); Krux('consent:set',{dc:window.qs.consent.service.krux.dc,al:window.qs.consent.service.krux.al,tg:window.qs.consent.service.krux.tg,cd:window.qs.consent.service.krux.cd,sh:window.qs.consent.service.krux.sh,re:window.qs.consent.service.krux.re},function(errors,body){if(errors){console.error('QS: SF/DMP Errors :: '+errors);}else{console.log('QS: Successfully set SF/DMP consent flags');}}); console.log('QS: ML Tag'); if (typeof window.qs != 'undefined' && window.qs.consent.service.ml.dc) { var mlCLID=50451;if(typeof mlCLID!='undefined'){var mlEml=gDFPC('eml');(function(f,i,c){var a=decodeURIComponent,e=,l=,o=\|\|,g=;;,h=split,b=length,j=indexOf,k=0,n=localStorage,m=_ccmdt;f[c]=f[c]\|\|{};function d(q){var p;if(f[n]){return f[n][q]\|\|}else{p=i.cookie.match(q+=([^;]));return(p&&p[1])\|\|}}f[c].us={};e=a(d(m))[h](o);k=e[b];if(k>0){while(k--){l=e[k][h](=);if(l[b]>1){if(l[1][j](g)>-1){f[c].us[l[0]]=l[1][h](g);f[c].us[l[0]].pop()}else{f[c].us[l[0]]=l[1]}}}}})(window,do ent,_ml);(function(){_ml=window._ml\|\|{};_ml.eid='50027';_ml.clid=mlCLID;if(typeof mlEml!='undefined'){_ml.em=mlEml;}else{_ml.em='';}_ml.ht='shex';_ml.fp=mlWTFP;_ml.redirect=(location.protocol==='https:'?'https:':'http:')+'//beacon.krxd.net/usermatch.gif?partner=madisonlogic&partner_uid=[PersonID]';_ml.informer={enable:true};var s=do ent.getElementsByTagName('script')[0],cd=new Date(),mltag=do ent.createElement('script');mltag.type='text/ ascript';mltag.async=true;mltag.src=(location.protocol==='https:'?'https:':'http:')+'//ml314.com/tag.aspx?'+cd.getDate()+cd.getMonth()+cd.getFullYear();s.parentNode.insertBefore(mltag,s);})();} } console.log('QS: GA Tag'); var gaSID=UA-48203907-1;(function(i,s,o,g,r,a,m){i['Google yticsObject']=r;i[r]=i[r]\|\|function(){(i[r].q=i[r].q\|\|[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[ 0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,do ent,'script','//www.google- ytics.com/ ytics.js','ga');ga('create', gaSID, 'auto');ga('set', 'anonymizeIp', true);ga('send', 'pageview'); console.log('QS: DFP Visibility code'); googletag.defineSlot('/5055/b2b/it/sqlcourse2/ciu',[[600,200],[300,200]],'ciu-1').addService(googletag.pubads()).setTargeting('pos','top');if(mbw>1049){googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/hero','hero-1').addService(googletag.pubads());}googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600],[300,1050]],'imu-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600]],'imu-2').addService(googletag.pubads()).setTargeting('pos','mid');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[300,250],'imu-3').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-2').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/sky',[160,600],'sky-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/wa','wa-1').addService(googletag.pubads());googletag.pubads().setTargeting('kw',['database professional sql dba interactive online beginners training']);googletag.pubads().setTargeting('tax',['industry','product development programming languages','audience company size','audience role development','audience title staff','audience title other']);googletag.pubads().setTargeting('path',['intro2.html']);googletag.pubads().setTargeting('articlekey','3427410');googletag.pubads().setTargeting('pagetype','other');googletag.pubads().setTargeting('securesite',''+qsDFPSec+'');googletag.pubads().setTargeting('url',['http://www.sqlcourse2.com/intro2.html']);if(mbw0){if(typeof window.qs!='undefined'&&window.qs.consent.service.ml.dc){googletag.pubads().setTargeting('mlt',''+_ml.us.tp+'');}}}if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof Krux!='undefined'&&Krux.segments&&Krux.user){googletag.pubads().setTargeting('ksg',Krux.segments);googletag.pubads().setTargeting('kuid',Krux.user);}if(window.qs.krux.dn!=''&&window.qs.krux.dn!='null'){googletag.pubads().setTargeting('dn',''+window.qs.krux.dn+'');}if(window.qs.krux.jf!=''&&window.qs.krux.jf!='null'){googletag.pubads().setTargeting('jf',''+window.qs.krux.jf+'');}if(window.qs.krux.dr!=''&&window.qs.krux.dr!='null'){googletag.pubads().setTargeting('dr',''+window.qs.krux.dr+'');}if(window.qs.krux.ir!=''&&window.qs.krux.ir!='null'){googletag.pubads().setTargeting('ir',''+window.qs.krux.ir+'');}if(window.qs.krux.noer!=''&&window.qs.krux.noer!='null'){googletag.pubads().setTargeting('noer',''+window.qs.krux.noer+'');}}googletag.pubads().enableSingleRequest();googletag.pubads().collapseEmptyDivs();googletag.pubads().enableSyncRendering();googletag.disablePublisherConsole();if(typeof window.qs!='undefined'&&!window.qs.consent.service.dfp.dc){googletag.pubads().setRequestNonPersonalizedAds(1);}googletag.enableServices(); var waitForConsent = timeoutms => new Promise((resolve, reject)=>{ var checkConsent = () => { if (timeoutms && (timeoutms % 1000) == 0) console.log('QS: Checking for consent data'); if (typeof window.qs != 'undefined' && window.qs.consent.ready && typeof window.evidon != 'undefined' && window.evidon.notice) { // DFP window.qs.consent.service.dfp.dc = window.evidon.notice.consentIsGiven; // Salseforce/Krux window.qs.consent.service.krux.dc = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.al = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.tg = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.cd = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.sh = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.re = window.evidon.notice.consentIsGiven; // ML window.qs.consent.service.ml.dc = window.evidon.notice.consentIsGiven; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); resolve(QS: Consent data is ready); } else if ((timeoutms -= 100) < 0) { // DFP window.qs.consent.service.dfp.dc = false; // Salseforce/Krux window.qs.consent.service.krux.dc = false; window.qs.consent.service.krux.al = false; window.qs.consent.service.krux.tg = false; window.qs.consent.service.krux.cd = false; window.qs.consent.service.krux.sh = false; window.qs.consent.service.krux.re = false; // ML window.qs.consent.service.ml.dc = false; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); reject(QS: Consent data is not ready - moving on); } else setTimeout(checkConsent, 100); } setTimeout(checkConsent, 100); }); (async ()=>{ waitForConsent(5000) .then(function (msg) { console.log(msg); }) .catch(function (err) { console.log(err); }) })(); window.webtrendsAsyncInit=function(){ var dcs=new Webtrends.dcs().init({ dcsid:dcsu4g2zh10000sh49hg5l5wa_4b2h, domain:www.qsstats.com, timezone:-8, i18n:true, onsitedoms:sqlcourse2.com, fpcdom:.sqlcourse2.com, plugins:{ //hm:{src://s.webtrends.com/js/webtrends.hm.js} } }).track(); }; (function(){ var s=do ent.createElement(script); s.async=true; s.src=/imageserver/common/v10/webtrends.min.js; var s2=do ent.getElementsByTagName(script)[0]; s2.parentNode.insertBefore(s,s2); }()); [censored]

/intro2.html:

Title

Introduction | SQLCourse - Advanced Online SQL Training

Description

This Intermediate/Advanced SQL Tutorial will cover the SELECT statement in great detail. The SELECT statement is the core of SQL, and it is likely that the vast majority of your SQL commands will be SELECT statements. Due to the enormous amount of options available for the SELECT statement, this entire tutorial has been dedicated to it.

SQL Command Executed+responseText+); window.scrollTo(0, 0); } function buildAjaxForm(){ var options = { beforeSubmit: showRequest, success: showResponse }; jQuery('div#content form').ajaxForm(options); } window.qs={consent:{ready:false,service:{dfp:{dc:false},krux:{dc:false,al:false,tg:false,cd:false,sh:false,re:false},ml:{dc:false}}},dfp:{ready:false},krux:{dn:'',jf:'',dr:'',ir:'',noer:''}};function gDFPC(e){var n=e+=;var ca=do ent.cookie.split(';');for(var i=0;i;}var e=t+-+a;var r= ;if(d){r+=d;}r+= googletag.display('+e+'); ;if(c){r+=#+e+_ad_container { height: 0px; } ;}return r;} console.log('QS: Evidon Code'); (function (id) { function append(scriptid, url, async) { var d = do ent, sn = 'script', f = d.getElementsByTagName(sn)[0]; if (!f) f = d.head; var s = d.createElement(sn); s.async = true; s.id = scriptid; s.src = url; f.parentNode.insertBefore(s, f); } function getRootDomain() { var parts = window.location.hostname.split('.'); if (parts.length === 2) rootDomain = parts[0]; else if (parts.length > 2) { // see if the next to last value is a common tld var part = parts[parts.length - 2]; if (part === 'com' || part === 'co') { rootDomain = parts[parts.length - 3]; // go back one more } else { rootDomain = part; } } return rootDomain; } window.evidon = {}; window.evidon.id = id; var cdn = '//c.evidon.com/', rootDomain = getRootDomain(), noticecdn = cdn + 'sitenotice/'; append('evidon-notice', noticecdn + 'evidon-sitenotice-tag.js', false); append('evidon-location', cdn + 'geo/country.js', true); append('evidon-themes', noticecdn + id + '/snthemes.js', true); if (rootDomain) append('evidon-settings', noticecdn + id + '/' + rootDomain + '/settings.js', true); window.evidon.priorConsentCallback = function () { // add the tags which need to wait for prior consent // here. This should be all your advertising tags and // probably most of your social and tracking tags. // QS globals window.qs.consent.ready = true; } window.evidon.closeCallback = function () { // this is executed when a user closes a UI element (banner/barrier) without // providing consent. // QS globals window.qs.consent.ready = true; } window.evidon.consentWithdrawnCallback = function () { // this is exeucted if the user withdraws consent and elects to // no longer allow technologies to run on the site. // QS globals window.qs.consent.ready = true; } window.evidon.consentDeclinedCallback = function () { // this is executed if the user explicitly declines giving consent by // using a Decline on // QS globals window.qs.consent.ready = true; }})(704); window.qs.krux.dn=gDFPC('dn'),window.qs.krux.jf=gDFPC('jf'),window.qs.krux.dr=gDFPC('dr'),window.qs.krux.ir=gDFPC('ir'),window.qs.krux.noer=gDFPC('noer'); console.log('QS: Krux Interchange Tag'); window.Krux||((Krux=function(){Krux.q.push(arguments);}).q=[]);(function(){function retrieve(n){var k='kx'+''+n,ls=(function(){try{return window.localStorage;}catch(e){return null;}})();if(ls){return ls[k]||'';}else if(navigator.cookieEnabled){var m=do ent.cookie.match(k+'=([^;]*)');return (m&&unescape(m[1]))||'';}else{return '';}}Krux.user=retrieve('user');Krux.segments=retrieve('segs')?retrieve('segs').split(','):[];})(); console.log('QS: Krux Control Tag'); window.Krux||((Krux=function(){Krux.q.push(arguments)}).q=[]);(function(){var k=do ent.createElement('script');k.type='text/ ascript';k.async=true;k.src=(location.protocol==='https:'?'https:':'http:')+'//cdn.krxd.net/controltag/Jd_NLuX7.js';var s=do ent.getElementsByTagName('script')[0];s.parentNode.insertBefore(k,s);}()); console.log('QS: Krux Data Layer'); var kruxDataLayer={page:{domain:www.sqlcourse2.com,section:intro2.html,category:intro2.html,keywords:database professional sql dba interactive online beginners training,url_path_1:http://www.sqlcourse2.com/intro2.html},user:{dn:'',jf:'',dr:'',ir:'',noer:''}};if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof window.qs.krux.dn!='undefined'&&window.qs.krux.dn!='null'){kruxDataLayer.user.dn=window.qs.krux.dn;}if(typeof window.qs.krux.jf!='undefined'&&window.qs.krux.jf!='null'){kruxDataLayer.user.jf=window.qs.krux.jf;}if(typeof window.qs.krux.dr!='undefined'&&window.qs.krux.dr!='null'){kruxDataLayer.user.dr=window.qs.krux.dr;}if(typeof window.qs.krux.ir!='undefined'&&window.qs.krux.ir!='null'){kruxDataLayer.user.ir=window.qs.krux.ir;}if(typeof window.qs.krux.noer!='undefined'&&window.qs.krux.noer!='null'){kruxDataLayer.user.noer=window.qs.krux.noer;}} console.log('QS: Krux Consent Tag'); Krux('consent:set',{dc:window.qs.consent.service.krux.dc,al:window.qs.consent.service.krux.al,tg:window.qs.consent.service.krux.tg,cd:window.qs.consent.service.krux.cd,sh:window.qs.consent.service.krux.sh,re:window.qs.consent.service.krux.re},function(errors,body){if(errors){console.error('QS: SF/DMP Errors :: '+errors);}else{console.log('QS: Successfully set SF/DMP consent flags');}}); console.log('QS: ML Tag'); if (typeof window.qs != 'undefined' && window.qs.consent.service.ml.dc) { var mlCLID=50451;if(typeof mlCLID!='undefined'){var mlEml=gDFPC('eml');(function(f,i,c){var a=decodeURIComponent,e=,l=,o=||,g=;;,h=split,b=length,j=indexOf,k=0,n=localStorage,m=_ccmdt;f[c]=f[c]||{};function d(q){var p;if(f[n]){return f[n][q]||}else{p=i.cookie.match(q+=([^;]*));return(p&&p[1])||}}f[c].us={};e=a(d(m))[h](o);k=e[b];if(k>0){while(k--){l=e[k][h](=);if(l[b]>1){if(l[1][j](g)>-1){f[c].us[l[0]]=l[1][h](g);f[c].us[l[0]].pop()}else{f[c].us[l[0]]=l[1]}}}}})(window,do ent,_ml);(function(){_ml=window._ml||{};_ml.eid='50027';_ml.clid=mlCLID;if(typeof mlEml!='undefined'){_ml.em=mlEml;}else{_ml.em='';}_ml.ht='shex';_ml.fp=mlWTFP;_ml.redirect=(location.protocol==='https:'?'https:':'http:')+'//beacon.krxd.net/usermatch.gif?partner=madisonlogic&partner_uid=[PersonID]';_ml.informer={enable:true};var s=do ent.getElementsByTagName('script')[0],cd=new Date(),mltag=do ent.createElement('script');mltag.type='text/ ascript';mltag.async=true;mltag.src=(location.protocol==='https:'?'https:':'http:')+'//ml314.com/tag.aspx?'+cd.getDate()+cd.getMonth()+cd.getFullYear();s.parentNode.insertBefore(mltag,s);})();} } console.log('QS: GA Tag'); var gaSID=UA-48203907-1;(function(i,s,o,g,r,a,m){i['Google yticsObject']=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[ 0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,do ent,'script','//www.google- ytics.com/ ytics.js','ga');ga('create', gaSID, 'auto');ga('set', 'anonymizeIp', true);ga('send', 'pageview'); console.log('QS: DFP Visibility code'); googletag.defineSlot('/5055/b2b/it/sqlcourse2/ciu',[[600,200],[300,200]],'ciu-1').addService(googletag.pubads()).setTargeting('pos','top');if(mbw>1049){googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/hero','hero-1').addService(googletag.pubads());}googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600],[300,1050]],'imu-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600]],'imu-2').addService(googletag.pubads()).setTargeting('pos','mid');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[300,250],'imu-3').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-2').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/sky',[160,600],'sky-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/wa','wa-1').addService(googletag.pubads());googletag.pubads().setTargeting('kw',['database professional sql dba interactive online beginners training']);googletag.pubads().setTargeting('tax',['industry','product development programming languages','audience company size','audience role development','audience title staff','audience title other']);googletag.pubads().setTargeting('path',['intro2.html']);googletag.pubads().setTargeting('articlekey','3427410');googletag.pubads().setTargeting('pagetype','other');googletag.pubads().setTargeting('securesite',''+qsDFPSec+'');googletag.pubads().setTargeting('url',['http://www.sqlcourse2.com/intro2.html']);if(mbw0){if(typeof window.qs!='undefined'&&window.qs.consent.service.ml.dc){googletag.pubads().setTargeting('mlt',''+_ml.us.tp+'');}}}if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof Krux!='undefined'&&Krux.segments&&Krux.user){googletag.pubads().setTargeting('ksg',Krux.segments);googletag.pubads().setTargeting('kuid',Krux.user);}if(window.qs.krux.dn!=''&&window.qs.krux.dn!='null'){googletag.pubads().setTargeting('dn',''+window.qs.krux.dn+'');}if(window.qs.krux.jf!=''&&window.qs.krux.jf!='null'){googletag.pubads().setTargeting('jf',''+window.qs.krux.jf+'');}if(window.qs.krux.dr!=''&&window.qs.krux.dr!='null'){googletag.pubads().setTargeting('dr',''+window.qs.krux.dr+'');}if(window.qs.krux.ir!=''&&window.qs.krux.ir!='null'){googletag.pubads().setTargeting('ir',''+window.qs.krux.ir+'');}if(window.qs.krux.noer!=''&&window.qs.krux.noer!='null'){googletag.pubads().setTargeting('noer',''+window.qs.krux.noer+'');}}googletag.pubads().enableSingleRequest();googletag.pubads().collapseEmptyDivs();googletag.pubads().enableSyncRendering();googletag.disablePublisherConsole();if(typeof window.qs!='undefined'&&!window.qs.consent.service.dfp.dc){googletag.pubads().setRequestNonPersonalizedAds(1);}googletag.enableServices(); var waitForConsent = timeoutms => new Promise((resolve, reject)=>{ var checkConsent = () => { if (timeoutms && (timeoutms % 1000) == 0) console.log('QS: Checking for consent data'); if (typeof window.qs != 'undefined' && window.qs.consent.ready && typeof window.evidon != 'undefined' && window.evidon.notice) { // DFP window.qs.consent.service.dfp.dc = window.evidon.notice.consentIsGiven; // Salseforce/Krux window.qs.consent.service.krux.dc = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.al = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.tg = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.cd = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.sh = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.re = window.evidon.notice.consentIsGiven; // ML window.qs.consent.service.ml.dc = window.evidon.notice.consentIsGiven; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); resolve(QS: Consent data is ready); } else if ((timeoutms -= 100) < 0) { // DFP window.qs.consent.service.dfp.dc = false; // Salseforce/Krux window.qs.consent.service.krux.dc = false; window.qs.consent.service.krux.al = false; window.qs.consent.service.krux.tg = false; window.qs.consent.service.krux.cd = false; window.qs.consent.service.krux.sh = false; window.qs.consent.service.krux.re = false; // ML window.qs.consent.service.ml.dc = false; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); reject(QS: Consent data is not ready - moving on); } else setTimeout(checkConsent, 100); } setTimeout(checkConsent, 100); }); (async ()=>{ waitForConsent(5000) .then(function (msg) { console.log(msg); }) .catch(function (err) { console.log(err); }) })(); window.webtrendsAsyncInit=function(){ var dcs=new Webtrends.dcs().init({ dcsid:dcsu4g2zh10000sh49hg5l5wa_4b2h, domain:www.qsstats.com, timezone:-8, i18n:true, onsitedoms:sqlcourse2.com, fpcdom:.sqlcourse2.com, plugins:{ //hm:{src://s.webtrends.com/js/webtrends.hm.js} } }).track(); }; (function(){ var s=do ent.createElement(script); s.async=true; s.src=/imageserver/common/v10/webtrends.min.js; var s2=do ent.getElementsByTagName(script)[0]; s2.parentNode.insertBefore(s,s2); }());

[censored]

/select2.html:
Title	SELECT Statement \| SQLCourse - Advanced Online SQL Training
Description	The SELECT statement is used to query the database and retrieve selected data that match the criteria that you specify.
H1	SQL Command Executed+responseText+); window.scrollTo(0, 0); } function buildAjaxForm(){ var options = { beforeSubmit: showRequest, success: showResponse }; jQuery('div#content form').ajaxForm(options); } window.qs={consent:{ready:false,service:{dfp:{dc:false},krux:{dc:false,al:false,tg:false,cd:false,sh:false,re:false},ml:{dc:false}}},dfp:{ready:false},krux:{dn:'',jf:'',dr:'',ir:'',noer:''}};function gDFPC(e){var n=e+=;var ca=do ent.cookie.split(';');for(var i=0;i;}var e=t+-+a;var r= ;if(d){r+=d;}r+= googletag.display('+e+'); ;if(c){r+=#+e+_ad_container { height: 0px; } ;}return r;} console.log('QS: Evidon Code'); (function (id) { function append(scriptid, url, async) { var d = do ent, sn = 'script', f = d.getElementsByTagName(sn)[0]; if (!f) f = d.head; var s = d.createElement(sn); s.async = true; s.id = scriptid; s.src = url; f.parentNode.insertBefore(s, f); } function getRootDomain() { var parts = window.location.hostname.split('.'); if (parts.length === 2) rootDomain = parts[0]; else if (parts.length > 2) { // see if the next to last value is a common tld var part = parts[parts.length - 2]; if (part === 'com' \|\| part === 'co') { rootDomain = parts[parts.length - 3]; // go back one more } else { rootDomain = part; } } return rootDomain; } window.evidon = {}; window.evidon.id = id; var cdn = '//c.evidon.com/', rootDomain = getRootDomain(), noticecdn = cdn + 'sitenotice/'; append('evidon-notice', noticecdn + 'evidon-sitenotice-tag.js', false); append('evidon-location', cdn + 'geo/country.js', true); append('evidon-themes', noticecdn + id + '/snthemes.js', true); if (rootDomain) append('evidon-settings', noticecdn + id + '/' + rootDomain + '/settings.js', true); window.evidon.priorConsentCallback = function () { // add the tags which need to wait for prior consent // here. This should be all your advertising tags and // probably most of your social and tracking tags. // QS globals window.qs.consent.ready = true; } window.evidon.closeCallback = function () { // this is executed when a user closes a UI element (banner/barrier) without // providing consent. // QS globals window.qs.consent.ready = true; } window.evidon.consentWithdrawnCallback = function () { // this is exeucted if the user withdraws consent and elects to // no longer allow technologies to run on the site. // QS globals window.qs.consent.ready = true; } window.evidon.consentDeclinedCallback = function () { // this is executed if the user explicitly declines giving consent by // using a Decline on // QS globals window.qs.consent.ready = true; }})(704); window.qs.krux.dn=gDFPC('dn'),window.qs.krux.jf=gDFPC('jf'),window.qs.krux.dr=gDFPC('dr'),window.qs.krux.ir=gDFPC('ir'),window.qs.krux.noer=gDFPC('noer'); console.log('QS: Krux Interchange Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments);}).q=[]);(function(){function retrieve(n){var k='kx'+''+n,ls=(function(){try{return window.localStorage;}catch(e){return null;}})();if(ls){return ls[k]\|\|'';}else if(navigator.cookieEnabled){var m=do ent.cookie.match(k+'=([^;])');return (m&&unescape(m[1]))\|\|'';}else{return '';}}Krux.user=retrieve('user');Krux.segments=retrieve('segs')?retrieve('segs').split(','):[];})(); console.log('QS: Krux Control Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments)}).q=[]);(function(){var k=do ent.createElement('script');k.type='text/ ascript';k.async=true;k.src=(location.protocol==='https:'?'https:':'http:')+'//cdn.krxd.net/controltag/Jd_NLuX7.js';var s=do ent.getElementsByTagName('script')[0];s.parentNode.insertBefore(k,s);}()); console.log('QS: Krux Data Layer'); var kruxDataLayer={page:{domain:www.sqlcourse2.com,section:select2.html,category:select2.html,keywords:SELECT statement database professional sql dba interactive online beginners training,url_path_1:http://www.sqlcourse2.com/select2.html},user:{dn:'',jf:'',dr:'',ir:'',noer:''}};if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof window.qs.krux.dn!='undefined'&&window.qs.krux.dn!='null'){kruxDataLayer.user.dn=window.qs.krux.dn;}if(typeof window.qs.krux.jf!='undefined'&&window.qs.krux.jf!='null'){kruxDataLayer.user.jf=window.qs.krux.jf;}if(typeof window.qs.krux.dr!='undefined'&&window.qs.krux.dr!='null'){kruxDataLayer.user.dr=window.qs.krux.dr;}if(typeof window.qs.krux.ir!='undefined'&&window.qs.krux.ir!='null'){kruxDataLayer.user.ir=window.qs.krux.ir;}if(typeof window.qs.krux.noer!='undefined'&&window.qs.krux.noer!='null'){kruxDataLayer.user.noer=window.qs.krux.noer;}} console.log('QS: Krux Consent Tag'); Krux('consent:set',{dc:window.qs.consent.service.krux.dc,al:window.qs.consent.service.krux.al,tg:window.qs.consent.service.krux.tg,cd:window.qs.consent.service.krux.cd,sh:window.qs.consent.service.krux.sh,re:window.qs.consent.service.krux.re},function(errors,body){if(errors){console.error('QS: SF/DMP Errors :: '+errors);}else{console.log('QS: Successfully set SF/DMP consent flags');}}); console.log('QS: ML Tag'); if (typeof window.qs != 'undefined' && window.qs.consent.service.ml.dc) { var mlCLID=50451;if(typeof mlCLID!='undefined'){var mlEml=gDFPC('eml');(function(f,i,c){var a=decodeURIComponent,e=,l=,o=\|\|,g=;;,h=split,b=length,j=indexOf,k=0,n=localStorage,m=_ccmdt;f[c]=f[c]\|\|{};function d(q){var p;if(f[n]){return f[n][q]\|\|}else{p=i.cookie.match(q+=([^;]));return(p&&p[1])\|\|}}f[c].us={};e=a(d(m))[h](o);k=e[b];if(k>0){while(k--){l=e[k][h](=);if(l[b]>1){if(l[1][j](g)>-1){f[c].us[l[0]]=l[1][h](g);f[c].us[l[0]].pop()}else{f[c].us[l[0]]=l[1]}}}}})(window,do ent,_ml);(function(){_ml=window._ml\|\|{};_ml.eid='50027';_ml.clid=mlCLID;if(typeof mlEml!='undefined'){_ml.em=mlEml;}else{_ml.em='';}_ml.ht='shex';_ml.fp=mlWTFP;_ml.redirect=(location.protocol==='https:'?'https:':'http:')+'//beacon.krxd.net/usermatch.gif?partner=madisonlogic&partner_uid=[PersonID]';_ml.informer={enable:true};var s=do ent.getElementsByTagName('script')[0],cd=new Date(),mltag=do ent.createElement('script');mltag.type='text/ ascript';mltag.async=true;mltag.src=(location.protocol==='https:'?'https:':'http:')+'//ml314.com/tag.aspx?'+cd.getDate()+cd.getMonth()+cd.getFullYear();s.parentNode.insertBefore(mltag,s);})();} } console.log('QS: GA Tag'); var gaSID=UA-48203907-1;(function(i,s,o,g,r,a,m){i['Google yticsObject']=r;i[r]=i[r]\|\|function(){(i[r].q=i[r].q\|\|[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[ 0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,do ent,'script','//www.google- ytics.com/ ytics.js','ga');ga('create', gaSID, 'auto');ga('set', 'anonymizeIp', true);ga('send', 'pageview'); console.log('QS: DFP Visibility code'); googletag.defineSlot('/5055/b2b/it/sqlcourse2/ciu',[[600,200],[300,200]],'ciu-1').addService(googletag.pubads()).setTargeting('pos','top');if(mbw>1049){googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/hero','hero-1').addService(googletag.pubads());}googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600],[300,1050]],'imu-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600]],'imu-2').addService(googletag.pubads()).setTargeting('pos','mid');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[300,250],'imu-3').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-2').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/sky',[160,600],'sky-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/wa','wa-1').addService(googletag.pubads());googletag.pubads().setTargeting('kw',['SELECT statement database professional sql dba interactive online beginners training']);googletag.pubads().setTargeting('tax',['audience','product development programming languages','product servers database']);googletag.pubads().setTargeting('path',['select2.html']);googletag.pubads().setTargeting('articlekey','3427420');googletag.pubads().setTargeting('pagetype','other');googletag.pubads().setTargeting('securesite',''+qsDFPSec+'');googletag.pubads().setTargeting('url',['http://www.sqlcourse2.com/select2.html']);if(mbw0){if(typeof window.qs!='undefined'&&window.qs.consent.service.ml.dc){googletag.pubads().setTargeting('mlt',''+_ml.us.tp+'');}}}if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof Krux!='undefined'&&Krux.segments&&Krux.user){googletag.pubads().setTargeting('ksg',Krux.segments);googletag.pubads().setTargeting('kuid',Krux.user);}if(window.qs.krux.dn!=''&&window.qs.krux.dn!='null'){googletag.pubads().setTargeting('dn',''+window.qs.krux.dn+'');}if(window.qs.krux.jf!=''&&window.qs.krux.jf!='null'){googletag.pubads().setTargeting('jf',''+window.qs.krux.jf+'');}if(window.qs.krux.dr!=''&&window.qs.krux.dr!='null'){googletag.pubads().setTargeting('dr',''+window.qs.krux.dr+'');}if(window.qs.krux.ir!=''&&window.qs.krux.ir!='null'){googletag.pubads().setTargeting('ir',''+window.qs.krux.ir+'');}if(window.qs.krux.noer!=''&&window.qs.krux.noer!='null'){googletag.pubads().setTargeting('noer',''+window.qs.krux.noer+'');}}googletag.pubads().enableSingleRequest();googletag.pubads().collapseEmptyDivs();googletag.pubads().enableSyncRendering();googletag.disablePublisherConsole();if(typeof window.qs!='undefined'&&!window.qs.consent.service.dfp.dc){googletag.pubads().setRequestNonPersonalizedAds(1);}googletag.enableServices(); var waitForConsent = timeoutms => new Promise((resolve, reject)=>{ var checkConsent = () => { if (timeoutms && (timeoutms % 1000) == 0) console.log('QS: Checking for consent data'); if (typeof window.qs != 'undefined' && window.qs.consent.ready && typeof window.evidon != 'undefined' && window.evidon.notice) { // DFP window.qs.consent.service.dfp.dc = window.evidon.notice.consentIsGiven; // Salseforce/Krux window.qs.consent.service.krux.dc = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.al = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.tg = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.cd = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.sh = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.re = window.evidon.notice.consentIsGiven; // ML window.qs.consent.service.ml.dc = window.evidon.notice.consentIsGiven; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); resolve(QS: Consent data is ready); } else if ((timeoutms -= 100) < 0) { // DFP window.qs.consent.service.dfp.dc = false; // Salseforce/Krux window.qs.consent.service.krux.dc = false; window.qs.consent.service.krux.al = false; window.qs.consent.service.krux.tg = false; window.qs.consent.service.krux.cd = false; window.qs.consent.service.krux.sh = false; window.qs.consent.service.krux.re = false; // ML window.qs.consent.service.ml.dc = false; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); reject(QS: Consent data is not ready - moving on); } else setTimeout(checkConsent, 100); } setTimeout(checkConsent, 100); }); (async ()=>{ waitForConsent(5000) .then(function (msg) { console.log(msg); }) .catch(function (err) { console.log(err); }) })(); window.webtrendsAsyncInit=function(){ var dcs=new Webtrends.dcs().init({ dcsid:dcsu4g2zh10000sh49hg5l5wa_4b2h, domain:www.qsstats.com, timezone:-8, i18n:true, onsitedoms:sqlcourse2.com, fpcdom:.sqlcourse2.com, plugins:{ //hm:{src://s.webtrends.com/js/webtrends.hm.js} } }).track(); }; (function(){ var s=do ent.createElement(script); s.async=true; s.src=/imageserver/common/v10/webtrends.min.js; var s2=do ent.getElementsByTagName(script)[0]; s2.parentNode.insertBefore(s,s2); }()); [censored]
H3	Review Exercises

/agg_functions.html:
Title	Aggregate Functions \| SQLCourse - Advanced Online SQL Training
Description	Aggregate functions are used to compute against a
H1	SQL Command Executed+responseText+); window.scrollTo(0, 0); } function buildAjaxForm(){ var options = { beforeSubmit: showRequest, success: showResponse }; jQuery('div#content form').ajaxForm(options); } window.qs={consent:{ready:false,service:{dfp:{dc:false},krux:{dc:false,al:false,tg:false,cd:false,sh:false,re:false},ml:{dc:false}}},dfp:{ready:false},krux:{dn:'',jf:'',dr:'',ir:'',noer:''}};function gDFPC(e){var n=e+=;var ca=do ent.cookie.split(';');for(var i=0;i;}var e=t+-+a;var r= ;if(d){r+=d;}r+= googletag.display('+e+'); ;if(c){r+=#+e+_ad_container { height: 0px; } ;}return r;} console.log('QS: Evidon Code'); (function (id) { function append(scriptid, url, async) { var d = do ent, sn = 'script', f = d.getElementsByTagName(sn)[0]; if (!f) f = d.head; var s = d.createElement(sn); s.async = true; s.id = scriptid; s.src = url; f.parentNode.insertBefore(s, f); } function getRootDomain() { var parts = window.location.hostname.split('.'); if (parts.length === 2) rootDomain = parts[0]; else if (parts.length > 2) { // see if the next to last value is a common tld var part = parts[parts.length - 2]; if (part === 'com' \|\| part === 'co') { rootDomain = parts[parts.length - 3]; // go back one more } else { rootDomain = part; } } return rootDomain; } window.evidon = {}; window.evidon.id = id; var cdn = '//c.evidon.com/', rootDomain = getRootDomain(), noticecdn = cdn + 'sitenotice/'; append('evidon-notice', noticecdn + 'evidon-sitenotice-tag.js', false); append('evidon-location', cdn + 'geo/country.js', true); append('evidon-themes', noticecdn + id + '/snthemes.js', true); if (rootDomain) append('evidon-settings', noticecdn + id + '/' + rootDomain + '/settings.js', true); window.evidon.priorConsentCallback = function () { // add the tags which need to wait for prior consent // here. This should be all your advertising tags and // probably most of your social and tracking tags. // QS globals window.qs.consent.ready = true; } window.evidon.closeCallback = function () { // this is executed when a user closes a UI element (banner/barrier) without // providing consent. // QS globals window.qs.consent.ready = true; } window.evidon.consentWithdrawnCallback = function () { // this is exeucted if the user withdraws consent and elects to // no longer allow technologies to run on the site. // QS globals window.qs.consent.ready = true; } window.evidon.consentDeclinedCallback = function () { // this is executed if the user explicitly declines giving consent by // using a Decline on // QS globals window.qs.consent.ready = true; }})(704); window.qs.krux.dn=gDFPC('dn'),window.qs.krux.jf=gDFPC('jf'),window.qs.krux.dr=gDFPC('dr'),window.qs.krux.ir=gDFPC('ir'),window.qs.krux.noer=gDFPC('noer'); console.log('QS: Krux Interchange Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments);}).q=[]);(function(){function retrieve(n){var k='kx'+''+n,ls=(function(){try{return window.localStorage;}catch(e){return null;}})();if(ls){return ls[k]\|\|'';}else if(navigator.cookieEnabled){var m=do ent.cookie.match(k+'=([^;])');return (m&&unescape(m[1]))\|\|'';}else{return '';}}Krux.user=retrieve('user');Krux.segments=retrieve('segs')?retrieve('segs').split(','):[];})(); console.log('QS: Krux Control Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments)}).q=[]);(function(){var k=do ent.createElement('script');k.type='text/ ascript';k.async=true;k.src=(location.protocol==='https:'?'https:':'http:')+'//cdn.krxd.net/controltag/Jd_NLuX7.js';var s=do ent.getElementsByTagName('script')[0];s.parentNode.insertBefore(k,s);}()); console.log('QS: Krux Data Layer'); var kruxDataLayer={page:{domain:www.sqlcourse2.com,section:agg_functions.html,category:agg_functions.html,keywords:database professional sql dba interactive online beginners training,url_path_1:http://www.sqlcourse2.com/agg_functions.html},user:{dn:'',jf:'',dr:'',ir:'',noer:''}};if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof window.qs.krux.dn!='undefined'&&window.qs.krux.dn!='null'){kruxDataLayer.user.dn=window.qs.krux.dn;}if(typeof window.qs.krux.jf!='undefined'&&window.qs.krux.jf!='null'){kruxDataLayer.user.jf=window.qs.krux.jf;}if(typeof window.qs.krux.dr!='undefined'&&window.qs.krux.dr!='null'){kruxDataLayer.user.dr=window.qs.krux.dr;}if(typeof window.qs.krux.ir!='undefined'&&window.qs.krux.ir!='null'){kruxDataLayer.user.ir=window.qs.krux.ir;}if(typeof window.qs.krux.noer!='undefined'&&window.qs.krux.noer!='null'){kruxDataLayer.user.noer=window.qs.krux.noer;}} console.log('QS: Krux Consent Tag'); Krux('consent:set',{dc:window.qs.consent.service.krux.dc,al:window.qs.consent.service.krux.al,tg:window.qs.consent.service.krux.tg,cd:window.qs.consent.service.krux.cd,sh:window.qs.consent.service.krux.sh,re:window.qs.consent.service.krux.re},function(errors,body){if(errors){console.error('QS: SF/DMP Errors :: '+errors);}else{console.log('QS: Successfully set SF/DMP consent flags');}}); console.log('QS: ML Tag'); if (typeof window.qs != 'undefined' && window.qs.consent.service.ml.dc) { var mlCLID=50451;if(typeof mlCLID!='undefined'){var mlEml=gDFPC('eml');(function(f,i,c){var a=decodeURIComponent,e=,l=,o=\|\|,g=;;,h=split,b=length,j=indexOf,k=0,n=localStorage,m=_ccmdt;f[c]=f[c]\|\|{};function d(q){var p;if(f[n]){return f[n][q]\|\|}else{p=i.cookie.match(q+=([^;]));return(p&&p[1])\|\|}}f[c].us={};e=a(d(m))[h](o);k=e[b];if(k>0){while(k--){l=e[k][h](=);if(l[b]>1){if(l[1][j](g)>-1){f[c].us[l[0]]=l[1][h](g);f[c].us[l[0]].pop()}else{f[c].us[l[0]]=l[1]}}}}})(window,do ent,_ml);(function(){_ml=window._ml\|\|{};_ml.eid='50027';_ml.clid=mlCLID;if(typeof mlEml!='undefined'){_ml.em=mlEml;}else{_ml.em='';}_ml.ht='shex';_ml.fp=mlWTFP;_ml.redirect=(location.protocol==='https:'?'https:':'http:')+'//beacon.krxd.net/usermatch.gif?partner=madisonlogic&partner_uid=[PersonID]';_ml.informer={enable:true};var s=do ent.getElementsByTagName('script')[0],cd=new Date(),mltag=do ent.createElement('script');mltag.type='text/ ascript';mltag.async=true;mltag.src=(location.protocol==='https:'?'https:':'http:')+'//ml314.com/tag.aspx?'+cd.getDate()+cd.getMonth()+cd.getFullYear();s.parentNode.insertBefore(mltag,s);})();} } console.log('QS: GA Tag'); var gaSID=UA-48203907-1;(function(i,s,o,g,r,a,m){i['Google yticsObject']=r;i[r]=i[r]\|\|function(){(i[r].q=i[r].q\|\|[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[ 0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,do ent,'script','//www.google- ytics.com/ ytics.js','ga');ga('create', gaSID, 'auto');ga('set', 'anonymizeIp', true);ga('send', 'pageview'); console.log('QS: DFP Visibility code'); googletag.defineSlot('/5055/b2b/it/sqlcourse2/ciu',[[600,200],[300,200]],'ciu-1').addService(googletag.pubads()).setTargeting('pos','top');if(mbw>1049){googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/hero','hero-1').addService(googletag.pubads());}googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600],[300,1050]],'imu-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600]],'imu-2').addService(googletag.pubads()).setTargeting('pos','mid');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[300,250],'imu-3').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-2').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/sky',[160,600],'sky-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/wa','wa-1').addService(googletag.pubads());googletag.pubads().setTargeting('kw',['database professional sql dba interactive online beginners training']);googletag.pubads().setTargeting('tax',['audience','product development programming languages','product servers database']);googletag.pubads().setTargeting('path',['agg_functions.html']);googletag.pubads().setTargeting('articlekey','3427440');googletag.pubads().setTargeting('pagetype','other');googletag.pubads().setTargeting('securesite',''+qsDFPSec+'');googletag.pubads().setTargeting('url',['http://www.sqlcourse2.com/agg_functions.html']);if(mbw0){if(typeof window.qs!='undefined'&&window.qs.consent.service.ml.dc){googletag.pubads().setTargeting('mlt',''+_ml.us.tp+'');}}}if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof Krux!='undefined'&&Krux.segments&&Krux.user){googletag.pubads().setTargeting('ksg',Krux.segments);googletag.pubads().setTargeting('kuid',Krux.user);}if(window.qs.krux.dn!=''&&window.qs.krux.dn!='null'){googletag.pubads().setTargeting('dn',''+window.qs.krux.dn+'');}if(window.qs.krux.jf!=''&&window.qs.krux.jf!='null'){googletag.pubads().setTargeting('jf',''+window.qs.krux.jf+'');}if(window.qs.krux.dr!=''&&window.qs.krux.dr!='null'){googletag.pubads().setTargeting('dr',''+window.qs.krux.dr+'');}if(window.qs.krux.ir!=''&&window.qs.krux.ir!='null'){googletag.pubads().setTargeting('ir',''+window.qs.krux.ir+'');}if(window.qs.krux.noer!=''&&window.qs.krux.noer!='null'){googletag.pubads().setTargeting('noer',''+window.qs.krux.noer+'');}}googletag.pubads().enableSingleRequest();googletag.pubads().collapseEmptyDivs();googletag.pubads().enableSyncRendering();googletag.disablePublisherConsole();if(typeof window.qs!='undefined'&&!window.qs.consent.service.dfp.dc){googletag.pubads().setRequestNonPersonalizedAds(1);}googletag.enableServices(); var waitForConsent = timeoutms => new Promise((resolve, reject)=>{ var checkConsent = () => { if (timeoutms && (timeoutms % 1000) == 0) console.log('QS: Checking for consent data'); if (typeof window.qs != 'undefined' && window.qs.consent.ready && typeof window.evidon != 'undefined' && window.evidon.notice) { // DFP window.qs.consent.service.dfp.dc = window.evidon.notice.consentIsGiven; // Salseforce/Krux window.qs.consent.service.krux.dc = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.al = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.tg = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.cd = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.sh = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.re = window.evidon.notice.consentIsGiven; // ML window.qs.consent.service.ml.dc = window.evidon.notice.consentIsGiven; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); resolve(QS: Consent data is ready); } else if ((timeoutms -= 100) < 0) { // DFP window.qs.consent.service.dfp.dc = false; // Salseforce/Krux window.qs.consent.service.krux.dc = false; window.qs.consent.service.krux.al = false; window.qs.consent.service.krux.tg = false; window.qs.consent.service.krux.cd = false; window.qs.consent.service.krux.sh = false; window.qs.consent.service.krux.re = false; // ML window.qs.consent.service.ml.dc = false; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); reject(QS: Consent data is not ready - moving on); } else setTimeout(checkConsent, 100); } setTimeout(checkConsent, 100); }); (async ()=>{ waitForConsent(5000) .then(function (msg) { console.log(msg); }) .catch(function (err) { console.log(err); }) })(); window.webtrendsAsyncInit=function(){ var dcs=new Webtrends.dcs().init({ dcsid:dcsu4g2zh10000sh49hg5l5wa_4b2h, domain:www.qsstats.com, timezone:-8, i18n:true, onsitedoms:sqlcourse2.com, fpcdom:.sqlcourse2.com, plugins:{ //hm:{src://s.webtrends.com/js/webtrends.hm.js} } }).track(); }; (function(){ var s=do ent.createElement(script); s.async=true; s.src=/imageserver/common/v10/webtrends.min.js; var s2=do ent.getElementsByTagName(script)[0]; s2.parentNode.insertBefore(s,s2); }()); [censored]

/agg_functions.html:

Title

Aggregate Functions | SQLCourse - Advanced Online SQL Training

Description

Aggregate functions are used to compute against a

SQL Command Executed+responseText+); window.scrollTo(0, 0); } function buildAjaxForm(){ var options = { beforeSubmit: showRequest, success: showResponse }; jQuery('div#content form').ajaxForm(options); } window.qs={consent:{ready:false,service:{dfp:{dc:false},krux:{dc:false,al:false,tg:false,cd:false,sh:false,re:false},ml:{dc:false}}},dfp:{ready:false},krux:{dn:'',jf:'',dr:'',ir:'',noer:''}};function gDFPC(e){var n=e+=;var ca=do ent.cookie.split(';');for(var i=0;i;}var e=t+-+a;var r= ;if(d){r+=d;}r+= googletag.display('+e+'); ;if(c){r+=#+e+_ad_container { height: 0px; } ;}return r;} console.log('QS: Evidon Code'); (function (id) { function append(scriptid, url, async) { var d = do ent, sn = 'script', f = d.getElementsByTagName(sn)[0]; if (!f) f = d.head; var s = d.createElement(sn); s.async = true; s.id = scriptid; s.src = url; f.parentNode.insertBefore(s, f); } function getRootDomain() { var parts = window.location.hostname.split('.'); if (parts.length === 2) rootDomain = parts[0]; else if (parts.length > 2) { // see if the next to last value is a common tld var part = parts[parts.length - 2]; if (part === 'com' || part === 'co') { rootDomain = parts[parts.length - 3]; // go back one more } else { rootDomain = part; } } return rootDomain; } window.evidon = {}; window.evidon.id = id; var cdn = '//c.evidon.com/', rootDomain = getRootDomain(), noticecdn = cdn + 'sitenotice/'; append('evidon-notice', noticecdn + 'evidon-sitenotice-tag.js', false); append('evidon-location', cdn + 'geo/country.js', true); append('evidon-themes', noticecdn + id + '/snthemes.js', true); if (rootDomain) append('evidon-settings', noticecdn + id + '/' + rootDomain + '/settings.js', true); window.evidon.priorConsentCallback = function () { // add the tags which need to wait for prior consent // here. This should be all your advertising tags and // probably most of your social and tracking tags. // QS globals window.qs.consent.ready = true; } window.evidon.closeCallback = function () { // this is executed when a user closes a UI element (banner/barrier) without // providing consent. // QS globals window.qs.consent.ready = true; } window.evidon.consentWithdrawnCallback = function () { // this is exeucted if the user withdraws consent and elects to // no longer allow technologies to run on the site. // QS globals window.qs.consent.ready = true; } window.evidon.consentDeclinedCallback = function () { // this is executed if the user explicitly declines giving consent by // using a Decline on // QS globals window.qs.consent.ready = true; }})(704); window.qs.krux.dn=gDFPC('dn'),window.qs.krux.jf=gDFPC('jf'),window.qs.krux.dr=gDFPC('dr'),window.qs.krux.ir=gDFPC('ir'),window.qs.krux.noer=gDFPC('noer'); console.log('QS: Krux Interchange Tag'); window.Krux||((Krux=function(){Krux.q.push(arguments);}).q=[]);(function(){function retrieve(n){var k='kx'+''+n,ls=(function(){try{return window.localStorage;}catch(e){return null;}})();if(ls){return ls[k]||'';}else if(navigator.cookieEnabled){var m=do ent.cookie.match(k+'=([^;]*)');return (m&&unescape(m[1]))||'';}else{return '';}}Krux.user=retrieve('user');Krux.segments=retrieve('segs')?retrieve('segs').split(','):[];})(); console.log('QS: Krux Control Tag'); window.Krux||((Krux=function(){Krux.q.push(arguments)}).q=[]);(function(){var k=do ent.createElement('script');k.type='text/ ascript';k.async=true;k.src=(location.protocol==='https:'?'https:':'http:')+'//cdn.krxd.net/controltag/Jd_NLuX7.js';var s=do ent.getElementsByTagName('script')[0];s.parentNode.insertBefore(k,s);}()); console.log('QS: Krux Data Layer'); var kruxDataLayer={page:{domain:www.sqlcourse2.com,section:agg_functions.html,category:agg_functions.html,keywords:database professional sql dba interactive online beginners training,url_path_1:http://www.sqlcourse2.com/agg_functions.html},user:{dn:'',jf:'',dr:'',ir:'',noer:''}};if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof window.qs.krux.dn!='undefined'&&window.qs.krux.dn!='null'){kruxDataLayer.user.dn=window.qs.krux.dn;}if(typeof window.qs.krux.jf!='undefined'&&window.qs.krux.jf!='null'){kruxDataLayer.user.jf=window.qs.krux.jf;}if(typeof window.qs.krux.dr!='undefined'&&window.qs.krux.dr!='null'){kruxDataLayer.user.dr=window.qs.krux.dr;}if(typeof window.qs.krux.ir!='undefined'&&window.qs.krux.ir!='null'){kruxDataLayer.user.ir=window.qs.krux.ir;}if(typeof window.qs.krux.noer!='undefined'&&window.qs.krux.noer!='null'){kruxDataLayer.user.noer=window.qs.krux.noer;}} console.log('QS: Krux Consent Tag'); Krux('consent:set',{dc:window.qs.consent.service.krux.dc,al:window.qs.consent.service.krux.al,tg:window.qs.consent.service.krux.tg,cd:window.qs.consent.service.krux.cd,sh:window.qs.consent.service.krux.sh,re:window.qs.consent.service.krux.re},function(errors,body){if(errors){console.error('QS: SF/DMP Errors :: '+errors);}else{console.log('QS: Successfully set SF/DMP consent flags');}}); console.log('QS: ML Tag'); if (typeof window.qs != 'undefined' && window.qs.consent.service.ml.dc) { var mlCLID=50451;if(typeof mlCLID!='undefined'){var mlEml=gDFPC('eml');(function(f,i,c){var a=decodeURIComponent,e=,l=,o=||,g=;;,h=split,b=length,j=indexOf,k=0,n=localStorage,m=_ccmdt;f[c]=f[c]||{};function d(q){var p;if(f[n]){return f[n][q]||}else{p=i.cookie.match(q+=([^;]*));return(p&&p[1])||}}f[c].us={};e=a(d(m))[h](o);k=e[b];if(k>0){while(k--){l=e[k][h](=);if(l[b]>1){if(l[1][j](g)>-1){f[c].us[l[0]]=l[1][h](g);f[c].us[l[0]].pop()}else{f[c].us[l[0]]=l[1]}}}}})(window,do ent,_ml);(function(){_ml=window._ml||{};_ml.eid='50027';_ml.clid=mlCLID;if(typeof mlEml!='undefined'){_ml.em=mlEml;}else{_ml.em='';}_ml.ht='shex';_ml.fp=mlWTFP;_ml.redirect=(location.protocol==='https:'?'https:':'http:')+'//beacon.krxd.net/usermatch.gif?partner=madisonlogic&partner_uid=[PersonID]';_ml.informer={enable:true};var s=do ent.getElementsByTagName('script')[0],cd=new Date(),mltag=do ent.createElement('script');mltag.type='text/ ascript';mltag.async=true;mltag.src=(location.protocol==='https:'?'https:':'http:')+'//ml314.com/tag.aspx?'+cd.getDate()+cd.getMonth()+cd.getFullYear();s.parentNode.insertBefore(mltag,s);})();} } console.log('QS: GA Tag'); var gaSID=UA-48203907-1;(function(i,s,o,g,r,a,m){i['Google yticsObject']=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[ 0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,do ent,'script','//www.google- ytics.com/ ytics.js','ga');ga('create', gaSID, 'auto');ga('set', 'anonymizeIp', true);ga('send', 'pageview'); console.log('QS: DFP Visibility code'); googletag.defineSlot('/5055/b2b/it/sqlcourse2/ciu',[[600,200],[300,200]],'ciu-1').addService(googletag.pubads()).setTargeting('pos','top');if(mbw>1049){googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/hero','hero-1').addService(googletag.pubads());}googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600],[300,1050]],'imu-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600]],'imu-2').addService(googletag.pubads()).setTargeting('pos','mid');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[300,250],'imu-3').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-2').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/sky',[160,600],'sky-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/wa','wa-1').addService(googletag.pubads());googletag.pubads().setTargeting('kw',['database professional sql dba interactive online beginners training']);googletag.pubads().setTargeting('tax',['audience','product development programming languages','product servers database']);googletag.pubads().setTargeting('path',['agg_functions.html']);googletag.pubads().setTargeting('articlekey','3427440');googletag.pubads().setTargeting('pagetype','other');googletag.pubads().setTargeting('securesite',''+qsDFPSec+'');googletag.pubads().setTargeting('url',['http://www.sqlcourse2.com/agg_functions.html']);if(mbw0){if(typeof window.qs!='undefined'&&window.qs.consent.service.ml.dc){googletag.pubads().setTargeting('mlt',''+_ml.us.tp+'');}}}if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof Krux!='undefined'&&Krux.segments&&Krux.user){googletag.pubads().setTargeting('ksg',Krux.segments);googletag.pubads().setTargeting('kuid',Krux.user);}if(window.qs.krux.dn!=''&&window.qs.krux.dn!='null'){googletag.pubads().setTargeting('dn',''+window.qs.krux.dn+'');}if(window.qs.krux.jf!=''&&window.qs.krux.jf!='null'){googletag.pubads().setTargeting('jf',''+window.qs.krux.jf+'');}if(window.qs.krux.dr!=''&&window.qs.krux.dr!='null'){googletag.pubads().setTargeting('dr',''+window.qs.krux.dr+'');}if(window.qs.krux.ir!=''&&window.qs.krux.ir!='null'){googletag.pubads().setTargeting('ir',''+window.qs.krux.ir+'');}if(window.qs.krux.noer!=''&&window.qs.krux.noer!='null'){googletag.pubads().setTargeting('noer',''+window.qs.krux.noer+'');}}googletag.pubads().enableSingleRequest();googletag.pubads().collapseEmptyDivs();googletag.pubads().enableSyncRendering();googletag.disablePublisherConsole();if(typeof window.qs!='undefined'&&!window.qs.consent.service.dfp.dc){googletag.pubads().setRequestNonPersonalizedAds(1);}googletag.enableServices(); var waitForConsent = timeoutms => new Promise((resolve, reject)=>{ var checkConsent = () => { if (timeoutms && (timeoutms % 1000) == 0) console.log('QS: Checking for consent data'); if (typeof window.qs != 'undefined' && window.qs.consent.ready && typeof window.evidon != 'undefined' && window.evidon.notice) { // DFP window.qs.consent.service.dfp.dc = window.evidon.notice.consentIsGiven; // Salseforce/Krux window.qs.consent.service.krux.dc = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.al = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.tg = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.cd = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.sh = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.re = window.evidon.notice.consentIsGiven; // ML window.qs.consent.service.ml.dc = window.evidon.notice.consentIsGiven; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); resolve(QS: Consent data is ready); } else if ((timeoutms -= 100) < 0) { // DFP window.qs.consent.service.dfp.dc = false; // Salseforce/Krux window.qs.consent.service.krux.dc = false; window.qs.consent.service.krux.al = false; window.qs.consent.service.krux.tg = false; window.qs.consent.service.krux.cd = false; window.qs.consent.service.krux.sh = false; window.qs.consent.service.krux.re = false; // ML window.qs.consent.service.ml.dc = false; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); reject(QS: Consent data is not ready - moving on); } else setTimeout(checkConsent, 100); } setTimeout(checkConsent, 100); }); (async ()=>{ waitForConsent(5000) .then(function (msg) { console.log(msg); }) .catch(function (err) { console.log(err); }) })(); window.webtrendsAsyncInit=function(){ var dcs=new Webtrends.dcs().init({ dcsid:dcsu4g2zh10000sh49hg5l5wa_4b2h, domain:www.qsstats.com, timezone:-8, i18n:true, onsitedoms:sqlcourse2.com, fpcdom:.sqlcourse2.com, plugins:{ //hm:{src://s.webtrends.com/js/webtrends.hm.js} } }).track(); }; (function(){ var s=do ent.createElement(script); s.async=true; s.src=/imageserver/common/v10/webtrends.min.js; var s2=do ent.getElementsByTagName(script)[0]; s2.parentNode.insertBefore(s,s2); }());

[censored]

/groupby.html:
Title	GROUP BY clause \| SQLCourse - Advanced Online SQL Training
Description	The GROUP BY clause will gather all of the rows together that contain data in the specified column(s) and will allow aggregate functions to be performed on the one or more columns.
H1	SQL Command Executed+responseText+); window.scrollTo(0, 0); } function buildAjaxForm(){ var options = { beforeSubmit: showRequest, success: showResponse }; jQuery('div#content form').ajaxForm(options); } window.qs={consent:{ready:false,service:{dfp:{dc:false},krux:{dc:false,al:false,tg:false,cd:false,sh:false,re:false},ml:{dc:false}}},dfp:{ready:false},krux:{dn:'',jf:'',dr:'',ir:'',noer:''}};function gDFPC(e){var n=e+=;var ca=do ent.cookie.split(';');for(var i=0;i;}var e=t+-+a;var r= ;if(d){r+=d;}r+= googletag.display('+e+'); ;if(c){r+=#+e+_ad_container { height: 0px; } ;}return r;} console.log('QS: Evidon Code'); (function (id) { function append(scriptid, url, async) { var d = do ent, sn = 'script', f = d.getElementsByTagName(sn)[0]; if (!f) f = d.head; var s = d.createElement(sn); s.async = true; s.id = scriptid; s.src = url; f.parentNode.insertBefore(s, f); } function getRootDomain() { var parts = window.location.hostname.split('.'); if (parts.length === 2) rootDomain = parts[0]; else if (parts.length > 2) { // see if the next to last value is a common tld var part = parts[parts.length - 2]; if (part === 'com' \|\| part === 'co') { rootDomain = parts[parts.length - 3]; // go back one more } else { rootDomain = part; } } return rootDomain; } window.evidon = {}; window.evidon.id = id; var cdn = '//c.evidon.com/', rootDomain = getRootDomain(), noticecdn = cdn + 'sitenotice/'; append('evidon-notice', noticecdn + 'evidon-sitenotice-tag.js', false); append('evidon-location', cdn + 'geo/country.js', true); append('evidon-themes', noticecdn + id + '/snthemes.js', true); if (rootDomain) append('evidon-settings', noticecdn + id + '/' + rootDomain + '/settings.js', true); window.evidon.priorConsentCallback = function () { // add the tags which need to wait for prior consent // here. This should be all your advertising tags and // probably most of your social and tracking tags. // QS globals window.qs.consent.ready = true; } window.evidon.closeCallback = function () { // this is executed when a user closes a UI element (banner/barrier) without // providing consent. // QS globals window.qs.consent.ready = true; } window.evidon.consentWithdrawnCallback = function () { // this is exeucted if the user withdraws consent and elects to // no longer allow technologies to run on the site. // QS globals window.qs.consent.ready = true; } window.evidon.consentDeclinedCallback = function () { // this is executed if the user explicitly declines giving consent by // using a Decline on // QS globals window.qs.consent.ready = true; }})(704); window.qs.krux.dn=gDFPC('dn'),window.qs.krux.jf=gDFPC('jf'),window.qs.krux.dr=gDFPC('dr'),window.qs.krux.ir=gDFPC('ir'),window.qs.krux.noer=gDFPC('noer'); console.log('QS: Krux Interchange Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments);}).q=[]);(function(){function retrieve(n){var k='kx'+''+n,ls=(function(){try{return window.localStorage;}catch(e){return null;}})();if(ls){return ls[k]\|\|'';}else if(navigator.cookieEnabled){var m=do ent.cookie.match(k+'=([^;])');return (m&&unescape(m[1]))\|\|'';}else{return '';}}Krux.user=retrieve('user');Krux.segments=retrieve('segs')?retrieve('segs').split(','):[];})(); console.log('QS: Krux Control Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments)}).q=[]);(function(){var k=do ent.createElement('script');k.type='text/ ascript';k.async=true;k.src=(location.protocol==='https:'?'https:':'http:')+'//cdn.krxd.net/controltag/Jd_NLuX7.js';var s=do ent.getElementsByTagName('script')[0];s.parentNode.insertBefore(k,s);}()); console.log('QS: Krux Data Layer'); var kruxDataLayer={page:{domain:www.sqlcourse2.com,section:groupby.html,category:groupby.html,keywords:GROUP BY database professional sql dba interactive online beginners training,url_path_1:http://www.sqlcourse2.com/groupby.html},user:{dn:'',jf:'',dr:'',ir:'',noer:''}};if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof window.qs.krux.dn!='undefined'&&window.qs.krux.dn!='null'){kruxDataLayer.user.dn=window.qs.krux.dn;}if(typeof window.qs.krux.jf!='undefined'&&window.qs.krux.jf!='null'){kruxDataLayer.user.jf=window.qs.krux.jf;}if(typeof window.qs.krux.dr!='undefined'&&window.qs.krux.dr!='null'){kruxDataLayer.user.dr=window.qs.krux.dr;}if(typeof window.qs.krux.ir!='undefined'&&window.qs.krux.ir!='null'){kruxDataLayer.user.ir=window.qs.krux.ir;}if(typeof window.qs.krux.noer!='undefined'&&window.qs.krux.noer!='null'){kruxDataLayer.user.noer=window.qs.krux.noer;}} console.log('QS: Krux Consent Tag'); Krux('consent:set',{dc:window.qs.consent.service.krux.dc,al:window.qs.consent.service.krux.al,tg:window.qs.consent.service.krux.tg,cd:window.qs.consent.service.krux.cd,sh:window.qs.consent.service.krux.sh,re:window.qs.consent.service.krux.re},function(errors,body){if(errors){console.error('QS: SF/DMP Errors :: '+errors);}else{console.log('QS: Successfully set SF/DMP consent flags');}}); console.log('QS: ML Tag'); if (typeof window.qs != 'undefined' && window.qs.consent.service.ml.dc) { var mlCLID=50451;if(typeof mlCLID!='undefined'){var mlEml=gDFPC('eml');(function(f,i,c){var a=decodeURIComponent,e=,l=,o=\|\|,g=;;,h=split,b=length,j=indexOf,k=0,n=localStorage,m=_ccmdt;f[c]=f[c]\|\|{};function d(q){var p;if(f[n]){return f[n][q]\|\|}else{p=i.cookie.match(q+=([^;]));return(p&&p[1])\|\|}}f[c].us={};e=a(d(m))[h](o);k=e[b];if(k>0){while(k--){l=e[k][h](=);if(l[b]>1){if(l[1][j](g)>-1){f[c].us[l[0]]=l[1][h](g);f[c].us[l[0]].pop()}else{f[c].us[l[0]]=l[1]}}}}})(window,do ent,_ml);(function(){_ml=window._ml\|\|{};_ml.eid='50027';_ml.clid=mlCLID;if(typeof mlEml!='undefined'){_ml.em=mlEml;}else{_ml.em='';}_ml.ht='shex';_ml.fp=mlWTFP;_ml.redirect=(location.protocol==='https:'?'https:':'http:')+'//beacon.krxd.net/usermatch.gif?partner=madisonlogic&partner_uid=[PersonID]';_ml.informer={enable:true};var s=do ent.getElementsByTagName('script')[0],cd=new Date(),mltag=do ent.createElement('script');mltag.type='text/ ascript';mltag.async=true;mltag.src=(location.protocol==='https:'?'https:':'http:')+'//ml314.com/tag.aspx?'+cd.getDate()+cd.getMonth()+cd.getFullYear();s.parentNode.insertBefore(mltag,s);})();} } console.log('QS: GA Tag'); var gaSID=UA-48203907-1;(function(i,s,o,g,r,a,m){i['Google yticsObject']=r;i[r]=i[r]\|\|function(){(i[r].q=i[r].q\|\|[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[ 0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,do ent,'script','//www.google- ytics.com/ ytics.js','ga');ga('create', gaSID, 'auto');ga('set', 'anonymizeIp', true);ga('send', 'pageview'); console.log('QS: DFP Visibility code'); googletag.defineSlot('/5055/b2b/it/sqlcourse2/ciu',[[600,200],[300,200]],'ciu-1').addService(googletag.pubads()).setTargeting('pos','top');if(mbw>1049){googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/hero','hero-1').addService(googletag.pubads());}googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600],[300,1050]],'imu-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600]],'imu-2').addService(googletag.pubads()).setTargeting('pos','mid');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[300,250],'imu-3').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-2').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/sky',[160,600],'sky-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/wa','wa-1').addService(googletag.pubads());googletag.pubads().setTargeting('kw',['GROUP BY database professional sql dba interactive online beginners training']);googletag.pubads().setTargeting('tax',['industry','product development programming languages','audience company size','audience role development','audience title staff','audience title other']);googletag.pubads().setTargeting('path',['groupby.html']);googletag.pubads().setTargeting('articlekey','3427470');googletag.pubads().setTargeting('pagetype','other');googletag.pubads().setTargeting('securesite',''+qsDFPSec+'');googletag.pubads().setTargeting('url',['http://www.sqlcourse2.com/groupby.html']);if(mbw0){if(typeof window.qs!='undefined'&&window.qs.consent.service.ml.dc){googletag.pubads().setTargeting('mlt',''+_ml.us.tp+'');}}}if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof Krux!='undefined'&&Krux.segments&&Krux.user){googletag.pubads().setTargeting('ksg',Krux.segments);googletag.pubads().setTargeting('kuid',Krux.user);}if(window.qs.krux.dn!=''&&window.qs.krux.dn!='null'){googletag.pubads().setTargeting('dn',''+window.qs.krux.dn+'');}if(window.qs.krux.jf!=''&&window.qs.krux.jf!='null'){googletag.pubads().setTargeting('jf',''+window.qs.krux.jf+'');}if(window.qs.krux.dr!=''&&window.qs.krux.dr!='null'){googletag.pubads().setTargeting('dr',''+window.qs.krux.dr+'');}if(window.qs.krux.ir!=''&&window.qs.krux.ir!='null'){googletag.pubads().setTargeting('ir',''+window.qs.krux.ir+'');}if(window.qs.krux.noer!=''&&window.qs.krux.noer!='null'){googletag.pubads().setTargeting('noer',''+window.qs.krux.noer+'');}}googletag.pubads().enableSingleRequest();googletag.pubads().collapseEmptyDivs();googletag.pubads().enableSyncRendering();googletag.disablePublisherConsole();if(typeof window.qs!='undefined'&&!window.qs.consent.service.dfp.dc){googletag.pubads().setRequestNonPersonalizedAds(1);}googletag.enableServices(); var waitForConsent = timeoutms => new Promise((resolve, reject)=>{ var checkConsent = () => { if (timeoutms && (timeoutms % 1000) == 0) console.log('QS: Checking for consent data'); if (typeof window.qs != 'undefined' && window.qs.consent.ready && typeof window.evidon != 'undefined' && window.evidon.notice) { // DFP window.qs.consent.service.dfp.dc = window.evidon.notice.consentIsGiven; // Salseforce/Krux window.qs.consent.service.krux.dc = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.al = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.tg = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.cd = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.sh = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.re = window.evidon.notice.consentIsGiven; // ML window.qs.consent.service.ml.dc = window.evidon.notice.consentIsGiven; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); resolve(QS: Consent data is ready); } else if ((timeoutms -= 100) < 0) { // DFP window.qs.consent.service.dfp.dc = false; // Salseforce/Krux window.qs.consent.service.krux.dc = false; window.qs.consent.service.krux.al = false; window.qs.consent.service.krux.tg = false; window.qs.consent.service.krux.cd = false; window.qs.consent.service.krux.sh = false; window.qs.consent.service.krux.re = false; // ML window.qs.consent.service.ml.dc = false; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); reject(QS: Consent data is not ready - moving on); } else setTimeout(checkConsent, 100); } setTimeout(checkConsent, 100); }); (async ()=>{ waitForConsent(5000) .then(function (msg) { console.log(msg); }) .catch(function (err) { console.log(err); }) })(); window.webtrendsAsyncInit=function(){ var dcs=new Webtrends.dcs().init({ dcsid:dcsu4g2zh10000sh49hg5l5wa_4b2h, domain:www.qsstats.com, timezone:-8, i18n:true, onsitedoms:sqlcourse2.com, fpcdom:.sqlcourse2.com, plugins:{ //hm:{src://s.webtrends.com/js/webtrends.hm.js} } }).track(); }; (function(){ var s=do ent.createElement(script); s.async=true; s.src=/imageserver/common/v10/webtrends.min.js; var s2=do ent.getElementsByTagName(script)[0]; s2.parentNode.insertBefore(s,s2); }()); [censored]
H3	Review Exercises

/having.html:
Title	HAVING clause \| SQLCourse - Advanced Online SQL Training
Description	The HAVING clause allows you to specify conditions on the rows for each group - in other words, which rows should be selected will be based on the conditions you specify. The HAVING clause should follow the GROUP BY clause if you are going to use it.
H1	SQL Command Executed+responseText+); window.scrollTo(0, 0); } function buildAjaxForm(){ var options = { beforeSubmit: showRequest, success: showResponse }; jQuery('div#content form').ajaxForm(options); } window.qs={consent:{ready:false,service:{dfp:{dc:false},krux:{dc:false,al:false,tg:false,cd:false,sh:false,re:false},ml:{dc:false}}},dfp:{ready:false},krux:{dn:'',jf:'',dr:'',ir:'',noer:''}};function gDFPC(e){var n=e+=;var ca=do ent.cookie.split(';');for(var i=0;i;}var e=t+-+a;var r= ;if(d){r+=d;}r+= googletag.display('+e+'); ;if(c){r+=#+e+_ad_container { height: 0px; } ;}return r;} console.log('QS: Evidon Code'); (function (id) { function append(scriptid, url, async) { var d = do ent, sn = 'script', f = d.getElementsByTagName(sn)[0]; if (!f) f = d.head; var s = d.createElement(sn); s.async = true; s.id = scriptid; s.src = url; f.parentNode.insertBefore(s, f); } function getRootDomain() { var parts = window.location.hostname.split('.'); if (parts.length === 2) rootDomain = parts[0]; else if (parts.length > 2) { // see if the next to last value is a common tld var part = parts[parts.length - 2]; if (part === 'com' \|\| part === 'co') { rootDomain = parts[parts.length - 3]; // go back one more } else { rootDomain = part; } } return rootDomain; } window.evidon = {}; window.evidon.id = id; var cdn = '//c.evidon.com/', rootDomain = getRootDomain(), noticecdn = cdn + 'sitenotice/'; append('evidon-notice', noticecdn + 'evidon-sitenotice-tag.js', false); append('evidon-location', cdn + 'geo/country.js', true); append('evidon-themes', noticecdn + id + '/snthemes.js', true); if (rootDomain) append('evidon-settings', noticecdn + id + '/' + rootDomain + '/settings.js', true); window.evidon.priorConsentCallback = function () { // add the tags which need to wait for prior consent // here. This should be all your advertising tags and // probably most of your social and tracking tags. // QS globals window.qs.consent.ready = true; } window.evidon.closeCallback = function () { // this is executed when a user closes a UI element (banner/barrier) without // providing consent. // QS globals window.qs.consent.ready = true; } window.evidon.consentWithdrawnCallback = function () { // this is exeucted if the user withdraws consent and elects to // no longer allow technologies to run on the site. // QS globals window.qs.consent.ready = true; } window.evidon.consentDeclinedCallback = function () { // this is executed if the user explicitly declines giving consent by // using a Decline on // QS globals window.qs.consent.ready = true; }})(704); window.qs.krux.dn=gDFPC('dn'),window.qs.krux.jf=gDFPC('jf'),window.qs.krux.dr=gDFPC('dr'),window.qs.krux.ir=gDFPC('ir'),window.qs.krux.noer=gDFPC('noer'); console.log('QS: Krux Interchange Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments);}).q=[]);(function(){function retrieve(n){var k='kx'+''+n,ls=(function(){try{return window.localStorage;}catch(e){return null;}})();if(ls){return ls[k]\|\|'';}else if(navigator.cookieEnabled){var m=do ent.cookie.match(k+'=([^;])');return (m&&unescape(m[1]))\|\|'';}else{return '';}}Krux.user=retrieve('user');Krux.segments=retrieve('segs')?retrieve('segs').split(','):[];})(); console.log('QS: Krux Control Tag'); window.Krux\|\|((Krux=function(){Krux.q.push(arguments)}).q=[]);(function(){var k=do ent.createElement('script');k.type='text/ ascript';k.async=true;k.src=(location.protocol==='https:'?'https:':'http:')+'//cdn.krxd.net/controltag/Jd_NLuX7.js';var s=do ent.getElementsByTagName('script')[0];s.parentNode.insertBefore(k,s);}()); console.log('QS: Krux Data Layer'); var kruxDataLayer={page:{domain:www.sqlcourse2.com,section:having.html,category:having.html,keywords:HAVING clause database professional sql dba interactive online beginners training,url_path_1:http://www.sqlcourse2.com/having.html},user:{dn:'',jf:'',dr:'',ir:'',noer:''}};if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof window.qs.krux.dn!='undefined'&&window.qs.krux.dn!='null'){kruxDataLayer.user.dn=window.qs.krux.dn;}if(typeof window.qs.krux.jf!='undefined'&&window.qs.krux.jf!='null'){kruxDataLayer.user.jf=window.qs.krux.jf;}if(typeof window.qs.krux.dr!='undefined'&&window.qs.krux.dr!='null'){kruxDataLayer.user.dr=window.qs.krux.dr;}if(typeof window.qs.krux.ir!='undefined'&&window.qs.krux.ir!='null'){kruxDataLayer.user.ir=window.qs.krux.ir;}if(typeof window.qs.krux.noer!='undefined'&&window.qs.krux.noer!='null'){kruxDataLayer.user.noer=window.qs.krux.noer;}} console.log('QS: Krux Consent Tag'); Krux('consent:set',{dc:window.qs.consent.service.krux.dc,al:window.qs.consent.service.krux.al,tg:window.qs.consent.service.krux.tg,cd:window.qs.consent.service.krux.cd,sh:window.qs.consent.service.krux.sh,re:window.qs.consent.service.krux.re},function(errors,body){if(errors){console.error('QS: SF/DMP Errors :: '+errors);}else{console.log('QS: Successfully set SF/DMP consent flags');}}); console.log('QS: ML Tag'); if (typeof window.qs != 'undefined' && window.qs.consent.service.ml.dc) { var mlCLID=50451;if(typeof mlCLID!='undefined'){var mlEml=gDFPC('eml');(function(f,i,c){var a=decodeURIComponent,e=,l=,o=\|\|,g=;;,h=split,b=length,j=indexOf,k=0,n=localStorage,m=_ccmdt;f[c]=f[c]\|\|{};function d(q){var p;if(f[n]){return f[n][q]\|\|}else{p=i.cookie.match(q+=([^;]));return(p&&p[1])\|\|}}f[c].us={};e=a(d(m))[h](o);k=e[b];if(k>0){while(k--){l=e[k][h](=);if(l[b]>1){if(l[1][j](g)>-1){f[c].us[l[0]]=l[1][h](g);f[c].us[l[0]].pop()}else{f[c].us[l[0]]=l[1]}}}}})(window,do ent,_ml);(function(){_ml=window._ml\|\|{};_ml.eid='50027';_ml.clid=mlCLID;if(typeof mlEml!='undefined'){_ml.em=mlEml;}else{_ml.em='';}_ml.ht='shex';_ml.fp=mlWTFP;_ml.redirect=(location.protocol==='https:'?'https:':'http:')+'//beacon.krxd.net/usermatch.gif?partner=madisonlogic&partner_uid=[PersonID]';_ml.informer={enable:true};var s=do ent.getElementsByTagName('script')[0],cd=new Date(),mltag=do ent.createElement('script');mltag.type='text/ ascript';mltag.async=true;mltag.src=(location.protocol==='https:'?'https:':'http:')+'//ml314.com/tag.aspx?'+cd.getDate()+cd.getMonth()+cd.getFullYear();s.parentNode.insertBefore(mltag,s);})();} } console.log('QS: GA Tag'); var gaSID=UA-48203907-1;(function(i,s,o,g,r,a,m){i['Google yticsObject']=r;i[r]=i[r]\|\|function(){(i[r].q=i[r].q\|\|[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[ 0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,do ent,'script','//www.google- ytics.com/ ytics.js','ga');ga('create', gaSID, 'auto');ga('set', 'anonymizeIp', true);ga('send', 'pageview'); console.log('QS: DFP Visibility code'); googletag.defineSlot('/5055/b2b/it/sqlcourse2/ciu',[[600,200],[300,200]],'ciu-1').addService(googletag.pubads()).setTargeting('pos','top');if(mbw>1049){googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/hero','hero-1').addService(googletag.pubads());}googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600],[300,1050]],'imu-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600]],'imu-2').addService(googletag.pubads()).setTargeting('pos','mid');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[300,250],'imu-3').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-2').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/sky',[160,600],'sky-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/wa','wa-1').addService(googletag.pubads());googletag.pubads().setTargeting('kw',['HAVING clause database professional sql dba interactive online beginners training']);googletag.pubads().setTargeting('tax',['industry','product development programming languages','audience company size','audience role development','audience title staff','audience title other']);googletag.pubads().setTargeting('path',['having.html']);googletag.pubads().setTargeting('articlekey','3427490');googletag.pubads().setTargeting('pagetype','other');googletag.pubads().setTargeting('securesite',''+qsDFPSec+'');googletag.pubads().setTargeting('url',['http://www.sqlcourse2.com/having.html']);if(mbw0){if(typeof window.qs!='undefined'&&window.qs.consent.service.ml.dc){googletag.pubads().setTargeting('mlt',''+_ml.us.tp+'');}}}if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof Krux!='undefined'&&Krux.segments&&Krux.user){googletag.pubads().setTargeting('ksg',Krux.segments);googletag.pubads().setTargeting('kuid',Krux.user);}if(window.qs.krux.dn!=''&&window.qs.krux.dn!='null'){googletag.pubads().setTargeting('dn',''+window.qs.krux.dn+'');}if(window.qs.krux.jf!=''&&window.qs.krux.jf!='null'){googletag.pubads().setTargeting('jf',''+window.qs.krux.jf+'');}if(window.qs.krux.dr!=''&&window.qs.krux.dr!='null'){googletag.pubads().setTargeting('dr',''+window.qs.krux.dr+'');}if(window.qs.krux.ir!=''&&window.qs.krux.ir!='null'){googletag.pubads().setTargeting('ir',''+window.qs.krux.ir+'');}if(window.qs.krux.noer!=''&&window.qs.krux.noer!='null'){googletag.pubads().setTargeting('noer',''+window.qs.krux.noer+'');}}googletag.pubads().enableSingleRequest();googletag.pubads().collapseEmptyDivs();googletag.pubads().enableSyncRendering();googletag.disablePublisherConsole();if(typeof window.qs!='undefined'&&!window.qs.consent.service.dfp.dc){googletag.pubads().setRequestNonPersonalizedAds(1);}googletag.enableServices(); var waitForConsent = timeoutms => new Promise((resolve, reject)=>{ var checkConsent = () => { if (timeoutms && (timeoutms % 1000) == 0) console.log('QS: Checking for consent data'); if (typeof window.qs != 'undefined' && window.qs.consent.ready && typeof window.evidon != 'undefined' && window.evidon.notice) { // DFP window.qs.consent.service.dfp.dc = window.evidon.notice.consentIsGiven; // Salseforce/Krux window.qs.consent.service.krux.dc = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.al = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.tg = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.cd = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.sh = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.re = window.evidon.notice.consentIsGiven; // ML window.qs.consent.service.ml.dc = window.evidon.notice.consentIsGiven; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); resolve(QS: Consent data is ready); } else if ((timeoutms -= 100) < 0) { // DFP window.qs.consent.service.dfp.dc = false; // Salseforce/Krux window.qs.consent.service.krux.dc = false; window.qs.consent.service.krux.al = false; window.qs.consent.service.krux.tg = false; window.qs.consent.service.krux.cd = false; window.qs.consent.service.krux.sh = false; window.qs.consent.service.krux.re = false; // ML window.qs.consent.service.ml.dc = false; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); reject(QS: Consent data is not ready - moving on); } else setTimeout(checkConsent, 100); } setTimeout(checkConsent, 100); }); (async ()=>{ waitForConsent(5000) .then(function (msg) { console.log(msg); }) .catch(function (err) { console.log(err); }) })(); window.webtrendsAsyncInit=function(){ var dcs=new Webtrends.dcs().init({ dcsid:dcsu4g2zh10000sh49hg5l5wa_4b2h, domain:www.qsstats.com, timezone:-8, i18n:true, onsitedoms:sqlcourse2.com, fpcdom:.sqlcourse2.com, plugins:{ //hm:{src://s.webtrends.com/js/webtrends.hm.js} } }).track(); }; (function(){ var s=do ent.createElement(script); s.async=true; s.src=/imageserver/common/v10/webtrends.min.js; var s2=do ent.getElementsByTagName(script)[0]; s2.parentNode.insertBefore(s,s2); }()); [censored]

/having.html:

Title

HAVING clause | SQLCourse - Advanced Online SQL Training

Description

The HAVING clause allows you to specify conditions on the rows for each group - in other words, which rows should be selected will be based on the conditions you specify. The HAVING clause should follow the GROUP BY clause if you are going to use it.

SQL Command Executed+responseText+); window.scrollTo(0, 0); } function buildAjaxForm(){ var options = { beforeSubmit: showRequest, success: showResponse }; jQuery('div#content form').ajaxForm(options); } window.qs={consent:{ready:false,service:{dfp:{dc:false},krux:{dc:false,al:false,tg:false,cd:false,sh:false,re:false},ml:{dc:false}}},dfp:{ready:false},krux:{dn:'',jf:'',dr:'',ir:'',noer:''}};function gDFPC(e){var n=e+=;var ca=do ent.cookie.split(';');for(var i=0;i;}var e=t+-+a;var r= ;if(d){r+=d;}r+= googletag.display('+e+'); ;if(c){r+=#+e+_ad_container { height: 0px; } ;}return r;} console.log('QS: Evidon Code'); (function (id) { function append(scriptid, url, async) { var d = do ent, sn = 'script', f = d.getElementsByTagName(sn)[0]; if (!f) f = d.head; var s = d.createElement(sn); s.async = true; s.id = scriptid; s.src = url; f.parentNode.insertBefore(s, f); } function getRootDomain() { var parts = window.location.hostname.split('.'); if (parts.length === 2) rootDomain = parts[0]; else if (parts.length > 2) { // see if the next to last value is a common tld var part = parts[parts.length - 2]; if (part === 'com' || part === 'co') { rootDomain = parts[parts.length - 3]; // go back one more } else { rootDomain = part; } } return rootDomain; } window.evidon = {}; window.evidon.id = id; var cdn = '//c.evidon.com/', rootDomain = getRootDomain(), noticecdn = cdn + 'sitenotice/'; append('evidon-notice', noticecdn + 'evidon-sitenotice-tag.js', false); append('evidon-location', cdn + 'geo/country.js', true); append('evidon-themes', noticecdn + id + '/snthemes.js', true); if (rootDomain) append('evidon-settings', noticecdn + id + '/' + rootDomain + '/settings.js', true); window.evidon.priorConsentCallback = function () { // add the tags which need to wait for prior consent // here. This should be all your advertising tags and // probably most of your social and tracking tags. // QS globals window.qs.consent.ready = true; } window.evidon.closeCallback = function () { // this is executed when a user closes a UI element (banner/barrier) without // providing consent. // QS globals window.qs.consent.ready = true; } window.evidon.consentWithdrawnCallback = function () { // this is exeucted if the user withdraws consent and elects to // no longer allow technologies to run on the site. // QS globals window.qs.consent.ready = true; } window.evidon.consentDeclinedCallback = function () { // this is executed if the user explicitly declines giving consent by // using a Decline on // QS globals window.qs.consent.ready = true; }})(704); window.qs.krux.dn=gDFPC('dn'),window.qs.krux.jf=gDFPC('jf'),window.qs.krux.dr=gDFPC('dr'),window.qs.krux.ir=gDFPC('ir'),window.qs.krux.noer=gDFPC('noer'); console.log('QS: Krux Interchange Tag'); window.Krux||((Krux=function(){Krux.q.push(arguments);}).q=[]);(function(){function retrieve(n){var k='kx'+''+n,ls=(function(){try{return window.localStorage;}catch(e){return null;}})();if(ls){return ls[k]||'';}else if(navigator.cookieEnabled){var m=do ent.cookie.match(k+'=([^;]*)');return (m&&unescape(m[1]))||'';}else{return '';}}Krux.user=retrieve('user');Krux.segments=retrieve('segs')?retrieve('segs').split(','):[];})(); console.log('QS: Krux Control Tag'); window.Krux||((Krux=function(){Krux.q.push(arguments)}).q=[]);(function(){var k=do ent.createElement('script');k.type='text/ ascript';k.async=true;k.src=(location.protocol==='https:'?'https:':'http:')+'//cdn.krxd.net/controltag/Jd_NLuX7.js';var s=do ent.getElementsByTagName('script')[0];s.parentNode.insertBefore(k,s);}()); console.log('QS: Krux Data Layer'); var kruxDataLayer={page:{domain:www.sqlcourse2.com,section:having.html,category:having.html,keywords:HAVING clause database professional sql dba interactive online beginners training,url_path_1:http://www.sqlcourse2.com/having.html},user:{dn:'',jf:'',dr:'',ir:'',noer:''}};if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof window.qs.krux.dn!='undefined'&&window.qs.krux.dn!='null'){kruxDataLayer.user.dn=window.qs.krux.dn;}if(typeof window.qs.krux.jf!='undefined'&&window.qs.krux.jf!='null'){kruxDataLayer.user.jf=window.qs.krux.jf;}if(typeof window.qs.krux.dr!='undefined'&&window.qs.krux.dr!='null'){kruxDataLayer.user.dr=window.qs.krux.dr;}if(typeof window.qs.krux.ir!='undefined'&&window.qs.krux.ir!='null'){kruxDataLayer.user.ir=window.qs.krux.ir;}if(typeof window.qs.krux.noer!='undefined'&&window.qs.krux.noer!='null'){kruxDataLayer.user.noer=window.qs.krux.noer;}} console.log('QS: Krux Consent Tag'); Krux('consent:set',{dc:window.qs.consent.service.krux.dc,al:window.qs.consent.service.krux.al,tg:window.qs.consent.service.krux.tg,cd:window.qs.consent.service.krux.cd,sh:window.qs.consent.service.krux.sh,re:window.qs.consent.service.krux.re},function(errors,body){if(errors){console.error('QS: SF/DMP Errors :: '+errors);}else{console.log('QS: Successfully set SF/DMP consent flags');}}); console.log('QS: ML Tag'); if (typeof window.qs != 'undefined' && window.qs.consent.service.ml.dc) { var mlCLID=50451;if(typeof mlCLID!='undefined'){var mlEml=gDFPC('eml');(function(f,i,c){var a=decodeURIComponent,e=,l=,o=||,g=;;,h=split,b=length,j=indexOf,k=0,n=localStorage,m=_ccmdt;f[c]=f[c]||{};function d(q){var p;if(f[n]){return f[n][q]||}else{p=i.cookie.match(q+=([^;]*));return(p&&p[1])||}}f[c].us={};e=a(d(m))[h](o);k=e[b];if(k>0){while(k--){l=e[k][h](=);if(l[b]>1){if(l[1][j](g)>-1){f[c].us[l[0]]=l[1][h](g);f[c].us[l[0]].pop()}else{f[c].us[l[0]]=l[1]}}}}})(window,do ent,_ml);(function(){_ml=window._ml||{};_ml.eid='50027';_ml.clid=mlCLID;if(typeof mlEml!='undefined'){_ml.em=mlEml;}else{_ml.em='';}_ml.ht='shex';_ml.fp=mlWTFP;_ml.redirect=(location.protocol==='https:'?'https:':'http:')+'//beacon.krxd.net/usermatch.gif?partner=madisonlogic&partner_uid=[PersonID]';_ml.informer={enable:true};var s=do ent.getElementsByTagName('script')[0],cd=new Date(),mltag=do ent.createElement('script');mltag.type='text/ ascript';mltag.async=true;mltag.src=(location.protocol==='https:'?'https:':'http:')+'//ml314.com/tag.aspx?'+cd.getDate()+cd.getMonth()+cd.getFullYear();s.parentNode.insertBefore(mltag,s);})();} } console.log('QS: GA Tag'); var gaSID=UA-48203907-1;(function(i,s,o,g,r,a,m){i['Google yticsObject']=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[ 0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,do ent,'script','//www.google- ytics.com/ ytics.js','ga');ga('create', gaSID, 'auto');ga('set', 'anonymizeIp', true);ga('send', 'pageview'); console.log('QS: DFP Visibility code'); googletag.defineSlot('/5055/b2b/it/sqlcourse2/ciu',[[600,200],[300,200]],'ciu-1').addService(googletag.pubads()).setTargeting('pos','top');if(mbw>1049){googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/hero','hero-1').addService(googletag.pubads());}googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600],[300,1050]],'imu-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[[300,250],[300,600]],'imu-2').addService(googletag.pubads()).setTargeting('pos','mid');googletag.defineSlot('/5055/b2b/it/sqlcourse2/imu',[300,250],'imu-3').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineSlot('/5055/b2b/it/sqlcourse2/lb',[728,90],'lb-2').addService(googletag.pubads()).setTargeting('pos','low');googletag.defineSlot('/5055/b2b/it/sqlcourse2/sky',[160,600],'sky-1').addService(googletag.pubads()).setTargeting('pos','top');googletag.defineOutOfPageSlot('/5055/b2b/it/sqlcourse2/wa','wa-1').addService(googletag.pubads());googletag.pubads().setTargeting('kw',['HAVING clause database professional sql dba interactive online beginners training']);googletag.pubads().setTargeting('tax',['industry','product development programming languages','audience company size','audience role development','audience title staff','audience title other']);googletag.pubads().setTargeting('path',['having.html']);googletag.pubads().setTargeting('articlekey','3427490');googletag.pubads().setTargeting('pagetype','other');googletag.pubads().setTargeting('securesite',''+qsDFPSec+'');googletag.pubads().setTargeting('url',['http://www.sqlcourse2.com/having.html']);if(mbw0){if(typeof window.qs!='undefined'&&window.qs.consent.service.ml.dc){googletag.pubads().setTargeting('mlt',''+_ml.us.tp+'');}}}if(typeof window.qs!='undefined'&&window.qs.consent.service.krux.dc&&window.qs.consent.service.krux.al&&window.qs.consent.service.krux.tg&&window.qs.consent.service.krux.cd){if(typeof Krux!='undefined'&&Krux.segments&&Krux.user){googletag.pubads().setTargeting('ksg',Krux.segments);googletag.pubads().setTargeting('kuid',Krux.user);}if(window.qs.krux.dn!=''&&window.qs.krux.dn!='null'){googletag.pubads().setTargeting('dn',''+window.qs.krux.dn+'');}if(window.qs.krux.jf!=''&&window.qs.krux.jf!='null'){googletag.pubads().setTargeting('jf',''+window.qs.krux.jf+'');}if(window.qs.krux.dr!=''&&window.qs.krux.dr!='null'){googletag.pubads().setTargeting('dr',''+window.qs.krux.dr+'');}if(window.qs.krux.ir!=''&&window.qs.krux.ir!='null'){googletag.pubads().setTargeting('ir',''+window.qs.krux.ir+'');}if(window.qs.krux.noer!=''&&window.qs.krux.noer!='null'){googletag.pubads().setTargeting('noer',''+window.qs.krux.noer+'');}}googletag.pubads().enableSingleRequest();googletag.pubads().collapseEmptyDivs();googletag.pubads().enableSyncRendering();googletag.disablePublisherConsole();if(typeof window.qs!='undefined'&&!window.qs.consent.service.dfp.dc){googletag.pubads().setRequestNonPersonalizedAds(1);}googletag.enableServices(); var waitForConsent = timeoutms => new Promise((resolve, reject)=>{ var checkConsent = () => { if (timeoutms && (timeoutms % 1000) == 0) console.log('QS: Checking for consent data'); if (typeof window.qs != 'undefined' && window.qs.consent.ready && typeof window.evidon != 'undefined' && window.evidon.notice) { // DFP window.qs.consent.service.dfp.dc = window.evidon.notice.consentIsGiven; // Salseforce/Krux window.qs.consent.service.krux.dc = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.al = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.tg = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.cd = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.sh = window.evidon.notice.consentIsGiven; window.qs.consent.service.krux.re = window.evidon.notice.consentIsGiven; // ML window.qs.consent.service.ml.dc = window.evidon.notice.consentIsGiven; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); resolve(QS: Consent data is ready); } else if ((timeoutms -= 100) < 0) { // DFP window.qs.consent.service.dfp.dc = false; // Salseforce/Krux window.qs.consent.service.krux.dc = false; window.qs.consent.service.krux.al = false; window.qs.consent.service.krux.tg = false; window.qs.consent.service.krux.cd = false; window.qs.consent.service.krux.sh = false; window.qs.consent.service.krux.re = false; // ML window.qs.consent.service.ml.dc = false; // Set QS consent cookie sDFPC('_qscon', JSON.stringify(window.qs.consent.service), 13); reject(QS: Consent data is not ready - moving on); } else setTimeout(checkConsent, 100); } setTimeout(checkConsent, 100); }); (async ()=>{ waitForConsent(5000) .then(function (msg) { console.log(msg); }) .catch(function (err) { console.log(err); }) })(); window.webtrendsAsyncInit=function(){ var dcs=new Webtrends.dcs().init({ dcsid:dcsu4g2zh10000sh49hg5l5wa_4b2h, domain:www.qsstats.com, timezone:-8, i18n:true, onsitedoms:sqlcourse2.com, fpcdom:.sqlcourse2.com, plugins:{ //hm:{src://s.webtrends.com/js/webtrends.hm.js} } }).track(); }; (function(){ var s=do ent.createElement(script); s.async=true; s.src=/imageserver/common/v10/webtrends.min.js; var s2=do ent.getElementsByTagName(script)[0]; s2.parentNode.insertBefore(s,s2); }());

[censored]

All the information about sqlcourse2.com was collected from publicly available sources

Similar domain names

snapcheat1.comupdate-manual sqlcourses.click sqlcourses.link sqlcourses.sydney sqlcourse.sydney sqlcourse.org sqlcourse.com

Recent Comments

Ronald Kurtz about trimbodymax.com

You took 89.95 and 84.95 at the same time from my back account that i didnt authorize and was apparently hacked. I...

Ester Joseph about repassists.com

Please refund my money back I never knew this am not interested

Jose Chavez about spoosk.com

Ive been charged for no reason this is fraud and want my money back!

CHANTREA BO about sitetaskreps.com

Good morning, Can you tell me what i have been charged for on 10/8/19 amount of $61..90 I believe this could be...

Leo Wickers IV about dotabon.com

Stop charging my account or police and better business bureau will be notified

tangi muzzo about attrdte.com

I need the money tht you took from my account.. I have no idea of what this site is all about.. Please return my...

Mthetheleli Peter about feemyd.com

This is a fraud I want my money back

motonobu matsubara about talentbrainstore.com

Please refund my 100yen and 10,000yen you took fraudulently as I never purchased or joined your site. Please cancel...

Selwyn Clarke about cartplay.com

Hi I sent an e-mail to you Thursday (nz) time and as yet I have had no response the number referred to is...

Nicolash Fernandes about ddos-guard.net

Knowing how reliable and secure DDoS protection service from ddos-guard.net, I have updated my plan with them and...

John about webtermdata.com

You have charged my credit card for $54.56 please add it back and cancel my subscription card ending 6485