2190 Courses in Nottingham

ADMINISTERING MICROSOFT SQL SERVER COURSE DESCRIPTION This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. WHAT WILL YOU LEARN * Describe core database administration tasks and tools. * Configure SQL Server databases and storage. * Import and export data. * Monitor SQL Server. * Trace SQL Server activity. * Manage SQL Server security. * Audit data access and encrypt data. ADMINISTERING MICROSOFT SQL SERVER COURSE DETAILS * Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. * Prerequisites: Introduction to data communications & networking. * Duration 3 days ADMINISTERING MICROSOFT SQL SERVER COURSE CONTENTS * Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. * Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. * Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. * Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. * Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. * Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

ORACLE SQL TRAINING COURSE DESCRIPTION The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create SQL statements to query database tables. * Use standard aggregate functions and related SELECT statement clauses. * Join Tables. * Use basic subqueries and the set operators. * Use numeric, character and date functions. * Use conversion and other miscellaneous functions. * Use SQL parameters. * Use complex subqueries. * Create and alter tables and views. * Insert, update and delete rows in database tables. * Manage sequences and synonyms. ORACLE SQL TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. * Prerequisites: None. * Duration 3 days ORACLE SQL TRAINING COURSE CONTENTS * Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. * Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. * Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. * Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. * Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. * Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. * SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. * Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. * Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. * Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. * Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. * Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

HTML5 DEVELOPMENT TRAINING COURSE DESCRIPTION This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-375, and build an understanding of these topics: Manage the Application Life Cycle, Build the User Interface by Using HTML5, Format the User Interface by Using CSS, Code by Using JavaScript. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. WHAT WILL YOU LEARN * Manage the Application Life Cycle. * Build the User Interface by Using HTML5. * Format the User Interface by Using CSS. * Code by Using JavaScript. HTML5 DEVELOPMENT TRAINING COURSE DETAILS * Who will benefit: Anyone working with HTML5. * Prerequisites: None. * Duration 3 days HTML5 DEVELOPMENT TRAINING COURSE CONTENTS * Managing the Application Life Cycle * Platform fundamentals Packaging and the runtime environment: app package, app container, credentials/permission sets, host process, leverage existing HTML5 skills and content for slate/tablet applications. * Manage the state of an application Manage session state, app state and persist state information; understand states of an application; understand the differences between local and session storage. * Debug and test a HTML5 touch-enabled application Touch gestures; gestures you test on a device. * HTML5 UI: Text, Graphics, and Media * HTML5 tags for text content and graphics. When, why and how to use Canvas; when, why and how to use scalable vector graphics (SVG). * HTML5 tags to play media. Video and audio tags. * HTML5 UI: Organization, Input, and Validation * HTML5 tags to organise content and forms Tables, lists, sections; semantic HTML. * HTML5 tags for input and validation * CSS Essentials: Content Flow, Positioning, styling * Core CSS concepts Separate presentation from content (create content with HTML and style content with CSS); manage content flow (inline versus block flow); manage positioning of individual elements( float versus absolute positioning); manage content overflow (scrolling, visible and hidden); basic CSS styling. * CSS Essentials: Layouts * Arrange UI content by using CSS Use flexible box and grid layouts to establish content alignment, direction and orientation; proportional scaling and use of "free scale" for elements within a flexible box or grid; order and arrange content; concepts for using flex box for simple layouts and grid for complex layouts; grid content properties for rows and columns; use application templates. * Managing Text Flow by Using CSS Regions and using regions to flow text content between multiple sections (content source, content container, dynamic flow, flow-into, flow-from, msRegionUpdate, msRegionOverflow, msGetRegionContent); columns and hyphenation and using these CSS settings to optimise the readability of text; use "positioned floats" to create text flow around a floating object * Managing the Graphical Interface by Using CSS Graphics effects (rounded edges, shadows, transparency, background gradients, typography and Web Open Font Format); 2-D 3-D transformations (translate, scale, rotate, skew and 3-D perspective transitions and animations); SVG filter effects; Canvas. * JavaScript and coding essentials Manage and maintain JavaScript, Create and use functions; jQuery and other third-party libraries. Update the UI by using JavaScript Locate/access elements; listen and respond to events; show and hide elements; update the content of elements. * Animations, Graphics, and Accessing Data * Code animations with JavaScript animation; manipulate the canvas; work with images, shapes and other graphics. * Access data access by using JavaScript Send and receive data; transmit complex objects and parsing; load and save files; App Cache; datatypes; forms; cookies; localStorage * JavaScript coding for Touch Interface, Device and Operating System Resources, and More Respond to the touch interface, Gestures, how to capture and respond to gestures, Code additional HTML5 APIs, GeoLocation, Web Workers, WebSocket; File API, Access device and operating system resources, In- memory resources, such as contact lists and calendar; hardware capabilities, such as GPS, accelerometer and camera.

