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]

The skills and knowledge acquired in Microsoft Access Level 3 are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access. Course Content Relational database design: Designing a relational database; Scoping the system; Determining the inputs; Normalising a database; First normal form (1nf); Second normal form; Second normal form – case study; Third normal form (3nf); Database indexin... [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]

The skills and knowledge acquired in Microsoft Access Level 1 are sufficient to create robust relational database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data Course Content Access orientation: Understanding Microsoft Access; Starting Access; Understanding the getting started screen; Opening an existing database file; Understanding the access screen; Working with the navigation pane; Working with a ... [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]

The aim of this course is to build on the introductory skills of Level 1. You will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries and will be introduced to some basic automation techniques involving macros. Course Content Data validation: Assigning default values; Validation rules and text; Validating numbers; Setting required fields; Working with validations Querying techniques: Modifying a saved query; Creating and queries;... [More]

This course delves deeper into topics introduced in Level 1 and explores a number of advanced topics. Discover ways to secure your entire website and protect information in your database. Learn how to design a database for optimum speed. Explore advanced programming techniques. Combine PHP with Flash, CSS and JavaScript to create some amazing web applications. Course Content Security Register globals Webpage encryption Creating a server certificate and key Working with SSL in your d... [More]

Learn how to create dynamic database-driven websites using PHP and MySQL – the fastest-growing scripting language in the world. The course includes demonstrations and hands-on exercises in class along with programming notes. Course Content Background and History of PHP Why PHP is so popular Incorporating PHP into HTML Using PHP to create HTML Escaping characters Comments Processing Form Data Displaying PHP variables as HTML Receiving variables from a form and displaying them in the ... [More]