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 Code: BIT201
Fee Code: S3
Duration (approx) Duration (approx) 100 hours
Qualification Statement of Attainment
Get started!

 

Learn SQL (Structured Query Language) for the Web

 

This course provides a comprehensive introduction to SQL. This course will provide you with a solid foundation if you have very little or no experience in SQL at all. 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
Since 1999 ACS has been a recognised member of IARC (International Approval and Registration Centre). A non-profit quality management organisation servicing education.

Member of Study Gold Coast Education Network.

ACS Global Partner - Affiliated with colleges in seven countries around the world.

UK Register of Learning Providers, UK PRN10000112


How can I start this course?

You can enrol at anytime and start the course when you are ready. Enrolments are accepted all year - students can commence study at any time. All study is self paced and ACS does not set assignment deadlines.

Please note that if a student is being assisted by someone else (e.g. an employer or government subsidy), the body offering the assistance may set deadlines. Students in such situations are advised to check with their sponsor prior to enrolling. The nominal duration of a course is approximately how long a course takes to complete. A course with a nominal duration of 100 hours is expected to take roughly 100 hours of study time to complete. However, this will vary from student to student. Short courses (eg. 100 hrs duration) should be completed within 12 months of enrolment. Certificates, Advanced Certificates and Awards (eg. over 500 hours duration) would normally be completed within 3 -5 years of enrolment. Additional fees may apply if a student requires an extended period to complete.
If a student cannot submit their assignments for 6 months to ACS, they should advise the school to avoid cancellation of their student
registration. Recommencement fees may apply.

Simply click on the ENROL OPTIONS button at the top of this screen and follow the prompts.

You can see the course price at the top of this page. Click 'enrolment options' to see any payment options available.

You can pay by Credit Card, PayPal, Afterpay or bank transfer.

Yes! We have payment plans for most courses. Click 'enrolment options' to see the available payment plans.
We also have Afterpay that will allow you to pay for your course or payment plans in four instalments (if you are in Australia).


What do I need to know before I enrol?

There are no entry requirements that you need to meet to enrol in our courses, our courses are for everyone.
If you are under 18, we need written permission from your parent/ guardian for your enrolment to continue, we can arrange that after you have enrolled.

You don’t need to purchase any additional resources to complete our courses.

We aim to teach you the essentials without you having to purchase any specific computer program.
We recommend that you have access to a word processing program, such as Microsoft Word or Google Docs, so that you can easily complete and submit your assignments.

You sure can. We are here to help you learn whatever your abilities.

Yes, if you are enrolling in a Certificate or Advanced Certificate, you might be eligible for credits if you have evidence of your previous studies or relevant experience. More information is here.

We recommend that you are able to browse websites, send emails and conduct online research. You will need to be able to type and submit your assignments.
If you have limited computer skills, we can make special arrangements for you.

This is possible, it depends on the institution. We recommend that if you would like to use our courses that you contact the institution first. Our Course Handbook is a good resource for this.

Our courses are written in English and we only have English speaking academic staff. If you can read and complete your assignments in English, our courses are ideal for you.

Our courses are designed to build knowledge, hands on skills and industry connections to help prepare you to work in the area, running your own business, professional development or as a base for further study.

This course has been designed to cover the fundamentals of the topic. It will take around 100 hours to complete, which includes your course reading, assignment work, research, practical tasks, watching videos and anything else that is contained in the course. Our short courses are a great way to do some professional development or to learn a new skill.

It’s up to you. The study hours listed in the course are a rough guide, however if you were to study a short course (100 hours) at 10 hours per week, you could finish the course in 10 weeks (just an example). Our courses are self-paced, so you can work through the courses in your own time. We recommend that you wait for your tutor to mark and return your assignment before your start your next one, so you get the benefits of their feedback.

The course consists of course notes, videos, set tasks for your practical work, online quizzes, an assignment for each lesson (that you receive feedback from your tutor from) and ends in an exam (which is optional, if would like to receive the formal award at the end), using our custom built Learning Management System - Login.Training.

Our courses are designed for adults to gain professional development and skills to further their careers and start businesses.

Our custom online learning portal allows you to conduct your learning online. There may be practical tasks that you can do offline. You have the option of downloading your course notes or print them to read later.

There is also the option to pay an additional fee for printed course notes and or USB (availability limited to location and deliverability).

Yes, if you don’t have access to the internet, you can receive the course as paper notes or on a USB stick for an additional fee. We can also make alternative arrangements for you to send your assignments to us.

We offer printed notes for an additional fee. Also, you can request your course notes on a USB stick for an additional fee.

Yes, your tutor is here to help you. Simply post any questions you have in your login.training portal or contact the office and we can pass on a message to your tutor.

We are more learning focussed, rather than assessment focussed. You have online quizzes to test your learning, written assignments and can complete an exam at the end of the course (if you want to receive your certificate). You will not receive a pass/ fail on your course work. If you need to add more details on your assignment, we will ask you to resubmit and direct you where you need to focus. If you need help, you can ask your tutor for advice in the student room.

Each module (short course) is completed with one exam.

Exams are optional, however you must sit an exam if you would like to receive a formal award. You will need to find someone who can supervise that you are sitting the exams under exams conditions. There is an additional cost of $55 (AUS) $50 (O/S) for each exam.
More information is here

There are practical components built into the course that have been designed to be achieved by anyone, anywhere. If you are unable to complete a task for any reason, you can ask your tutor for an alternative.

When you complete the course work and the exam and you will be able receive your course certificate- a Statement of Attainment. Otherwise, you can receive a Letter of Completion.

You can bundle the short courses to create your own customised learning bundle, Certificates or Advanced Certificates. More information is on this page.

Yes, our courses are built to be applicable for people living anywhere in any situation. We provide the fundamentals, and each student can apply their own unique flair for their own interests, region and circumstances with the one-on-one guidance of a tutor. There is also a bit of student directed research involved.

Employers value candidates with industry skills, knowledge, practical skills and formal learning. Our courses arm you with all of these things to help prepare you for a job or start your own business. The longer you study the more you will learn.

ACS has an arrangement with OAMPS (formerly AMP) who can arrange Professional Indemnity from Australian and New Zealand graduates across all disciplines. Ph: 1800 222 012 or email acs@oamps.com.au.


Who are ACS Distance Education?

ACS Distance Education have been educating people for over 40 years.

We are established and safe- we have been in education for over 40 years.
We are focused on developing innovative courses that are relevant to you now and what you will need to know in the future.
We are focused on helping you learn and make the most of your experience.
You can enrol at any time, you can work on your course when it suits you and at your own pace.
We are connected to many industry bodies and our staff participate in continuous improvement and learning activities to ensure that we are ahead of what learning is needed for the future.

Our courses are not accredited by the Australian Government. However many of our courses are recognised and held in high regard by many industry bodies.

Our courses are written by our staff, who all have many years experience and have qualifications in their speciality area. We have lots of academic staff who write and update our courses regularly.


How do I enrol my staff/ sponsored students?

Yes, you can do a request for a bulk enrolment and request an invoice on our Invoice Request Form

We can prepare an invoice, quote or proforma invoice. Simply complete your details on our Invoice Request form

We can arrange bulk discounts for your course enrolment, please get in touch with us to discuss your needs.

Yes, we have many students who are in locked facilities, such as prisons or hospitals. We can cater by also offering paper notes at an additional cost.


What if I have any more questions or need more information?

We can assist you to find the right course for your needs. Get in touch with us via email (admin@acs.edu.au) call on +61 7 5562 1088 or complete our course advice form.


What if I change my mind?

Please get in touch with studentservices@acs.edu.au if you would like to be removed from our mail list.

If you would like ACS Distance Education to delete your information at any time (whether you are a customer or a prospective customer), please contact our privacy officer and we will process this ( admin@acs.edu.au ).




Course Contributors

The following academics were involved in the development and/or updating of this course.





Tutors

Meet some of the tutors that guide the students through this course.

Josiane Joubran

Josiane has eight years experience as an I.T professional in Lebanon and Australia. Extensive experience with computer hardware and engineering, CSC consultant with IBM, Software QA Engineer, Course Writer and Tutor

Alan Vo

Alan has 14 years experience as an I.T professional in Australia. Extensive experience with software engineering, web development, web marketing, and ecommerce at digital agencies as well as client-sides on various projects and industries.

Lachlan Allan

Lachlan has experience of the hospitality, banking and utilities sectors in managerial positions in the UK. Following a career change after moving to Australia, he is also experienced in the medical engineering field where he was an engineer responsible for devices at hospital sites and laboratories

Need Help?

Take advantage of our personalised, expert course counselling service to ensure you're making the best course choices for your situation.


I agree for ACS Distance Education to contact me and store my information until I revoke my approval. For more info, view our privacy policy.