SQL For The Web


Study SQL (Structured Query Language) online. Learn about building a database with SQL, retrieving, storing, updating and deleting data, database security, and more.

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


It's Easy to Enrol

Select a Learning Method

I am studying from...

Enable Javascript to automatically update prices.

All prices in Australian Dollars.

Payment plans available.

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

 

Learn SQL (Structured Query Language) for the Web

 

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.

This course will suit beginners who are new to databases, experienced database users may also find this course of benefit to update or expand their current knowledge using databases in SQL.

Change is fast and inevitable in the IT industry.

 

Most courses simply don't keep up to date. Trying to learn specifics in IT is like trying to catch a racing car running after it on foot. If you learn the fundamentals across a wide enough swathe of the industry though, from people who are not only teachers, but also practicing programmers and technicians.

You have the capacity to be part of the changes that are moving the IT industry forward.

 

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. 1. Introduction to Databases
    • What is a database
    • DBMS
    • The relational model
    • Primary keys
    • Foreign keys
    • Relationships
    • Normalisation
    • Other normal forms
    • De normalisation
  2. 2. Fundamentals of SQL
    • Installing a DBMS
    • SQL
    • The select statement
    • Common errors
    • Identifiers
  3. 3. Building a database with SQL
    • Building a database: RAD tool, CSV file, opening database, commands, etc
    • Data types and MS access
  4. 4. Retrieving, Storing, Updating and Deleting Data
    • Retrieving data
    • Retrieving from tables with relationships
    • Creating column aliases Eliminating duplicate rows with DISTINCT
    • 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 data Updating rows with UPDATE
    • Deleting rows with DELETE
  5. 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. 6. Database Security
    • Security is important
    • Triggers
  7. 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. 8. Cursors
    • What are cursors
    • Preventing updates and deletions
    • Scrollable Cursors
  9. 9. Stored procedures
    • Introduction
    • Compound statements
    • Stored functions
    • Stored modules
    • Views
    • Indexes
    • Controlled flow statements
  10. 10. Error Handling
    • Stability
  11. 11. Dynamic SQL
    • Introduction
    • Execution of dynamic SQL
    • Single step execution
    • Two step execution
    • Dynamic cursors
  12. 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

  • 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.

What You Will Do

  • Explain the difference between a flat file and relational database.
  • Define DBMS.
  • Write an SQL statement that will perform a set task.
  • Explain the difference between an Integer and Numeric data type.
  • Learn what the four DDL commands are.
  • Define set function.
  • Write the SQL code needed to create a database for a car sales yard.
  • What is the importance of a primary key.
  • What is a RAD tool?
  • Gain an understanding of referential integrity rules.
  • Give an example of a logical connective and how it would be used in an SQL select statement.
  • Learn the appropriate use of the keyword select.
  • Learn about JOINS.
  • Explain the access privilege hierarchy.
  • Learn how to declare ROLE.
  • Write an SQL statement for takes away or grants rights to a member of a particular list.
  • Explain Embedded SQL.
  • What is 3 tier web database architecture?
  • Explain the benefits vs disadvantages of using a web based database application rather than a client based application.
  • Develop a list of code needed to send a personalised email out to each customer.
  • Explain the benefits of using cursors.
  • What clause do you need to use to prevent updates and deletions within the scope of a cursor?
  • Develop a stored procedure for creating an employees table.
  • Explain the difference between stored procedures, stored functions and stored modules.
  • Develop error handling.
  • Explain what an exception is and how to handle one with SQL.
  • Describe the differences between dynamic and static SQL.

WHAT IS A DATABASE?

A database is simply a place where you can store data. The most basic form of a

database is a card file system, where information of different contacts or clients are

written on cards that are then stored in alphabetical order. Each card is called a ‘record’

and each record contains ‘fields’ such as ‘name’, ‘address’ and ‘phone number’.

 

Databases come in all sizes, from simple collections of a few records to large systems

holding millions of records. A Personal Database is designed for use by a single person

on a single computer. Such a database usually has a simple structure and a relatively

small size, whereas a Departmental or Workgroup database is used by members of a

single department or workgroups within an organisation. This type of database is

generally larger than a personal database and far more complex in its structure, by

having the functionality to enable multiple users to access the same database

simultaneously. Bigger still, are Enterprise databases, which are used to model critical

information flow within entire large organisations.

SECURITY IS IMPORTANT

One of the major roles of a database developer or administrator is database security.

Once a database is full of information, that information must be protected so that only

authorised people have access to it. It is also important to ensure that the right people

have the right levels of access.

 

USING SQL IN AN APPLICATION

SQL is all very well and good for creating and maintaining databases but it lacks any

functionality to build complete applications. Applications (such as Windows programs or

eCommerce websites) need to be created in a ‘procedural language’ that uses SQL to

talk to the databases. Some of the languages used with SQL are C, C++, Visual Basic, C# ASP.NET.

Database servers are available in all operating systems, and are being

implemented in mobile phones, personal computers, business networks, and in very

large multiprocessor machines.

 

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(DBA)
  • 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


Need assistance?



Start Now!