5G TRAINING COURSE DESCRIPTION This course is designed to give the delegate an understanding of the technologies and interworking requirements of the next generation of cellular communications. It is not a definitive set of descriptions but a possibility of the final deployment. During the course we will investigate the 10 pillars for 5G, which will include various Radio Access Technologies that are required to interwork smoothly. Hence we will look at the 4G Pro features and other RATs. WHAT WILL YOU LEARN * List the ten pillars of 5G deployment. * Explain the 5G Internet and Software Distributed Networks (SDN). * Explain carrier aggregation, the mobile cloud and RAT virtualisation. * Explain an overall picture of 5G architecture. 5G TRAINING COURSE DETAILS * Who will benefit: Anyone who is looking to work with next generation networks. * Prerequisites: Mobile communications demystified * Duration 3 days 5G TRAINING COURSE CONTENTS * Drivers for 5G 5G Road Map, 10 Pillars of 5G, evolving RATs, small cell, o SON, MTCm, mm-wave, backhaul, EE, new spectrum, spectrum sharing, RAN virtualisation. * 4G LTE advanced features *MIMO, Downlink & uplink MIMO R8, MIMO technology in LTE advanced, Downlink 8-layer SU-MIMO, Downlink MU-MIMO, Uplink MU-MIMO, Uplink transmit diversity, Coordinated multi-point operation (CoMP), Independent eNB & remote base station configurations, Downlink CoMP, * Uplink Multi-Cell Reception. * ICIC & eICIC ICIC, Homogeneous to heterogeneous network, eICIC, Macro-pico scenario, Macro-femto scenario, Time orthogonal frequencies. Almost Blank Subframe (ABS). * Carrier aggregation Component carriers (CC), * CC aggregation, Intra-band contiguous solutions, Intra-band non-contiguous solutions, Inter-band non-contiguous solutions, CA bandwidth classes, Aggregated transmission bandwidth configurations (ATBC), Possible carrier aggregation configurations (Rel 9, 10 & 12). * Enhanced Interference Mitigation & Traffic Adaptation (eIMTA) TDD UL-DL reconfiguration for traffic adaptation, Reconfiguration mechanisms, Interference mitigation schemes, Dynamic & flexible resource allocation. * 5G architectures 5G in Europe, horizon 2020 framework, 5G infrastructure PPP, METIS project, innovation centre, 5G in North America, research, company R & D, 5G specifications. * The 5G internet Cloud services, IoT & context awareness, network reconfiguration & virtualization support, hypervisors, SDN, the controller, service-oriented API, OpenFlow switches, SDN operation, SDN control for traffic flow redirection, OpenFlow controllers, how SDN works, application, control and infrastructure layers, a programmable network, how SDN & NFV tie together, SDN's downside, SDN orchestration, Mobility, architectures for distributed mobility management, MEDIEVAL & MEDIVO projects, a clean slate approach, mobility first architecture, network virtualization (VNet), INM, NetInf, ForMux, MEEM, GP & AM, QoS support, network resource provisioning, IntServ, RSVP, DiffServ, CoS, aggregated resource provisioning, SICAP, MARA, Emerging approach for resource over-provisioning, example use case architecture for the 5G internet, integrating SDN/NFV for efficient resource control, control information repository, service admission control policies, network resource provisioning, control enforcement functions, network configurations, network operations. * Small cells for 5G Average spectral efficiency evolution, What are small cells? WiFi & Femto cells as candidate small-cell technologies, Capacity limits & achievable gains with densifications, gains with multi-antenna techniques, gains with small cells, Mobile data demand, approach & methodology, subscriber density projections, traffic demand projections, global mobile data traffic increase modelling, country level backhaul traffic projections, 2020 average spectrum requirement, Small cell challenges, backhaul, spectrum, automation. * Cooperation for next generation wireless networks Cooperative diversity & relaying strategies, Cooperative ARQ & MAC protocols, NCCARQ & PRCSMA packet exchange, Physical layer impact on MAC protocol, NCCARQ overview, PHY layer impact, Performance evaluation, simulation scenario and results. * Mobile clouds; technology & services for future communications platforms Mobile cloud, software, hardware and networking resources, Mobile cloud enablers, mobile user domain, wireless technologies, WWAN WLAN and WPAN range, Bluetooth, IEEE.802.15.4, software stacks, infrared, near field communications (NFC), store & forward vs compute & forward, random/linear network coding. * Security for 5G communications Potential 5G architectures, Security issues & challenges in 5G, user equipment, mobile malware attacks, 5G mobile botnets, attacks on 4G networks, C-RNTI & packet sequence numbers based UE location tracking, false buffer status reports attacks, message insertion attacks, HeNB attacks, physical attacks, attacks on mobile operator's network, user data & identity attacks, DDoS attacks, amplification, HSS saturation, external IP networks.

