PCWorkshops courses

...This course includes an assessment-based SQL course certificate, including the notes, practical exercises, revisions of your work and also coffee and... Learn about: Database Management, SQL Database, Basic transactions...

...Gain the essentials of Java programming. Create a small program using various techniques. Students and curious ones who are considering coding as a career choice... Learn about: Oriented Programming, Java 6, Java Programming...

...different visual with parameters and interactivity. The Target Audience for this course would ideally be end-users who need to present data via visual... Learn about: Data Types, SQL Database, SQL Server...

...With this programme you’ll learn about desktop fundamentals, data visualisation using Tableau, which is the best software since its very intuitive and powerful... Learn about: Data Collection, SQL Database, Data Mining...

...** 1 weekly lesson for 12 weeks, ** Plus 1-1 Mentoring, ** Plus self-study Excellent course to become a professional Java Programmer, learning from scratch to fully job ready... Learn about: Code debugging and testing, Java API...

...choose what you are comparing) Linking cells to a text box Linking cells to chart labels Linking dynamically to changing ranges and values Create Relationships... Learn about: Data Mining, Dashboards and servicing reports, Data Collection...

...Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators; More in operators Decision Making... Learn about: Decrement operators, Oracle Java, Java Programming...

...HashSet, TreeSet, HasSet, LinkedHashSet. Queues: PriorityQueue, LinkedBlockingQueue Session 3: Introduction to Classes and Objects: Creating a Class... Learn about: Java 6, Decision Making, Oriented Programming...

...Foreign Keys -Key Constraints -Attribute Constraints -Implementing Sub-type/Super-type Relationships -Views -Denormalization using Pre-joined Tables... Learn about: Database System Development, Database training, Database Management...

...from data by using SQL queries. It is made easy and simple by this hands-on, practical course. Ask you questions in small, friendly class-room training... Learn about: Multiple tables, Relational Database, Database training...

...and listed at Emagister is the right choice for you. With this course, you will understand different concepts of SQL in order to get important information... Learn about: SQL Server, Database Concepts, Original syntax...

...You will have time to discuss and ask questions... Learn about: Microsoft Excel, Microsoft excel training, Business Intelligence...

...Course summary This Excel course is offered one-to-one, because we understand that profesionals have varying skill levels and varying applications... Learn about: Microsoft excel training, MS Excel, Excel Functions and Formulas...

...Expressions Introducing the expression builder, Report Items, Built-in fields and conditional formatting options and expressions Page set-up Creating page names... Learn about: Database Design, Data Mining, SQL Server...

...Connect to your data. Edit and save a data source. Use the Tableau interface / paradigm to effectively create powerful visualisations. Create basic calculations... Learn about: SQL queries, Data Mining, Data Types...

...Logical, Array, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage... Learn about: How to use Excel, Mathematical formulae, MS Excel...

...It highlights the key trends so the most useful data insights could be interpreted in a matter of seconds. Management descisions are based on the information... Learn about: Data Analytics, Data Mining, MS Excel...

...offered by Emagister and imparted by PCWorkshops. As a modern manager you need to go one step beyond and use Excel to obtain insights of your data... Learn about: Data analysis, MS Excel, Data Collection...

...who anyone who use data as part of their work and who need to draw analysis from the data. It is best to already have an understanding of programming... Learn about: Data Analytics, Data analysis, Data Mining...

...Using the Offset Method Using With Blocks Referencing Workbooks and Worksheets Updating values in the spreadsheet and putiing values into the spreadsheet... Learn about: Excel VBA, MS Excel, Microsoft Excel...