692 Courses in London

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Francesca Wyllie (BA Hons Fine Art) has an amazing north-facing art studio at El Retiro in Andalucia, which was purpose-built to accommodate painting groups. Bespoke painting and sculpture workshops can be arranged or Francesca can travel locally to guide you in your own studios or locations.

Python Unittest Course Summary. Testing plays a major role in software development. This course will explain Python Unit Testing using the unittest built-in module. We'll cover issues before going to the production itself and the basics of testing in Python. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Unittest Certification Duration: 1-Day, 10am-5pm Unittest topics UnitTest Framework - Home UnitTest Framework - Overview UnitTest - Framework UnitTest - API UnitTest - Assertion UnitTest - Test Discovery UnitTest - Skip Test UnitTest - Exceptions Test UnitTest - Time Test UnitTest - Unittest2 UnitTest - Signal Handling UnitTest - Doctest UnitTest - Doctest API UnitTest - Py.test Module Nose Testing - Framework Nose Testing - Tools Included with Python Unittest Course Python Unittest Certificate on completion Python Unittest Videos Python Unittest Notes Python Unittest Examples Practical Python Unittest exercises Book Unittest Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Java Threads Course Duration: 1 Day Who would find this course useful? Java coders Level: Not quite basics level. It specifically concentrates on Threads Principles (Threads) in Java. Download: Download Java JDK and Eclipse IDE. For classroom courses: Bring your own device. Java Threads Course description General Threads Concepts Java Threads Course Description General Threads Concepts Multithreading Cycle of a Thread Create a Thread by Implementing a Runnable Interface Create a Thread by Extending a Thread Class Major thread operations Processes and Threads, Thread Objects Thread Methods getName, getId, setName, etc Pausing Execution with Sleep Interrupts, Joins Thread Priorities Thread Pools Executors, Executor Interfaces, Thread Pools, Fork/Join Synchronozation What is thread synchronization? Thread Interference, Memory Consistency Errors, Synchronized Methods, Lock Objects, Intrinsic Locks and Synchronization, Handling interthread communication, Handling thread deadlock, Liveness, Starvation and Livelock, Atomic Access. Concurrent Collections Guarded Blocks, Immutable Objects. Strategy for Defining Immutable Objects, High Level Concurrency Objects, Java Threads Course, 1 Day What is included PCWorkshops Course Certificate on completion Java Threads Course Notes Java Threads Code Examples Practical exercises, Java Course Revision work After the course: 1-Hour personalised online revision session About us Our experienced trainers are award winners. More about us FAQ's Client Comments

dvanced Course This MS Project Advanced course is an intensive, hands-on, one-day training course, concentrating on complex calendars, complex costs, multiple baselines, multiple projects and other advanced MS Project features. This is a one day course, one a one-to-one basis, attending to individual questions and issues. Group bookings could be requested

