• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

129 Courses in London

Intermediate UX Design Bootcamp

5.0(5)

By UX Academy

We are excited to introduce to you our 5 Day In-Person Training for Intermediate & Advanced Level. The goal of the training is deep learning about Design Thinking, UX Maturity, and enhancing your UX knowledge. The five-days training offers a path to learn more about UX teamwork, collaboration, and communication. The maximum size of the class is 6 people to ensure interaction between the students and the teacher.

Intermediate UX Design Bootcamp
Delivered In-Person in LondonFlexible Dates
£2,500

Oracle database administration

5.0(3)

By Systems & Network Training

Oracle Database 12c Admin training course description This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. What will you learn Administer an Oracle database instance. Monitor an Oracle database. Configure the Oracle network environment. Create and manage database storage structures. Manage users, profiles, privileges and roles. Manage undo data and temporary segments. Monitor and resolve lock conflicts. Maintain database security. Implement database auditing. Monitor the performance of the Database. Load and unload data. Use the job scheduler. Configure a database for backup and recovery. Oracle Database 12c Admin training course details Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. Duration 5 days Oracle Database 12c Admin training course contents Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

Oracle database administration
Delivered in Internationally or OnlineFlexible Dates
£2,797

Interior Design Visualization Professional Certificate

By ATL Autocad Training London

Who is this course for? The Interior Design Visualization Professional Certificate is perfect for individuals aspiring to launch their interior design business. Learn essential skills in AutoCAD, SketchUp, Photoshop, InDesign, Vray, and 3ds Max. If you prefer to book over the phone, simply call 02077202581. Click here for more info: Website Duration: 120 hours. 1-on-1 Training. When can I book: (Choose your preferred day and time once a week). Monday to Saturday: 9 am - 7 pm (Flexible timing with advance booking). Module 1: Introduction to Interior Design Visualization (4 hours) Understanding the Significance of Visualization in Interior Design Familiarity with Software Used: AutoCAD, 3ds Max, SketchUp, V-Ray, Photoshop, and InDesign Workflow Overview and Best Practices for Interior Design Visualization Module 2: AutoCAD for Interior Design (16 hours) Basics of AutoCAD and Its Interface Utilizing Drawing and Editing Tools for Accurate Floor Plans and Elevations Creating and Modifying 2D and 3D Objects Application of Layers, Line Types, and Hatches for Clarity Precision in Measurements and Annotations Module 3: 3ds Max for Interior Design (16 hours) Introduction to 3ds Max Interface Furniture, Fixtures, and Architectural Element Modeling Techniques Material and Texture Application for Realism Lighting Strategies for Interior Scenes V-Ray Introduction for High-Quality Rendering Scene Setup and Camera Placement for Effective Visualization Module 4: SketchUp for Interior Design (12 hours) Introduction to SketchUp and Its Interface Creating 3D Models of Interiors, Furniture, and Objects Enhancing Visuals with Materials and Textures Efficient Use of SketchUp Plugins and Extensions Seamless File Exchange Between SketchUp and Other Software Module 5: V-Ray for Interior Design Rendering (12 hours) Principles of Photorealistic Rendering Installation and Setup of V-Ray in 3ds Max and SketchUp Configuring V-Ray Settings for Optimal Rendering Advanced Material Application for Realistic Surfaces Lighting Techniques for Atmosphere and Mood Creation Module 6: Photoshop for Interior Design Visualization (12 hours) Introduction to Photoshop Interface Image Enhancement: Color, Contrast, and Saturation Adjustments Post-Processing Effects for a Polished Look Integration of 2D Elements like Textures and Patterns Creating Composite Images Using Multiple Render Passes Module 7: InDesign for Portfolio Presentation (8 hours) Introduction to InDesign Interface Designing a Visually Appealing Portfolio Layout Effective Organization and Presentation of Interior Design Visualizations Integration of Images, Text, and Graphics for Cohesive Portfolios Portfolio Export for Print and Digital Distribution Module 8: Project Work and Final Presentation (4 hours) Application of Learned Skills on a Comprehensive Interior Design Visualization Project Refinement and Polish under Instructor's Guidance Preparation and Delivery of Final Presentation Showcasing the Project Note: The course outline encompasses 80 instructional hours. The actual duration may vary based on class pace and additional practice and project work. Final Project (With Full-Time Tutor Assistance): Students will develop and present their best work in a final presentation at the end of the course. Projects are to be submitted via email to training@realanimationworks.com, and timely submission is crucial to avoid delays or interruption of sessions. Please be aware: Failure to attend a session or notify us of absence within 48 hours of the session time results in session loss and full class fee charges due to the personalized nature of the sessions. Students can request breaks or extended pauses by providing written notice through email. Benifits and Jobs after this course: Master Design Tools: Proficiency in AutoCAD, 3ds Max, SketchUp, V-Ray, Photoshop, and InDesign for interior design visualizations. Advanced 3D Skills: Expertise in detailed 3D modeling, realistic rendering, and precise lighting techniques. Portfolio Development: Create compelling portfolios using InDesign, blending images and text professionally. Career Opportunities: Interior Visualization Specialist 3D Modeler Architectural Visualizer Interior Design Consultant Digital Content Creator Freelance Interior Visualizer Virtual Reality Designer Educator/Trainer Certificate Program in Interior Design Visualization: Maintain a dedicated notebook for effective organization of study notes. Schedule makeup sessions for missed coursework, subject to available time slots. Keep detailed records and create a specialized design folder to monitor progress and nurture creative ideas. Allocate focused time for self-guided practice and project work. Receive certification from our esteemed professional design team upon successful completion of the program. Post-Program Achievements: Upon completion of the certificate program, you will: Gain confidence in software proficiency and a strong understanding of underlying principles. Demonstrate the ability to create high-quality visual representations for architectural and interior design projects. Feel well-prepared for career opportunities, backed by your software expertise. Ongoing Support: We are pleased to offer lifelong complimentary email and phone support, ensuring swift assistance with any inquiries or challenges you may face. Software Access: Access to necessary software is available via download from the developer's website or at student-friendly rates. Please note that student software usage is limited to non-commercial projects. Payment Flexibility: Choose from various payment options including internet bank transfers, credit cards, debit cards, and PayPal. Additionally, we offer installment plans tailored to our students' needs.