COMPLETE RUBY PROGRAMMING TRAINING COURSE DESCRIPTION This course starts with a quick-start session and then explains the language in detail from the bottom up. Hands on sessions follow all the major sessions to reinforce the theory. WHAT WILL YOU LEARN * Read Ruby programs. * Write Ruby programs. * Debug Ruby programs. COMPLETE RUBY PROGRAMMING TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to program in Ruby. * Prerequisites: Software development fundamentals * Duration 3 days COMPLETE RUBY PROGRAMMING TRAINING COURSE CONTENTS * Introduction A tour of Ruby, Try Ruby, A suduko solver in Ruby. * The Structure and execution of Ruby Lexical structure, Syntactic structure, Files structure, Program encoding, Program execution. * Datatypes and objects Numbers, text, Arrays, Hashes, Ranges, Symbols, True, false, and nil, Objects. * Expressions and operators Literals and keyword literals, Variable references, Constant references, Method invocations, Assignments, Operators. * Statements and control structures Conditionals, loops, Iterators and enumerable objects, Blocks, Altering flow control, Exceptions and exception handling, BEGIN and END, Threads, fibres and continuations. * Methods, Procs, Lambdas and closures Defining simple methods, Method names, Methods and parentheses, Method arguments, Procs and lambdas, Closures, Method objects, Functional programming. * Classes and modules Defining a simple class, Method visibility: public, protected, privates, Subclassing and inheritance, Object creation and initialization, Modules, Loading and requiring modules, Singleton methods and Eigenclass, Method lookup, Constant lookup. * Reflection and metaprogramming Types, classes and modules, Evaluating strings and blocks, Variables and constants, Methods, Hooks, Tracing, ObjectSpace and GV, Custom control structures, Missing methods and missing constants, Dynamically creating methods, Alias chaining. * The Ruby platform Strings, Regular expressions, Numbers and Math, Dates and times, Collections, Files and directories, Input/output, Networking, Threads and concurrency. * The Ruby environment Invoking the Ruby interpreter, The Top-level environment, Practical extraction and reporting shortcuts, Calling the OS, Security.

