We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course SQL Language
  • Course Duration2 Days
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.

Overview
SQL is an industry-standard language for accessing mainframe, midrange and LAN-based, multi-user relational databases. This course will teach the delegate how to read and write good SQL for querying, updating and maintaining SQL databases. The course progresses through the elements of the language to build a thorough appreciation and understanding of SQL's capabilities and power. It covers ANSI-standard SQL and some of the common extensions.

This course is made up of a mix of theory and practical sessions. You will complete a series of exercises that cover all the important components of the language and allow you to practise your SQL.

Please Note: The course will use a Microsoft SQL Server platform and T-SQL in all labs and practices to illustrate the use of the SQL language
Prerequisites
    • Typically delegates will have coded in some other language but it is not necessary to have done so to be successful on this course as the range of exercises allow students to work at the most appropriate pace for them.
    • The most successful delegates on this course are those who can type accurately and consistently, and can cope with 'syntax' as SQL is a syntactically 'fussy' language.
    • Typically delegate skills will include a working familiarity with the Windows graphical environment but no prior knowledge of SQL.
Objectives
    • Describe where the SQL language came from and its set-based mode of operation
    • Write SQL statements to create and manipulate database objects and data
    • Read SQL effectively
    • Write queries to join many related tables
    • Use the features of the language to safeguard the data and its value to the user
    • Recognise the dangers inherent in the language that may return the right result but would be fatally flawed with different data
Target Audience
    • This course is suitable for anyone wishing to use SQL to access data. This course is a common prerequisite for those going on our client/server or database courses.
What's included
    • For courses held on our premises, complimentary tea, coffee and biscuits are available. Lunch is not provided, however, there is a wide variety of eateries within a short walk of the centre.
    • Comprehensive course materials and exercises
Course Content
    • Introduction to Relational Databases
      The need for an SQL standard; The ANSI standards; What is a database?; What is a relational database?; Components of a relational database; Normalised data; Anatomy of a table; Primary and foreign keys; Joins; Components of SQL
    • Data Manipulation Language
      SELECT operations; DISTINCT; Virtual columns; Column aliases; Functions; Restricting the rows returned; Multiple conditions; Ordering data; Inserting rows; Updating rows; Deleting rows
    • Joining tables
      The theory of joining tables; Cross, Inner, Outer, Full, Left and Right; Composite joins; Table aliases;
    • Data Definition Language
      Data types; Column attributes; Create table; Primary and foreign keys; Referential integrity; Alter and drop tables
    • Views
      Defining simple views; Views with virtual columns; Restricted-column views; Joined-table views; Restricted-row views; View restrictions
    • Summarised Queries
      Table aggregates; GROUP BY and aggregates; The HAVING clause
    • Subqueries
      Using simple Subqueries; EXISTS; Correlated Subqueries
    • Set operations
      Union; Intersect; Except/Minus

 

Course Dates Please contact us to discuss dates for this course, thank you

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Aug 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields