Top » Catalog » Information Technology courses » » SQL For The Web Course

SQL is the next generation

Many older web sites use Access Databases - SQL is the next generation -If you are serious about websites and data management within computer software systems, you need to know SQL

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 is most suitable for programmers and web developers who are looking to expand their skills with SQL server

Course Details

If you are doing the course full time you can complete it in 6 weeks, if you are studying part time then it will take 3-6 months on average to complete the course. Your course will expire after 1 year. You can start the course at any time as it is a self-paced online course.

Course Outline

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
◦Uusing 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.

 

We have payment plans avaliable

Email admin@thetrainingacademy.com.au for a detailed course brochure with course outlines for all the modules.


$550.00
Course Home
Tell A Friend
Tell someone you know about this product.
Information