Structure Query Language Server Service

a) Apply the normalisation technique to relational database tables.
b) Explain and apply the ER modelling technique to design a relational database.
c) Create a database with multiple tables with the relationship between the tables and insert records.
d) Analyse and implement constraints in the tables.
e) Increase the fast accessibility of rows in the tables.

You will be able to write queries, stored procedures, functions and triggers using the Structured Query Language.

We will teach you how to:  

a) Create SQL queries to retrieve data from the tables using different clauses in Select/Update/Insert statements
b) Evaluate and improve the process by employing a single call instead of multiple calls. 
c) Generate automatically stored procedure when some event occurs in the database. 
d) Design and create a user-defined function in the SQL database.

You will be able to design a secure database using setting up security measures such as users, logins, roles and permissions to meet the organisational requirements.

a) Create server login and Windows accounts in the SQL database.
b) Examine the various built-in permissions and user rights in the SQL database.
c) Adding logins to the various roles in the server and the database.
d) Creating and adding users and group accounts in the SQL database
e) Test and resolve the problem by employing an application role.
f) Administer the user profiles, policies, permissions and privileges in the database server.

You will be able to construct optimised queries with exception handling techniques in SQL.

We will teach you how to:  

a) Discuss different types of exception handling techniques that are used to identify the issues and state the measures that can be taken to resolve the issue in the SQL database.
b) Create queries with error handling technique.
c) Design SQL with customised exception handling to identify a problem and resolve it in the database.