DEFINITIVE SEGMENT ROUTING COURSE DESCRIPTION This Segment Routing (SR) training course is a comprehensive program designed to equip network professionals with the knowledge and skills needed to implement and manage SR in modern networking environments. Segment Routing is a cutting-edge network architecture that enhances network flexibility, scalability, and efficiency. This course offers in-depth coverage of SR principles, protocols, and practical implementation techniques. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. WHAT WILL YOU LEARN * Explain packet paths when implementing SLB. * Explain how Segment Routing works. * Explain the relationship between SR and MPLS. * Use SR for Traffic Engineering. * Troubleshoot Segment Routing. * Implement TI-LFA using Segment Routing DEFINITIVE SEGMENT ROUTING COURSE DETAILS * Who will benefit: This course is ideal for network engineers, architects, and administrators who want to stay up-to-date with the latest networking technologies and enhance their expertise in Segment Routing. * Prerequisites: Concise MPLS for engineers * Duration 3 days DEFINITIVE SEGMENT ROUTING COURSE CONTENTS * Introduction to Segment Routing (SR) What is SR? Source based routing, SPRING, history, segments, why SR? SR benefits.SR usage: Traffic Engineering, Shortest path, local protection. Relationship between SR and MPLS, SRv6. Hands on Investigating the base network. * Segment Routing architecture SR domains, SR paths, SR segments. Segment types. Segment IDs, combining segments, IGP extensions, control plane components. Hands on Configuring SR, exploring how SR works, * Segment Routing protocols SR-MPLS. MPLS label stack operations. Segment Routing Global Block (SRGB). SRLB. IS-IS and OSPF extensions for SR. Prefix segments, adjacency segments. SRGB/IGP interactions. Multidomain SR policies. SPF, Strict SPF. Hands on Analysing IGP SR extension operation. Investigating the SRGB. * Segment Routing Traffic Engineering RSVP-TE versus SR-TE. SR policies. Anycast and binding SIDs. SR flexible algorithm flex-algo, Performance measurement delay. Hands on Optimising network paths for various applications. * SR integration with 'older' technologies MPLS and LDP integration with SR. Hands on Integration. * Topology Independent Loop Free Alternative Classic LFA and IP/MPLS protection mechanisms. TI-LFA protection options. Hands on TI-LFA operation with SR and LDP traffic. * Scenarios SDN. Managing SR with SR controllers. Analyse, optimise, automate. Network slicing. * BGP peering segments Path Computation Elements, BGP Link State. BGP prefix segments, BGP peer segments. Egress peer engineering. SR enabled VPNs. Hands onBGP segment routing. * Troubleshooting Segment Routing IP toolkit: ping and traceroute. MPLS toolkit: MPLS ping, MPLS echo request/reply, MPLS ping, MPLS traceroute and path discovery. Router show commands. Hands on Used throughout the course during exercises. * SRv6 Note this is an optional extra day. See our one day SRv6 course for details. IPv6 headers review, routing headers, IPv6 segment, SRv6 segment Identifiers. IPv6 Segment Routing Header. SRH procedures. Hands on Configuring SRv6, Analysing SRv6 operation.

