Return-path: <bounce-mc.us5_10342275.58573-christoper=ssf.com.mx@mail155.atl171.mcdlv.net>
Envelope-to: christoper@ssf.com.mx
Delivery-date: Wed, 24 Jun 2015 15:29:48 -0500
Received: from mail155.atl171.mcdlv.net ([198.2.138.155]:24275)
	by vishnu.hosting-mexico.net with esmtp (Exim 4.85)
	(envelope-from <bounce-mc.us5_10342275.58573-christoper=ssf.com.mx@mail155.atl171.mcdlv.net>)
	id 1Z7rIn-003VTD-Kv
	for christoper@ssf.com.mx; Wed, 24 Jun 2015 15:29:48 -0500
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; s=k1; d=mail155.atl171.mcdlv.net;
 h=Subject:From:Reply-To:To:Date:Message-ID:List-ID:List-Unsubscribe:Sender:Content-Type:MIME-Version; i=hal=3Dcodeschool.com@mail155.atl171.mcdlv.net;
 bh=A3bvTI15F59IXIOAzQoTQNM3z/I=;
 b=Nuay+6t/280CvqnBFiaDgfkOYgZd0YReGYo2cMxd/ro/Z6ixx3EEFqfhvJLN9KpuxWc/DIeo2yTP
   /x4bRjWO9Nsupdepm2FXibBgsZF2hnM8B5J8qEQmFVaobsVEb/37CfdyMV+d/WuJrQE+mRyasWaw
   MtJh9X+QR1beey0GGvg=
DomainKey-Signature: a=rsa-sha1; c=nofws; q=dns; s=k1; d=mail155.atl171.mcdlv.net;
 b=LKuy1IXL/b4PC5fPUq0QHRqmu5MBXPIU/ViGLdEW28ePG1SiWdVXSu1oc73txyGkQG+1spyCO1gQ
   ArELw87EqJYiCfYnwGGlkaxkk9LRf7XFJ1CKqwZM4ITyLIcWISvNVkjyJczWOQ/vEo1x6gmUA/Mb
   U+wzFi0LyIPRmi78a2k=;
Received: from (127.0.0.1) by mail155.atl171.mcdlv.net id hhc9jm1sb54n for <christoper@ssf.com.mx>; Wed, 24 Jun 2015 20:29:45 +0000 (envelope-from <bounce-mc.us5_10342275.58573-christoper=ssf.com.mx@mail155.atl171.mcdlv.net>)
Subject: =?utf-8?Q?=F0=9F=9A=80=C2=A0New=20Course=20Launched=3A=20The=20Sequel=20to=20SQL?=
From: =?utf-8?Q?Code=20School?= <hal@codeschool.com>
Reply-To: =?utf-8?Q?Code=20School?= <hal@codeschool.com>
To: <christoper@ssf.com.mx>
Date: Wed, 24 Jun 2015 20:29:45 +0000
Message-ID: <8234ed62d6a7fa87721ff1d8ab2beb48d48.20150624202912@mail155.atl171.mcdlv.net>
X-Mailer: MailChimp Mailer - **CID51c5296975b2beb48d48**
X-Campaign: mailchimp8234ed62d6a7fa87721ff1d8a.51c5296975
X-campaignid: mailchimp8234ed62d6a7fa87721ff1d8a.51c5296975
X-Report-Abuse: Please report abuse for this campaign here: http://www.mailchimp.com/abuse/abuse.phtml?u=8234ed62d6a7fa87721ff1d8a&id=51c5296975&e=b2beb48d48
X-MC-User: 8234ed62d6a7fa87721ff1d8a
X-Feedback-ID: 10342275:10342275.58573:us5:mc
List-ID: 8234ed62d6a7fa87721ff1d8amc list <8234ed62d6a7fa87721ff1d8a.24393.list-id.mcsv.net>
X-Accounttype: pd
List-Unsubscribe: <mailto:unsubscribe-8234ed62d6a7fa87721ff1d8a-51c5296975-b2beb48d48@mailin1.us2.mcsv.net?subject=unsubscribe>, <http://CodeSchool.us5.list-manage.com/unsubscribe?u=8234ed62d6a7fa87721ff1d8a&id=b819d211aa&e=b2beb48d48&c=51c5296975>
Sender: "Code School" <hal=codeschool.com@mail155.atl171.mcdlv.net>
x-mcda: FALSE
Content-Type: multipart/alternative; boundary="_----------=_MCPart_180873568"
MIME-Version: 1.0
X-Spam-Status: No, score=-2.4
X-Spam-Score: -23
X-Spam-Bar: --
X-Ham-Report: Spam detection software, running on the system "vishnu.hosting-mexico.net",
 has NOT identified this incoming email as spam.  The original
 message has been attached to this so you can view it or label
 similar future email.  If you have any questions, see
 root\@localhost for details.
 
 Content preview:  http://CodeSchool.us5.list-manage.com/track/click?u=8234ed62d6a7fa87721ff1d8a&id=67276717a5&e=b2beb48d48
    The Sequel to SQL ​Learn the most important parts of the SQL language
    so you can create tables with constraints, use relationships, and write powerful
    join queries. [...] 
 
 Content analysis details:   (-2.4 points, 5.0 required)
 
  pts rule name              description
 ---- ---------------------- --------------------------------------------------
  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was blocked.
                             See
                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block
                              for more information.
                             [URIs: mailchimp.com]
 -0.0 RCVD_IN_DNSWL_NONE     RBL: Sender listed at http://www.dnswl.org/, no
                             trust
                             [198.2.138.155 listed in list.dnswl.org]
 -0.0 SPF_HELO_PASS          SPF: HELO matches SPF record
  0.0 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail
                             domains are different
 -0.0 SPF_PASS               SPF: sender matches SPF record
 -1.4 RP_MATCHES_RCVD        Envelope sender domain matches handover relay domain
 -1.0 RCVD_IN_MSPIKE_H5      RBL: Excellent reputation (+5)
                             [198.2.138.155 listed in wl.mailspike.net]
  0.0 HTML_MESSAGE           BODY: HTML included in message
  0.0 MIME_QP_LONG_LINE      RAW: Quoted-printable line longer than 76 chars
  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid
 -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature
 -0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders
X-Spam-Flag: NO

This is a multi-part message in MIME format

--_----------=_MCPart_180873568
Content-Type: text/plain; charset="utf-8"; format="fixed"
Content-Transfer-Encoding: quoted-printable

http://CodeSchool.us5.list-manage.com/track/click?u=3D8234ed62d6a7fa87721f=
f1d8a&id=3D67276717a5&e=3Db2beb48d48

The Sequel to SQL
=E2=80=8BLearn the most important parts of the SQL language so you can cre=
ate tables with constraints=2C use relationships=2C and write powerful joi=
n queries.

level title                                 description
1     Aggregate Functions                   Learn how to use SQL aggregate=
 functions=2C including COUNT=2C SUM=2C and AVG=2C to do calculations on g=
roups of data.
2     Table Constraints                     Add constraints =E2=80=94 like=
 NOT NULL=2C UNIQUE=2C FOREIGN KEY=2C and PRIMARY KEY =E2=80=94 to your ta=
bles to increase data integrity.
3     Normalization and Relationships       Apply normalization rules to c=
reate tables without duplicate data and build the appropriate relationship=
s.
4     Inner Joins=2C Aliases=2C and Outer Joins Explore writing a single q=
uery to pull data from multiple tables and using aliases to create succinc=
t queries.
5     Subqueries                            Dive deeper as you learn how t=
o write queries within queries.

Play the Course (http://CodeSchool.us5.list-manage1.com/track/click?u=3D82=
34ed62d6a7fa87721ff1d8a&id=3D138c014b80&e=3Db2beb48d48)

Recommended Prerequisite
Try SQL
Try SQL badge
Play the Course (http://CodeSchool.us5.list-manage.com/track/click?u=3D823=
4ed62d6a7fa87721ff1d8a&id=3D7d838b497a&e=3Db2beb48d48)

Tweet This (http://CodeSchool.us5.list-manage.com/track/click?u=3D8234ed62=
d6a7fa87721ff1d8a&id=3D64d19d9448&e=3Db2beb48d48)