Interior Design Visualization Professional Certificate
Delivered in London or OnlineFlexible Dates
£2,820

Security+

5.0(3)

By Systems & Network Training

Security+ training course description A hands on course aimed at getting delegates successfully through the CompTia Security+ examination. What will you learn Explain general security concepts. Describe the security concepts in communications. Describe how to secure an infrastructure. Recognise the role of cryptography. Describe operational/organisational security. Security+ training course details Who will benefit: Those wishing to pass the Security+ exam. Prerequisites: TCP/IP foundation for engineers Duration 5 days Security+ training course contents General security concepts Non-essential services and protocols. Access control: MAC, DAC, RBAC. Security attacks: DOS, DDOS, back doors, spoofing, man in the middle, replay, hijacking, weak keys, social engineering, mathematical, password guessing, brute force, dictionary, software exploitation. Authentication: Kerberos, CHAP, certificates, usernames/ passwords, tokens, biometrics. Malicious code: Viruses, trojan horses, logic bombs, worms. Auditing, logging, scanning. Communication security Remote access: 802.1x, VPNs, L2TP, PPTP, IPsec, RADIUS, TACACS, SSH. Email: S/MIME, PGP, spam, hoaxes. Internet: SSL, TLS, HTTPS, IM, packet sniffing, privacy, Javascript, ActiveX, buffer overflows, cookies, signed applets, CGI, SMTP relay. LDAP. sftp, anon ftp, file sharing, sniffing, 8.3 names. Wireless: WTLS, 802.11, 802.11x, WEP/WAP. Infrastructure security Firewalls, routers, switches, wireless, modems, RAS, PBX, VPN, IDS, networking monitoring, workstations, servers, mobile devices. Media security: Coax, UTP, STP, fibre. Removable media. Topologies: Security zones, DMZ, Intranet, Extranet, VLANs, NAT, Tunnelling. IDS: Active/ passive, network/host based, honey pots, incident response. Security baselines: Hardening OS/NOS, networks and applications. Cryptography basics Integrity, confidentiality, access control, authentication, non-repudiation. Standards and protocols. Hashing, symmetric, asymmetric. PKI: Certificates, policies, practice statements, revocation, trust models. Key management and certificate lifecycles. Storage: h/w, s/w, private key protection. Escrow, expiration, revocation, suspension, recovery, destruction, key usage. Operational/Organisation security Physical security: Access control, social engineering, environment. Disaster recovery: Backups, secure disaster recovery plans. Business continuity: Utilities, high availability, backups. Security policies: AU, due care, privacy, separation of duties, need to know, password management, SLAs, disposal, destruction, HR policies. Incident response policy. Privilege management: Users, groups, roles, single sign on, centralised/decentralised. Auditing. Forensics: Chain of custody, preserving and collecting evidence. Identifying risks: Assets, risks, threats, vulnerabilities. Role of education/training. Security documentation.

