Every website is supported by a database at the back end, and every time a user submits information or searches a website, data gets stored and is retrieved from the database. Structured Query Language (SQL) is a programming language used to interact with databases. This course is ideal for those working in computer programming, web or database development, or in data analysis and testing.
SQL for the Web is an online program that will teach you how to build a database with SQL and then retrieve, store, update, delete and secure data.
In this professional development course, you will study database management systems (DBMS), learn how to build a DBMS with SQL, use advanced SQL database access methods, and use ‘dynamic’ SQL.
You will also learn about cursors, stored procedures, error handling, and how to use SQL in a variety of applications including on websites, mobile devices and desktops.
On completion of this course, you will be confident executing and managing SQL on a web-based platform, which will keep you ahead of the game in the fast and ever-changing IT sector.
Unit 1 - Introduction to databases
What is a database
The relational model
Other normal forms
Unit 2 - Fundamentals of SQL
Installing a DBMS
The select statement
Unit 3 - Building a database with SQL
Building a database: RAD tool, CSV file, opening database, commands, etc
Data types and MS access
Unit 4 - Retrieving, storing, updating and deleting 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
Unit 5 - Advanced SQL database access methods
Creating outer joins with OUTER JOIN
Using HAVING for filtering rows
Unit 6 - Database security
Security is important
Unit 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
Unit 8 - Cursors
What are cursors
Preventing updates and deletions
Unit 9 - Stored procedures
Controlled flow statements
Unit 10 - Error handling
Unit 11 - Dynamic SQL
Execution of dynamic SQL
Single step execution
Two step execution
Unit 12 - Advice and tips
Assuming the client knows what they need
Underestimating project scope
Only considering technical factors
Not seeking client feedback
Skipping beta testing
When you study with Australian Online Courses you will be assessed using a competency-based training method. Competency-based training focuses on a learner’s ability to receive, respond to and process information to achieve a competency result. As such, skills-based and knowledge assessments are geared towards attainment to meet industry-defined standards.
Assessment will be comprised of written assignments and exercises, including short answer questions, reports, essays, research projects and reflective tasks. There are no examinations or due dates for assessment. As a result, you can complete training in your own time and at your own pace with the assistance of unlimited tutor support.
Why Choose Australian Online Courses?
Professional development that is widely recognised and respected;
Improve your employment opportunities;
Study online, anywhere via our elearning system;
High-quality professional development programs written by industry experts;
No entry requirements;
All course materials provided online – no textbooks to buy;
Unlimited tutor support;
Easy to understand course content;
We offer twelve (12) months’ access, with extensions available upon application (fees apply);
Certificate of Attainment/Completion issued for your CV (hard copy provided); and
Course may be tax deductible; see your tax advisor.
How long will it take to complete this course?
The approximate study hours for this course is 100 hours. We offer twelve (12) months’ access, with extensions available upon application (fees apply).
Can I purchase optional printed materials?
While printed materials are not available for purchase, PDF copies are available for download and self-printing for this program.
When can I start this course?
You can start within 60 minutes during business hours when you enrol and pay in full with a credit card!
Credit card: Within 60 mins during business hours.
BPAY: Within 1-2 working days.
Internet Banking: Within 1-2 working days.
Cheque/Money Order: Upon receipt of mailed cheque.
Will I receive a certificate upon completion of this course?
Yes! You will receive a Certificate of Attainment upon successful completion of your assessment.
Do I need to attend classes or undertake any work placements?
No. All courses are delivered online via our e-learning system and there are no work placement requirements in this course.
What support can I expect from Australian Online Courses?
Unlimited tutor support is available throughout your studies via email during business hours Monday to Friday. Our Administrative team are available Monday to Friday via email, live chat and telephone.
I am an international student. Can I enrol into this course?
Yes! We accept enrolments from individuals both within Australia and internationally; location is no barrier to entry into our programs.