37802 Courses in Cardiff delivered Online

Unlock Your Potential as a Learning & Development Practitioner with Our Level 3 Course This qualification allows candidates to learn, develop and practice the skills required for employment and a career in Learning & Development. The content covers all essential areas of learning & development and is mapped out to the institute of apprenticeships standards. It’s a work-based program combining on-the-job training with classroom learning, equipping you with skills to support employee learning and development (L&D) within an organisation. Learn about the Cavity Training Learning & Development Practitioner Course You will be introduced to the role and responsibilities and essential attributes and behaviours required in the various L&D roles that may be required for effective learning and development in an organisation. Additionally, it will teach you the policies and processes required for effective organisation learning. You will learn how to identify and analyse learning needs, establish team and individual capability and learning gaps, in line with organisational performance outcomes and to enable effective evaluation. This may include the needs of the staff impacted by the move to a net carbon zero economy by 2050 and the requirements for a just transition. Fees This course can be completed as an government funded apprenticeship, through Cavity Training, or as a privately funded course for £2500. You can either pay as a lump sum or alternatively, you can split into 12 instalments. Entry Requirements Whilst any entry requirements will be a matter for individual employers, typically an apprentice will have an area of technical, vocational or behavioural expertise in which the organisation needs others to acquire through training. And a minimum of English & Maths GCSE. Structure Our candidates are trained to the highest standards and are fully supported to develop all of the knowledge, skills and behaviours required to be an outstanding Learning & Development practitioner. The course duration is typically 18-24 months. Knowledge Our course is delivered via live training webinars with specialist tutors. Skills and Behaviours You will be appointed a designated Learning & Skills Teacher, who will coach you through your qualification and complete regular assessments with you to support you to complete your qualification. You will have weekly contact from your tutor. How we compare with our competitors? Don't just take our word for it, here is what our staff think Bridget I did my course years ago. It was classroom based one night per week. I think I would prefer to be more ‘hands on’ like it is now. Cavity really are a great company to work for. I truly believe that there expertise will ensure the next generation are amazing! Gina I did mine over an apprenticeship but the company my employer used wasn’t great and I didn’t get much support. Although I passed I can only imagine the length that Cavity have gone to to ensure that the students feel supported. As an employee, its super! Enquire Today

