PCWorkshops courses

...Correlated sub-queries and the ones with EXISTS predicate. Furthermore, you’ll learn about Derived tables and CTEs (Common Table Expressions)... Learn about: Testing conditions, Basic transactions, Data Types...

...of the principles of Object Orientated Programming. The course is practical with clear explanations and useful examples, and great tutors. All Inclusive Pricing... Learn about: Java 6, Object-oriented programming, Oriented Programming...

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

...line charts, cluster charts and many others. In addition to that you’ll get in touch with heat maps, geographic maps and word maps. All of this will boost... Learn about: Data Types, SQL Server, Data Mining...

...Duration: 12 Weeks Online Lesson Times: Either Fridays or Saturdays, 11am - 6pm Self-study: +-15 hours per week. 1-1 Mentoring: to be scheduled individually... Learn about: Java API, Code debugging and testing...

...are essential for Dashboards: Offset Lookup formulae (Vlookup, Hlookup, Match, Index) Conditional formulae (If, Countifs, And, Or, etc.) Aggregate formulae... Learn about: Dashboards and servicing reports, Data Analytics, Data Mining...

...If you are starting out as a professional software developer using Java, this course is essential. The Java Beginners Course (Evenings) is practical... Learn about: Logical operators, Data Types, Oracle Java...

...also about operators and expressions needed to introduce yourself to the programming dynamic. In addition you’ll get in touch with the decision making and using loops... Learn about: Object oriented training, Operators and expressions, Java Programming...

...Resolving many-to-many relationships -Sub-type and Super-type Relationships -Arc Relationships -Recursive Relationships -Constraints and Assumptions... Learn about: Database Management, Database System Development, Relational Model...

...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, SQL Server, Oracle SQL*Plus...

...contact PCWorkshops through Emagister without hesitation. You won’t regret it! This course is ideal for managers who need to get business intelligence from their data... Learn about: Database training, Table aliases, Databases and Tables...

...Pivot Tables Made Easy: -Pivot Tables are really very easy to create, but very very powerful. By using Pivot Tables, one can get very interesting and valuable... Learn about: Microsoft excel training, Microsoft Excel, Business Intelligence...

...Advanced filter Pivot-tables Adding the Finishing Touches Adding Comments Using Themes Adding Text Boxes Charts and Sparklines Adding and Editing Charts... Learn about: Pivot tables, Excel for Data Management, Excel Tables...

...with sorting and floating headers Grouping Inserting groups with group headers and group footers, creating group totals, Expanding and collapsing the groups... Learn about: Data Mining, Database Design, Data warehousing...

...To understand the Tableau software package and use it efectively Data professionals, analysts, managers and people who work with data Course Outline Tableau Overview and Terminology... Learn about: SQL Database, Data Mining, Ms Word...

...to tailor the training style and pace to your own requirements. To leave you with excellent, professional and in-depth Excel Skills People who use spreadsheets... Learn about: Graphic representation, MS Excel, How to use Excel...

...Excel Dashboards summarizes and presents the most important information of large data in attractive, easy-to-read charts, graphs, tables and pivots... Learn about: Data Analytics, Dashboards and servicing reports, Data Collection...

...Instructor-Led, Practical Excel Course Outline Working with Excel sheets and files, calculating using multiple sheets or files, getting trends over sheets of files... Learn about: Data Visualization, MS Excel, Data Mining...

...used by data scientists. Throughout five different sessions you’ll learn a variety of subjects, including basic terminology as modules, how to use it for data analysis... Learn about: Data Mining, Data Collection, Data trends...

...You will learn to record Excel macros, create macros in Excel by coding in Excel VBA. The we add the macros to icons on a custom toolbar, and you... Learn about: Microsoft Excel, MS Excel, Excel VBA...