Security+
Delivered in Internationally or OnlineFlexible Dates
£2,797

Linux engineer certification 1 (LPIC-2)

5.0(3)

By Systems & Network Training

Linux engineer certification training course description LPIC-2 is the second certification in LPI's multi level professional certification program. This course teaches the skills necessary to pass the LPI 201 exam; the first of two LPIC-2 exams. Specifically, the course covers the administration of Linux systems in small to medium sized mixed networks. What will you learn Perform advanced administration tasks. Perform advanced file system administration. Linux engineer certification training course details Who will benefit: Linux administrators. Prerequisites: Linux system administration (LPIC-1) Duration 5 days Linux engineer certification fundamentals training course contents Part I The LPI 201 Exam Starting a System The Linux Boot Process, Firmware Startup, BIOS Startup, UEFI Startup, Linux Bootloaders, GRUB Legacy, GRUB 2, Alternative Bootloaders, Secure Bootloaders, Process Initialization, SysV Method, systemd Method, Upstart Method, System Recovery, Kernel Failures, Root Drive Failure. Maintaining the System Fluid Messaging, Static Messaging, System backups, Backup Strategies, Performing Backups, Installing Programs from Source, Obtaining and unpacking Installation Files, Compiling Programs, Resource Usage: Managing, measuring, predicting and troubleshooting. Mastering the Kernel What Is the Kernel? Kernel Features, Parts of the Kernel, Kernel Versions, Obtaining Source Code, Creating the Configuration File, Compiling and Installing the Kernel, Compiling and Installing Modules, Creating an Initial RAM Disk, Booting the New Kernel, Creating a Kernel Package, Maintaining the Kernel, Working with Module Files, Module Commands, Working with Hardware, Automatically Detecting Hardware, Troubleshooting the Kernel. Managing the Filesystem The Linux Filesystem, Filesystem Structures, Filesystem Types, Making Filesystems, Attaching Filesystems, Memory-Based Linux Filesystems, the Btrfs Filesystem, Btrfs Subvolumes, Btrfs Snapshots, Optical Filesystems, Swap Filesystems, Network-Based Filesystems, Auto-Mounting, Encrypted Filesystems, Maintaining Linux Filesystems, Adjusting a Filesystem, Checking and Repairing a Filesystem, SMART. Administering Advanced Storage Devices Configuring RAID, Implementing RAID on Linux, Managing a RAID Array, Adjusting Storage Devices, Looking at Drive Interface Concepts, Testing and Tuning Drives, Implementing iSCSI, Managing Logical Volumes, LVM, Creating Logical Volumes, Supporting Logical Volumes, Understanding the Device Mapper. Navigating Network Services Networking Basics, The Physical Layer, The Network Layer, The Transport Layer, The Application Layer, Configuring Network Features, Network Configuration Files, Graphical Tools, Command-Line Tools, Basic Network Troubleshooting, Checking the Log Files, the ARP Cache, Sending Test Packets, Testing Network Routes, Testing Client/Server Connectivity, Finding Host Information, Network Security, Advanced Network Troubleshooting, Viewing Open Network Connections, Viewing Network Statistics, Scanning the Network, Capturing Network Traffic.