Why Learn Vectorworks Basics to Essentials Training Course? Our Vectorworks training is meticulously crafted to educate and inspire designers of all levels. Whether you're a beginner or an experienced designer, our courses will equip you with new skills, refine your workflows, and teach Plans, sections and elevations. Course Link Duration: 10 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking hours of your choice, available from Mon to Sat between 9 am and 7 pm. Vectorworks Basics to Essentials Training Course Discover and Enhance Your Design Skills Our Vectorworks training is meticulously crafted to educate and inspire designers of all levels. Whether you're a beginner or an experienced designer, our courses will equip you with new skills, refine your workflows, and unlock the full potential of your Vectorworks software. Online Training Options Customized Online Sessions: Tailored training sessions for your specific needs and expertise level. Virtual Classroom: Join interactive virtual classes from the comfort of your office. Getting Started Guides: Comprehensive guides to help you navigate the fundamentals of Vectorworks. In-Person Training Opportunities Customized On-Site Sessions: Hands-on training delivered directly to your office or regional event. One to One: Engage in interactive learning at our training locations. Get Vectorworks https://www.vectorworks.net › downloads › ServicePack Vectorworks, Inc. 2D 3D CAD BIM software for Mac or Windows allows designers to transform the world. Project sharing makes it easy. Download or try today. Module 1: Grasping CAD and Vectorworks Understanding the Role of CAD in Design Getting Acquainted with Vectorworks Software Module 2: Configuring Your Workspace Customizing Your Workspace Essential Options and Preferences Module 3: Mastering Foundational Drawing Skills Techniques for Drawing Object Selection Methods Module 4: Advanced Object Manipulation Merging Shapes Reflecting Objects Rotating Objects Grouping Elements Module 5: Precision Drawing and Scaling Techniques Working with Scale Setting Preferences for Accuracy Creating and Saving Templates Module 6: Achieving Accurate Object Placement Ensuring Drawing Precision Precise Object Movement Module 7: Advanced Editing Methods Utilizing Fillet Tool Applying Offset Function Module 8: Understanding Object Attributes and Groups Basic Attribute Management Editing Object Groups Module 9: Object Duplication Techniques Linear Duplicates Rectangular Duplicates Circular Duplicates Module 10: Crafting Room Plans Designing Walls Incorporating Windows and Doors Module 11: Development of Room Plans Methods for Room Plan Drawing Module 12: Exploring Additional Attributes Hatch Patterns Gradients Image Fills Module 13: Creating Elevation Drawings Elevation Drawing Techniques Effective Approaches Module 14: Importing Images for Graphic Use Graphic Illustration Integrating Images Module 15: Symbols and Resource Handling Symbol Creation Introduction to Resource Browser Module 16: Organizing Drawings Using Design Layers Optimizing Design Layer Utilization Module 17: Labeling Drawings and Title Blocks Drawing Labels Title Block Text Placement Module 18: Plotting and Printing Methods User Interface Navigation and Terminology Printing Approaches Module 19: Generating Drawing Sheets A1, A2, and A3 Sheet Formats Module 20: Utilizing Viewports Effectively Managing Multiple Views Module 21: Professional Model Presentation Techniques Paper Space Presentation Conversion to PDF Formats Module 22: File and Project Management Module 23: Object Display and Terminology Module 24: Objects and Data Management Module 25: Precise Object Placement Object Snapping Quick Selection Module 26: Dividing and Measuring Objects Module 27: Dimensioning and Annotations Module 28: Working with Text Elements Module 29: Customizing Tool Palettes Module 30: Organizing Tool Palettes Module 31: Efficient Tool Palette Usage Module 32: Standard Views and Drawing Techniques Module 33: Drawing Curved Shapes Arcs, Donuts, and Ellipses Drawing Module 34: Real-World Units and Measurements Module 35: Object Manipulation Adjusting Object Angles Module 36: File Handling and Management Saving, Exiting, and Opening Projects Module 37: Creating Mirrored Images Module 38: Introduction to 3D Modeling Creating Extrusions Basic 3D Concepts Understanding For a free 30-day trial of Vectorworks, request an evaluation serial number at the provided link. https://www.vectorworks.net/trial Learning Outcomes of the Vectorworks Basics to Essentials Training Course: Proficiency in Vectorworks software, mastering its basic and essential features. Enhanced design skills and efficient workflows for architectural, landscape, and entertainment projects. Customized training based on individual needs and expertise levels. Flexibility with online and on-site options for convenient learning. Access to Vectorworks University with a wealth of resources for continuous learning. Interactive virtual classrooms and immersive hands-on training for practical experience.

Business Intelligence: Virtual In-House Training Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance. What you will Learn You will learn how to: Specify a data warehouse schema Identify the data and visualization to be used for data mining and Business Intelligence Design a Business Intelligence user interface Getting Started Introductions Agenda Expectations Foundation Concepts The challenge of decision making What is Business Intelligence? The Business Intelligence value proposition Business Intelligence taxonomy Business Intelligence management issues Sources of Business Intelligence Data warehousing Data and information Information architecture Defining the data warehouse and its relationships Facts and dimensions Modeling, meta-modeling, and schemas Alternate architectures Building the data warehouse Extracting Transforming Loading Setting up the data and relationships Dimensions and the Fact Table Implementing many-to-many relationships in data warehouse Data marts Online Analytical Processing (OLAP) What is OLAP? OLAP and OLTP OLAP functionality Multi-dimensions Thinking in more than two dimensions What are the possibilities? OLAP architecture Cubism Tools OLAP variations - MOLAP, ROLAP, HOLAP BI using SOA Applications of Business Intelligence Applying BI through OLAP Enterprise Resource Planning and CRM Business Intelligence and financial information Business Intelligence User Interfaces and Presentations Data access Push-pull data access Types of decision support systems Designing the front end Presentation formats Dashboards Types of dashboards Common dashboard features Briefing books and scorecards Querying and Reporting Reporting emphasis Retrofitting Talking back Key Performance Indicators Report Definition and Visualization Typical reporting environment Forms of visualization Unconstrained views Data mining What is in the mine? Applications for data mining Data mining architecture Cross Industry Standard Process for Data Mining (CISP-DM) Data mining techniques Validation The Business Intelligence User Experience The business analyst role Business analysis and data analysis Five-step approach Cultural impact Identifying questions Gathering information Understand the goals The strategic Business Intelligence cycle Focus of Business Intelligence Design for the user Iterate the access Iterative solution development process Review and validation questions Basic approaches Building ad-hoc queries Building on-demand self-service reports Closed loop Business Intelligence Coming attractions - future of Business Intelligence Best practices in Business Intelligence

