PCWorkshops courses

...·Customizing SQL error messages ·@@ error function Debugging ·The SQL Server debugger, Debugging (breakpoints, etc... Learn about: SQL Server, Testing conditions, Rolling back...

...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: Operators and expressions, Oriented Programming, Data Types...

...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 warehousing, Data Types, Database Design...

...including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. Represent your data using the following visualisation types... Learn about: Data Mining, SQL Database, SQL queries...

...COURSE DETAILS Blended Learning: ** 1 weekly lesson for 12 weeks, ** Plus 1-1 Mentoring, ** Plus self-study Study Level : Learn Java from scratch to job ready... Learn about: Code debugging and testing, Java API...

...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...

...Primitive types; Variables and scope; Converting and casting of data types; Introduction to String class. Operators and Expressions: Introduction of operators... Learn about: Assignment operator, Object-oriented programming, Data Types...

...5 days will be all you need in order to achieve your goals; with Personalised attention and the help of a great instructor. At the beginning you’ll... Learn about: Object-oriented programming, Object oriented Programming, Java 6...

...Course Title: Relational Databases & Data Normalisation Overview Training Course Course Duration: 1-Day Course Important: If booking within 7 days of the date of the course... Learn about: Database System Development, Database training, Database Design...

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

...from your company such as trends, statistics, summaries and insights in order to make better decisions in the daily business routine. This company’s data... Learn about: Table aliases, Database training, Data Management...

...additional formulae Create a Pivot Charts Changing a Pivot Table and more features of PIvot Table to show you how you can get the best out of Pivot Tables... Learn about: Pivot tables, Pivot charts, Microsoft excel training...

...Adding and Editing Sparklines Adding Graphics Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes... Learn about: Excel Graphics, Excel Tables, Excel Functions and Formulas...

...the main report Linking the two reports Report parts: Publishing report parts, using the part gallery and update report parts Read... Learn about: Data Types, SQL Server, SQL Database...

...Course Revision work Tea, coffees, but no lunch To assist after the course, 1 free session for questions online Tableau Course via Skype or Teamviewer... Learn about: Data warehousing, SQL Database, SQL queries...

...Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts What is included... Learn about: Data Analytics, Mathematical formulae, Graphic representation...

...provided by these visuals. To create attractive and insightful data charts and dashboards. Data people. Excel users who analyse data with Excel or create management reports... Learn about: Data Analytics, Data Collection, 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: MS Excel, Microsoft Excel, Data trends...

...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 Analytics, Data analysis...

...workbooks Understanding Objects, Properties and Methods Interacting with the spreadsheet : Referencing Cells and Ranges Gathering Cell and Range Information... Learn about: MS Excel, Microsoft Excel, Excel VBA...