SIP TRAINING COURSE DESCRIPTION A hands on course covering IP telephony with SIP. The course starts with a brief review of knowledge students should already possess including RTP and RTCP. The main focus is on SIP though, progressing from what SIP is through SIP signalling, call processing and architectures, moving onto more advanced issues including security, multimedia, and interoperability. Hands-on practicals follow each major theory session. WHAT WILL YOU LEARN * Explain how SIP works. * Analyse SIP packets. * Deploy SIP IP telephony solutions. * Integrate SIP with other telephony solutions. SIP TRAINING COURSE DETAILS * Who will benefit: Technical staff working with SIP. * Prerequisites: Definitive VoIP for engineers * Duration 3 days SIP TRAINING COURSE CONTENTS * VoIP review What is VoIP? Brief review of IP, Brief review of telephones and voice. RTP, RTCP, mixers and translators. Hands on Analysing RTP packets. * What is SIP? Why SIP? SIP history, SIP standards, SIP capabilities, key services, how SIP works, and a basic SIP call. Hands on Peer to peer SIP. * SIP messages SIP sessions, SIP flows, Message structure, INVITE, ACK, BYE, CANCEL, OPTIONS, REGISTER. Extension methods. Response codes. SIP call flows. Hands on Analysing SIP packets. * SIP architectures UA client, UA server, Proxy servers, Redirect servers, registrars. SIP phones, gateways, application servers, and other products. Stateful and stateless servers. Various call scenarios. Hands on SIP proxies. * SIP addressing URLs, SIP addresses, registration, Location and Directory servers. Address tracking. Hands on SIP and DNS. * Supplementary services SIP signalling, signalling compression, Call hold, Call forwarding, Home and away scenarios, transfers, conferences, call control. Hands on Analysing SIP supplementary services. * SDP What is SDP? Multimedia, multimedia session announcement, invitation and others. Relationship with SIP. Hands on Video conferencing with SIP. * SIP security Access control, Authentication, encryption, firewalls. Hands on SIP authentication. * Interoperability Inter working with PSTN, ISUP to SIP mapping, SIP and 3G, SIP-T, SIP and SIGTRAN. SIP and H323. Hands on SIP and gateways. * SIP mobility Terminal mobility, service mobility, personal mobility, Mobile IP, SIP signalling flows in 3G.

4G & 5G ROAMING SCENARIOS & PROCEDURES COURSE DESCRIPTION This course is designed to explain the roaming procedures of modern mobile networks, based on the GSMA roaming specification the course explains all scenarios where a mobile subscriber may find themselves whilst visiting a preferred mobile network partner. Interconnection between MNOs and the use of GRX & IPX as an interworking process. The course will work through the registration & authentication procedure, download of the user profile, the APN configuration & DIAMETER process to verify user authenticity. VoLTE roaming and IMS registration procedures for voice support & SMS delivery will be discussed and explained. WHAT WILL YOU LEARN * Architecture Models * Technical requirements for interfaces - 4G Roaming Scenarios * Technical requirements & recommendations for services * Other Technical Requirements & Recommendations * Technical Requirements for QoS support * Technical Requirements & Recommendations for Interfaces - 5G Scenarios * Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC * Technical Requirements & Recommendations for Services * Other Technical Requirements & Recommendations 4G & 5G ROAMING SCENARIOS & PROCEDURES COURSE DETAILS * Who will benefit: Those working in mobile networks. * Prerequisites: None. * Duration 3 days 4G & 5G ROAMING SCENARIOS & PROCEDURES COURSE CONTENTS ARCHITECTURE MODELS 4G Evolved Packet System 5G Core Network SGs Interface for CSFB& SMS over SGs TECHNICAL REQUIREMENTS FOR INTERFACES - 4G ROAMING SCENARIOS General requirements for inter-PLMN interfaces Stream Control Transmission Protocol (SCTP) IAMETER S8 Interface 1. SGW selection 2. PGW selection GTP Transport Layer engineering S9 interface 1. Implementation requirements 2. Guidelines for DIAMETER over S9 S6a & S6d interface Gy interface 1. Guidelines for DIAMETER over Gy Legacy interworking scenarios 1. VPLMN has not implemented LTE 2. HPLMN has not implemented LTE Co-existence scenarios 1. Possible scenarios 1. 2G/3G roaming agreement only 2. 2G/3G LTE roaming agreement 3. LTE roaming registrations Consequences of different APN approaches when roaming 1. Guidance regarding the APN approach when roaming Inter-RAT handover 1. Handover & access restrictions to/from 2G/3G & LTE (Active mode) 2. Access restriction for 2G/3G and/or LTE (Idle mode) 3. Handover of PDN Connections between GERAN/UTRAN & LTE Handover to/from non-3GPP accesses & LTE Bandwidth considerations ARP considerations at handover from LTE to 2G/3G TECH REQUIREMENTS & RECOMMENDATIONS FOR SERVICES SMS 1. SMS over SGs Voice 1. CSFB 2. Roaming retry for CSFB 3. Roaming Forwarding for CSFB 4. Coexistence of Roaming Forwarding & Roaming Retry 5. Recommended procedures IMS Voice Roaming Architecture OTHER TECHNICAL REQUIREMENTS & RECOMMENDATIONS Access Control Addressing APN for IMS based services 1. IMS Well Known APN APN for Home Operator Services 1. Gateway Selection 2. Inter-PLMN roaming handover 3. Data off related functionality Emergency Services 1. Emergency PDN connectivity Emergency Call indicator Security 1. GTP Security 2. DIAMETER Security DIAMTER Roaming hubbing Default APN E-UTRA NR Dual Connectivity with EPC 1. GW Selection for E-UTRA-NR Dual Connectivity TAC/LAC Restriction Guidelines TECHNICAL REQUIREMENTS FOR QOS SUPPORT QoS parameters definition QoS Management in the Home Routed architecture QoS control for IMS APN in the S8HR architecture Support of QoS in GRX/IPX QoS Control in Local Breakout architecture TECHNICAL REQUIREMENTS & RECOMMENDATIONS FOR INTERFACES - 5G SCENARIOS 1. General requirements for inter-PLMN interfaces 2. Transport protocol - TCP/IP 3. Serialisation protocol - JSON 4. Interface Definition language - OpenAPI 5. Application Protocol - HTTP2 Inter-PLMN (N32) Interface 1. N32c 2. N32f 3. ALS & IPX HTTP Proxy SMF & UPF in HPLMN & VPLMN Requirements related to Service Based Architecture Naming, addressing & routing for 5G SA roaming 1. SEPP load distribution 2. SEPP administration, naming convention & routing 3. SEPP HTTP redirections TECHNICAL REQUIREMENTS & RECOMMENDATIONS FOR INTERWORKING & COEXISTENCE WITH E-UTRAN & EPC Interworking scenarios Coexistence scenarios Inter-RAT Handover Handover & Access restriction between 5GC & EPC TECHNICAL REQUIREMENTS & RECOMMENDATIONS FOR SERVICES Network slicing Voice, Video & Messaging Location support UE Route Selection Policy OTHER TECHNICAL REQUIREMENTS & RECOMMENDATIONS Access control IP Addressing DNN for IMS based services Emergency PDU Session Emergency Services Fallback Security Steering of Roaming in 5GS TECHNICAL REQUIREMENTS FOR QOS SUPPORT 5G QoS model 5G QoS profile QoS Control