Certificate in Intellectual Property (CIP) Why Attend As international trade and business continues to evolve, the importance of Intellectual Property Rights (IPRs) becomes increasingly vital. With new technologies and products relying heavily on IPRs, governments around the world are competing to offer higher levels of protection in order to attract investments and promote local innovation and production. Due to the complex nature of the scientific, economic, social, and theoretical aspects of IPRs, it is crucial for entities to have a comprehensive understanding of these issues. During this course, through practical workshops, case studies and expert knowledge, participants will gain an understanding of the concepts, theories, legislative and practical elements necessary to develop a successful IP strategy for their organization. Course Methodology In this interactive training course participants will frequently work in pairs as well as in larger groups to complete exercises, and regional and international case studies Course Objectives By the end of the course, participants will be able to: Understand the theoretical background of Intellectual Property (IP) and the various types of IP existence Understand the international and local set of conventions and laws governing IPRs Demonstrate deep knowledge of the conditions that should exist in each type of IPR, their registration, licensing and enforcement Apply knowledge of IPRs in all legal fields including contracts and litigation Participate effectively in building a comprehensive IP strategy for their organization Target Audience This course is suitable for professionals working in the legal and IP filed, including but not limited to; lawyers, in-house counsels, governmental officials, police, customs, health authorities, researchers, university lecturers, publishers, IP agents as well as researchers who are interested in having deeper knowledge about IP in the GCC. It will also highly benefit in-house councils who recently joined their companies in the GCC as it will give them all the knowledge needed to handle all IP issues within the region. Target Competencies General principles of IPRs Trademarks, Patents, Copyright Principles of IP Enforcement Building IP Strategy Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practise through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. This PLUS Specialty Training Legal course qualifies for 4 elective CLPD points. Introduction and basic concepts Types of IPRs Main theories justifying IP protection The role of IP in economic development The Role of IP in innovation and creativity The globalization of IPRs protection International conventions Trade-Related Aspects of Intellectual Property Rights (TRIPS) and the World Trade Organization The GCC Cooperation in the field of IP protection Trademarks and copyright Definition and types of marks Scope of trade marks protection Registration procedures and rights conferred to trade mark owner Legal protection of trade marks Subject matter and conditions of copyright Types of protected works Financial and moral rights Fair use, duration of protection and legal protection for copyright Patents and trade secrets Patentable inventions and types of patents Registration process Ownership and rights conferred to patent owner Employer-employee inventions and legal protection for patents Definition of trade secrets and confidential information Elements of trade secrets Utilization of trade secrets commercially Legal protection of trade secrets Building a strong IP strategy and strategic management of IPRs Overview and basic concepts Understand your business and your IP needs IP audit and building the portfolio Onward licensing (licensing process and contracts) IP commercialization mechanisms and maximizing the benefits Practical steps to building a successful IP strategy IP valuation - your gateway to know how much your IP worth Assessment of the IP strategy for further success

Course Overview From maintaining the school culture to supporting child development, a school administrator's duties are a mixture of diverse roles. As a result, it becomes difficult to complete the tasks without proper training. So, before you join this sector, train yourself with the School Administrator Training course. This all-in-one course will equip you with the core skills to become an excellent school administrator. In the School Administrator Training course, you will learn the essentials of UK schools. The easy-to-follow modules will teach you the school culture strategies to maintain. You will pick up the fundamental skills to carry out the administrative duties and manage everything proficiently. The course will also help you acquire the skills to safeguard children and support their development. In addition, there will be lessons on how to manage the school premises.  This School Administrator Training course will ensure you are ready to take up the challenges that come with this job. Along with that, you will receive a valuable certificate. This certificate will boost your employability. Enrol now! What You Will Learn Learn about different types of schools in the UK Understand how to create and maintain a school culture Develop the essential skills for educational administration and management Grasp the principles of safeguarding children Build the competence to support child development Know how to help children to resolve their problem Gain the skills to control and manage the school premises Why Should You Choose this School Administrator Training Course Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential Who is this Course for? The School Administrator Training course is for those who want to develop their skills and knowledge to pursue a school administrator career.  Requirements Our School Administrator Training course is fully compatible with any kind of device. Whether you are using Windows computers, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path This School Administrator Training course will assist you in pursuing a career in the relevant fields. School Administrator (Salary Range £17,000-£25,000) School Administrator Training Module 01: Introduction to School Administration 00:12:00 Module 02: Types of Schools In The UK 00:15:00 Module 03: Workplace Development 00:12:00 Module 04: Creating and Maintaining a School Culture 00:13:00 Module 05: Educational Administration and Management 00:11:00 Module 06: Safeguarding Students 00:14:00 Module 07: Child Development 00:13:00 Module 08: Serious Behavioural Issues and Problems of Students 00:12:00 Module 09: Managing School Premises 00:10:00 Module 10: Safety and Maintenance As an Administrator 00:08:00 Module 11: Self-Management and Dealing with Stress 00:13:00 Assignment Assignment - School Administrator Training 02:00:00

This mega life skills training course will equip you with all the essential skills you need to successfully navigate everyday life. Through life skills training, you'll learn everything from problem-solving techniques and communication techniques to time management tips and financial literacy skills. Drawing on the personal experiences of successful people, this course will teach you how to communicate effectively and meaningfully with others, so you can be confident when faced with difficult conversations or challenging situations. You'll discover easy-to-follow strategies for overcoming mental obstacles and conquering procrastination, and develop the resilience you need to weather any storm life throws your way. Life skills course is designed to give you knowledge that you can apply immediately to enrich your life, reduce stress levels, and whatever comes your way! Course includes: Course 01: Life Coaching and Career Counselling Course 02: Spiritual Life Coaching Course Course 03: Behaviour Management & Emotional Intelligence Course 04: Anger Management & Conflict Resolution Course 05: Dealing With Difficult People In Life & Work Course 06: Psychology, Meditation & Parapsychology Course 07: Motivation Skills Course 08: Personal Development Skills Course 09: Team Management Course 10: Setting & Achieving Goals Course 11: Time Management Skills Course 12: Office Skills The comprehensive learning resources for Life skills course are available anytime, anywhere, so you can study at your own pace in the convenience of your own home. Industry experts break down the curriculum into tiny, manageable units. And our professionals will respond to any of your questions. Reality Check: Many students claim that even though it is shorter than other courses they have taken, it has taught them considerably more. This course is just as good as many other offline courses that were 5 to 10 times more expensive. As a result, taking this outstanding course is highly recommended by everyone. Course Significant Points: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Method of Assessment MCQ Based Passing Marks 60% Unlimited Retake Exam Instant Assessment and Feedback CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in Life skills course. However, This course particularly effective for- Students Recent graduates Job Seekers in related field Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill We take pleasure in offering the most adaptable, relatively inexpensive, and enjoyable online courses possible to eager aspirants all around the world. Requirements Learners seeking to enrol for Life skills course should meet the following requirements; Basic knowledge of the English language, which you have already Basic Knowledge of Information & Communication Technologies for studying online or digital platform Stable Internet or Data connection in your learning devices Career path This is a whole course package. You'll be capable of covering every job/employment sector after finishing this Life skills bundle. The major goal of this package is to make you intelligent and proficient in all areas, so you can communicate and perform effectively at work. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - £9.99

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! This Certificate in Health Economics and Health Technology Assessment Training at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Health Economics and Health Technology Training at QLS Level 3 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Health Economics and Health Technology Training at QLS Level 3 course. Due to Health Economics and Health Technology Training at QLS Level 3's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Health Economics and Health Technology Training at QLS Level 3 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Health Economics and Health Technology Training at QLS Level 3 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Health Economics and Health Technology Training at QLS Level 3 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Health Economics and Health Technology Training at QLS Level 3 course. This Health Economics and Health Technology Training at QLS Level 3 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Health Economics and Health Technology Training at QLS Level 3 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Health Economics and Health Technology Training at QLS Level 3 course: Module 01: Introduction to Health Economics and Health Technology Assessment Module 02: Basic Economic and Technological Concepts Module 03: What Is Health Economics? Module 04: What Is Health Technology Assessment? Module 05: The Health Minister's Dilemma Module 06: Exploring the Relationship Between Health Economics (HE) and Health Technology Assessment (HTA) Module 07: Economic Evaluation Module 08: Health Insurance Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Certificate in Health Economics and Health Technology Assessment Training at QLS Level 3 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Health Economics and Health Technology Training at QLS Level 3 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements Health Economics and Health Technology Training at QLS Level 3 No prior background or expertise is required. Career path The Health Economics and Health Technology Training at QLS Level 3 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates Certificate in Health Economics and Health Technology Assessment Training at QLS Level 3 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Certificate in Health Economics and Health Technology Assessment Training at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost. CPDQS Accredited Certificate Digital certificate - Included

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

Voice over LTE training course description This course provides a basic understanding of the 3G LTE Air Interface, SAE, as well as Voice over LTE options and LTE Advanced features. Investigating the standards for the EPS , formulated by the 3GPP standards body, the course will set out to examine and explain the 4G environment from user equipment to border gateway and beyond. This course will ensure the delegate has a grasp of all aspects of the current global deployments, the next steps in upgrades and the promise of things to come. What will you learn Describe the complete EPC architecture. Explain the use of QoS within the air interface & core network. Explore the features of LTE advanced. Describe the various methods of supporting voice services with 3G LTE. Describe IMS structure and control entities. Explain an IMS session. Voice over LTE training course details Who will benefit: Any engineers who are assisting in the deployment of voice services within their LTE networks. Prerequisites: Intro to Data comms & networking Telecommunications Introduction Duration 3 days Voice over LTE training course contents 3GPP standards body Release 8 - Release 12, Supported and expected features. The EPC revisited EPC revisited 3G LTE & EPC Architecture, NB, MME, SGW, PDNGW, PCRF, Interworking capabilities, Protocol stack explored, NAS signalling, Default EPS bearer, Slot allocation algorithms, Scheduling algorithms, Quality of Service requirements, Dedicated EPS bearers. VoLTE deployment strategies Common networks everywhere, GSM/WCDMA view, CDMA view. VoLTE system architecture LTE radio, LTE Radio background, LTE radio architecture, Evolved packet core, EPC entities & functions, EPS mobility management, MS entities, Home subscriber server, Policy & charging rules function. VoLTE functionality Radio functionality, Bearers & schedulers, Mobility, Circuit switched fall back handover, Mobility from 2G/3G back to LTE, Power Saving Features, Positioning services, UE radio access capabilities for VoLTE users. EPC functionalities, LTE subscriber identification, PDN connectivity establishment, EPS dedicated bearer setup, IMS identification, IP multimedia identification module, Public user identity, Private user identity, Relationship between public & private identity, identification of users device, identification of network entities, identification of services, identification without ISIM. IMS service provisioning, Enforcement of allowed services, Service triggering information, Selection of the AS, AS behaviour, Service provisioning in action. VoLTE end-to-end & signalling VoLTE subscription & device configuration. EPS attach for CSFB/IMS VoIP & default bearer. IMS registration, Constructing the REGISTER request, From UE to P-CSCF, From P-CSCF to I-CSCF, From I-CSCF to S-CSCF, S-CSCF challenges the UE, UE's response to the challenge, Registration at the S-CSCF, The 200 OK response, Third-party registration to application servers, Subscription to registration event package, Re-registration & re-authentication, De-registration, Related standards. IMS VoIP session, Constructing the INVITE request, Routing, Media negotiation, Media resource reservation & policy control, Charging, Session release. Voice continuity, PS - PS intersystem handover, Single radio voice call continuity. IMS emergency session, PDN Connection setup for emergency session, Emergency registration, Emergency session. CS fallback for EPS call case, Architecture of CS fallback in EPS, Description of SGs interface, Idle mode signalling reduction, Idle mode vs active mode, CS fallback attachment, Mobile originating call using CSFB, Mobile terminating call using CSFB, Call unrelated CSFB procedures, Mobile terminating roaming retry & forwarding. VoLTE Messaging, Native IMS messages, SMS interworking, Multimedia messaging service. Unstructured supplementary services data simulation in IMS. IMS services VoLTE radio performance Coverage, Latency, Capacity. LTE advanced features Carrier aggregation, Coordinated mMulti-point Operation (CoMP), ICIC & eICIC, Relay node deployment & donor eNBs, Improved cell edge coverage, Reduced control plane latency, Heterogeneous networks, HeNB, security gateways, HeNB gateways.