Linux engineer certification 1 (LPIC-2)
Delivered in Internationally or OnlineFlexible Dates
£2,797

Concise Mikrotik routers for engineers

5.0(3)

By Systems & Network Training

Mikrotik routers training course description A fast paced practical hands on introduction to Mikrotik routers concentrating on basic product knowledge needed for the real world. Starts with the basics of accessing the routers through configuring static routes, RIP and OSPF, ending with firewalls. Hands on sessions follow all the major chapters. What will you learn Use Winbox. Use the Mikrotik command line. Perform basic troubleshooting. Configure Interfaces, RIP and OSPF. Perform housekeeping tasks such as: - save and load configurations - upgrade the OS - recover lost passwords Mikrotik routers training course details Who will benefit: Anyone who will be working with Mikrotik routers. Prerequisites: TCP/IP foundation for engineers Duration 2 days Mikrotik routers training course content Mikrotik routers RouterOS, RouterBoard. System resources. Getting started Accessing the router, Winbox, Webfig, Quickset. telnet. The command line interface Contexts, online help, basic troubleshooting. Configuring Interfaces Basics, Enabling interfaces. Ethernet, loopback interfaces. Adding IP addresses. Static routes Why use static routes? Configuring static routes, default routes. Configuring RIP How RIP works, configuration, troubleshooting. OSPF Configuration and troubleshooting. Housekeeping Configuration management, offline editing and FTP usage. RouterOS upgrades. Packages. Bypassing passwords. Other functions DHCP server. Firewall Connections, chains, actions, filters.

Concise Mikrotik routers for engineers
Delivered in Internationally or OnlineFlexible Dates
£2,477

Essential Bluetooth

5.0(3)

By Systems & Network Training

Bluetooth training course description Bluetooth is used by many kids these days but is probably under-utilised in business environments. This hands on training course provides an overview of what Bluetooth is, how it works, what it can be used for and how to configure it on different devices. What will you learn Explain what Bluetooth is. Describe the Bluetooth protocol stack. Recognise the applications of Bluetooth. Configure Bluetooth. Bluetooth training course details Who will benefit: Anyone who needs to know more about Bluetooth. Prerequisites: None. Duration 2 days Bluetooth training course contents Classic Bluetooth Bluetooth overview Basics, standards, competing technologies. Bluetooth radio RF bands, power losses, frequency hopping. Bluetooth modulation PSK, DPSK, DPQSK. Bluetooth data transfer FH, TDD, FDMA, ACL, SCO, Bluetooth packets. Making connections Piconets, Scatternets, Pairing The protocol stack Baseband, Link Manager, L2CAP, SDP, GAP, RFCOMM. Profiles FTP, DUN, LAN, Synch, HDP, GOEP/OBEX etc. Security Authentication, authorisation, encryption, risks. Bluetooth Low Energy Introduction Bluetooth Smart and Bluetooth Smart Ready. BLE device types Design goals, terminology and core concepts. BLE usage models Presence detection, data broadcasting connectionless models, gateways. BLE architecture Controller, host, applications and stack splits. BLE protocol stack Link layer, HCI, L2CAP. BLE profiles GAP roles, models, procedures, security modes, data advertising. BLE security Pairing, bonding, data signing BLE applications Devices, services, profiles, peripherals

Essential Bluetooth
Delivered in Internationally or OnlineFlexible Dates
£2,477

Concise Cisco routing

5.0(3)

By Systems & Network Training