SOFTWARE DEVELOPMENT TRAINING COURSE DESCRIPTION This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-361, and build an understanding of these topics: Core programming, Object-Oriented programming, general software development, web applications, desktop applications, and databases. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. WHAT WILL YOU LEARN * Describe core programming. * Explain Object Oriented programming. * Describe general software development. * Describe Web applications. * Describe desktop applications. * Explain how databases work. SOFTWARE DEVELOPMENT TRAINING COURSE DETAILS * Who will benefit: Anyone looking to learn the fundamentals of software. * Prerequisites: None. * Duration 3 days SOFTWARE DEVELOPMENT TRAINING COURSE CONTENTS * Core programming * Computer storage and data types How a computer stores programs and the instructions in computer memory, memory stacks and heaps, memory size requirements for the various data storage types, numeric data and textual data. * Computer decision structures Various decision structures used in all computer programming languages; If decision structures; multiple decision structures, such as If…Else and switch/Select Case; reading flowcharts; decision tables; evaluating expressions. * Handling repetition For loops, While loops, Do...While loops and recursion. * Understand error handling Structured exception handling. * Object-oriented programming * Classes Properties, methods, events and constructors; how to create a class; how to use classes in code. * Inheritance Inheriting the functionality of a base class into a derived class. * Polymorphism Extending the functionality in a class after inheriting from a base class, overriding methods in the derived class. * Encapsulation Creating classes that hide their implementation details while still allowing access to the required functionality through the interface, access modifiers. * General software development * Application life cycle management Phases of application life cycle management, software testing. * Interpret application specifications Application specifications, translating them into prototypes, code, select appropriate application type and components. * Algorithms and data structures Arrays, stacks, queues, linked lists and sorting algorithms; performance implications of various data structures; choosing the right data structure. * Web applications * Web page development HTML, CSS, JavaScript. * ASP.NET web application development Page life cycle, event model, state management, client-side versus server-side programming. * Web hosting Creating virtual directories and websites, deploying web applications, understanding the role of Internet Information Services. * Web services Web services that will be consumed by client applications, accessing web services from a client application, SOAP, WSDL. * Desktop applications * Windows apps UI design guideline categories, characteristics and capabilities of Store Apps, identify gestures. * Console-based applications Characteristics and capabilities of console- based applications. * Windows Services Characteristics and capabilities of Windows Services. * Databases * Relational database management systems Characteristics and capabilities of database products, database design, ERDs, normalisation concepts. * Database query methods SQL, creating and accessing stored procedures, updating and selecting data. * Database connection methods Connecting to various types of data stores, such as flat file; XML file; in-memory object; resource optimisation.