Dreamweaver training course description Dreamweaver is a web authoring program that allows you to build professional quality websites. This course starts with a tour of Dreamweaver and customising your workspaces, moving onto HTML and CSS basics. Page layouts, templates and interactive pages are also covered. The final session covers how to use Dreamweaver as a HTML editor. Hands on session follow all the major theory chapters. What will you learn Use Dreamweaver to create websites. Customise Dreamweaver. Use templates. Add interactivity to web pages. Use Dreamweaver to edit HTML code. Dreamweaver training course details Who will benefit: Anyone wishing to create or edit websites. Prerequisites: None. Duration 3 days Dreamweaver training course contents Getting started Installing the programme, Updating to the latest version,, Online content, On first launch, Choosing the program colour theme, Setting up the workspace, Defining a Dreamweaver site, Checking for updates, Additional resources. Customizing your workspace Touring the workspace, Using the start screen, Exploring new feature guides, Setting interface preferences, Switching and splitting views, Selecting a workspace layout, Personalising Dreamweaver, Working with extract, Creating custom keyboard shortcuts, Using the Property inspector, Using the Related Files interface, Using tag selectors, Using the CSS Designer, Using the Visual Media Query (VMQ) interface, Using the DOM viewer, Using Element dialogs, displays and inspectors, Setting up version control in Dreamweaver, Exploring experimenting and learning. HTML Basics What is HTML? Where did HTML begin? Frequently used HTML elements, What's new in HTML5. CSS Basics What is CSS? HTML vs. CSS formatting, HTML defaults, CSS box model, Applying CSS styling, Multiples, classes and ids. Web design basics Developing a new website, Scenario, Working with thumbnails and wireframes, Creating a page layout Evaluating page design options, Working with predefined layouts, Styling an existing layout, Styling elements using the Extract panel, Extracting text from a Photoshop mockup, Troubleshooting CSS styling, Extracting text styling from a Photoshop mockup, Creating a gradient background using Extract, Extracting image assets from a mockup, Adding CSS background effects in code, Finishing up the layout. Working with templates Creating a template from an existing layout, Inserting editable regions, Inserting editable regions, Inserting HTML entities, Inserting metadata, Validating HTML code, Producing child pages, Moving CSS styles to linked file, Updating a template. Working with text, lists and tables Previewing the completed file, Creating and styling text, Creating lists, Creating and styling tables, Spell-checking webpages, Finding and replacing text. Working with images Web image basics, Previewing completed files, Inserting an image, Controlling image positions with CSS classes, Working with the Insert panel, Using the Insert menu, Inserting non-web file types, Working with Photoshop Smart Objects, Copying and pasting images from Photoshop, Inserting images by drag and drop, Optimizing images with the Property inspector. Working with navigation Hyperlinks, previewing the completed file, creating internal and external hyperlinks, setting up email links, Creating image-based links, Targeting page elements, Locking an element on the screen, Styling a navigation menu, Checking your page, Adding destination links. Adding interactivity Dreamweaver behaviours, Previewing the completed file, Working with Dreamweaver behaviours, Working with jQuery Accordion widgets, Inserting a jQuery Accordion widget, Styling a jQuery Accordion. Publishing to the web Defining a remote site, Cloaking folders and files, Wrapping things up, Putting your site online, Synchronizing local and remote sites. Working with code Creating HTML code, multicursor support, commenting your code, Working with CSS preprocessors, Selecting code, Collapsing code, Expanding code, Accessing Split code view, Previewing assets in Code View.