37466 Courses delivered Online

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

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Our OISC Level 1 training course is designed as a two-day, entry-level course, offering participants an introduction into Immigration Advice. In this course, we aim to cover the syllabus at level one, as according to OISC standards. View the OISC Level 1 course dates below, delivered on Microsoft Teams. Course Overview:   Our OISC Level 1 Training Course, your gateway to comprehensive knowledge in Immigration, EU, and Asylum law. Our course is specifically designed to equip participants with the fundamental understanding needed to excel in the level one assessments, with a strong focus on fulfilling the core requirements set by the OISC (Office of the Immigration Services Commissioner). Designed as a comprehensive two-day entry-level course, it serves as an excellent introduction to Immigration Advice. Our aim is to cover the level one syllabus prescribed by the OISC, ensuring that you meet the standards set by the regulatory body. By enrolling in our OISC Level 1 training course, you’ll gain the essential knowledge, skills, and confidence required to navigate the complex world of immigration law effectively. Whether you’re looking to launch a career in immigration advice or seeking to enhance your existing expertise, this course will lay a solid foundation for your professional journey. Don’t forget to check out ourExam Technique Training (Level 1) which is designed to help prepare learners for their accreditation exam. Are you interested in setting up your own OISC law firm? Join our Setting Up An OISC Firm course, where you’ll learn the requirements, processes and key information about running a firm as well as receive handy resources and materials. Course joining links, materials and instructions are sent out 24hours before the course starts. What is included in the OISC Level 1 Syllabus? Based on the latest syllabus, published by the Office of the Immigration Services Commissioner, the OISC Level 1 Training Course covers the following: Analysis of the structures, terminology, ethical practices and frameworks of immigration law Asylum and protection law European Economic Area (EEA) free movement law British Naturalisation and British Citizenship registration Business immigration law Appeals process and structures of the Asylum and Immigration Tribunal Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course. How is the OISC Level 1 exam structured? The OISC Level 1 exam is structured into two parts: The first part comprises 20 multiple-choice questions. You have 1 hour and 15 minutes to complete this section of your OISC exam. There is only one correct answer for each question. The second part presents different scenario-based questions to be answered within 1 hour and 15 minutes. You should provide answers which are legible and written clearly in plain English. Detailed instructions on how to complete each section of your OISC Level 1 exam will be provided during the course, to ensure that each candidate is adequately prepared to pass the test.

AutoCAD Mac Basic to Intermediate Training: Clickhere for more info Learn to produce accurate, to-scale 2D drawings with AutoCAD for Mac training.  A project-based course made for AutoCAD Mac users and focused on architecture & interior designs students and professionals. Duration: 10 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. AutoCAD Mac Basic to Intermediate Training: Master precise, to-scale 2D drawings with tailored AutoCAD for Mac training. Designed for architecture and interior design professionals and students. Duration: 10 hours of in-depth learning. Method: Personalized 1-on-1 attention for an immersive learning experience. Flexible Scheduling: Choose your convenient hour from Monday to Saturday, between 9 am and 7 pm. Book now to customize your training journey! AutoCAD Mac Basic to Intermediate Training: Master precise, to-scale 2D drawings with tailored AutoCAD for Mac training. Designed for architecture and interior design professionals and students. Duration: 10 hours of in-depth learning. Method: Personalized 1-on-1 attention for an immersive learning experience. Flexible Scheduling: Choose your convenient hour from Monday to Saturday, between 9 am and 7 pm. Book now to customize your training journey! AutoCAD Mac Basic to Intermediate Training: Master precise, to-scale 2D drawings with tailored AutoCAD for Mac training. Designed for architecture and interior design professionals and students. Duration: 10 hours of in-depth learning. Method: Personalized 1-on-1 attention for an immersive learning experience. Flexible Scheduling: Choose your convenient hour from Monday to Saturday, between 9 am and 7 pm. Book now to customize your training journey! AutoCAD Mac Basic to Intermediate Training: Master precise, to-scale 2D drawings with tailored AutoCAD for Mac training. Designed for architecture and interior design professionals and students. Duration: 10 hours of in-depth learning. Method: Personalized 1-on-1 attention for an immersive learning experience. Flexible Scheduling: Choose your convenient hour from Monday to Saturday, between 9 am and 7 pm. Book now to customize your training journey!