LTE ARCHITECTURE AND PROTOCOLS COURSE DESCRIPTION This course provides a comprehensive tour of the LTE architecture along with services provided and the protocols used. WHAT WILL YOU LEARN * Describe the overall architecture of LTE. * Explain the information flows through LTE. * Describe the LTE security. * Describe LTE mobility management. * Recognise the next steps for LTE. LTE ARCHITECTURE AND PROTOCOLS COURSE DETAILS * Who will benefit: Anyone working with LTE. * Prerequisites: Mobile communications demystified * Duration 3 days LTE ARCHITECTURE AND PROTOCOLS COURSE CONTENTS * Introduction History, LTE key features. The 4G ITU process. The LTE 3GPP specifications. Specifications. * System Architecture LTE hardware architecture. UE architecture and capabilities. E-UTRAN and eNB. EPC, MME functions, SGW, PGW and PCRF. System interfaces and protocol stacks. Example information flows. Dedicated and default bearers. EMM, ECM, RRC state diagrams. * Radio transmission and reception OFDMA, SC-FDMA, MIMO antennas. Air interface protocol stack. Logical, transport and physical channels. Frame and slot structure, the resource grid. Resource element mapping of the physical channels and signals. Cell acquisition, data transmission and random access. MAC, RLC, PDCP protocols. LTE spectrum allocation. * Power-on procedures Network and cell selection. RRC connection establishment. Attach procedure, including IP address allocation and default bearer activation. LTE detach procedure. * Security in LTE networks LTE security features, identity confidentiality, ciphering and integrity protection. Architecture of network access security in LTE. Secure key hierarchy. Authentication and key agreement procedure. Security mode command procedure. Network domain security architecture. Security associations using IKE and IPSec. * Mobility management RRC_IDLE, RRC_CONNECTED. Cell reselection, tracking area updates. Measurement reporting. X2 and S1 based handovers. Interoperation with UMTS, GSM and non-3GPP technologies such as cdma2000. * QoS, policy control and charging QoS in LTE, EPS bearers, service data flows and packet flows. The architecture and signalling procedures for policy and charging control. Data transport using GPRS, differentiated services and MPLS. Offline and online charging in LTE. * Delivery of voice and text messages over LTE Difficulties and solutions for Voice over LTE. Architecture and call setup procedures for circuit switched fallback. Architecture, protocols and call setup procedures in IP multimedia subsystem. * Enhancements in release 9 LTE location services. Multimedia broadcast / multicast service and MBSFN. Cell selection, commercial mobile alert service. * LTE Advanced and release 10 Impact of carrier aggregation on LTE air interface. Enhanced MIMO processing on uplink and downlink. Relaying. Release 11 and beyond. * OAM and self organising networks Operation, administration, maintenance and provisioning for LTE. Self-configuration of base station parameters. Fractional frequency re-use, inter-cell interference co-ordination. Self-optimisation of base station procedures. Self-healing to detect and recover from faults.