Student Services

SQL Databases

Statement of AchievementPlease enquire for prices and more information
Course Duration: 100 Hours
DeliveryCorrespondence
Course REF: BIT201

SQL Databases Outline

Please note: this course is not suitable for MAC computers users

Why choose this course?
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.
Is this course right for me?
This course is most suitable for programmers and web developers who are looking to expand their skills with SQL server

Lesson Structure

There are 12 lessons in this course:

  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.


Aims

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

Activities

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

To learn how to enrol click here

SQL Databases

Statement of AchievementPlease enquire for prices and more information
Course Duration: 100 Hours
DeliveryCorrespondence
Course REF: BIT201