Escalate your career by learning how to extract and change data in relational databases with SQL (Structured Query Language) that traverses multiple tables with Select, Insert, Update and Delete statements, functions and scripts. SQL is a current hot skill, valued by employers. Microsoft SQL Server is used for hands on exercises during this course. However, the content of the course is kept as close as possible to standard SQL. (Please note, there will be no instruction on how relat... [More]

Do you want to write more powerful SQL code? This course takes your SQL skills to the next level by introducing the use of flow control statements (if statements and loops etc.), the use of common SQL functions and creation of user defined functions, stored procedures and triggers. You’ll also learn how to activate SQL from, and return data to, user applications via ADO or ADO .Net. You’ll implement transactions, cursors, an audit trail and learn how to handle errors. Microsoft SQL ... [More]

This course is provided for people with minimum understanding of relational databases (Access, Oracle, SQL Server, MySQL etc) who want to get more value from the SQL Level 2 course or who just want to demystify relational database management systems. There is a trend developing in business for non IT people to understand and use SQL (structured query language) to query relational database management systems. For many years CCE has offered several courses that teach SQL. The content ... [More]