PCWorkshops courses

...Entering data, Modifying Cells and Data, Autofill Cell Formatting, Enhancing a Worksheet’s Appearance, Copy Fomats Conditional Formatting Entering basic Formulae... Learn about: MS Excel, Conditional Formatting, Business Intelligence...

...alter and drop Indexes. Session 11: Access Control Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges Session... Learn about: Database training, Access Control, Data Types...

...Are you ready to separate yourself from the crowd by learning how to use MS SQL Server Report Builder? With the course SQL Server Report Builder Course... Learn about: Data Analytics, Graphical Indicators, Data Retrieval...

...In this course we expand on OO programming, database and data structures, front-end and web services. This is a very practical course giving you for those... Learn about: GUI programming, Java Programming, Object-oriented programming...

...dealing null values, expressions, Totals and Grooup by. Forms; Queries; Reports and Filters • Creating and Using Forms • Creating and Using Queries • Creating... Learn about: Database training, Databases and Tables, Data Analytics...

...1-day Course, Private 1-1 To understand table relationships and referential integrity. Be capable of making queries such as total queries, expression queries and action queries... Learn about: Database Concepts, Data Retrieval, Database training...

...PCWorkshops Beginners and Intermediate course or have experience in Access database MS Access Database Advanced Course Course Outline Advanced Data Management Database design... Learn about: Data Types, Access Macros, Database training...

...More in operators. Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else; Operators and Expressions... Learn about: Classes and Objects, Software Engineering, Beginners Python...

...Decision Making: If statement; If - else statement; Switch Statements. Using Loops: The while, do-while and the for loop; Enhanced for... Learn about: Oriented Programming, Java API, Decision Making...

...ones who are considering coding as a career choice. Coders or IT Professionals who want to migrate or cross-skill to Java. We will send an email with a booking... Learn about: Oriented Programming, Operators and expressions, Java Programming...

...using Derived Data An Introduction to Structured Query Language (SQL) Simple Queries Simple Updates of the... Learn about: Relational Databases, Data normalisation, Database Management...

...In this course, Python packages that are commonly used for data analysis are covered. These packages include handling CSV files, Numpy... Learn about: Data trends, Data Mining, Data Collection...

...Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products. Session 5: Subqueries. Correlated and uncorrelated Subqueries... Learn about: Database training, Access Control, Data Types...

...Creating the main report Linking the two reports Report parts Publishing report parts The report part gallery Updating report parts... Learn about: Data Retrieval, Conditional Formatting, Data Analytics...

...Python Machine Learning § Learn how to implement Python functions for machine learning and code and implement algorithms to predict future data... Learn about: Training data, Machine Learning, Predicting a category...

...Lists. Using Modules: Creating and using Functions. Creating a Module in class; Calling a Module; Returning value from a Module; Adding a Method that takes parameters... Learn about: Python operators, Software Engineering, Programming Application...

...Using objects as parameters; Returning objects; Access control : private, public and protected; The final keyword... Learn about: Oracle Java, Java API, Programming Application...

...work To assist after the course, an hour's 1-1 mentoring via Skype or at our office... Learn about: GUI programming, Application Development, Android Studio...

...Learn the concepts of the big data Hadoop framework by completing PCWorkshops introductory course. By adding Hadoop to your skillset, you could potentially... Learn about: Hadoop Ecosystem, Big Data, Data Analytics...