SQL Fundamentals

SQL FUNDAMENTALS

Course Description
This instructor-led 2-day 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
<ul
</ul
Duration
2 days
Target Audience
Individuals who need to learn the basics of SQL to extract data from various types of databases or who need to understand the basics of programming for use with other programming languages.
Course Prerequisites
A programming background will not be required although it would be important that attendees are very familiar with using computers.
Course Content
<ol

• </ol
  <ul
  <liTables</li
  <liRows</li
  <liColumns</li
  <liRelationships</li
  <liDatatypes</li
  </ul
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ul
  <liComments</li
  </ul
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ul
  <liAND</li
  <liOR</li
  </ul
  <ol
• </ol
  

  <ol

• </ol
  <ul
  <liConcatenation</li
  <liAliases</li
  </ul
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ul
  </ul
  <ol
• </ol
  <ol
  <liINSERT, UPDATE, DELETE</li
  </ol
  To book your place email Dee dtimoney@itag.ie