• SELECT SITE CURRENCY
Select a currency for use throughout the site
Introduction to SQL
E-Careers, January 2012, Pages: 20
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. 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
ALL our 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.
Should you still have any questions regarding your online course, our tutor support hotline will be available from 9am to 8pm Monday to Friday. Job Prospects
Become fully trained and substantially improve your chances of employment or earn more money!
Upon completion of the course, you can download the completion certificate as well as any other qualifications you have been awarded.
Feel like you are actually using the software you are being trained about in the added security of our learning environment.
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn.
Printable reference guides and exercises
Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide.
Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 9.00am-5.00pm to help you out if you get stuck.
Free upgrades for 12 months
For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.
Best price in UK guaranteed
We are so confident that you will not find another online training service of the same quality and price that we will beat any legitimate quote on a like for like basis by 10%.
Total Course Duration: 20 Hours
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 wildcards 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 Queeries 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 0 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 makeup 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)
ThisSQL 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
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