721 Courses delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions

Our teams are increasingly built from colleagues from around the world, each of whom has their own unique culture and communication style. We can help you embrace, enjoy and harness the diversity in teams for incredible outcomes! This course includes: The impact on the team of language and cultural differences Communication techniques for an effective global team The importance of clarity and commitment The difference in planning and scheduling across cultures Different perceptions of power and leadership Leveraging the diversity in your team

Unity 3d face to face training customised and bespoke.

In order to be an effective manager, it is extremely important to have good communication skills so that you can get your instructions across clearly and in a manner which will get you the results you desire from your employees. Our 2-day Effective Communication and Influencing course aims to provide attendees with a range of skills and behaviours which will allow them to communication clearly and effectively. Course syllabus modules include explaining the communication process, the different styles of influencing, the importance of body language and tone of voice, non-verbal communication and more. Course Syllabus The syllabus of the Effective Communication and Influencing course is comprised of seven modules, covering the following: Module One The Communication Process Identifying, what is effective communication? Recognising the different ways in which we communicate The barriers to effective communication Looking at Johari's™ Window, to better understand how communication flows Module Two Effective Communication Skills Demonstrating a positive mental attitude Establishing active listening Developing your questioning skills Using positive language Module Three Different Types of Influencing Looking at influencing versus manipulation Developing your own preferred influencing style Understanding the different influencing styles and their uses adopting a flexible style for the desired outcome Module Four Behaviour Breeds Bahaviour (Transactional Analysis) Looking at the history of hidden transactions in communications The hidden meaning in what we say and what we receive How to recognise if what you're saying is calm, rational, logical and professional Module Five Body Language Understanding the impact of body language in effective communication Noticing how your own body language influences others positively and negatively Analysing and practicing the techniques of successful body language Module Six It's All in the Voice Learning the importance of tone of voice in effective communication Realising how your tone of voice influences others Module Seven Written Communication Understanding the pitfalls of opening a discussion Identifying the different types of written communication Recognising the importance of preparation and planning Looking at different structures and layouts of written communication Using the correct words and phrases Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

This is not a course.  There are two options: Whatching movie and reading book together with comments. Only reading a book  Every meeting is one hour. Usually 8 or 10 meeting. One hour each

Duration 3 Days 18 CPD hours Discover and explore how to use the fundamental building blocks of the Swift programming language. class will teach you the basic concepts of Swift programming, including syntax, logic, structures, functions, and patterns. It also includes detailed explanations of language syntax and coding exercises. Introduction to Swift Constants, Variables, and Data TypesOperatorsControl FlowStrings & FunctionsStructures & ClassesOptionalsCollectionsLoopsType CastingGuard StatementsScope & EnumerationsProtocolsClosuresExtensions

Understanding cultural differences in the global sales environment is critical to your salespeople’s success. Developing their intercultural communication skills and knowledge of the sales and negotiation techniques of different cultures and nationalities, will help them to ensure relationships are as effective and rewarding as possible. Bespoke courses include: The impact of language and cultural differences on the sales environment Communication techniques in international sales Effective sales questions A global mindset Culture and its impact on sales Delivering on different cultural expectations Perceptions of time across cultures and the impact on sales cycles and timelines

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES

conversazione in italiano, gruppo di lettura in italiano. Italian book club

Duration 5 Days 30 CPD hours This course is intended for Software Engineers Mobile Developers Overview The training is geared to build essential skills to develop professional applications for iOS 8.0 devices. The complete hands-on course will be delivered using Xcode 6. The 2 days of Objective-C and Swift training, at the start of the course is designed to allow developers , with a non-Objective C background, to jumpstart into iOS application development. The training is intended to lay a solid foundation in Apple's new programming language - Swift for development of next-generation iOS applications. The training is intended to lay a solid foundation in Apple's new programming language - Swift for development of next-generation iOS applications.