Concise Cisco routers course description A fast paced practical hands on introduction to Cisco routers concentrating on basic product knowledge needed for the real world. Starts with the basics of routing through configuring static routes, RIP, OSPF, and EIGRP ending with access lists. Hands on sessions follow all the major chapters with a major practical at the end to reinforce all that was learnt in the course. What will you learn Use the Cisco setup script. Use the Cisco command line. Perform basic troubleshooting. Configure - Interfaces - RIP, IGRP - OSPF, EIGRP Concise Cisco routers course details Who will benefit: Anyone who will be working with Cisco routers. In particular: Network Administrators, Field engineers, Network support personnel Prerequisites: None, although a knowledge of the TCP/IP protocols would be advantageous. Duration 3 days Concise Cisco routers course content Basics of routing What are routers? Network protocols, Routing protocols. The Cisco routers Router models, The IOS, DRAM, SRAM, NVRAM, Flash, ROM and boot flash. Getting started Accessing the router, installing a Cisco, using the setup script. The command line interface User and privilege modes, online help show, debug, basic troubleshooting Configuring Ciscos The configuration editor, Global, major and sub commands, enable, secret and other passwords, telnet. Miscellaneous exercises Buffered logging, web access, CDP… Subnetting IP addressing rules. The need for subnetting, subnet masks, Calculating network numbers. Configuring Interfaces Basics, Ethernet, Serial lines, PPP, DCE, loopback interfaces. Static routes Why use static routes? Configuring static routes, default routes. Configuring RIP and IGRP How they work, configuration, troubleshooting. OSPF Configuration and troubleshooting. EIGRP Configuration and troubleshooting. Housekeeping Configuration management, offline editing and TFTP usage. Cisco boot sequence, IOS upgrades. Bypassing Cisco passwords. Access lists What are access lists? General rules, basic and extended IP access lists. Putting it all together A series of exercises based around, installs, adds, moves, changes, upgrades and troubleshootin

Concise Cisco routing
Delivered in Internationally or OnlineFlexible Dates
£2,367

PROFESSIONAL TRAINING: MODULE 4 – CONSTRUCTION AND SEWING OF LEATHER GOODS GUSSETS, FEATURES AND COMPONENTS

5.0(52)

By The London Leather Workshop

This course is not suitable for total beginners. To attend this course, you must already have some experience with industrial machines and be able to operate and set up a walking foot independently, or have attended our MODULE 3 – INDUSTRIAL MACHINE TRAINING. UNDERSTANDING THE CONSTRUCTION AND SEWING OF LEATHER GOODS: GUSSETS, FEATURES AND COMPONENTS This is the forth module of a series designed to provide thorough, professional training in leatherworking, leather sewing, bag and accessory making. Each module has been carefully designed to equip individuals with key skills for starting a career in this sector, broadening their industry knowledge, or embarking on their own journey with solid foundational skills. Through this lesson, you will learn how to construct, sew, and finish some of the most challenging parts of leather goods making, such as straps, handles, zips, pockets, and more. By working on various shapes and structures, you will gain insights into the technical aspects of leatherworking, including preparation, marking, cutting, gluing, reinforcing, skiving, and more. At the end of the lesson, you will have experienced a wide range of techniques, worked with numerous tools, used leatherworking sewing machines, and produced samples to take home with you. By the end of the lesson, you will have: – Received an introduction to leather preparation, pattern placement, and leather marking – Received an overview of leather cutting, gluing, reinforcing and skiving – Learned how to sew and finish zips on leather – Learned how to cut, assemble, and sew simple straps and handles – Gained knowledge on incorporating two types of lining in your project – Learned how to assemble and sew simple gussets – Learned how to construct simple and zipped pockets Included in the course: You will receive useful paper handouts containing: – A list of tools and materials used during the lesson(s), with descriptions and usage instructions – A list of recommended suppliers for leather and fittings, both in London and online – A glossary containing information about leather goods components Find all modules here: https://the-london-leather-workshop.cademy.co.uk/

PROFESSIONAL TRAINING: MODULE 4 – CONSTRUCTION AND SEWING OF LEATHER GOODS GUSSETS, FEATURES AND COMPONENTS
Delivered In-Person in London + more
£225 to £264

Oracle SQL foundation

5.0(3)

By Systems & Network Training

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.

Oracle SQL foundation
Delivered in Internationally or OnlineFlexible Dates
£2,367
1...34567...13