Java OOP Course Duration: 1 Day Who would find this course useful? This is useful if you have some coding skills already. This course is fast paced, not quite basics level. It specifically concentrates on Object Oriented Programming Principles (OOP) in Java. Download: Download Java JDK and Eclipse IDE. For classroom courses: Bring your own device. Java OOP Course description Session 1: General Concepts Revision: Scanner, Input from stdin, Print to stdout. Descision, While and For Loops Arrays Session 2: Packages, Methods, Encapsulation Using packages Creating and calling methods, parameters, method overloading Data protection through encapsulation Session 3: Classes, object construction Inheritance, method overload and override Polymorphism or runtime binding Session 4: Constructors, parameterised constructors Create abstract classes and methods Create and use an interface Session 5: Use the access modifiers protected and the default (package-friendly) Create static variables, methods, and initialisers Create final classes, methods, and variables Session 6: Nested Classes, Local Classes, Anonymous Classes, and Lambda Expressions, Enum Types Nested and inner classes; A stack class. What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java OOP Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Java Bootcamp Course Summary. Learn all about Java Programming program thoroughly. From scratch to job-ready. 1 lesson per week for 12 weeks. Many Practical exercises. Practical project. Personalised, Max 4 people per course. PCWorkshops Certificate, Oracle Certification is assessment based Course Details How does it work Java bootcamp Structure: 1 weekly lesson for 12 weeks Plus practical: +-15 hours per week. Plus 1-1 Mentoring: additional between sessions Plus Practical Project: Upload and showcase your project Plus Practical Java Exercises: Java practical exercises per session Duration: 12 Weeks, one session per week Where: Online or Classroom Study level: From beginner to job-ready. Java Bootcamp Certification: PCWorkshops Java certificate Java Oracle certificate: OCP Where is the Java Bootcamp? Online: Instructor-led. Classroom: Request per email Materials Video Tutorials: Short and easy Java Coding Examples: All lessons are illustrated with code examples Java Manuals and Notes: In-depth reference materials Exercises: Weekly practical exercises Personalised 1-1 Mentoring 1-1 Mentoring: Arranged additionally Personalised: Dedicated expert Java mentor per student Success Guarantee: Ask your Java questions and work at your pace Practical Exercises Learn by doing: Excellent way to learn Java and re-inforce weekly lesson content Gain practical expertees: You will become fluent at coding Java with practice Practical Project Weekly exercises amalgamate into a great practical project Show case your project on Github Projects: Student may choose from a few given options, prioritise frontend, backend or full stack for their projects. Project requirements for Certification: To receive the PCWorkshops Programmer Java Certificate students need to work on a project and complete practicals. Uploading any one project of you choice, is necessary for the certificate. We evaluate practicals during the course of the bootcamp. Exclusion from projects: If you would like to be excluded from the project, then you mention that on the registration form. You may be excluded from the project, but this will not qualify you for any discount. In-work professionals: Some students attend because their employers want them to attend to upgrade their skills and they sometime apply to be excused from the projects, because they have limited time and they work already where they are involved in their professional projects. Previous project topics include: Movie theatre ticket sales Student Management System Hotel Booking System Bank Management Project E-commerce Product Sales Services quotation system Quiz app Food Ordering System Media Player Application Tic-Tac-Toe Game Part Time One full day per week: Fridays or Saturdays Learn and earn: Keep your job, earn your salary, get qualified in Java, then change Learn Java in your own time: Practice in your own time 1-1 Mentoring: Schedule this according to your own diary Payment Options Follow the booking link Arrange for installments Weekly Java bootcamp topics and other details Weekly Java lesson topic descriptions Overview of Java Fundamentals: Java Data Types, Variables: Primitive types; Characters; Boolean; Working with variables and its scope; Type conversion and casting; The String Class: Using the String class and String methods. Scanner Class: Getting user input. Java Operators and Expressions: Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. Decision Making: If statement; If - else statement; If- else if - else statement; Nested if - else; Switch Statements Using Loops: The while, do-while and the for loop; Enhanced for loop; Jump statements : break, continue; The return statement; Nesting loops. Using Methods Introduction of methods; Calling a Method. Introduction to Classes and Objects: Creating a Class; Declaring Member Variables; Creating an Object; Using an Object; Adding Instance variables; Encapsulation, getters and setters; Controlling accessibility; private, public and protected; Class Constructors; Parameterized Constructors; Inheritance. Override. Polymorphism. Abstraction. Interfaces and implementing interfaces. The dot operator, this keyword, the static keywords, the super keyword. Access modifiers: Learn Java Nested Classes, Inner Class Classes, Local Classes, Anonymous Classes, Lambda Expressions, Method References, When to Use: Nested Classes, Local Classes, Anonymous Classes, and Lambda Expressions, Enum Types Nested and inner classes; A stack class. Handling Exceptions Differentiate among checked exceptions, unchecked exceptions, and Errors Create a try-catch block and determine how exceptions alter normal program flow Describe the advantages of Exception handling Create and invoke a method that throws an exception Recognize common exception classes (such as NullPointerException, , ArithmeticException, ArrayIndexOutOfBoundsException, ClassCastException) Use try-catch and throw statements Use catch, multi-catch, and finally clauses Create custom exceptions and Auto-closeable resources Use Autoclose resources with a try-with-resources statement Test invariants by using assertions Java I/O Fundamentals Read and write data from the console Use BufferedReader, BufferedWriter, File, FileReader, FileWriter, FileInputStream, FileOutputStream, ObjectOutputStream, ObjectInputStream, and PrintWriter in the java.io package. Json Files Learn Java Arrays: Working with arrays, 2-d arrays, iterating arrays.Using the for-each loop with Java Arrays The Collection Interface This enables you to work with groups of objects; it is at the top of the collections hierarchy. The List Interface This extends Collection and an instance of List stores an ordered collection of elements. The Set This extends Collection to handle sets, which must contain unique elements. The SortedSet This extends Set to handle sorted sets. The Map This maps unique keys to values. Collections Streams and Filters Use java.util.Comparator and java.lang.Comparable interfaces Collections Streams and Filters Iterate using forEach methods of Streams and List Describe Stream interface and Stream pipeline Filter a collection by using lambda expressions Use method references with Streams Lambda Built-in Functional Interfaces Use the built-in interfaces included in the java.util.function package such as Predicate, Consumer, Function, and Supplier Develop code that uses primitive versions of functional interfaces Develop code that uses binary versions of functional interfaces Develop code that uses the UnaryOperator interface Java Stream API Develop code to extract data from an object using peek() and map() methods including primitive versions of the map() method Search for data by using search methods of the Stream classes including findFirst, findAny, anyMatch, allMatch, noneMatch Develop code that uses the Optional class Develop code that uses Stream data methods and calculation methods Sort a collection using Stream API Save results to a collection using the collect method and group/partition data using the Collectors class Use flatMap() methods in the Stream API Application Programming Interface (API) An Application Programming Interface (API) contains software building tools that facilitate interaction between systems. An API may be for a database system, operating system, computer hardware or a web-based system. Java File I/O (NIO.2) Use Path interface to operate on file and directory paths Use Files class to check, read, delete, copy, move, manage metadata of a file or directory Use Stream API with NIO.2 Working with Selected classes from the Java API Manipulate data using the StringBuilder class String methods Create and manipulate Strings Random Functions Math Class Use Date/Time API Create and manage date-based and time-based events including a combination of date and time into a single object using LocalDate, LocalTime, LocalDateTime, Instant, Period, and Duration Work with dates and times across timezones and manage changes resulting from daylight savings including Format date and times values Define and create and manage date-based and time-based events using Instant, Period, Duration, and TemporalUnit Localization Read and set the locale by using the Locale object Create and read a Properties file Build a resource bundle for each locale and load a resource bundle in an application Refer to the SQL 1-Day Course Relational Database Concepts: SQL Language Essentials: The SQL Select Statement SQL Conditions and the Where Clause: Greater and Less than, =, Not, Between, AND, OR, Like, Wildcards The SQL Order By Clause SQL Arithmetic Operations, Expression Queries SQL Column Aliases Limit/Top, Distinct Working with Null Values SQL Summarizing and Grouping Data: Aggregate Functions (Sum, Avg, Count, Max, Min) The Group By Clause The Having Clause Querying Multiple Tables: Joining Tables, Inner Joins, Outer Joins, Self Joins, Full Joins, Cross Joins Alternative Join Syntax Additional SQL Features: Combining Queries The Union, Intersect and Minus Operators Basic Subqueries SQL Queries, DML, DDL commands, stored procedures. Introduction to Big Data, NoSQL databases and Hadoop. JDBC JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and execute the query with the database. It is a part of JavaSE (Java Standard Edition). JDBC API uses JDBC drivers to connect with the database Connecting to databases and embedding SQL Queries to interact with database while coding, Defining the layout of the Java JDBC API, Connecting to a database by using a JDBC driver, Submitting queries and get results from the database, Specifying JDBC driver information externally, Create database, drop database using JDBC Create Table, Drop Table using JDBC Insert Records, Udate Records, Delete Records using JDBC Select records using JDBC : Multithreading Life Cycle of a Thread Thread Priorities Create a Thread by Implementing a Runnable Interface Create a Thread by Extending a Thread Class Thread Methods Major Java Multithreading Concepts While doing Multithreading programming in Java, you would need to have the following concepts very handy − What is thread synchronization? Handling interthread communication Handling thread deadlock Major thread operations Processes and Threads, Thread Objects Defining and Starting a Thread, Pausing Execution with Sleep Interrupts, Joins The SimpleThreads Example Synchronization, Thread Interference, Memory Consistency Errors, Synchronized Methods Intrinsic Locks and Synchronization, Atomic Access, Liveness, Deadlock, Starvation and Livelock Executors, Executor Interfaces, Thread Pools, Fork/Join, Concurrent Collections Guarded Blocks, Immutable Objects A Synchronized Class Example A Strategy for Defining Immutable Objects, High Level Concurrency Objects, Lock Objects Overview: Different types of testing Principles of unit testing using JUnit JUnit Environment Setup JUnit Test Framework JUnit Basic Usage JUnit API Writing a Tests Using Assertion Execution Procedure Executing Tests Suite Test Ignore Test Time Test Exceptions Test Parameterized Test Plug with Ant JUnit Plug with Eclipse JUnit Extensions Why Choose Spring as Your Java Framework? Inversion of Control and Dependency Injection with Spring Constructor Dependency Injection in Spring What is a Spring Bean? Spring Bean Scopes Spring Bean Annotations Spring @Autowired Annotation Wiring in Spring: @Autowired, @Resource and @Inject Spring @Qualifier Annotation @Component vs @Repository and @Service in Spring Properties with Spring Create a small JAVA Sprin Boot web app Introduction to JPA with Spring Transactions with Spring and JPA Spring JDBC Spring Persistence Tutorial Create a Login System using CRUD operations Getting Started with JavaFX What Is JavaFX What is JavaFX? JavaFX is a software platform for creating and delivering desktop applications, as well as rich Internet applications (RIAs). JavaFX is intended to replace Swing as the standard GUI library for Java SE. Get Acquainted with JavaFX Architecture Deployment JavaFX Guide Graphics Getting Started with JavaFX 3D Graphics Use the Image Ops API Work with Canvas JavaFx User Interface Components Work with JavaFx UI Controls Create Charts Add Text in JavaFx Add HTML Content Work with Layouts Skin Applications with CSS within JavaFx Build UI with FXML Handle Events JavaFX Scene Builder 2 JavaFX Scene Builder Overview. JavaFX Scene Builder is a visual layout tool that lets users quickly design JavaFX application user interfaces, without coding. Users can drag and drop UI components with Scene Builder. Get Started with JavaFx Scene Builder Working with Scene Builder Design UI with Scene Builder Use JavaFx Scene Builder with Java IDEs Install Scene Builder Book the Java Coding Bootcamp Book the Java Boot Camp Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

