This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.
Class Goals
o Understand how relational databases work
o Learn to use SQL to output reports
o Learn to write queries getting data from multiple tables.
Pre-requisites
A programming background will not be required although it would be important that attendees are very familiar with using computers.
Course Outline
<ul
<ul
<ul
<liTables</li
<liRows</li
<liColumns</li
<liRelationships</li
<liDatatypes</li
</ul
</li
<ul
</ul
<ul
</ul
</li
<ul
</ul
</li
</ul
</li
</ul
<ul
<ul
<liComments</li
</ul
</li
<ul
</ul
</li
<ul
</ul
</li
<ul
</ul
</li
<ul
<liAND</li
<liOR</li
</ul
</li
</ul
</li
</ol
<ul
<ul
<liConcatenation</li
<liAliases</li
</ul
</li
<ul
</ul
</li
<ul
</ul
</li
</ul
</li
</ol
<liSubqueries, Joins and Unions
<ul
<liSubqueries</li
<liJoins
<ul
</ul
</li
<liUnions
<ul
</ul
</li
</ul
</li
</ol
<ul
<liINSERT, UPDATE, DELETE</li
</ul
</li
</ol
Course Funding
ITAG Skillnet is funded by member companies and the Training Networks Programme, an initiative of
