PCWorkshops courses

...stored procedures Variables ·Declaring variables ·SET versus SELECT Parameters and Return Values ·Passing parameters ·Default values and WHERE clauses... Learn about: Basic transactions, Rolling back, SQL Server...

...Coders or IT Professionals who want to migrate or cross-skill to Java. We will send an email with a booking form. You could book when ready... Learn about: Data Types, Object-oriented programming, Oriented Programming...

...creating and editing report parameters, using the parameters to filter reports, creating parameter drop lists. and copying with empty tables Matrices... Learn about: SQL Database, Data Mining, SQL Server...

...Pie charts, bar charts, Line Charts, Area Charts, Cluster Charts, Cross tabs Geographic maps Heat maps Tree maps Word maps Multiple Categories... Learn about: Data Types, Data Collection, SQL Server...

...OOP Week 3: Data Structures, Arrays, Collections Week 4: Database Principles and SQL Week 5: I/O, Exceptions and JDBC Week 6: Java Test-Driven Development with JUnit... Learn about: Code debugging and testing, Java API...

...with PowerPivot Data Create Relationships to Master Data Create PivotTables with Table Relationships Refreshing Dashboards inline with changing data What is included... Learn about: Data Analytics, MS Excel, Dashboards and servicing reports...

...The final keyword; Nested and inner classes; A stack class Exception Handling: Fundamentals of exception handling; Exception types; Using try and catch... Learn about: Jump statements, Oracle Java, Logical operators...

...With this course you’ll be focused in understanding more everyday in a small group, with both theoretical and practical activities. 5 days will be all... Learn about: Decision Making, Java 6, Oriented Programming...

...Normalization to the Second Normal Form (2NF) -Normalization to the Third Normal Form (3NF) -Exercises: Data Normalization producing table specifications... Learn about: Relational Databases, Database Management, Database training...

...Multiple Tables Inner Joins Column Qualification and Table Aliases Multiple table joins Left Joins Self Joins Additional SQL Features Union... Learn about: SQL Server, Oracle SQL*Plus, Multiple tables...

...Import and Export Read more: https://pcworkshopslondon.co.uk/sql-intermediate-3-day-course... Learn about: Data Management, Replacing rows, Database training...

...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, MS Excel, Business Intelligence...

...Adding and Editing Sparklines Adding Graphics Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes... Learn about: Excel Tables, Pivot tables, MS Excel...

...C ourse Outline Report Models Views of Data Sources, Creating a model, introducing the concepts of entities, attributes and roles Tables Creating tables... Learn about: Data warehousing, Database Design, Data Mining...

...multiple value axes Adding trendlines and reference lines Build dashboards to share visualisations. What is included in this Tableau Course... Learn about: Data Types, SQL Server, SQL queries...

...Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external... Learn about: MS Excel, Mathematical formulae, Data Analytics...

...GMT 1-day Introduction Activating Power Pivot in Excel Browse, Filter and Sort PowerPivot Data PowerPivot Menu Options The AutoSum Function in Power Pivot... Learn about: MS Excel, Data Collection, Dashboards and servicing reports...

...Prepare yourself to upgrade your Excel skills in order to manipulate sets of data with this Microsoft Excel Data Analysis for Modern Managers... Learn about: Data Mining, Data Collection, Data Analytics...

...slice, analyze large data sets using Python data function libraries. Python and data users, analysts, scientist, business analysts. You could simply... Learn about: Data Mining, Data Collection, Data analysis...

...Instructor-led, Online. Many Excel tasks become tedious and repetitive. To create macros will automate these repeated actions and saves you the time of doing... Learn about: Excel VBA, MS Excel, Microsoft Excel...