Welcome to the e-Learning Introduction to SQL course powered by XYZ.co.uk. Classroom versions of this course are also available. If you would like us to host a e-Learning Introduction to SQL course at your premises, at a location, date and time of your choosing – then please complete this form.

e-Learning Introduction to SQL

At eLearning.co.uk all of our courses are delivered online. This gives you the opportunity to study at your own pace and within your own time. Online learning allows you to study in the evenings, weekends, or even the odd hour during the day! With each course you will have full tutor and technical support available via the telephone and by e-mail – so you are not on your own by any means. This e-Learning Introduction to SQL course will award you with the same certification as the classroom version of this course – usually for a cheaper cost and with the additional benefit of flexible study times!

Once you’ve decided to go ahead and enrol on this e-Learning Introduction to SQL course, you will receive an e-mail shortly after containing your user name and password, receipt of payment and full course joining instructions. Use this with the link/url provided in the e-mail and you can log into the online training system and begin learning right away. This e-Learning Introduction to SQL online learning course will use various interactive features and different types of media to enable you to stay engaged whilst learning. The course has been designed to be simple to follow and solely with the user in mind – so don’t worry about the technical side of things.

If you want to learn a little more about e-Learning in general, watch the video below. If you want to know more about your chosen course, please scroll down.

This SQL Course provides an overview of SQL, including basic concepts and terms related to database and table design. Acquiring a good working knowledge of SQL is an important skill for anyone who interacts with databases. Lessons start with simple data retrieval and progress to complex topics such as using joins, subqueries, stored procedures, and table constraints.

About the course

Introduction to Databases & SQL - Duration 2 Hour(s)

• Describe the basics of database structure
• Explain how to use SQL to interact with most database applications
• Use the SELECT statement to retrieve data
• Explain the sorting options available when using the ORDER BY clause

SQL Filtering Databases - Duration 2 Hour(s)

• Use the WHERE clause in a SELECT statement
• Use the AND, OR, IN, and NOT operators in a WHERE clause
• Use the LIKE operator in a WHERE clause
• Use wild cards to create search patterns

SQL Calculations and Functions - Duration 2 Hour(s)

• Concatenate fields in your queries
• Perform mathematical calculations in your queries
• Use text and numeric functions in your queries
• Use date and time functions in your queries

Summarising SQL Data - Duration 1 Hour(s)

• This course explains how to use the SQL aggregate functions to summarize data from database tables.
• Explain the purpose of the SQL aggregate functions
• Use the SUM() and COUNT() functions
• Use the AVG(), MAX(), and MIN() functions
• Use aggregate functions for advanced operations

SQL Groups and Queries - Duration 2 Hour(s)

• This SQL course explains how to use the GROUP BY and ORDER BY clauses to sort and group data. It also explains how to use subqueries and combined queries to add more options to retrievals using the SQL SELECT statement.
• Create data groups using the GROUP BY clause
• Sort and filter grouped data
• Understand and filter subqueries
• Use subqueries as calculated fields Create combined queries using UNION

SQL Joins - Duration 3 Hour(s)

• This SQL course shows you how to access data stored in multiple relational tables by using joins in your queries
• Query multiple tables using a join
• Use table aliases in your queries
• Perform inner, outer, self, and natural joins
• Use aggregate functions with joins

SQL data and Tables - Duration 3 Hour(s)

• This course explains how to insert data into existing database tables and then modify or delete that data. It also explains how to create new database tables and modify or delete existing tables
• Insert rows of data into a database table
• Copy data from one table to another
• Update and delete data from a database table
• Create database tables
• Modify and delete database tables

SQL Views and Stored Procedures - Duration 2 Hour(s)

• This course teaches the learner the use of views in SQL and how views can be used to simplify complex operations. It also provides an overview on the use and creation of stored procedures.
• Explain the make-up of views
• Use views to simplify joins
• Use views to reformat retrieved data
• Use filtering and calculated fields within your views
• Explain the use of stored procedures
• Execute stored procedures
• Describe some of the features involved in creating stored procedures

Transaction Processing and Cursors - Duration 1 Hour(s)

• This SQL course shows you how to use transaction processing to execute SQL operations in batches. This enables you to prevent processing errors from corrupting the database..
• Explain how transaction processing works in SQL code
• Control transactions
• Explain how cursors are used to save SQL results
• Declare and use cursors in your SQL code

Advanced SQL Functions -  Duration 2 Hour(s)

• This course explains the use of constraints in databases. The user will learn about primary and foreign keys, and unique and check constraints. The user will also learn about the use of indexes and triggers within databases. Finally, the user will receive an overview of the tools used to manage database security.
• Explain the use of database constraints
• Define primary and foreign keys
• Describe the use of unique and check constraints
• Explain the function of database indexes
• Describe the function of triggers Identify the tools used in database security

Course study options

Course Study Format
This course is delivered through online method. The course is available for you to complete at your convenience over a 12 month period.

IT Training Course Tutor Support
Home study courses include step by step online training and keyword search facilities.
Our Interactive online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.

Study Hours
This is only an approximate figure and is dependent upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.

Technical Requirements

• Windows: Windows 98, 2000, XP, Vista, Windows 7 – Acrobat Reader 4.0 and above
  OR
  Macintosh: Mac OS X, Mac OS 9.2 – Acrobat Reader 4.0 and above
• An up to date internet browser such as Internet Explorer, Mozilla Firefox, or Safari.
• Internet connection (broadband recommended.)

Cost - Per Person

Make An Enquiry Or Book This Training Here