Overview One of the most effective ways to understand people is through their body language. If you want to secure the power to understand people and their intentions better, master the art of body language. Our Body Language Training course can help you out. This course is broken down into bite-sized modules to help you understand the fundamentals of body language. Through these modules, you will learn how different parts of our body can convey messages. Along with explaining non-verbal communication, the course will also shed light on digital body language. Here, you will also develop the ability to decode the personalities of others through their body language. So, if you are interested in grasping this valuable skill set and excelling in your personal and professional life, enrol now! Course Preview Learning Outcomes Familiarise yourself with the fundamentals of non-verbal communication Understand the science of body language portrayed by different body parts Learn how to use digital body language Develop the skills to understand people and their personalities through their body language Build the skills for using your body language to express yourself Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Non-verbal communication Body language Identification Who Should Take This Body Language Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Body Language Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Body Language Training Certification After completing and passing the Body Language Training successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Body Language Training will equip you with effective skills and abilities and help you explore career paths such as  Body Language Experts Investigators Recruiter SEN Teacher Mental Health Counsellor Module 01: Understanding the Basics Understanding the Basics 00:44:00 Module 02: Non-Verbal Communication Non-Verbal Communication 00:38:00 Module 03: Science of Body Language - Head-Part 1 Science of Body Language - Head-Part 1 01:06:00 Module 04: Science of Body Language - Head-Part 2 Science of Body Language - Head-Part 2 00:53:00 Module 05: Science of Body Language - Hand Science of Body Language - Hand 01:32:00 Module 06: Science of Body Language - Mid Body Science of Body Language - Mid Body 01:08:00 Module 07: Science of Body Language - Lower Body Science of Body Language - Lower Body 01:01:00 Module 08: Understanding People Understanding People 00:59:00 Module 09: Personality and Types of It Personality and Types of It 00:47:00 Module 10: Digital Body Language Digital Body Language 00:56:00 Module 11: Use Body Language Use Body Language 00:59:00 Module 12: Persuasion or Manipulation Persuasion or Manipulation 00:41:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

Overview This comprehensive course on Sales Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Sales Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Sales Training. It is available to all students, of all academic backgrounds. Requirements Our Sales Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 24 lectures • 01:30:00 total length •Preview of Course: 00:01:00 •Introduction: 00:04:00 •Introduction to Action Plan: 00:02:00 •Belief Part 1: 00:04:00 •Belief Part 2: 00:03:00 •Belief Part 3: 00:04:00 •Belief Reinforcement: 00:03:00 •Belief Chapter (Written Context from the Sales Pro Book): 00:12:00 •Belief Cartoon Story: 00:06:00 •Celebrity Moment: 00:02:00 •Belief Action Plan: 00:04:00 •Authenticity: 00:05:00 •Celebrity Moment: 00:01:00 •Establishing Trust Part 1: 00:03:00 •Establishing Trust Part 2: 00:08:00 •Selling Results Part 1: 00:07:00 •Selling Results Part 2: 00:02:00 •Animation Selling Results: 00:01:00 •Selling Results Cartoon Story: 00:02:00 •Selling Value: 00:02:00 •Matching Benefits & Adding Value: 00:03:00 •Experience of Value: 00:07:00 •It Is Time To Take Action!: 00:04:00 •Assignment - Sales Training: 00:00:00