Have questions or need assistance? codeschool.com/support
Edit your email settings (http://CodeSchool.us5.list-manage1.com/track/cli=
ck?u=3D8234ed62d6a7fa87721ff1d8a&id=3D5efb628626&e=3Db2beb48d48)   =
  Unsubscribe (http://CodeSchool.us5.list-manage.com/unsubscribe?u=3D8234e=
d62d6a7fa87721ff1d8a&id=3Db819d211aa&e=3Db2beb48d48&c=3D51c5296975)
http://CodeSchool.us5.list-manage.com/track/click?u=3D8234ed62d6a7fa87721f=
f1d8a&id=3D58836557ab&e=3Db2beb48d48
http://CodeSchool.us5.list-manage.com/track/click?u=3D8234ed62d6a7fa87721f=
f1d8a&id=3D040e88964f&e=3Db2beb48d48   http://CodeSchool.us5.list-ma=
nage.com/track/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3Dd33b04e92c&e=3D=
b2beb48d48   http://CodeSchool.us5.list-manage.com/track/click?u=3D8234=
ed62d6a7fa87721ff1d8a&id=3D6b8376f914&e=3Db2beb48d48   http://CodeSc=
hool.us5.list-manage.com/track/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3D2e=
0d4d4573&e=3Db2beb48d48
http://CodeSchool.us5.list-manage.com/track/click?u=3D8234ed62d6a7fa87721f=
f1d8a&id=3Ddc7f1d1004&e=3Db2beb48d48
Code School
618 E South Street
Suite 620
Orlando=2C FL 32801
USA
=C2=A9 2015 Code School LLC. Crafted lovingly in Orlando=2C Florida.
http://CodeSchool.us5.list-manage.com/track/click?u=3D8234ed62d6a7fa87721f=
f1d8a&id=3Dee326a4cdf&e=3Db2beb48d48
--_----------=_MCPart_180873568
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html>
<html lang=3D"en">
  <head>
    <meta charset=3D"utf-8">
    <meta content=3D"width=3Ddevice-width=2C initial-scale=3D1.0" name=3D"=
viewport">
    <title>Announcement Sequel to SQL</title>
  <style type=3D"text/css">
