ASIC Accreditation - Premier Institution

SQL for the Web BIT201

£395.00

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. Similar concepts can be used and applied to the open source MySQL.

SKU: BIT201 Category: Tags: , , , , ,

COURSE STRUCTURE

There are 12 lessons as follows:

  1. Introduction to Databases
  2. Fundamentals of SQL
  3. Building a database with SQL
  4. Storing & Retrieving Data
  5. Advanced SQL database access methods
  6. Database Security
  7. Using SQL in applications
  8. Cursors
  9. Stored procedures
  10. Error Handling
  11. Dynamic SQL
  12. Advice & Tips

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.

SUMMARY OF COMPETENCIES DEVELOPED

On successful completion of the course you should be able to do the following:

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

WHAT THE COURSE COVERS

Here are just some of the things you may be doing:

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

Related products