Advanced Adobe InDesign Training Program Learn InDesign with a course at Real Animation Works. Choose from Weekend, Weekday or Evening Courses and learn from expert tutors. Benefit from professional InDesign training conducted by Adobe Certified Instructors with extensive graphic design expertise. Check our Website Duration: 10 hours. Approach: 1-on-1 and personalized attention. Schedule: 1-on-1 sessions, available Monday to Saturday from 9 am to 7 pm.   Course Title: Comprehensive Adobe InDesign Training Duration: 10 Hours Session 1: Introduction to Adobe InDesign (1 hour) Overview of InDesign interface and tools Document setup: page size, margins, and columns Basic text formatting and paragraph styles Introduction to working with images and graphics Session 2: Advanced Text Formatting and Styles (1 hour) In-depth exploration of character and paragraph styles Advanced text composition techniques Managing text flow with threaded frames Incorporating special characters for typographic control Session 3: Mastering Images and Graphics (1 hour) Advanced image manipulation: resizing, cropping, and effects Text wrap options and integrating text with images Creating image frames and working with transparency Interactive elements: buttons and hyperlinks Session 4: Layout Design Techniques (1.5 hours) Grids and guides: precise alignment and spacing Working with layers for efficient design management Advanced object arrangement and distribution Utilizing master pages for consistent layout elements Session 5: Advanced Document Features (1.5 hours) Tables and data merge: organizing and automating data Interactive PDFs: forms, multimedia, and navigation Advanced print preparation: color management and preflighting Exporting for various digital and print outputs Session 6: Advanced Special Effects (1 hour) Creating drop shadows, gradients, and blending modes Working with typography on a path Advanced text and image effects Integrating Adobe Illustrator and Photoshop files Session 7: Project-Based Learning (1 hour) Participants work on a comprehensive project applying learned skills Instructor-guided project review and feedback Session 8: Tips, Tricks, and Time-Saving Techniques (1 hour) Productivity hacks and shortcuts Troubleshooting common issues and errors Best practices for efficient workflow and collaboration Session 9: Portfolio Building and Career Guidance (0.5 hour) Creating a professional portfolio showcasing InDesign projects Career advice and industry insights from the instructor Session 10: Q&A, Certification, and Course Completion (0.5 hour) Addressing participant questions and concerns Certificate of Completion distribution and course review Celebrating the completion of the Adobe InDesign training journey Upon completion of the Comprehensive Adobe InDesign Training course, participants will: Master Core Skills: Develop proficiency in essential InDesign tools, functions, and techniques for effective layout design. Advanced Text and Typography: Understand advanced text formatting, paragraph styles, and typographic controls for professional typography. Image Manipulation Expertise: Acquire skills in advanced image manipulation, text wrapping, transparency, and integration of multimedia elements. Advanced Layout Design: Learn precise layout techniques using grids, guides, layers, and master pages for consistency and visual appeal. Interactive Document Creation: Create interactive PDFs, forms, multimedia-rich content, and navigation elements for digital publications. Data Management and Automation: Master tables, data merge, and automation features for organized data presentation and streamlined workflow. Print and Export Proficiency: Understand color management, preflighting, and export settings for high-quality print and digital output. Special Effects and Integration: Apply advanced effects, gradients, blending modes, and integrate InDesign with Illustrator and Photoshop files seamlessly. Project-Based Expertise: Develop a comprehensive portfolio-worthy project, showcasing a range of InDesign skills and creativity. Efficient Workflow and Troubleshooting: Implement time-saving techniques, shortcuts, and troubleshoot common design challenges effectively. Career Readiness: Gain valuable insights into industry practices, portfolio building, and career guidance for pursuing opportunities in graphic design and desktop publishing. Versatile Learning Choices: Opt for either in-person sessions at our London center or engage in interactive online learning. Both options offer hands-on experience, detailed demonstrations, and ample chances for inquiries. Compatibility and Assistance: InDesign operates smoothly on Windows and Mac systems. Participants receive a comprehensive InDesign training manual for reference and an electronic certificate upon course completion. Additionally, enjoy lifelong email assistance from your InDesign instructor. Entry Requirements: No prior InDesign expertise is necessary. The training concentrates on InDesign 2023, relevant to recent software updates. Guarantees: We ensure exceptional value for your investment, guaranteeing your acquisition of essential skills and concepts during the training. Course Highlights: Master advanced typography techniques, including paragraph styles, character styles, and nested styles. Explore multi-page layout design, long document management, and advanced table formatting. Acquire skills to create and manipulate complex shapes, vector graphics, and custom illustrations. Learn efficient workflows for data merging, interactive documents, and digital/print output. Collaborate seamlessly with other Adobe Creative Cloud applications. Upon completion, receive a Certificate of Completion and access recorded lessons for self-paced learning. Expert Instruction: Learn from certified tutors and industry experts, gaining valuable insights, tips, and best practices for professional-level designs. Flexible Learning Options: Choose between in-person or live online sessions based on your schedule. Sessions are available Monday to Sunday, from 9 am to 8 pm, accommodating your convenience. Lifetime Support: Benefit from lifetime email support for continuous assistance. Our dedicated team is available to address your queries and challenges. Explore Adobe InDesign - Free Trial:  https://www.adobe.com/uk/products/indesign/free-trial-download.html

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.