=09=09table{
=09=09=09border-collapse:collapse;
=09=09=09border-spacing:0;
=09=09}
=09=09td.text=2C.has-btn{
=09=09=09mso-line-height-rule:exactly;
=09=09=09-webkit-font-smoothing:antialiased;
=09=09=09-ms-text-size-adjust:none;
=09=09=09-webkit-text-size-adjust:none;
=09=09}
=09@media screen and (max-width: 600px){
=09=09.text{
=09=09=09font-size:14px !important;
=09=09=09line-height:21px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.h1{
=09=09=09font-size:20px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.h2{
=09=09=09font-size:18px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.h3{
=09=09=09font-size:16px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.h4{
=09=09=09font-size:14px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.h5{
=09=09=09font-size:14px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09table{
=09=09=09line-height:1.5 !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.h1=2C.h2=2C.h3=2C.h4=2C.h5{
=09=09=09line-height:1.2 !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.cs-logo{
=09=09=09width:120px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.flex-size{
=09=09=09max-width:100% !important;
=09=09=09width:100% !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.flex-size img{
=09=09=09max-width:100% !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-height{
=09=09=09height:10px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-hf{
=09=09=09height:0 !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-paf{
=09=09=09padding:0 !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-plf{
=09=09=09padding-left:0 !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-prf{
=09=09=09padding-right:0 !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-pts{
=09=09=09padding-top:8px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-ptm{
=09=09=09padding-top:15px !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-tac{
=09=09=09text-align:center !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.s-tal{
=09=09=09text-align:left !important;
=09=09}

}=09@media screen and (max-width: 600px){
=09=09.maskLink-footer a{
=09=09=09color:#a5a6a7 !important;
=09=09}

}=09@media screen and (min-device-width: 375px) and (max-device-width: 667=
px){
=09=09table{
=09=09=09font-size:16px !important;
=09=09}

}=09@media screen and (min-device-width: 375px) and (max-device-width: 667=
px){
=09=09table.footer-content{
=09=09=09font-size:12px !important;
=09=09}

}=09=09.footer a{
=09=09=09color:#a5a6a7;
=09=09}
=09@media (max-width: 599px){
=09=09.flex-data td{
=09=09=09display:block !important;
=09=09=09width:100% !important;
=09=09}

}</style></head>
  <body style=3D"margin: 0; padding: 0;">
    <table bgcolor=3D"#ffffff" border=3D"0" cellpadding=3D"0" cellspacing=
=3D"0" class=3D"header" width=3D"100%" style=3D"border-collapse: collapse;=
border-spacing: 0;">
      <tr>
        <td align=3D"center" style=3D"border-bottom: 1px solid #f7f7f7; pa=
dding: 12px 0;">
          <a href=3D"http://CodeSchool.us5.list-manage.com/track/click?u=
=3D8234ed62d6a7fa87721ff1d8a&id=3Db9ebdb788c&e=3Db2beb48d48">
            <img alt=3D"" border=3D"0" src=3D"https://gallery.mailchimp.co=
m/8234ed62d6a7fa87721ff1d8a/images/3b956e42-1381-4d47-8332-808334d3b280.pn=
g" width=3D"190">
          </a>
        </td>
      </tr>
    </table>

    <table bgcolor=3D"#000000" border=3D"0" cellpadding=3D"0" cellspacing=
=3D"0" width=3D"100%" style=3D"border-collapse: collapse;border-spacing: 0=
;">
      <tr>
        <td align=3D"center" style=3D"padding: 0 20px;">
          <!--[if (IE)|mso]>
          <table align=3D'center' border=3D'0' cellpadding=3D'0' cellspaci=
ng=3D'0' width=3D'600'>
          <tr>
          <td>
          <![endif]-->
          <table align=3D"center" border=3D"0" cellpadding=3D"0" cellspaci=
ng=3D"0" class=3D"flex-size" style=3D"max-width: 600px;border-collapse: co=
llapse;border-spacing: 0;" width=3D"100%">
            <tr>
              <td align=3D"center">
                <img alt=3D"The Sequel to SQL" src=3D"https://gallery.mail=
chimp.com/8234ed62d6a7fa87721ff1d8a/images/1368c9ff-d26f-42b3-ab8a-888c4f3=
e112e.png" style=3D"display: block; max-width: 100%;" width=3D"600">
              </td>
            </tr>
            <tr>
              <td align=3D"left" class=3D"text" style=3D"color: #f6f7f7;fo=
nt-family: 'Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C sans-serif;font=
-size: 16px;line-height: 24px;padding-top: 16px;mso-line-height-rule: exac=
tly;-webkit-font-smoothing: antialiased;-ms-text-size-adjust: none;-webkit=
-text-size-adjust: none;">
                =E2=80=8BLearn the most important parts of the SQL languag=
e so you can create tables with constraints=2C use relationships=2C and wr=
ite powerful join queries.
              </td>
            </tr>
          </table>
          <!--[if (IE)|mso]>
          </td>
          </tr>
          </table>
          <![endif]-->
        </td>
      </tr>
    </table>
    <table bgcolor=3D"#000000" border=3D"0" cellpadding=3D"0" cellspacing=
=3D"0" width=3D"100%" style=3D"border-collapse: collapse;border-spacing: 0=
;">
      <tr>
        <td align=3D"center" style=3D"padding: 16px 20px 0 20px;">
          <!--[if (IE)|mso]>
          <table align=3D'center' border=3D'0' cellpadding=3D'0' cellspaci=
ng=3D'0' width=3D'600'>
          <tr>
          <td>
          <![endif]-->
          <table align=3D"center" bgcolor=3D"#222222" border=3D"0" cellpad=
ding=3D"0" cellspacing=3D"0" class=3D"flex-size flex-data" style=3D"max-wi=
dth: 600px;border-collapse: collapse;border-spacing: 0;" width=3D"100%">
            <tr>
              <td align=3D"left" bgcolor=3D"#333333" class=3D"text" style=
=3D"border: 1px solid #666666;color: #f6f7f7;font-family: 'Open Sans'=2C V=
erdana=2C Helvetica=2C Arial=2C sans-serif;font-size: 16px;font-weight: bo=
ld;line-height: 24px;padding: 4px;vertical-align: top;mso-line-height-rule=
: exactly;-webkit-font-smoothing: antialiased;-ms-text-size-adjust: none;-=
webkit-text-size-adjust: none;" width=3D"47">
                level
              </td>
              <td align=3D"left" bgcolor=3D"#333333" class=3D"text" style=
=3D"border: 1px solid #666666;color: #f6f7f7;font-family: 'Open Sans'=2C V=
erdana=2C Helvetica=2C Arial=2C sans-serif;font-size: 16px;font-weight: bo=
ld;line-height: 24px;padding: 4px;vertical-align: top;mso-line-height-rule=
: exactly;-webkit-font-smoothing: antialiased;-ms-text-size-adjust: none;-=
webkit-text-size-adjust: none;">
                title
              </td>
              <td align=3D"left" bgcolor=3D"#333333" class=3D"text" style=
=3D"border: 1px solid #666666;color: #f6f7f7;font-family: 'Open Sans'=2C V=
erdana=2C Helvetica=2C Arial=2C sans-serif;font-size: 16px;font-weight: bo=
ld;line-height: 24px;padding: 4px;vertical-align: top;mso-line-height-rule=
: exactly;-webkit-font-smoothing: antialiased;-ms-text-size-adjust: none;-=
webkit-text-size-adjust: none;">
                description
              </td>
            </tr>
            <tr>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;" width=
=3D"47">
                1
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Aggregate Functions
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Learn how to use SQL aggregate functions=2C including COUN=
T=2C SUM=2C and AVG=2C to do calculations on groups of data.
              </td>
            </tr>
            <tr>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;" width=
=3D"47">
                2
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Table Constraints
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Add constraints &mdash; like NOT NULL=2C UNIQUE=2C FOREIGN=
 KEY=2C and PRIMARY KEY &mdash; to your tables to increase data integrity.
              </td>
            </tr>
            <tr>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;" width=
=3D"47">
                3
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Normalization and Relationships
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Apply normalization rules to create tables without duplica=
te data and build the appropriate relationships.
              </td>
            </tr>
            <tr>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;" width=
=3D"47">
                4
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Inner Joins=2C Aliases=2C and Outer Joins
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Explore writing a single query to pull data from multiple=
 tables and using aliases to create succinct queries.
              </td>
            </tr>
            <tr>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;" width=
=3D"47">
                5
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Subqueries
              </td>
              <td align=3D"left" class=3D"text" style=3D"border: 1px solid=
 #666666;color: #f6f7f7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=
=2C Arial=2C sans-serif;font-size: 14px;line-height: 24px;padding: 4px;ver=
tical-align: top;mso-line-height-rule: exactly;-webkit-font-smoothing: ant=
ialiased;-ms-text-size-adjust: none;-webkit-text-size-adjust: none;">
                Dive deeper as you learn how to write queries within queri=
es.
              </td>
            </tr>
          </table>
          <!--[if (IE)|mso]>
          </td>
          </tr>
          </table>
          <![endif]-->
        </td>
      </tr>
    </table>
    <table bgcolor=3D"#000000" border=3D"0" cellpadding=3D"0" cellspacing=
=3D"0" width=3D"100%" style=3D"border-collapse: collapse;border-spacing: 0=
;">
      <tr>
        <td align=3D"center" style=3D"padding: 0 20px;">
          <!--[if (IE)|mso]>
          <table align=3D'center' border=3D'0' cellpadding=3D'0' cellspaci=
ng=3D'0' width=3D'600'>
          <tr>
          <td>
          <![endif]-->
          <table align=3D"center" border=3D"0" cellpadding=3D"0" cellspaci=
ng=3D"0" class=3D"flex-size" style=3D"max-width: 600px;border-collapse: co=
llapse;border-spacing: 0;" width=3D"100%">
            <tr>
              <td align=3D"center" style=3D"padding: 40px 0;">
                <!--[if mso]>
                  <v:roundrect xmlns:v=3D"urn:schemas-microsoft-com:vml" x=
mlns:w=3D"urn:schemas-microsoft-com:office:word" href=3D"https://www.codes=
chool.com/courses/the-sequel-to-sql/?utm_medium=3Demail&utm_campaign=3Dann=
ouncement_sequel_to_sql&utm_source=3Dmailchimp&utm_content=3Dnull" style=
=3D"height:42px;v-text-anchor:middle;width:200px;" arcsize=3D"250%" stroke=
=3D"f" fillcolor=3D"#ffffff">
                  <w:anchorlock/>
                  <center>
                <![endif]-->
                <a class=3D"btn-a" href=3D"http://CodeSchool.us5.list-mana=
ge.com/track/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3Dca18a7ae19&e=3D=
b2beb48d48" style=3D"background-color:#b7a474; background-image: linear-gradie=
nt(#b39e5e=2C #7f6e3c); border-radius:100px; color:#ffffff; display:inline=
-block; font-family: 'Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C sans-=
serif; font-size:14px; font-weight:bold; line-height:42px; text-align:cent=
er; text-decoration:none; text-transform: uppercase; width:200px;">Play th=
e Course</a>
                <!--[if mso]>
                  </center>
                  </v:roundrect>
                <![endif]-->
              </td>
            </tr>
          </table>
          <!--[if (IE)|mso]>
          </td>
          </tr>
          </table>
          <![endif]-->
        </td>
      </tr>
    </table>
    <table bgcolor=3D"#151515" border=3D"0" cellpadding=3D"0" cellspacing=
=3D"0" width=3D"100%" style=3D"border-collapse: collapse;border-spacing: 0=
;">
      <tr>
        <td align=3D"center" style=3D"border-bottom: 1px solid #444444; bo=
rder-top: 1px solid #444444; padding: 32px 20px;">
          <!--[if (IE)|mso]>
          <table align=3D'center' border=3D'0' cellpadding=3D'0' cellspaci=
ng=3D'0' width=3D'600'>
          <tr>
          <td>
          <![endif]-->
          <table align=3D"center" border=3D"0" cellpadding=3D"0" cellspaci=
ng=3D"0" class=3D"flex-size" style=3D"max-width: 600px;border-collapse: co=
llapse;border-spacing: 0;" width=3D"100%">
            <tr>
              <td align=3D"center" class=3D"text h5" style=3D"color: #b7a4=
74;font-family: 'Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C sans-serif=
;font-size: 16px;font-weight: bold;line-height: 24px;mso-line-height-rule:=
 exactly;-webkit-font-smoothing: antialiased;-ms-text-size-adjust: none;-w=
ebkit-text-size-adjust: none;">
                Recommended Prerequisite
              </td>
            </tr>
            <tr>
              <td align=3D"center" class=3D"text h3" style=3D"color: #b7a4=
74;font-family: 'Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C sans-serif=
;font-size: 24px;font-weight: bold;line-height: 36px;mso-line-height-rule:=
 exactly;-webkit-font-smoothing: antialiased;-ms-text-size-adjust: none;-w=
ebkit-text-size-adjust: none;">
                Try SQL
              </td>
            </tr>
            <tr>
              <td align=3D"center" style=3D"padding: 16px 0 20px 0;">
                <img alt=3D"Try SQL badge" src=3D"https://gallery.mailchim=
p.com/8234ed62d6a7fa87721ff1d8a/images/9833afaa-046d-40f6-9e9d-e125be305f7=
8.png" style=3D"display: block; max-width: 100%;" width=3D"110">
              </td>
            </tr>
            <tr>
              <td align=3D"center">
                <!--[if mso]>
                  <v:roundrect xmlns:v=3D"urn:schemas-microsoft-com:vml" x=
mlns:w=3D"urn:schemas-microsoft-com:office:word" href=3D"https://www.codes=
chool.com/courses/try-sql/?utm_medium=3Demail&utm_campaign=3Dannouncement_=
sequel_to_sql&utm_source=3Dmailchimp&utm_content=3Dnull" style=3D"height:4=
2px;v-text-anchor:middle;width:200px;" arcsize=3D"250%" stroke=3D"f" fillc=
olor=3D"#b7a474">
                  <w:anchorlock/>
                  <center>
                <![endif]-->
                <a class=3D"btn-a" href=3D"http://CodeSchool.us5.list-mana=
ge1.com/track/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3D15c6f9bdca&e=3D=
b2beb48d48" style=3D"background-color:#a38d55; border-radius:100px; color:#ff=
ffff; display:inline-block; font-family: 'Open Sans'=2C Verdana=2C Helveti=
ca=2C Arial=2C sans-serif; font-size:14px; font-weight:bold; line-height:4=
2px; text-align:center; text-decoration:none; text-transform: uppercase; w=
idth:200px;">Play the Course</a>
                <!--[if mso]>
                  </center>
                  </v:roundrect>
                <![endif]-->
              </td>
            </tr>
          </table>
          <!--[if (IE)|mso]>
          </td>
          </tr>
          </table>
          <![endif]-->
        </td>
      </tr>
    </table>
    <table bgcolor=3D"#000000" border=3D"0" cellpadding=3D"0" cellspacing=
=3D"0" width=3D"100%" style=3D"border-collapse: collapse;border-spacing: 0=
;">
      <tr>
        <td align=3D"center" style=3D"padding: 32px 20px;">
          <!--[if (IE)|mso]>
          <table align=3D'center' border=3D'0' cellpadding=3D'0' cellspaci=
ng=3D'0' width=3D'600'>
          <tr>
          <td>
          <![endif]-->
          <table align=3D"center" border=3D"0" cellpadding=3D"0" cellspaci=
ng=3D"0" class=3D"flex-size" style=3D"max-width: 600px;border-collapse: co=
llapse;border-spacing: 0;" width=3D"100%">
            <tr>
              <td align=3D"center" class=3D"text" style=3D"color: #f6f7f7;=
font-family: 'Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C sans-serif;fo=
nt-size: 16px;line-height: 24px;mso-line-height-rule: exactly;-webkit-font=
-smoothing: antialiased;-ms-text-size-adjust: none;-webkit-text-size-adjus=
t: none;">
                <a href=3D"http://CodeSchool.us5.list-manage1.com/track/cl=
ick?u=3D8234ed62d6a7fa87721ff1d8a&id=3Dc91a28c0f9&e=3Db2beb48d48" style=
=3D"color: #ffffff; font-weight: bold;">
                  <img alt=3D"Twitter" height=3D"20" src=3D"https://galler=
y.mailchimp.com/8234ed62d6a7fa87721ff1d8a/images/76034afd-ef45-4825-8a20-a=
bc63a8b2302.png" style=3D"display: block; max-width: 100%; padding-bottom:=
 5px;">
                  Tweet This
                </a>
              </td>
            </tr>
          </table>
          <!--[if (IE)|mso]>
          </td>
          </tr>
          </table>
          <![endif]-->
        </td>
      </tr>
    </table>
    <table bgcolor=3D"#2d3033" border=3D"0" cellpadding=3D"0" cellspacing=
=3D"0" class=3D"wrapper" style=3D"color: #a5a6a7;font-size: 12px;border-co=
llapse: collapse;border-spacing: 0;" width=3D"100%">
      <tr>
        <td>
          <!--[if (IE)|mso]>
          <table align=3D'center' border=3D'0' cellpadding=3D'0' cellspaci=
ng=3D'0' width=3D'600'>
          <tr>
          <td>
          <![endif]-->
          <table align=3D"center" border=3D"0" cellpadding=3D"0" cellspaci=
ng=3D"0" class=3D"flex-size" style=3D"max-width: 600px;border-collapse: co=
llapse;border-spacing: 0;" width=3D"100%">
            <tr>
              <td style=3D"font-size: 0; text-align: center;">
                <div style=3D"display: inline-block; vertical-align: top;"=
>
                  <table align=3D"left" border=3D"0" cellpadding=3D"0" cel=
lspacing=3D"0" class=3D"content footer" width=3D"300" style=3D"border-coll=
apse: collapse;border-spacing: 0;">
                    <tr>
                      <td align=3D"left" class=3D"text s-tac" style=3D"col=
or: #a5a6a7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C s=
ans-serif;font-size: 12px;line-height: 18px;padding-top: 32px;mso-line-hei=
ght-rule: exactly;-webkit-font-smoothing: antialiased;-ms-text-size-adjust=
: none;-webkit-text-size-adjust: none;">
                        Have questions or need assistance?
                        <a href=3D"http://CodeSchool.us5.list-manage.com/t=
rack/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3D9a4f75d6dc&e=3Db2beb48d48"=
 style=3D"color: #a5a6a7">codeschool.com/support</a>
                      </td>
                    </tr>
                    <tr>
                      <td align=3D"left" class=3D"text s-tac" style=3D"col=
or: #a5a6a7;font-family: 'Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C s=
ans-serif;font-size: 12px;line-height: 18px;padding-top: 16px;mso-line-hei=
ght-rule: exactly;-webkit-font-smoothing: antialiased;-ms-text-size-adjust=
: none;-webkit-text-size-adjust: none;">
                        <a href=3D"http://CodeSchool.us5.list-manage1.com/=
track/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3D1d20c08922&e=3Db2beb48d48"=
 style=3D"color: #a5a6a7;">Edit your email settings</a>
                        &nbsp; &nbsp;
                        <a href=3D"http://CodeSchool.us5.list-manage.com/u=
nsubscribe?u=3D8234ed62d6a7fa87721ff1d8a&id=3Db819d211aa&e=3Db2beb48d48&c=3D=
51c5296975" style=3D"color: #a5a6a7;">
                          Unsubscribe
                        </a>
                      </td>
                    </tr>
                  </table>
                </div>
                <!--[if (IE)|mso]>
                </td>
                <td>
                <![endif]-->
                <div style=3D"display: inline-block; vertical-align: top;"=
>
                  <table align=3D"left" border=3D"0" cellpadding=3D"0" cel=
lspacing=3D"0" class=3D"content" width=3D"300" style=3D"border-collapse: c=
ollapse;border-spacing: 0;">
                    <tr>
                      <td align=3D"right" class=3D"s-tac o-app-store" styl=
e=3D"padding-top: 32px;">
                        <a href=3D"http://CodeSchool.us5.list-manage2.com/=
track/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3Db998ff944f&e=3Db2beb48d48"=
 style=3D"text-decoration: none;">
                          <img alt=3D"Download the Code School app on the=
 app store" border=3D"0" src=3D"https://gallery.mailchimp.com/8234ed62d6a7=
fa87721ff1d8a/images/f24caf18-6ec3-4492-b5ea-352f6248a789.png" width=3D"14=
0">
                        </a>
                      </td>
                    </tr>
                    <tr>
                      <td align=3D"right" class=3D"s-tac" style=3D"font-si=
ze: 12px; line-height: 30px; padding-top: 16px;">
                        <a href=3D"http://CodeSchool.us5.list-manage.com/t=
rack/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3Dff2453ccec&e=3Db2beb48d48"=
 style=3D"text-decoration: none;">
                          <img alt=3D"Twitter Icon" border=3D"0" height=3D=
"24" src=3D"http://d367zuf2xzw0m3.cloudfront.net/common/social-twitter.png=
" width=3D"24">
                        </a>
                        &nbsp;
                        <a href=3D"http://CodeSchool.us5.list-manage.com/t=
rack/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3D9cceae11d5&e=3Db2beb48d48"=
 style=3D"text-decoration: none;">
                          <img alt=3D"Facebook Icon" border=3D"0" height=
=3D"24" src=3D"http://d367zuf2xzw0m3.cloudfront.net/common/social-facebook=
=2Epng" width=3D"24">
                        </a>
                        &nbsp;
                        <a href=3D"http://CodeSchool.us5.list-manage.com/t=
rack/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3D5af713f9f9&e=3Db2beb48d48"=
 style=3D"text-decoration: none;">
                          <img alt=3D"Youtube Icon" border=3D"0" height=3D=
"24" src=3D"https://gallery.mailchimp.com/8234ed62d6a7fa87721ff1d8a/images=
/email_social_youtube.png" width=3D"24">
                        </a>
                        &nbsp;
                        <a href=3D"http://CodeSchool.us5.list-manage.com/t=
rack/click?u=3D8234ed62d6a7fa87721ff1d8a&id=3D6cf5e45fc0&e=3Db2beb48d48"=
 style=3D"text-decoration: none;">
                          <img alt=3D"Google+ Icon" border=3D"0" height=3D=
"24" src=3D"https://gallery.mailchimp.com/8234ed62d6a7fa87721ff1d8a/images=
/email_social_gplus.png" width=3D"24">
                        </a>
                      </td>
                    </tr>
                  </table>
                </div>
              </td>
            </tr>
          </table>
          <!--[if (IE)|mso]>
          </td>
          </tr>
          </table>
          <![endif]-->
          <table bgcolor=3D"#2d3033" border=3D"0" cellpadding=3D"0" cellsp=
acing=3D"0" class=3D"content footer" style=3D"color: #a5a6a7;border-collap=
se: collapse;border-spacing: 0;" width=3D"100%">
            <tr>
              <td align=3D"center" style=3D"padding-top: 24px;">
                <a href=3D"http://CodeSchool.us5.list-manage1.com/track/cl=
ick?u=3D8234ed62d6a7fa87721ff1d8a&id=3Ded776b220c&e=3Db2beb48d48">
                  <img alt=3D"Code School - a Pluralsight Company" border=
=3D"0" src=3D"https://gallery.mailchimp.com/8234ed62d6a7fa87721ff1d8a/imag=
es/93aed0a5-2afa-4e21-b5ec-2b9f2a9473c0.png" width=3D"240">
                </a>
              </td>
            </tr>
            <tr>
              <td align=3D"center" style=3D"color: #a5a6a7; font-family: '=
Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C sans-serif; font-size: 12px=
; line-height: 18px; padding-top: 16px;">
                <span class=3D"maskLink-footer">Code School
618 E South Street
Suite 620
Orlando=2C FL 32801
USA</span>
              </td>
            </tr>
            <tr>
              <td align=3D"center" style=3D"color: #a5a6a7; font-family: '=
Open Sans'=2C Verdana=2C Helvetica=2C Arial=2C sans-serif; font-size: 12px=
; line-height: 18px; padding-top: 16px;">
                &copy; 2015 Code School LLC. Crafted lovingly in Orlando=
=2C Florida.
              </td>
            </tr>
            <tr>
              <td align=3D"center" style=3D"padding: 16px 0 32px;">
                <a href=3D"http://CodeSchool.us5.list-manage.com/track/cli=
ck?u=3D8234ed62d6a7fa87721ff1d8a&id=3D0e99897ffa&e=3Db2beb48d48">
                  <img alt=3D"Pluralsight" border=3D"0" src=3D"https://gal=
lery.mailchimp.com/8234ed62d6a7fa87721ff1d8a/images/ac97a163-e338-4977-84b=
3-2722a3dda6a4.png" width=3D"160">
                </a>
              </td>
            </tr>
          </table>
        </td>
      </tr>
    </table>
  <img src=3D"http://CodeSchool.us5.list-manage.com/track/open.php?u=3D823=
4ed62d6a7fa87721ff1d8a&id=3D51c5296975&e=3Db2beb48d48" height=3D"1" width=
=3D"1"></body>
</html>
--_----------=_MCPart_180873568--