This MS Access Advanced Course mostly covers creating advanced MS Access reports, forms, and macros. Create and amend Advanced Forms and Advanced Reports. Macro buttons. This assists you to build user-friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data This course will help you to structure MS Access tables, import, and manage your data effectively.

Java JUnit Course Duration: 1 Day Who would find this course useful? This is useful if you have some Java coding skills already. Location: Attend from your internet connection. Download: Java JDK and Eclipse. Learn the basic principles of Unit Testing, using Java JUnit in this excellent, practical, interactive Java Webinar. In software testing, is the execution of tests and the comparison of actual outcomes with predicted outcomes. Test automation is the use of software to control these execution of tests. JUnit is a framenwork facilitating unit testing for the Java programming language. This 1 day course explains the use of JUnit for unit testing a Java project. By completing this tutorial you will gain sufficient knowledge in using JUnit testing framework from where you can take yourself to next levels. Java JUnit Course Description JUnit 1-Day Course Outline: Online, Instructor-Led, Practical, Personalised Overview: Different types of testing Principles of unit testing JUnit Environment Setup JUnit Test Framework JUnit Basic Usage JUnit API Writing a Tests Using Assertion Execution Procedure Executing Tests Suite Test Ignore Test Time Test Exceptions Test Parameterized Test Plug with Ant Plug with Eclipse JUnit Extensions What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java JUnit Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments