It's Easy to Enrol

Select a Learning Method

 

£355.00 Payment plans available.

Enable Javascript to automatically update prices.

Courses can be started at any time from anywhere in the world!

SQL For The Web

Course CodeBIT201
Fee CodeS3
Duration (approx)100 hours
QualificationStatement of Attainment

LEARN SQL AND DATABASE MANAGMENT

Gain valuable skills and knowledge in a growing and in-demand field of IT.

Databases in general are of the up most importance to businesses world wide and SQL is the most common and used language.

This course provides a comprehensive introduction to SQL. By the end of the course, the student should be able to easily understand all the major aspects of SQL.

Is this course right for me?

Weather you are a beginner, intermediate or professional in IT, this course is designed to provide a solid foundation on databases and the SQL language.

Study online at your own pace

Using our modern online portal for study is a simple and effective way of learning. Once enrolled, you will receive your online account to our login.training system that will give you all the lessons assignments and self-assessment tests so you can start studying straight away.

Lesson Structure

There are 12 lessons in this course:

  1. Introduction to Databases
    • What is a database
    • DBMS
    • The relational model
    • Primary keys
    • Foreign keys
    • Relationships
    • Normalisation
    • Other normal forms
    • De normalisation
  2. Fundamentals of SQL
    • Installing a DBMS
    • SQL
    • The select statement
    • Common errors
    • Identifiers
  3. Building a database with SQL
    • Building a database: RAD tool, CSV file, opening database, commands, etc
    • Data types and MS access
  4. Retrieving, Storing, Updating and Deleting Data
    • Retrieving data
    • Retrieving from tables with relationships
    • Creating column aliasesEliminating duplicate rows withDISTINCT
    • Filtering rows with WHERE
    • Matching patterns with LIKE
    • Escaped and unescaped patterns
    • Range filtering with BETWEEN
    • List filtering with IN
    • Evaluating conditional values with CASE
    • Sorting rows by ORDER BY
    • Storing, updating and deleting dataUpdating rows with UPDATE
    • Deleting rows with DELETE
  5. Advanced SQL database access methods
    • Relational databases
    • Creating outer joins with OUTER JOIN
    • Subqueries
    • Summarising data
    • Grouping rows
    • Using HAVING for filtering rows
    • Set operations
    • Union
    • Intersect
    • Except
    • Handling duplicates
  6. Database Security
    • Security is important
    • Triggers
  7. Using SQL in applications
    • Using SQL in an application
    • Using SQL in web sites
    • Using SQL in desk top applications
    • Using SQL in mobile devices
    • Embedded SQL
    • SQL injection
  8. Cursors
    • What are cursors
    • Preventing updates and deletions
    • Scrollable Cursors
  9. Stored procedures
    • Introduction
    • Compound statements
    • Stored functions
    • Stored modules
    • Views
    • Indexes
    • Controlled flow statements
  10. Error Handling
    • Stability
  11. Dynamic SQL
    • Introduction
    • Execution of dynamic SQL
    • Single step execution
    • Two step execution
    • Dynamic cursors
  12. Advice and Tips
    • Common mistakes
    • Assuming the client knows what they need
    • Underestimating project scope
    • Only considering technical factors
    • Not seeking client feedback
    • Skipping beta testing

Each lesson culminates in an assignment which is submitted to the school, marked by the school's tutors and returned to you with any relevant suggestions, comments, and if necessary, extra reading.

Aims

  • Understand the concept of relational databases.
  • Understand the fundamentals of SQL.
  • Build and maintain a database with SQL.
  • Define how to store data in a database using SQL.
  • Understand advanced and more efficient ways of working with databases in SQL.
  • Keep databases secure with SQL.
  • Understand how to use SQL in real world applications.
  • Define how to use cursors to work with data in a database.
  • Understand how to re-use common code and develop efficient database driven applications with the use of stored procedures.
  • Define the benefits of error handling and how to implement it.
  • Define how dynamic SQL works in applications.

Database Management System (DBMS)

A Database Management System (DBMS) is a software program that acts as a ‘go-between’ (interface) for the database information. When an application requires data, it sends its' request to the DBMS which searches the database records for the relevant data and then returns the result back to the application.

You can think of a DBMS as a librarian. You go to the library and ask them “have you got any books on car engine repairs”. The librarian then goes and looks through the shelves, finds all the relevant books and brings them back to you. Without the librarian, you would need to search through all the shelves yourself, which is slow and inefficient.

DBMSs make life easy and reduce the time it takes for an application to process data.

It is important to understand the difference between a Database and a DBMS. Many people confuse the two or do not realise there is a difference which can cause confusion.

DBMSs come in all shapes and sizes with different features and uses. Many have features that are unique and almost all DBMSs are incompatible with each other (although some have partial compatibility).

Some examples of popular DBMSs are:

  • Microsoft Access
  • Microsoft SQL Server
  • Microsoft MSDE
  • Oracle
  • Sybase SQL Server
  • MySQL

There are many other DBMSs around too. Some are general ones used for a variety of applications and some are specifically designed for certain applications (such as banking and finance).

Introducing SQL

SQL (structured query language) is the most common language used for communicating with relational databases.

Traditionally, programming languages such as Basic, C# and C++ are known as ‘procedural’ languages. This means that in order to do something, a procedure is written telling the computer what to do.

For example, to get the computer to draw a box, you would have a procedure similar to the following:

1) Move the pointer to the top left of the screen

2) Draw a line horizontally until it reaches the edge of the screen

3) Draw a line down until it reaches the bottom of the screen

4) Draw a line to the left until it reaches the left hand side of the screen

5) Draw a line up until it meets the top left corner of the screen

 

SQL is a ‘non-procedural’ language. Instead, you tell SQL what you want and it communicates with the DBMS to retrieve your request without you having to tell SQL exactly how to do it.

For example, to retrieve all records from a database where all people lived in Australia, you would use the following SQL command:

Select * from records where location=’Australia’

The DBMS then understands what SQL is asking and will go and retrieve the data and send it back to SQL.

SQL commands are performed in one of two ways:

1) Via a console

You can execute SQL commands via a console that is connected to a DBMS. This may be the SQL query builder in Microsoft Access, a web page connected to a database of some sort, or either via SQL Server Express, Enterprise Manager & Query Analyser for SQL Server. You would simply type in your request in SQL and after the task has been completed, you will see the result. This form of using SQL is generally only used by professional database administrators due to the large margin for error and lack of database security (someone could easily wipe out a database by typing the wrong command).

2) Via an application

This is the most common form of SQL programming. An application acts as a ‘front end’ for the database, allowing someone with basic computer knowledge to use a database. For example, a button that says ‘add record’ would appear on a page with blank fields for ‘name’ and ‘address’. The operator would enter the name and address then click the button. This button would then fire off an SQL command, telling the DBMS to add a new record to the database with the data the operator typed in.

VALUABLE KNOWLEDGE LIKE THIS IS PRICELESS

When you talk IT, one of the most common things that a business will have is a database of some sort. SQL is the worlds leading database language and learning this will give you the skills to branch out into many different areas. Not all databases are built the same, however when you have a foundation like this, there is very little that you will not be able to accomplish.

In fact the database job growth estimated between 2014 and 2024 is set to grow 11percent, which makes it the fastest growing career in the world!!

Having these skills equips you for the future and the growing demand in IT, currently the fastest moving industry in the world. You can take these skills anywhere in the world and find work as SQL is used by every major country across many different industries. 

Some of the titles you will find in the IT industry related to databases are:

  • Database Administrator
  • Database Developer
  • Database support and maintenance
  • Database security
  • Data miner
  • Data reporting and business integration

Other areas of IT that relate/integrate to databases you can study in future to expand your skills even further include:

  • Computer programming
  • Computer security
  • Web development
  • Networking
  • Business Analysis 
  • Marketing

 



Meet some of our academics

Dr. Sherif SakrResearch Scientist and University Lecturer in Computer Science and Engineering. Sherif has a PhD in Computer Science, MSc, BSc.
Josiane JoubranCSC consultant with IBM, Software QA Engineer, Course Writer and Tutor. Josiane is an I.T professional with extensive experience with computer hardware and engineering in Lebanon and Australia. Josiane has a B.Eng., Grad.Dip.I.T., Master Info.Tech., MCP, MCSE.
Martin Powdrill25 years working in Telecommunications, IT, Organisational Development, and Energy Conservation & Efficiency, prior to setting up his own Permaculture consulting business. Martin has a Bsc (Hons) Applied Science (Resources Option), MSc Computer Studies, Permaculture Design Certificate. Martin volunteers with many local environmental and community groups, and facilitates discussions on climate change, peak oil, and transition towns. Martin has an allotment, and is currently enrolled in the Scottish Mountain Bike Leader Award programme. Martin’s goal as a catalyst for sustainable change brings together his strengths and experience in his environmental, project management, and business backgrounds.


Check out our eBooks

Business OperationsExplore how to improve the management and profitability of an existing business. Businesses do not run themselves - goals need to be set and decisions need to be made in order to achieve business goals. This book talks you through all of the different aspects involved in running a business from finance and forecasting to staffing changes and legal issues. Six chapters cover the daily challenges of running a business, people, the law, finance, product management, and risk management. 73 pages
Professional WritingHow many people dream about becoming a professional writer? Professional writing is any writing that you are being paid for. It can include fiction writing, a best-selling book, articles in a magazine, articles in a newspaper, blogs for companies, technical manuals, copy for catalogues, newsletters, text books, other academic material and so on. However, many people just write for sheer pleasure. A must read for anyone wanting to make money from writing. 63 pages
Starting a BusinessThinking of starting your own business? Many businesses fail, but this doesn’t need to happen! This is a concise, easy to read ebook which alerts you to all of the things that commonly make a difference to business success or failure. Seven chapters include: A Reality Check, The Product or Service, Managing a Business, How to Find Customers, How to Make a Sale, Delivering the Product or Service and Pitfalls to Avoid. 51 pages
Project ManagementLearn to manage any type of project, in any industry. Six chapters cover the nature and scope of project management, risk and uncertainty, maintaining control, interpersonal relationships, the end game, and golden rules. This is a very concise text - easy to follow, with much of the information presented in bulleted lists. 72 pages