Programming Training Courses

Programming Training

Computer Programming courses

Client Testimonials

SQL in SQL Server

Lukasz (the trainer) was very knowlegable and importantly adaptable to the different levels of knoweldge in the room, tailoring help and teaching on an individual level which was great. Very open and apporachable, being informativite, clear and providing good mechanisms for genuine understanding of the material provided.

Thomas Houiellebecq- Ernst & Young AG

Oracle Application Express Introduction

The format was really good, the exercises were not too difficult and helped us to fully understand the tool.

Juan Salvador Rios Hoyos- Oracle

Oracle Application Express Introduction

The format was really good, the exercises were not too difficult and helped us to fully understand the tool.

Juan Salvador Rios Hoyos- Oracle

Software Engineering

Kristian (the trainer) was very well prepared and anticipated potential changes in the course content ( we had varying levels of experience). He also integrated information specific to our company in a professional and dynamic way.

Maell Cullen - Altran UK

Software Engineering

Kristian (the trainer) was very well prepared and anticipated potential changes in the course content ( we had varying levels of experience). He also integrated information specific to our company in a professional and dynamic way.

Maell Cullen - Altran UK

Software Engineering

Kristian (the trainer) was very well prepared and anticipated potential changes in the course content ( we had varying levels of experience). He also integrated information specific to our company in a professional and dynamic way.

Maell Cullen - Altran UK

Software Engineering

Kristian (the trainer) was very well prepared and anticipated potential changes in the course content ( we had varying levels of experience). He also integrated information specific to our company in a professional and dynamic way.

Maell Cullen - Altran UK

Software Engineering

The trainer was excellent, the only reason I have not indicated all sixes was that there were some subjects that I was less interested in but this is just due to personal taste and career path.

There were computer based activities e.g writing code and using existing programs.

Mel Irfan - Altran UK

Software Engineering

The trainer was excellent, the only reason I have not indicated all sixes was that there were some subjects that I was less interested in but this is just due to personal taste and career path.

There were computer based activities e.g writing code and using existing programs.

Mel Irfan - Altran UK

Software Engineering

The trainer was excellent, the only reason I have not indicated all sixes was that there were some subjects that I was less interested in but this is just due to personal taste and career path.

There were computer based activities e.g writing code and using existing programs.

Mel Irfan - Altran UK

Software Engineering

The trainer was excellent, the only reason I have not indicated all sixes was that there were some subjects that I was less interested in but this is just due to personal taste and career path.

There were computer based activities e.g writing code and using existing programs.

Mel Irfan - Altran UK

Software Engineering

Enthusiastic and interesting trainer.

Adrian Turner - Altran UK

Software Engineering

Enthusiastic and interesting trainer.

Adrian Turner - Altran UK

Software Engineering

Enthusiastic and interesting trainer.

Adrian Turner - Altran UK

Software Engineering

Enthusiastic and interesting trainer.

Adrian Turner - Altran UK

Software Engineering

I liked the refresher of what we had learnt at the end of each day and at other regular intervals. Kristian (the trainer) seemed to have anticipated questions that we asked and had presentations and knowledge to help answer these questions.

Ashley Day - Altran UK

Software Engineering

I liked the refresher of what we had learnt at the end of each day and at other regular intervals. Kristian (the trainer) seemed to have anticipated questions that we asked and had presentations and knowledge to help answer these questions.

Ashley Day - Altran UK

Software Engineering

I liked the refresher of what we had learnt at the end of each day and at other regular intervals. Kristian (the trainer) seemed to have anticipated questions that we asked and had presentations and knowledge to help answer these questions.

Ashley Day - Altran UK

Software Engineering

I liked the refresher of what we had learnt at the end of each day and at other regular intervals. Kristian (the trainer) seemed to have anticipated questions that we asked and had presentations and knowledge to help answer these questions.

Ashley Day - Altran UK

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

This was the first time I did remote training ever. It went well, better than I expected.

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

He's (the trainer) very flexible and work along with our questions.

Bokhara Bun- Employment and Social Development Canada.

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Apache Solr - Full-Text Search Server

The pace was just right.

Greg Noseworthy - Employment and Social Development Canada

Git for Users

He (the trainer) provided solutions to more particular problems when using GIT.

Learning Brick

Git for Users

I liked the atmosphere of the course.

Wallace Welles - Learning Brick

WildFly Server Administration

Trainer was excellent.

100% hands on. Very effective way of learning.

Steve Kirkland-Walton - Purple Secure Systems

WildFly Server Administration

Trainer was excellent.

100% hands on. Very effective way of learning.

Steve Kirkland-Walton - Purple Secure Systems

WildFly Server Administration

Trainer was excellent.

100% hands on. Very effective way of learning.

Steve Kirkland-Walton - Purple Secure Systems

WildFly Server Administration

Trainer was excellent.

100% hands on. Very effective way of learning.

Steve Kirkland-Walton - Purple Secure Systems

WildFly Server Administration

Trainer was excellent.

100% hands on. Very effective way of learning.

Steve Kirkland-Walton - Purple Secure Systems

WildFly Server Administration

Trainer was excellent.

100% hands on. Very effective way of learning.

Steve Kirkland-Walton - Purple Secure Systems

Subversion for Users

Trainer was excellent - very helpful and knowledgeable about the product.

The pace of the training was good.

Eoin Conneely - IPSI

Subversion for Users

Trainer was excellent - very helpful and knowledgeable about the product.

The pace of the training was good.

Eoin Conneely - IPSI

Subversion for Users

Trainer was excellent - very helpful and knowledgeable about the product.

The pace of the training was good.

Eoin Conneely - IPSI

Subversion for Users

Trainer was excellent - very helpful and knowledgeable about the product.

The pace of the training was good.

Eoin Conneely - IPSI

PostgreSQL

The course was interesting and understandable for me, even If I don´t have every day contact with database servers.

Iti Liivik - Helmes AS

PostgreSQL

The course was interesting and understandable for me, even If I don´t have every day contact with database servers.

Iti Liivik - Helmes AS

SOA Architect

I liked the new idea about how visualize your understanding of Service Oriented Architecture.

Yaqoub Al-Abri - Oman Airports Management Company

SOA Architect

I liked the new idea about how visualize your understanding of Service Oriented Architecture.

Yaqoub Al-Abri - Oman Airports Management Company

SOA Architect

I liked the new idea about how visualize your understanding of Service Oriented Architecture.

Yaqoub Al-Abri - Oman Airports Management Company

SOA Architect

I liked the new idea about how visualize your understanding of Service Oriented Architecture.

Yaqoub Al-Abri - Oman Airports Management Company

Developing Websites with PHP

I enjoyed the free software we were allowed to use, allowing us to see our code changes in real time

Very thankful for the course, it has increased my confidence and I am now eager to try out php as soon as I can

James Derrick - Sea Bass Software Ltd.

Subcategories

Programming Course Outlines

ID Name Duration Overview
2603 Excel Advanced with VBA 21 hours Participants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks. Adjustment of the working environment Keyboard shortcuts, facilities Create and modify toolbars Excel Options (autosave, input, etc.). Options paste special (transpose) Formatting (style, format painter) Tool go to Organization of information Management sheets (naming, copying, color change) Assign and manage the names of cells and ranges Protect worksheet and workbook Secure and encrypt files Collaboration and track changes, comments Inspection sheet Create your own templates, charts, worksheets, workbooks Data analysis Logic Basic functions Advanced functions Scenarios Search by Solver Charts Graphics support (shadows, charts, AutoShapes) Database management (list) Data consolidation Grouping and outlining data Sorting data (over 4 columns) Advanced data filtering Database Functions Subtotal (partial) Tables and Pivot Charts Cooperation with other applications Get External Data (CSV, TXT) OLE (static and link) Web Queries Publication sheets on site (static and dynamic) Publication PivotTables Automation of work Conditional Formatting Create your own formats Check the correctness Recording and editing macros Visual Basic for Applications Create your own functions Results in VBA VBA Forms
2512 Creating and managing Web sites 35 hours The training program prepares you for professional web designer (occupation code: 213202 for Standards of Professional Qualifications) in respect of "HTML and CSS in web design" and includes a programming problem using JavaScript and PHP language. The following program assumes that the participant will be able to design and make websites using HTML 4.0 and Cascading Style Sheets 2.0. In building a web site, you will use the HTML tags to place text, graphics, tables, and interactive forms on the web page, and also links to other web pages and web sites. Using Cascading Style Sheets 2.0 you will perform formatting of web content according to customer requirements. Course graduates can seek employment in service companies involved in web designing or start consulting service (self-employed). The training program covers the issues of creating web sites using HTML and CSS. Using HTML to create Web pages Inserting and formatting text on the website The main elements of a web page text The header and content of the page The titles of sections Separators Placing images on the website Graphic files: PNG, JPEG / JPG, GIF Making calls on websites Links / Hyperlinks Insert Hyperlink File sharing via the web Automatic creation of an e-mail Change the display of links Using graphics as hyperlinks / link Use tables to build websites The development of the forms on the website Develop a web page using frames Use CSS to create web pages Construction and structure of the style Putting styles in the document Settings for all parties (including font sizes and background color of the letter) Define the font and text with styles Formatting paragraphs and titles Indentation, and line spacing Centered and change the background color of titles The use of small caps or caps Defining color, background, spacing and margins by using styles Borders and frames for various page elements Defining the borders, scrollbars, and display using styles Define positioning elements and units with styles Defining tables and prints with styles Defining selectors using classes and IDs JavaScript Introduction to JavaScript History, implementations, versions Embedding code in an HTML document Syntax Keywords and reserved Variables Data types Operators Control statements Function Memory management Reference types Types wrapper Array Date RegExp Math Function Object-Oriented Programming Creating Objects Inheritance Anonymous functions Recursion Closures Private elements Browser Object Model Objects: window, location, navigator, screen, history Counters time Detecting the type of customer Document Object Model Hierarchy DOM Access and modify elements Events Types of events Handling events Propagation The event object Software generation of events Memory and Performance Service forms from JavaScript Emergencies and debugging Reporting and Exception Handling Techniques and tools for debugging Typical mistakes IE PHP PHP syntax operators, variables basic functions, File operations, strings and arrays Data structures associative arrays session variables, form, url, cookie Object-Oriented Programming in PHP Classes, constructors, inheritance Object-oriented features
2230 Programming Metro-style Apps with C# (Windows 8, Windows RT, WinRT) 21 hours Day 1 Understanding WinRT Pros and cons of HTML5 track over XAML track Basic form layouts HTTP communication with JSON Local data storage Day 2 More local data storage (ORM) Infinite scroll lists Pull to refresh Multitouch Split-view Day 3 Notifications Location Social network integration Selling on Windows Store Handing in-app purchases
2066 jQuery Advanced 14 hours This course has been created for web developers who want to master jQuery development, develop their own libraries and build a reusable jQuery code. Javascript and OOP Chaining Objects and Prototypes Optimization Dynamic properties and methods jQuery structure and components Core Selectors Attributes Traversing Manipulation Effects Ajax XMLHttpRequest object using HTTP GET, POST Using JSON objects jQuery Events Binding and unbinding events Convenient event helper methods jQuery event object Event features Event propagation Plugins Writing own plugins
1976 ActionScript 3.0 Programming 21 hours This course deals with developing graphical parts of a web application using ActionScript. The participants will learn how to use the powerful features of the new ActionScript 3.0, programming with object oriented, managing the interactivity part of the application and using the API to display graphics. Core Concepts  Datatypes and type checking Conditional and loops Instance members, static members and functions Inheritance and Interfaces Managing Arrays Exceptions and Error Handling   Interactivity The Display API and the Display List Events and Display Hierarchies Interactivity with mouse, focus, keyboard, .. events How to manage screen updates Scheduled and post-event screen updates Animation with code The ENTER_FRAME and TIMER event Display Drawing with vectors Drawing lines, curves, shapes Programming with bitmap The BitmapData and Bitmap Classes Creating and loading a bitmap image Applying filters and effects Creating and displaying text Loading External Display Asset Applied ActionScript ActionScript and the Flash Authoring Tool Symbols and instances Linked classes for movie clip symbols Accessing created symbol instances Programmatic timeline control Preloading classes Distributing a class library as a .swc file Distributing a class library as a .swf file
993 Android Fundamentals 56 hours Android is an open source platform developed by Google for mobile development. Applications for the Android platform are developed in Java. This course overviews Android's fundamental topics. Introduction What is Android? Android SDK Android JVM The Software Stack The Development Tools (ADT) User Interface Installing Development Tools Content Providers Services Intents Activities Views Configuration File Simple Hello World Application Artifacts Asset Packaging Tool Entry Point Activity Intent Calling Other Activities The Activities Stack Paused & Stopped Activities SQLite Database System Management Separated Processes Component & Integration Architecture Application Resources Introduction What are Resources? String Resources Layout Resources Code Samples Resource Reference Syntax Compiled Resources Compiled Animation Files Compiled Bitmaps Compiled UI View Definitions Compiled Arrays Compiled Colors Compiled Strings Compiled Styles Compiled Arbitrary Raw XML Files Uncompiled Resources The .apk File Assets Assets & Resources Directory Structure The Intent Concept Introduction Intent Filter Use Intent to Start Activity Android Available Intentions Code Samples Intent Categories Late Run-Time Binding Use Intent to Start Service Broadcast Receivers The Intent Object Structure The Intent Component Name The Intent Action The Intent Data The Intent Category The Intent Extras The Intent Flags Intents Resolution Intent Filter Structure The Action Test The Category Test The Data Test Multiple Matches Android Predefined Intents Samples User Interface Controls Introduction GUI Sample in Source Code GUI Sample in XML GUI Sample in XML & Source Code TextView TextView Sample TextView Style Sample EditText EditText Sample AutoCompleteTextView AutoCompleteTextView Sample MultiAutoCompleteTextView MultiAutoCompleteTextView Sample Button Button Sample ImageButton ImageButton Sample ToggleButton ToggleButton Sample CheckBox Control CheckBox Control Sample RadioButton Control RadioButton Control Sample ListView ListView Sample GridView Control GridView Control Sample Date & Time Controls Gallery Controller MapView WebView Layout Managers Introduction LinearLayout Layout Weight Gravity Samples TableLayout Padding Properties RelativeLayout AbsoluteLayout FrameLayout TabsHost Menus and Dialogs Introduction Menu Interface MenuItem Interface SubMenu Interface Menu Items Group Menu Items Attributes Container Menu Items System Menu Items Secondary Menu Items Alternative Menu Items Creating Menu Sample Menu Items Groups Menu Items Events Handling Overriding Callback Function Define Listener Using Intents Expanded Menu Icon Menus Sub Menus System Menus Context Menus Samples Handling Menu Events Creating Menu using XML Alert Dialog Prompt Dialog Samples Touchscreens Introduction Motion Events Events Sequences Events Handling Handling Method Samples Style Definition Introduction Style Definition Samples Style Definitions Inheritance Style Properties Theme Definition Predefined Themes Predefined Themes Inherit Predefined Theme App Widgets Development App Widgets Overview Practical Samples Basic App Widget Structure Configuration Activity Design Guidelines Location Based Services Introduction The Map Key The MD-5 Signature Google Maps Key Required Permissions Code Sample The Map Controller Code Samples Maps Overlays Code Samples The Geocoder Class The Address Class The LocationManager Class The LocationListener Interface The Debug Monitor Service (DMS) Web Services Introduction The HttpClient Class The HttpGet Class The HttpPost Class The HttpResponse Class Code Samples HTTP Get Request HTTP Post Request Code Samples Timeout Exceptions Threading Issues Android Services Introduction Creating Services The Service Class Background Tasks Inter Process Communication Separated Implementation Local ServiceRemote Services AIDL Compiler Creating Remote ServiceUsing Remote Service Samples Media Framework Introduction Playing Audio Playing Video Simple MP3 Player Demo Simple Video Player Demo Android Security Model Introduction Deployment The keytool Utility The jarsigner Utility Deployment using Eclipse Separated Processes Declarative Permission Model Graphics Animation Introduction Frame by Frame Animation Code Sample Tween Animation Code Samples Basic Graphics Introduction The Drawable Abstract Class Code Sample The ShapeDrable Abstract Class Code Sample OpenGL Graphics Introduction The glVertexPointer Method The glDrawElements Method Code Sample Customized Views Introduction Customized Progress Bar Model View Controller Android Threads Introduction The UI Thread The Single Thread Rule The runOnUiThread Method The post Method The postDelayed Method The Handler Class The AsyncTask Utility Class Sending Messages to Handler Background Threads Caveats Application Life Cycle Introduction Activity Life Cycle Methods The onStart() and onResume() Methods The onPause() and onStope() Methods Return Back to Previous Activity The onStop() and onDestroy() Methods The onCreate() Method The onPause() Method SQLite Database Introduction SQLite Implementation The SQLiteOpenHelper Class The onCreate() Method The onUpgrade() Method The onOpen() Method The getWriteableDatabase() Method The getReadableDatabase() Method The SQLiteDatabase Class The execSQL() Method The insert() Method The delete() Method The rawQuery() Method() Code Samples The query() Method Code Samples Content Providers Introduction Android Built-In Content Providers SQLite Database Content Providers Architecture Content Providers Registration Content Providers REST Access Content Providers URL Structure Content Providers Mime Types Using Content Provider Retrieving Records,Adding Records The Cursor Object,The ContentValues() Object Content Provider Demo Developing Content Providers Code Samples The SimpleCursorAdapter Class The onCreate() Method The query() Method The insert() Method The update() Method The delete() Method The getType() Method Code Samples Changes Notification Shared Preferences Introduction The SharedPreferences Interface The SharedPreferences.Editor Class Code Samples File Management Introduction Creating Files Accessing Simple Files Accessing Raw Resources XML Files Resources SD Card External Storage Dalvik VM Introduction Comparing with JVM The dex File Format The dx Utility Garbage Collector Controlling the Dalvik VM Background Applications Introduction Services Background Threads Making Toasts Notifications Other System Services Background Activity Sample Activity Data Introduction The Intent Class Start Activity Methods Passing Data between Activities Coherent User Experience Code Sample SMS Messages Introduction The SMSManager Class The SEND_SMS Permission Sending SMS Receiving SMS Telephony Introduction Initiate Phone Calls The android.telephony Package The CallLocation Class The PhoneStateListener Class The ServiceState Class The TelephonyManager Class Limitations,Android VoIP Web View Introduction The WebView Class The android.webkit Package The INTERNET Permission The loadUrl() Method JavaScript Support The loadData() Method The WebView Methods The WebViewClient Class The WebChromeClient Class Java Language Introduction The Limits Third Party Java Libraries Debugging Introduction Eclipse Java Editor Eclipse Java Debugger Logcat Android Debug Bridge Dalvik Debug Monitor Service Traceview Instrumentation Framework Adapters Introduction Classes Hierarchy The Adapter Purpose The SimpleCursorAdapter Class The ArrayAdapter Class Live Wallpapers Introduction Develop Live Wallpaper User Interaction The user-sdk Element The uses-feature Element PerformanceCode Samples BroadcastReceiver Introduction Registering a Receiver Receiver Life Cycle Code Samples Bluetooth Introduction The Capabilities The BluetoothAdapter Class The BluetoothDevice Class The BluetootnSocket Interface The BluetoothServerSocket Class The Bluetooth Class Bluetooth Permission Setting Up Bluetooth Finding Devices Querying Paired Devices Devices Discovery Enabling Discoverability Devices Connection Code Samples Text To Speech Introduction Pico Engine Demo Single TTS Engine Code Samples Android Search Introduction Suggestions Providers The onSearchRequest() Method Suggestion Provider Camera Introduction Auto Focus Picture Parameters Scene Modes Accelerometer Introduction The SensorManager Class The SensorListenr Interface Compass Introduction The SensorManager Class The SensorListenr Interface Vibration Introduction The Vibrator Class Vibration Sequences WiFi Connectivity Introduction The WifiManager Class User Permissions Searching for Hot Spots Connecting Hot Spots Networking Introduction Java Networking Classes Android Networking Classes Apache Networking Classes Input Method Framework Introduction The android:inputType Attribute Customized IMF Device Rotation Introduction Two XML Layout Documents Code Samples Localization Introduction Default Resources Current Locale Testing Custom Locale Code Samples Memory Management The Application Context Screen Orientation Changes Static Inner Classes Weak References Garbage Collector Speech Input Introduction The RecognizerIntent Class Start Speech Recognition Google Server Side The Language Model Free Form Language Model Web Search Language Model Development Tools Introduction The aapt Tool The adb Tool The android Tool The ddms Tool The dx Tool The draw9patch Tool The emulator Tool Instant Messaging Introduction Jabber Protocol GTalk Interaction
533 Drupal SEO 14 hours With this course you can gain the knowledge you need to get your website to the top of search engines and to reach paying customers for your business with Drupal. Seo basics Business Analysis & Research Keywords Target Group Website Structure HTML basics Tags used for SEO Links Drupal SEO Basics Categorization Clean Urls & Paths Avoiding Duplicate Content Correct Page Titles Better 404 pages Meta Tags Link Attributes XML, Page & Google News Sitemaps Site Verification Service Links User Statistics RSS Feeds Drupal SEO Advanced Advanced Automated & Semi-Automated Crosslinks Related Content Semantic Content (automatically create rich semantic metadata for your content) Other Webmaster Central Google Adwords, Trends, Insights SEO Tools
2591 SQL in MySQL 14 hours How to build a query? What opportunities has the SQL in a MySQL database? What is a relational database? What is the structure and SQL commands? Relational database models Relational operators Characteristics of declarative SQL language SQL syntax Division language DQL, DML, DDL, DCL Data Query Language SELECT queries. Aliases columns of tables Service date (DATE types, display functions, formatting) Group Features Combining internal and external tables (JOIN clause) UNION operator Nested Subqueries (the WHERE clause, the table name, column name) Correlated subqueries Data Modification Language Inserting rows (INSERT clause) Inserting rows by request Variation of the rows (UPDATE) Delete rows (DELETE) Data Definition Language Tworzenie, zmiana własności, usuwanie tabel (CREATE,ALTER,DROP) Tworzenie tabel poprzez zapytanie (CREATE TABLE .... AS SELECT...) CONSTRAINTS Options NULL and NOT NULL CONSTRAINT clause ENUM type type SET PRIMARY KEY condition UNIQUE condition FOREIGN KEY condition DEFAULT clause Transactions The command COMMIT, ROLLBACK, SAVEPOINT
287864 MariaDB 10 Developer Course 28 hours Created DBAs, Administrators and developers who are interested with getting involved in MariaDB 10 based on Linux system. Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Database Concept and SQL and to show it is very easy to understand how to use SQL and manage MariaDB on Linux system. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities After this course, you can apply the knowledge, which you obtained through this course, to the other database systems such as MySQL, Oracle Database, MSSQL Server and PostgreSQL as well. It can be deliver on any distribution (Ubuntu, CentOS are commonly used) This course covers these kinds of topics: Chapter 00 MariaDB 10 Developer Course Introduction Chapter 01 MariaDB 10 Introduction Chapter 02 Startup MariaDB 10 Chapter 03 MariaDB Tools - Command & GUI Chapter 04 Retrieving Data using SQL Chapter 05 Filtering Data using SQL Chapter 06 Summarizing, Grouping & Combining Chapter 07 Database, Table & Indexes Chapter 08 Inserting, Updating & Deleting Data Chapter 09 Table Joins Chapter 10 Subqueries Chapter 11 Views Chapter 12 Stored Procedures Chapter 13 Triggers Chapter 14 MariaDB Datatypes Chapter 15 Transaction Processing Chapter 16 MariaDB User Management Chapter 17 MariaDB Client Tools
2597 Visual Basic for Applications (VBA) in Excel - Introduction to programming 28 hours It is an introduction to procedural programming in VBA. Training allows you to gain a strong foundation for further learning and VBA environment. After the course you can: Record and edit the macro as required, Write procedures using data from the sheet, Create your own functions Handle the event (opening worksheet cell update etc) by means of the handler, Create form Macros Recording and editing macros Assigning macros to forms, toolbars, keyboard shortcuts VBA Environment Visual Basic Editor and its options Management components Keyboard Shortcuts Optimizing the environment Introduction to procedural programming Procedures: Function Sub Data types The if statement ... then ... elseif ... else ... end if Case statement Loops for ... loop while, until Loop for ... next Instructions loop break (exit) Array processing Quoted string Combining quoted strings (concatenation) Conversion to other types of (implicit and explicit) Features processing quoted strings Visual Basic Download and upload data to a spreadsheet (Cells, Range) Download and upload data to the user (InputBox, MsgBox) The declaration of variables The extent and lifetime of variables Operators and their priorities Options modules Create your own functions and use them in a sheet Objects, classes, methods and properties Securing code Security code tampering and preview Debugging Processing step Locals window Immediate window Traps - Watches Call Stack Error handling Types of errors and ways to avoid Capturing and handling run-time errors Structures: On Error Resume Next, On Error GoTo Excel Object Model The Application Object Workbook object and a collection of Workbooks Worksheet Object and Collection Worksheets Objects ThisWorkbook, ActiveWorkbook, ActiveCell Object Selection Collection Range Object Cells Display data on the status bar Optimization using ScreenUpdating The time measurement by the method Timer Event handling in VBA What is an event? Responding to an event and create an event handler Triggering Event Handlers Service frequently occurring events VBA Forms Create your own forms Calling a form from code Use the forms in the sheet
2497 Introducing C# 4.0 with Visual Studio 2010 28 hours IDE Introduction to Visual Studio 2010 Console.WriteLine, Console.ReadLine Hello C# World ! Compiling and Debugging Comments in C # The mention of Class, using, Main .NET 4.0 What is .NET? CLR and GC DLL and EXE ? Technologies within. NET C# Fundamenty History C# from 1.0 do 4.0 Pascal Case, Camel Case Uppercase Keywords, Literals, Operators, Punctuators, Statements, Comments Value Type, Reference Type Assigning and comparing variables Conditional operations - If, Switch Loops - For, Foreach, while, to… while… Overview of key words and operators of C # C# 4.0 Numeric and Boolean types Classes and Objects (inheritance, polymorphism) Felds Properties Indexery, Operators Methods Delegates, Events, Anonymous Methods Namespaces Interface, Structure, Enum Boards Exceptions Generic Types and Anonymous Strings text strings and characters. Attributes .NET Class Library Collections Files and Data Streams Communication between systems Dates Serialization Parallel Programming Asynchronous operations and parallelized Useful operations Access to Data ADO.NET LINQ ORM – Entity Framework Data in SOA Review of applications that can be developed in C # and. NET Framework 4 Windows Presentation Foundation ASP.NET MVC 2 Silverlight
2222 Cross-platform mobile development with PhoneGap/Apache Cordova 21 hours The objective of cross-platform frameworks is to allow you to write applications once and have it run on multiple platforms. Want to build an iPhone app that will also run on Android? Have a customer turn round and want their Android app to run on Windows Phone? No problem. On this three-day PhoneGap/Apache Cordova course you will look at two different yet complimentary technologies for cross-platform mobile development. (Apache Cordova is the new name for PhoneGap. Adobe acquired PhoneGap from the original developers and gifted it to the Apache Software Foundation.) Upon completion of this PhoneGap/Apache Cordova course, you will be able to build fully-functioning mobile Web applications using the framework, manage source code and handle platform tweaks, create “native like” experiences from a web application -- and much more! Day 1 Getting up and running Accessing native capabilities of the device Structuring source code and handling SCM Persisting data locally Building forms and communicating with the server Day 2 Network communication Managing source code and handling platform tweaks Using plug-ins Working with lists of data Day 3 Using jQuery Mobile with PhoneGap applications Presenting Lists of Data Handling Touch Events Packaging your apps
2064 Introduction to HTML 5 14 hours Introduction Background Audience Scope History Design notes HTML vs XHTML Structure of this specification A quick introduction to HTML Conformance requirements for authors Recommended reading Common infrastructure Terminology Conformance requirements Case-sensitivity and string comparison UTF-8 Common microsyntaxes URLs Fetching resources Common DOM interfaces Namespaces Semantics, structure, and APIs of HTML documents Documents Elements APIs in HTML documents Interactions with XPath and XSLT Dynamic markup insertion The elements of HTML The root element Document metadata Scripting Sections Grouping content Text-level semantics Edits Embedded content Tabular data Forms Interactive elements Links Common idioms without dedicated elements Matching HTML elements using selectors Loading Web pages Browsing contexts The Window object Origin Session history and navigation Browsing the Web Offline Web applications Web application APIs Scripting Base64 utility methods Timers User prompts System state and capabilities: the Navigator object User interaction The hidden attribute Activation Focus Assigning keyboard shortcuts The contenteditable attribute Spelling and grammar checking Drag and drop Editing APIs The HTML syntax Writing HTML documents Parsing HTML documents Serializing HTML fragments Parsing HTML fragments Named character references The XHTML syntax Writing XHTML documents Parsing XHTML documents Serializing XHTML fragments Parsing XHTML fragments Rendering Introduction The CSS user agent style sheet and presentational hints Replaced elements Bindings Frames and framesets Interactive media Print media Obsolete features Obsolete but conforming features Non-conforming features Requirements for implementations IANA considerations text/html text/html-sandboxed application/xhtml+xml text/cache-manifest
1951 Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server 14 hours The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. Review of Structured Query Language DQL, DML, DDL The GROUP BY, HAVING Clause Sub-queries and Correlated Sub-queries Advanced Update & Delete Statements Sub-queries Correlated Sub-queries Procedural Programming Variables Control-Of-Flow Statements IF, WHILE, CASE, GOTO, RETURN Managing Errors Responding To Errors RAISERROR PRINT Using Transactions Introduction To Transactions Transaction Isolation Levels Deadlocks Transactional Error Handling Implementing Cursors Declaring Cursors OPEN, FETCH, CLOSE DEALLOCATE CURRENT OF Stored Procedures Creating Stored Procedures Passing values into a Stored Procedure Returning Information From Stored Procedures Altering Stored Procedures Triggers Creating Triggers Transactional Error Handling Using Inserted and Deleted Tables
162 Enterprise Java Programming with Java EE and JBoss (EJB 3.0) 28 hours This 4-day course is for programmers who already know the Java language and wish to exploit the Enterprise Java Beans 2.0 technology while becoming aware of the security implications of distributing applications. This course has a large practical component which includes developing an e-commerce application based on Enterprise Java Beans. The course uses the JBoss Application Server. Enterprise Java Programming From client-server to 3-tier architecture Design considerations Security considerations Naming Services Comparison of RMI, CORBA and EJB Java Naming and Directory Interface (JNDI) JNDI Architecture Service Providers and the Service Provider Interface The Initial Naming Context Looking up objects Creating, searching and destroying directory entries Exercise 1: JNDI File Search Introducing Enterprise Java Beans (EJB) EJB concepts and versions Component Transaction Monitors Commercial implementations The EJB Architecture Persistence and transactions Java EE and EJB Deployment The JEE environment and tools Configuring Java EE JEE and JNDI Naming EJB packaging and deployment The deployment tool The Hypersonic Database Exercise 2: Set up JBoss EJB Clients Types of client Java clients Web and JSP clients Servlets and WAR files Exercise 3: Write and Deploy a Servlet Client JPA The role of an JPA Configuring an JPA Exercise 4: JPA/li> Stateless Session Beans The roles of Session Beans Creating Session Beans Stateless Session Beans Exercise 6: Stateless Session Bean Stateful Session Beans Stateful Session Beans Exercise 7: Stateful Session Bean EJB Implementation Issues Meta data Transaction management 1-1, 1-many, many-1 and many-many associations EJB versions The Java Messaging System The Java Messaging System (JMS) Exercise 8: JMS Security Users and roles Access control Authentication Exercise 9: JBoss Security Message Driven Beans The Message Driven Enterprise Bean Exercise 10: Message Driven Bean
2547 IIS 7 and ASP.NET Administration 21 hours Teaches attendees the fundamentals of administering IIS 7 and applications on the .NET platform. The course is a mixture of lectures and hands-on exercises. Delegates learn by doing, with immediate opportunities to apply the material they learn to real-world problems. Introducing the .NET Platform The .NET Common Language Runtime and Framework Class Library Review of applications that .NET can be used to create ASP.NET web forms and web services ASP.NET web forms versus ASP.NET MVC applications Classic versus WCF services Introduction and IIS 7 Architecture Integrated Pipeline Mode Extensibility and Modularity IIS Manager Extensibility Metabase (gone!) WAS and the Worker Process Installing IIS 7 Clean Installation Upgrade Installation Adding Features to an Existing Installation Automated Installation and Configuration Server Core Command-Line Installation Hosting Service Recommendations Administration IIS Manager IIS Manager Extensibility Configuration Settings (walking tour) Using the Configuration Editor (add-on for IIS 7.0; standard in IIS 7.5) Command-Line Management Command-Line Management with PowerShell Overview of PowerShell Getting a list of the IIS 7/7.5 PowerShell cmdlets New cmdlets in IIS 7.5 Hands-on work with some of the most useful cmdlets Fundamentals of Web Site Management Web Sites, Applications, and Virtual Directories Creating a New Web Site Configuring Logging Configuring Host Headers Administering Applications Administering Virtual Directories Configuring Compression Configuring MIME Settings Basic Administrative Tasks Web Application Administration [only sections relevant to your environment would be covered] ASP ASP.NET ISAPI CGI FastCGI (including the FastCGI interface available as an add-on in IIS 7.0 or standard in IIS 7.5) Web Application Pool Administration Understanding Web Application Pools Virtual Directories versus Applications Understanding the w3wp.exe Process Application Pool Security Advanced Settings Application Pool Users Packaging and Deployment Overview of Options for ASP.NET application deployment ClickOnce Building an installer package Handling deployment of updated applications Versioning applications and managing the deployment of updated applications Delegating Remote Administration Introducing the Main Characters IIS 7 Manager Remote Access Delegation Settings Securing IIS 7 Types of Attacks Securing the Server Securing IIS 7 Using the Request Filter (configuration GUI is an add-on in IIS 7.0; standard in IIS 7.5) Rewriting URLs with the Rewrite module (available as an add-on from iis.net) Authentication and Authorization Authentication Types Configuring the Authentication Types in Use in Your Organization Understanding IIS 7 User Accounts SSL and TLS Securing a Web Site with TLS Requiring SSL or TLS Client Certificates Monitoring and Performance Tuning How to Monitor IIS 7 IIS Performance Tuning Techniques Monitoring and tuning your .NET code Performance tuning suggestions for .NET applications Diagnostics and Troubleshooting Common Issues Runtime Status and Control API IIS 7 Error Pages Failed Request Tracing Error Logging Access Logging ASP.NET Tracing IIS Troubleshooting Strategies ASP.NET Troubleshooting Strategies Log4net and other approaches for systematically integrating logging into your applications Using Additional IIS 7 Built-In Tools Using Installable IIS 7 tools Configuring and Load Balancing Web Farms IIS 7 and Web Farms Content Configuration Content Replication Complete Redundancy Load Balancing Other Considerations Looking Ahead to IIS 8
2626 MATLAB Programming 14 hours This two-day course provides a comprehensive introduction to the MATLAB® technical computing environment. The course is intended for beginner users and those looking for a review. No prior programming experience or knowledge of MATLAB is assumed. Themes of data analysis, visualization, modeling, and programming are explored throughout the course. Working with the MATLAB user interface Entering commands and creating variables Analyzing vectors and matrices Working with data types Automating commands with scripts Writing programs with logic and flow control Writing functions Visualizing vector and matrix data Working with data files Importing data Organizing data Visualizing data
287854 Octave for Data Analysis 14 hours Audience: This course is for data scientists and statisticians that have some familiarity statistical methods and would like to use the Octave programming language at work. The purpose of this course is to give a practical introduction in Octave programming to participants interested in using this programming language at work.   environment data types: numeric string, arrays  matrices variables  expressions  control flow  functions exception handling  debugging input/output  linear algebra  optimization statistical distributions  regression plotting
2594 Programming in C 21 hours The course is prepared for beginning programmers. A Brief History of C Programming Language Basic Instructions Data types Keywords Operators and their priorities Retrieving and Displaying Data Printf formatting instructions and scanf Operators Functions, macros Structures Indicators Pointers to variables Pointers to functions Pointers to variables in the structure Dynamic memory allocation Malloc function Recursion Functions with a variable number of parameters unions bit fields Basic functions of the library Libraries math, stdio, stdlib, time Introduction to algorithms and data structures * Unidirectional list Tree Sorting algorithms * Optional topics
2491 Visual Basic for Applications (VBA) for Analysts 21 hours The course is designed for users of Excel for creating analyzes and reports. Macros Recording and editing macros Where to store macros. Assigning macros to forms, toolbars, keyboard shortcuts VBA Environment Visual Basic Editor and its options Keyboard Shortcuts Optimizing the environment Introduction to procedural programming Procedures: Function, Sub The data types The conditional statement If...Then....Elseif....Else....End If Instruction Case Loop while, until Loop for ... next Instructions break the loop(exit) Strings Combining strings (concatenation) Conversion to other types - implicit and explicit Features processing strings Visual Basic Download and upload data to a spreadsheet (Cells, Range) Download and upload data to the user (InputBox, MsgBox) The declaration of variables The extent and lifetime of variables Operators and their priorities Options modules Create your own functions and use them in a sheet Objects, classes, methods and properties Securing code Security code tampering and preview Debugging Processing step Locals window Immediate window Traps - Watches Call Stack Error handling Types of errors and ways to avoid Capturing and handling run-time errors Structures: On Error Resume Next, On Error GoTo label, On Error GoTo 0 Excel Object Model The Application object Workbook object and a collection of Workbooks Worksheet Object and Collection Worksheets Objects ThisWorkbook, ActiveWorkbook, ActiveCell .... Object Selection Collection Range Object Cells Display data on the statusbar Optimization using ScreenUpdating The time measurement by the method Timer The use of external data sources Using ADO library References to external data sources ADO objects: Connection Command Recordset Connection string Create connections to different databases: Microsoft Access, Oracle, MySQL Reporting Introduction to the SQL language The basic structure of SQL (SELECT, UPDATE, INSERT INTO, DELETE) Calling a Microsoft Access query from Excel Forms to support the use of databases
2209 Expert Advisor Programming 7 hours An introduction to MQL Introduction to MetaEditor Basic Concepts Layout of an MQ4 File Order Placement Bid, Ask and Spread Order Types The Order Placements Process OrderSend() Calculating Stop Loss and Take Profit Retrieving Order Information Closing Orders A Simple Expert Advisor Advanced Order Placement Order Modification Verifying Stops and Pending Order Prices Calculating Lot Size Other Considerations Putting It All Together Working with Functions Add Stop Loss and Take Profit Using Include Files Using Libraries A Simple Expert Advisor (with Functions) Order Management The Order Loop Order Counting Trailing Stops Updating the Expert Advisor Order Conditions and Indicators Price Data Indicators Indicator Constants Evaluating Trade Conditions Comparing Indicator Values Across Bars Working with Time and Date Datetime Variables Date and Time Functions Creating a Simple Timer Execute on Bar Open Tips and Tricks Escape Characters Using Chart Comments Check Settings Demo or Account Limitations MessageBox() Email Alerts Retry on Error Using Order Comments as an Identifier Margin Check Spread Check Multiple Orders Global Variables Check Order Profit Martingale Debugging Your Expert Advisor Custom Indicators and Scripts Buffers Creating a Custom Indicator Scripts
2063 Introduction to Firebird 14 hours Classic, SuperClassic or Superserver? Installation packages Embedded Server for Windows What is in the kit? Default disk locations Linux Windows Installing Firebird Installing the Firebird server Installing multiple servers Testing your installation Performing a client-only install Server configuration and management User management: gsec Security Windows Control Panel applets Administration tools Working with databases Connection strings Connecting to an existing database Creating a database using isql Firebird SQL Protecting your data Backup How to corrupt a database
1950 ORACLE PL/SQL Fundamentals 21 hours This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands. The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements. Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database. Introduction Aims and Objectives Course Schedule Introductions Pre-requisites Responsibilities SQL Tools Objectives SQL Developer SQL Developer - Connection Viewing Table Information Using SQL, SQL Developer - Query SQL*Plus Login Direct Connection Using SQL*Plus Ending the Session SQL*Plus Commands SQL*Plus Environment SQL*Plus Prompt Finding Information about Tables Getting Help Using SQL Files iSQL*Plus, Entity Models The ORDERS Tables The FILM Tables Course Tables Handout SQL Statement Syntax SQL*Plus Commands What is PL/SQL? What is PL/SQL? Why Use PL/SQL? Block Structure Displaying a Message Sample Code Setting SERVEROUTPUT Update Example, Style Guide Variables Variables Datatypes Setting Variables Constants Local and Global Variables %Type Variables Substitution Variables Comments with & Verify Option && Variables Define and Undefine SELECT Statement SELECT Statement Populating Variables %Rowtype Variables CHR Function Self Study PL/SQL Records Example Declarations Conditional Statement IF Statement SELECT Statement Self Study Case Statement Trapping Errors Exception Internal Errors Error Code and Message Using No Data Found User Exceptions Raise Application Error Trapping Non-defined Errors Using PRAGMA EXCEPTION_INIT Commit and Rollback Self Study Nested Blocks Workshop Iteration - Looping Loop Statement While Statement For Statement Goto Statement and Labels Cursors Cursors Cursor Attributes Explicit Cursors Explicit Cursor Example Declaring the Cursor Declaring the Variable Open, Fetching the First Row Fetching the Next Row Exit When %Notfound Close For Loop I For Loop II Update Example FOR UPDATE FOR UPDATE OF WHERE CURRENT OF Commit with Cursors Validation Example I Validation Example II Cursor Parameters, Workshop Workshop Solution Procedures, Functions and Packages Create Statement Parameters Procedure Body Showing Errors Describe a Procedure Calling Procedures Calling Procedures in SQL*Plus Using Output Parameters Calling with Output Parameters Creating Functions Example Function Showing Errors Describe a Function Calling Functions Calling Functions in SQL*Plus Modular Programming Example Procedure Calling Functions Calling Functions In An IF Statement Creating Packages Package Example Reasons for Packages Public and Private Sub-programs Showing Errors Describe a Package Calling Packages in SQL*Plus Calling Packages From Sub-Programs Dropping a Sub-Program Finding Sub-programs Creating a Debug Package Calling the Debug Package Positional and Named Notation Parameter Default Values Recompiling Procedures and Functions Workshop Triggers Creating Triggers Statement Triggers Row Level Triggers WHEN Restriction Selective Triggers - IF Showing Errors Commit in Triggers Restrictions Mutating Triggers Finding Triggers Dropping a Trigger Generating an Auto-number Disabling Triggers Enabling Triggers Trigger Names Sample Data ORDER Tables FILM Tables EMPLOYEE Tables Dynamic SQL SQL in PL/SQL Binding Dynamic SQL Native Dynamic SQL DDL and DML DBMS_SQL Package Dynamic SQL - SELECT Dynamic SQL - SELECT Procedure Using Files Using Text Files UTL_FILE Package Write/Append Example Read Example Trigger Example DBMS_ALERT Packages DBMS_JOB Package COLLECTIONS %Type Variables Record Variables Collection Types Index-By Tables Setting Values Nonexistent Elements Nested Tables Nested Table Initialisation Using the Constructor Adding to a Nested Table Varrays Varray Initialization Adding Elements to a Varray Multilevel Collections Bulk Bind Bulk Bind Example Transactional Issues BULK COLLECT Clause RETURNING INTO Ref Cursors Cursor Variables Defining REF CURSOR Types Declaring Cursor Variables Constrained and Unconstrained Using Cursor Variables Cursor Variable Examples
116 Introduction to CSS 7 hours Introduction to CSS, for web page developers, designers, web producers. CSS Basic CSS Introduction CSS Syntax CSS Background CSS Text CSS Font CSS Box Model CSS Border CSS Outline CSS Margin CSS Padding CSS List CSS Table CSS Advanced CSS Dimension CSS Classification CSS Positioning CSS Pseudo-class CSS Pseudo-element CSS Image Gallery CSS Image Opacity CSS Media Types CSS Don't CSS Summary
287873 IIS 8 and ASP.NET Administration 21 hours Teaches attendees the fundamentals of administering IIS 8 and applications on the .NET platform. The course is a mixture of lectures and hands-on exercises. Delegates learn by doing, with immediate opportunities to apply the material they learn to real-world problems. Introducing the .NET Platform The .NET Common Language Runtime and Framework Class Library Review of applications that .NET can be used to create ASP.NET web forms and web services ASP.NET web forms versus ASP.NET MVC applications Classic versus WCF services   IIS 8 Architecture Integrated Pipeline Mode Extensibility and Modularity IIS Manager Extensibility WAS and the Worker Process   Installing IIS 8 Clean Installation Upgrade Installation Adding Features to an Existing Installation Automated Installation and Configuration Server Core Command-Line Installation Hosting Service Recommendations   Administration Tools IIS Manager and Extensibility Configuration Settings Command-Line Management Command-Line Management with PowerShell Overview of PowerShell Getting a list of the IIS 8 PowerShell cmdlets New cmdlets in IIS 8 Hands-on work with some of the most useful cmdlets   Fundamentals of Web Site Management Web Sites, Applications, and Virtual Directories Creating a New Web Site Configuring Logging Configuring Host Headers Administering Applications Administering Virtual Directories Configuring Compression Configuring MIME Settings Basic Administrative Tasks   Web Application Administration ASP ASP.NET ISAPI CGI FastCGI Application Initialization   Web Application Pool Administration Understanding Web Application Pools Virtual Directories versus Applications Understanding the w3wp.exe Process Application Pool Security Advanced Settings Application Pool Users   Packaging and Deployment Overview of Options for ASP.NET application deployment Building an installer package Handling deployment of updated applications Versioning applications and managing the deployment of updated applications   Delegating Remote Administration Introducing the Main Characters IIS 8 Manager Remote Access Delegation Settings   Securing IIS 8 Types of Attacks Securing the Server Securing IIS 8 Using the Request Filter Rewriting URLs with the Rewrite module (available as an add-on from iis.net)   Authentication and Authorization Authentication Types Configuring the Authentication Types in Use in Your Organization Understanding IIS 8 User Accounts   SSL and TLS Securing a Web Site with TLS Requiring SSL or TLS Client Certificates   Monitoring and Performance Tuning How to Monitor IIS 8 IIS Performance Tuning Techniques Monitoring and tuning your .NET code Performance tuning suggestions for .NET applications   Diagnostics and Troubleshooting Common Issues Runtime Status and Control API IIS 8 Error Pages Failed Request Tracing Error Logging Access Logging ASP.NET Tracing IIS Troubleshooting Strategies ASP.NET Troubleshooting Strategies   Load Balancing Web Farms IIS 8 and Web Farms Content Configuration Content Replication Complete Redundancy Load Balancing
287852 Software Engineering 35 hours Software Engineering starts where programming stops. In this course you will learn a solid foundation in Software Engineering. It builds a bridge from programming to solid engineering practices. The course gives you an overview of basic concepts and vocabulary typically used in the field. During the course, you will learn to use many techniques to plan, implement and validate software projects and to evaluate and improve development processes. Audience: This course is intended for software developers with various backgrounds who know at least one programming language. Day 1: Process Introduction What is Systems Engineering? What is Software Engineering? Why is Software Engineering difficult? System requirements System modeling Software Engineering Processes What is a Software Development Process? Traditional Processes Agile Processes Processes for building High-Integrity Systems Standards & certification systems High-Integrity Systems What are High-Integrity Systems? The role of QM culture Reasons for errors Critical systems standard Reliability engineering Software Maintenance Day 2: Planning Requirements User requirements Elicitation/analysis of user requirements System requirements Software requirements Specification of software Requirements process Tools to manage requirements Software Design Conways Law Design patterns Textual modeling tools Principles of OO design Design tools Common architectures Modeling Planning an architecture UML graphical representations Non-UML graphical representations Day 3: Code Software Construction How to take a design into code Programming best practices Abstraction of code Programming workflow Configuration Management What is Configuration Management? Configuration Management in ISO9000 and CMMI CASE tools for planning, design & QA CASE tools for writing software Version control with SVN System Integration Code for High-Integrity Systems Preventing errors Catching errors Reducing the impact of errors Typical problems with code for High-Integrity Systems Code quality metrics Code size metrics Code complexity metrics Non-code metrics Static analysis Day 4: Verification & Validation Reviews Fundamentals of VV Independent Verification & Validation Design and requirement reviews Code inspections Software Walkthroughs Audits Other V & V methods Testing High-Integrity Systems Documents regarding safety Scenarios Argumentation for safety Reviews of High-Integrity Systems Predicting reliability Formal methods Costs of V + V Automated Testing Why test? Automatic vs manual tests Incremental testing Types of tests Testing tools Test Harnesses Day 5: Management Project Management What is Project Management? Customer handover Standards (PMP, PRINCE2) Time management Cost management Risk management Project documentation Process Evaluation The function of process evaluation Acting on the metric Process metrics Process evaluation standards & frameworks (CMMI, ISO 9001, TickIt+) Process evaluation meetings Summary and Conclusions
287836 AngularJS Basics 14 hours Angular JS (AKA Angular) is a JavaScript library for rapid app development. Audience developers programmers javascript architects Format of the course 40% lectures, 60% labs Introduction Why AngularJS? Alternatives Extensibility The basics: Add some control Data Binding Controller Plain JavaScript Wire up a Backend Deep Linking Form Validation Server Communication Create Components Directives Reusable Components Localization Embed and Inject Embeddable Injectable Testable
287845 Oracle SQL Intermediate 14 hours Listeners All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge. Format of the course 25% lectures, 75% labs Create complex queries to databases Use available operators Queries with multiple conditions Creating tables and references DDL commands (create, alter, and drop) Create referential integrity Normalization of tables (up to 3 normal form) anomalies and ways to avoid them Changes in the structure of existing tables ALTER clause Manipulation of data DML commands (insert, update, delete) Creating new users and granting permissions DCL commands (grant, revoke) Linking Tables Internal and external joins Data Aggregation Features of grouping functions Use the GROUP BY clause and HAVING Grouping multiple column Subqueries multi-column correlated WITH clause
2585 Design Patterns - efficient code reusability 21 hours The course will cover the design patterns. We provide design patterns trainings divided in two groups: Core patterns include (selected patterns from GoF package) some basic design patterns used throughout all modern applications and systems. They significantly increase productivity and decrease complexity of these applications introducing ready and checked ways to accomplish certain functionalities. Creational patterns: Builder Factory Prototype Singleton Structural patterns: Delegator Interface Facade Composite Immutable Adapter Decorator Activity patterns: Interpreter Command Template method Observer Proxy Java EE Patterns include (SUN Microsystems selected patterns). This selection of patterns helps to build and maintain complex and huge Java EE based projects. Following design patterns simplify design via introduction of multi-tier application design and well controlled responsibility flow. View tier patterns: Intercepting filter Front controller Application controller View helper Composite view Dispatcher view Business tier patterns: Business delegate Service locator Session facade Application service Business object Value object Integration tier patterns: Data Access Object Service activator Web service broker
2483 Android - The Basics 28 hours Android System Architecture. Operating environment Discussion of the overall architecture of the system Android (Linux kernel, core libraries, JVM, etc.) Preparation of the working environment (Eclipse + Android SDK). Methods of debugging the program. Discussion of tools such as adb, draw9patch, DDMS, emulator, etc. Activity life cycle. Implementation and performance analysis methods onCreate, onStart, OnResume, OnPause, OnDestroy. Data structure design androidowego (src directories, res, xml file AndroidManifest.xml, permissions) The rules for creating layouts. Examples of Linear-class implementation, Frame-, table-, RelativeLayout. Implementation loading layouts from XML files and from within the application. Gravity class. Create menus and dialogs. Implementation and event handling class menu and classes that inherit the dialogue. Support graphics and touch interface Review and implementation of the View class methods and drawable. Gestures - touch event processing. The implementation class methods TouchEvent implementation of the basic 'building blocks' of the software for Android. Implementation classes TextView, Button, Checkbox, ListView, etc.) Notification class implementation Access to the other activities and services running in the background, multithreading Intent class overview - what it does. Running other activities. Implementation of the method startActivity () and onActivityResult (). Starting and communication services operating in the background. Discussion and implementation methods of the class Service. broadcasts Threads and Multithreading. Implementation AsyncTask class. Synchronization. Implementation synchronize blocks and synchronized methods. Service Location The basic theoretical information about GPS, WGS84, digital maps (GoogleMaps, OpenStreetMap, BingMaps, etc.) Event handling GPS. Implementation LocationListener class methods. Drawing icons and objects on the map. Extracting the coordinates of the click on the map. Other Service settings are stored on the device. Class Preferences. Access to remote network services. Implementation classes HttpPost / HttpGet. parsing data structures in XML and JSON. Read and write files on the device. SQLite CONTENTMANAGER. Sensors, Cameras, OpenGL.
2184 Windows Forms with C#.Net 35 hours Objectives This course will enable delegates to develop Windows applications using Visual Studio 2005. This includes creating customised forms and controls. It will also cover the C# programming language, using the principles of object orientated programming. Delegates will be able to access data from a database and update this from a Windows form. Audience This workshop is intended for software developers who have a desire to learn more about specific technology areas in Windows application development. Getting started with .Net What is .Net? Overview of the framework class libraries Understanding the Common Language Runtime (CLR) Compiling an application to a assembly A tour of the Visual Studio 2005 IDE C# Language Fundamentals Data Types Variables Constants Strings Statements Expressions Branching Conditional branching statements Unconditional branching statements Loops Operators Assignment Mathematical operators Increment & decrement Relational Strings Creating strings Manipulating strings The StringBuilder class Debugging Setting a breakpoint Stepping through lines of code The debugging windows The call stack Throwing and Catching Exceptions The throw statement The try, catch and finally statements How the call stack works Exception class methods and properties Principle of Object Orientation Creating models of systems Classes & objects Encapsulation, specialisation & polymorphism Classes and Objects Defining classes Creating class constructors Static and instance members Destroying objects Inside Methods Overloading methods Encapsulating data with properties Returning multiple values Inheritance and Polymorphism Specialisation and generalisation Inheritance Polymorphism Abstract and sealed classes The root class: object Boxing and unboxing types Interfaces Implementing and interface Implementing more than one interface Casting to an interface Extending and interface Delegates and Events Using delegates Using events Generics Type parameter for classes and methods Limit generic classes to hold only certain types of data Generic collections Building Applications with Windows Forms Why use windows forms? Structure of windows forms Windows forms class hierarchy Using windows forms Using controls New controls in visual studio 2005 Click-once deployment Customizing Windows Forms and Controls Methods of authoring controls for windows forms Windows forms inheritance Creating the base form Creating the inherited form Creating custom controls Data Access List the benefits of ADO.NET Create applications by using ADO.NET List the main ADO.NET objects and their functions Use Visual Studio NET data designers and data binding Explain how XML integrates with ADO.NET Performing Asynchronous Tasks by Using Multithreaded Techniques Techniques for asynchronous programming Load a bitmap into a windows forms application asynchronously. Using multithreading to perform simultaneous operations Using the background worker component Synchronising data between threads
2011 PowerShell Master Class 21 hours To learn the fundamentals of PowerShell from the command line and via scripts To take a deep dive in to the underlying technologies in use with PowerShell To learn how to automate common operations using PowerShell We will look at PowerShell in Windows and in Windows Servers such as SQL, Exchange and System Center Overview PowerShell and The Holy Trinity Discovery Formatting Remoting Providers Scripting concepts Modules .NET, WMI and COM Objects PowerShell and Windows Server/Client PowerShell in Key Microsoft Servers Taking it to the Next Level The Basics Discovery – finding your way and discovering more Formatting – how to format output nicely Remoting – working with remote systems Providers – getting into OS data stores Diving Deep Scripting Concepts – automating everyday tasks including language constructs, error handling and debugging Modules – managing PowerShell in the enterprise .NET/WMI/COM objects – working with objects Practical PowerShell PowerShell and Windows Client/Server – how you can use built in PowerShell cmdlets PowerShell in Key Microsoft Servers  - a look at PowerShell today in SQL, SCVMM plus a look forward to the future with SharePoint 2010 Taking it to the Next Level – the stuff we can’t cover in these three days PowerShell Fundaments – the key elements of PowerShell plus installation, setup, profiles
1949 ORACLE SQL Fundamentals 21 hours This 3 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2. The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements. Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database. Introduction Overview Aims and Objectives Sample Data Schedule Introductions Pre-requisites Responsibilities Relational Databases The Database The Relational Database Tables Rows and Columns Sample Database Selecting Rows Supplier Table Saleord Table Primary Key Index Secondary Indexes Relationships Analogy Foreign Key Foreign Key Joining Tables Referential Integrity Types of Relationship Many to Many Relationship Resolving a Many-to-Many Relationship One to One Relationship Completing the Design Resolving Relationships Microsoft Access - Relationships Entity Relationship Diagram Data Modelling CASE Tools Sample Diagram The RDBMS Advantages of an RDBMS Structured Query Language DDL - Data Definition Language DML - Data Manipulation Language DCL - Data Control Language Why Use SQL? Course Tables Handout SQL*Plus SQL*Plus Login Easy Connect Using /NOLOG Using SQL*Plus Ending the Session SQL*Plus Commands SQL*Plus Environment SQL*Plus Prompt LOGIN.SQL File Changing the Password Finding Information about Tables Getting Help Where Clause Using SQL Files iSQL*Plus SQL*Plus Commands Data Retrieval SQL Developer SQL Developer - Connection Viewing Table Information Using SQL, Where Clause Using Comments Character Data Users and Schemas AND and OR Clause Using Brackets Date Fields Using Dates Formatting Dates Date Formats TO_DATE TRUNC Date Display Order By Clause DUAL Table Concatenation Selecting Text IN Operator BETWEEN Operator LIKE Operator Common Errors UPPER Function Single Quotes Finding Metacharacters Regular Expressions REGEXP_LIKE Operator Null Values IS NULL Operator NVL Accepting User Input Data Definition Creating a Table Datatypes Simple Create Example Naming Tables Constraints Not Null Primary Key Foreign Key Check Unique Altering Constraints Full Create Example Data Dictionary Alter Table Secondary Indexes B-tree Index Bitmap Index Create Index Explain Plan Using Indexes Clusters Partitioned Tables Creating a Partitioned Table Rename Drop Statement Flashback Table Managing the Recycle Bin Data Update Insert Some Values Insert All Values Insert Date Values Insert TO_DATE Default Values Using Substitution Variables Transactions Commit Rollback Using Constraints Update Date Arithmetic Update TO_DATE TRUNC Delete Truncate Sequences Grant Create Synonym Create Public Synonym Locking Revoke Savepoint Auto Commit Multi-Table Retrieval Calculations Precedence ROUND Function Column Alias Date Arithmetic Using Aliases CEIL and FLOOR Cartesian Product Table Join Table Alias Selecting the Join Column Joining without Selecting Views Dropping Views Finding Views Derived Columns With Check Option Snapshot Views Flashback Query Using Functions TO_CHAR TO_NUMBER LPAD RPAD NVL NVL2 Function DISTINCT Option SUBSTR INSTR Date Functions Aggregate Functions COUNT Group By Clause Rollup and Cube Modifiers Having Clause Grouping By Functions DECODE CASE Workshop Sub-Query & Union Single Row Sub-queries Union Union - All Intersect and Minus Multiple Row Sub-queries Union – Checking Data Outer Join More On Joins Joins Cross Join or Cartesian Product Inner Join Implicit Join Notation Explicit Join Notation Natural Join Equi-Join Cross Join Outer Joins Left Outer Join Right Outer Join Full Outer Join Using UNION Join Algorithms Nested Loop Merge Join Hash Join Reflexive or Self Join Single Table Join Workshop Advanced Queries ROWNUM and ROWID Top N Analysis Inline View Exists and Not Exists Correlated Sub-queries Correlated Sub-queries with Functions Correlated Update Snapshot Recovery Flashback Recovery All Any and Some Operators Insert ALL Merge Sample Data ORDER Tables FILM Tables EMPLOYEE Tables The ORDER Tables The FILM Tables PL/SQL What is PL/SQL? Why Use PL/SQL? Block Structure Sample Code SELECT Statement Using Variables Accepting User Input Exceptions Other DML Statements Creating Procedures Showing Errors Describe a Procedure Calling Procedures Creating and Running Functions Showing Errors Describe a Function Calling Functions Creating Triggers Showing Errors Query Optimisation Query Optimisation Creating The Tables Timing SQL Statements Other Timing Statements Explain Plan Creating the PLAN_TABLE Table Using SET AUTOTRACE Collecting Statistics Primary Key Secondary Indexes The Query Optimizer Rule Based Optimization Cost Based Optimization Choose Keyword Gathering Statistics Optimizer Hints How to Specify Hints Using Indexes Index Types B*tree Indexes Bitmap Indexes Index-organized table When to Create Indexes Choosing Composite Indexes Using Objects Object-oriented Database Object-relational Database Creating Objects Creating Tables with Objects Using Objects in Tables Large Object Support LOB Datatypes Creating Tables with LOBs Inserting an Empty LOB Creating Tables with BFILEs Creating Directories for BFILEs Inserting a BFILE SQL*PLUS REPORTS Objectives ACCEPT and PROMPT Define and Undefine Creating an SQL*Plus Report Break Command Compute Command Saving the Output in a File Utilities What is a Utility? Export Utility Using Parameters Using a Parameter file Import Utility Using Parameters Using a Parameter file Unloading Data Batch Runs SQL*Loader Utility Running the Utility Appending Data
51 Javascript And Ajax 35 hours This course has been created for web site developers who want to understand and use Javascript and Ajax. Browser and Document Objects When to Use JavaScript The Document Object Model When a Document Loads Object References Node Terminology Scripts and HTML Documents Where Scripts Go into Documents JavaScript Statements When Script Statements Execute Viewing Script Errors Programming Fundamentals Variables Expressions and Evaluation Data Type Conversions Operators Decisions and Loops Control Structures Functions The String Object, Date Object, Array Object The Regular Expression and RegExp Objects Control Structures and Exception Handling Debugging Scripts Document Object Model Essentials The Object Model Hierarchy Object Properties, Methods, Event Handlers The W3C DOM Generic HTML Element Objects Window and Frame Objects Location and History Objects The Document and Body Objects The Form and Related Objects Button Objects Text-Related Form Objects Select, Option and FileUpload Objects Event Objects Style Sheet and Style Objects Functions and Custom Objects Function Object Function Application Notes Creating Your Own Objects with Object-Oriented JavaScript Object-Oriented Concepts Creating Ajax Applications What Can You Do with Ajax? JavaScript's role Interacting with Server-Side Code Passing Data to Server-Side Scripts Using Ajax with XML Ajax in Depth Working with Multiple Concurrent XMLHttpRequest Requests Handling JavaScript Sent from the Server Calling Another Domain in Ajax Working with Ajax and Head Requests Eliminate Caching Introducing Ajax Frameworks Using the Ajax Utility Library Using libXmlRequest to Download XML Using AJAXLib to Download XML Majax, Sack, XHConn, uniAjax Framework Using Server-Side Ajax Frameworks XML and Ajax Retrieving Data from an XML Document Accessing XML Data Directly and Attributes Values Validating your XML Ajax And Security Protecting Against Malicious Users Looking at the Security Issues with Proxy Servers Handling Security in Ajax Applications Ajax And Web Implementations Ajax And Validations Ajax And Dynamic Loading Ajax And Progress Bars Ajax And Dynamic Tool tips Ajax and Web Services Ajax and Autocomplete
287911 Object Oriented Design using Design Patterns 14 hours Objective: Helping Technical Analysts and Designers to understand how to go through software implementation of the requirements, ensuring traceability between business specifications and the software code. This 2 day training course aims at assisting technical analysts and designers in designing specifications described by the business analysts. After transformation into software component representations, the resulting system components trace system requirements toward software component structures. Finally, these technical specifications are implemented in software code and tested upon component basis. The resulting software components provide good level of reactivity to changes as they allow to trace separately toward the implementation level the system behaviours layer by layer (from the user interfaces toward business objects layer through the application components where the usage choices of the actors are stored. Introduction What is the System Analysis and Design Process? Place of the Analysis and Design activities in the Unified Process (RUP) A panorama of UML 2 diagrams used in the system analysis and design Frameworks for tracing requirements toward software implementation and tests How to transform requirements into component based analysis specifications? Traceability between requirements and system analysis Advanced notions for representing the system structure and dynamics Refinement of the requirements on both axis Toward the system design using operation contracts Case Study : Definition of the analysis component model of the system How to transform analysis specifications into design level ones? Traceability between system analysis and design Design Patterns for loose coupling and high cohesion of components Definition of the Design level Architectural Backbone of the system (components, ports, interfaces, exchange objects) Design level interaction diagrams to implement operation contracts Case Study : Updating design level component diagram with architectural choices Implementing technical specifications and testing on a component basis Generating design level specifications into an object oriented programming language Deployment of Components on the Physical Nodes Integration and Acceptance tests on the basis of the previous specifications Conclusion Steps of the system analysis and design processes Patterns for ensuring traceability between requirements and the software code Testing requirements on the system architecture Notice: The above training-mentoring sessions are conducted interactively using Requirement Engineering and Modeling tools in order to ensure good level of traceability between requirements and underlying solutions. Concepts are explained first using basic examples and are then followed by solution drafts to your own issues. After this session, we can accompany you by reviewing and validating your solutions depending on your needs.
287808 Machine Learning Fundamentals with Python 14 hours The aim of this course is to provide a basic proficiency in applying Machine Learning methods in practice. Through the use of the Python programming language and its various libraries, and based on a multitude of practical examples this course teaches how to use the most important building blocks of Machine Learning, how to make data modeling decisions, interpret the outputs of the algorithms and validate the results. Our goal is to give you the skills to understand and use the most fundamental tools from the Machine Learning toolbox confidently and avoid the common pitfalls of Data Sciences applications. Course and outline author: Mihaly Barasz Introduction to Applied Machine Learning Statistical learning vs. Machine learning Iteration and evaluation Bias-Variance trade-off Machine Learning with Python Choice of libraries Add-on tools Regression Linear regression Generalizations and Nonlinearity Exercises Classification Bayesian refresher Naive Bayes Logistic regression K-Nearest neighbors Exercises Cross-validation and Resampling Cross-validation approaches Bootstrap Exercises Unsupervised Learning K-means clustering Examples Challenges of unsupervised learning and beyond K-means
287838 Ext JS Fundamentals 21 hours Foundation XHR/defer Ext.data – the store/data components Custom components I18n/l10n Best practice (natch) Integration with other JS libraries SASS/SCSS Architect
2580 Java Programming 28 hours This course is intended for developers who are familiar with any other procedural or structural language (such as C, Pascal, C + +, Delphi). During the training participants will learn how it is built into the Java virtual machine to install Java to write basic programs use standard libraries and create an application with a graphical interface. The course also introduces the multi-threaded programming. Introduction to Java Versions of Java Installing Virtual Machine Platform Tools Using the documentation and selected books Java Development Directions Discussion of options The syntax of the language Declarations and Data Types Simple types Reference types Flow Control Instructions Boards Object-Oriented Programming Modeling Objects: Properties and Methods Creating Objects Objects and references Classes Interfaces Packages Inheritance Abstract Classes Polymorphism Error handling exceptions The try ... catch Create your own exception types Actions inputs and outputs Streams and Filters File Handling Object Serialization Data Collections Multi-threaded Programming Multi-threaded Applications The life cycle of thread Synchronization Data protection Fundamentals of Web Application Development in Java Overview s most popular framework for creating web applications Multi-tier architecture Applications in Architecture Request / Response Call and work with the database Modeling the business application Service request and controller layer. Create views Discussion of the popular use cases
2479 GlassFish Administration 21 hours GlassFish Administration Training introduces participants to the secrets of the installation, configuration, management, monitoring GlassFish server. Training is open to future GlassFish server administrators. Introduction and Installation GlassFish Overview and architecture of Java EE GlassFish White Basic GlassFish Architecture Download and install GlassFish Starting and Stopping the GlassFish Structure and architecture File structure Server profiles, domains, and configuration Configuration Files - Setup.xml and domain.xml Login and login configuration The Admin Console The asadmin Command Line Interface Deployment The structure of the Java EE Application (Jars, Wars, Ears, Sars) GlassFish Deployment Details Deploying with the Admin Console and asadmin Deploying Using autodeploy Deploying with asant Tasks Directory (Expanded) Deployments GlassFish Classloading, and Effect on Deployment Configuration Services (Web, JNDI, Datasource, EJB, Web Service) Web Container Overview Configuring the Web Container / HTTP Service Virtual Hosts and Listeners JNDI and Naming Overview Configuration GlassFish Naming Configuration klienta JNDI Review DataSource i JCA Configuration DataSource i Connection Pool Container EJB EJB Pooling and Caching Container Management EJB Web Service Overview and Deployment Viewing, Monitoring, and Managing Web Services Messaging JMS - Java Message Service Overview GlassFish Messaging Overview - Sun Message Queue Creating Connection Factories and Destinations (Queue/Topic) Configuring the JMS Provider Safety Overview Java security EE GlassFish Security Architecture Manage Users, Groups file, JDBC, LDAP, and other Realms Password security - password encryption, Master and adminstracja password SSL / TLS and HTTPS Overview Configuring and Using GlassFish keytool Security other sites Monitoring and Tuning GlassFish Monitoring Tuning Clustering GlassFish Clustering Overview Cluster Configuration The Repository, Cluster Instances, and the DAS Clustering Architecture (Client Interceptor, Load Balancing and Fault Tolerance, State Replication) Clustered Services Load Balancers and Clustered Http Configuring Apache httpd for Use with the Load Balancer Conclusions
2182 Transact SQL Basic 14 hours Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following: Construct queries to extract and filter data from a SQL Server database Create summarised results Change, derive and format data to suit the required output Change data and maintain database components and definitions This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data. Basics Selection of all columns/fields Selection of certain columns/fields Use of distinct/unique Selection of certain rows/records Selection of values in a range Selection of values matching a pattern mask Selection of values within a list Treatment of null values How to sort and order data Selection of calculated and derived values How to control column headings in query results How to send query results to external files Joining Tables Principles of joining tables: Use of cartesian join Use of inner join Use of non-equi join Use of outer join Joining Queries Union operator Intersect operator Except operator Simple Functions Conversion functions Date functions Number functions Text functions Group/summary/aggregate functions Sub-Queries Principles of sub-queries How to filter rows from main query Use of nested sub-query Use of multi-column sub-query Use of correlated sub-query Use of sub-query as an inline view and common table expression Use of sub-query as a column in main query Case Statements Principles of case statements Use of case statement to derive column values Use of nested case statements Use of case statements to produce pivot tables Use of case statement with sub-queries Data Manipulation How to insert values into a table How to copy values between tables How to update values How to delete records How to change data via views Use of transactions How to lock rows and tables Data Definition Principles of a relational database and data normalisation Use of primary key and foreign key relationships and constraints How to create tables How to alter tables How to create views Use of synonyms How to remove tables and views
2009 Perl Programming 21 hours This course gives a comprehensive introduction to Perl programming. Running Perl programs Creating a Perl script Running Perl scripts Getting help with perldoc Variable types and contexts Scalars, lists and hashes Strings and interpolated strings Special variables Context if/else/elseif do, while, until, for and foreach Compound data structures References to named variables References to anonymous data Multidimensional arrays Multidimensional hashes Managing files and user input Standard I/O streams File handles Command line arguments Reading and writing data files Perl regular expressions Extracting important text information Perl regular expressions Altering data with substitutions Global and case-insensitive matches Perl Operators Arithmetic expressions Replicating and growing strings SAssignment operators ile attributes Logical operators Ranges Subroutines Defining and calling a subroutine Passing and receiving parameters Returning values to the caller Perl Functions String functions for text manipulation List functions Sorting data Manipulating file system entries Reading binary files split and join Formatting tabular output Object Orientation OO in Perl Methods, classes and constructors Obtaining third-party packages from CPAN How to use use Defining a schema to employ OO modules Calling methods with the -> syntax Passing initialisation parameters
1948 SQL in Microsoft Access 14 hours This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with Microsoft Access dialect of SQL. RDBMS (Relational DataBase Management System) Relational Operators SQL as Declarative Language SQL Syntax SQL Sublanguages DQL, DML, DDL, DCL DQL (Data Query Language) in Detail SELECT clause Column aliases Table aliases Date types and Date functions Group function Table joins JOIN clause UNION operator Nested queries Correlated subqueries DML (DataManipulationLanguage) Overview Inserting rows (INSERT) Inserting rows using subquery Updating rows (UPDATE) Deleting rows (DELETE) DDL (Data Definition Language) Overview Creating, altering and dropping objects (CREATE, ALTER, DROP) Creating tables using subquery (CREATE TABLE .... AS SELECT...) CONSTRAINTS Overview NULL i NOT NULL CONSTRAINT clause ENUM type SET type PRIMARY KEY UNIQUE FOREIGN KEY DEFAULT clause Transactions Overview COMMIT ROLLBACK SAVEPOINT Implicit and explicit rollbacks and commits SQL Dialects Overview MySQL Microsoft Access and SQL Server Oracle and PostgreSQL
16 Subversion for Users 7 hours This course has been created for people who need to work co-operatively. The course explains the concepts of merges, conflicts, branches, revisions and diff files. Participants will learn how to use command line tools as well as GUIs like Tortoise. Repository Basics What is a repository What should be stored in a repository Tracking file changes and history Repository URL and protocols Working With Revisions Import project Concept of working copies Checking out and exporting Checking in and writing log messages Solving conflicts Finding differences between revisions and working copy files Reverting changes Adding new files to the repository Removing, moving and renaming files in the repository and working copy Creating snapshots with tagging Switching files to a certain moment in the past Sharing Files Locking and unlocking file The Lock-Modify-Unlock Solution versus Copy-Modify-Merge Solution Branching and Merging Creating branches Merging changes Troubleshooting How to deal with not properly moved or copied files and folders Dealing with multiple working copies
287913 System Engineering using SysML and UML 2 21 hours Objective: Helping Analysts and Designers of the System Engineering domain to understand how to efficiently gather requirements then go through the embedded software design implementation on the basis of system specifications using UML 2 and SysML. This 3 days training aims at assisting system analysts to express efficiently their needs and designers to make the appropriate architectural design of the system on the basis of these needs. The resulting system architecture provides a good level of agility to the embedded system software in face of changes as it allows a coherent traceability of the business rules encapsulated in system functions and those of the usage choices (use cases) of the end-users toward the software implementation level. Introduction The System Development Life Cycle with the Harmony Process (IBM/Telelogic) Overview of the UML/SysML diagrams used in requirements gathering, system analysis and design of the System Engineering domain A Method based Framework for requirement gathering, system analysis and design Gathering Requirements and Transforming them into System Specifications Making business and system requirements traceable using the SysML requirement diagram Define the scope of the system composed of functions and use cases that invoke these functions Model the Life Cycle of the System that orchestrates transitions between its states where functions are triggered Prepare test cases using scenarios that realize Use Cases and System Functions Case Study : Model the System Scope and the usage of the system functions on the basis of requirements Transforming System Specifications into Design Level Components Model the Block Diagram of the system and refine it using internal blocks Elaborate the Communication Architecture between Sub-System using Parts, Ports and Interfaces Case Study : Elaborate the block and Internal Block diagrams on the basis of system specifications and by considering design level choices Model the description of white box Interactions at the design level Case Study : Model interactions between blocks and Internal Blocks on the basis of design level choices Mapping of Operations on the Components (Parts) of Blocks Elaborate the Parametric Diagram of the System Functions Case Study : Update the Block and Internal Block Diagrams on the basis of design level scenarios Conclusion Steps of requirement analysis and system specifications in system engineering Traceability between requirements and the software System Integration and Acceptance Tests of the requirements Notice: The above training-mentoring sessions are conducted interactively using Requirement Engineering and Modeling tools like Enterprise Architect (EA) in order to ensure good level of traceability between requirements and underlying solutions. Concepts are explained first using basic examples and are then followed by solution drafts to your own problems. After this session, we can accompany you by reviewing and validating your solutions depending on your needs. Provided by GooBiz
287806 PLC Ladder Programming 14 hours Automation Engineers, Passionates who would like to create their own intelligent home etc.PLC Basics and overview of applications with PLC Overview of PLC programming languages (Ladder, SFC, C) Simple Ladder programming Coils, Inputs, Outputs Working with memory Logical functions Advanced functionality Sample programming - exercises PLC and Networking
287821 iPhone and iPad Development using iOS 8 and Xcode 6 35 hours This 5 day course is for developers who want to learn how to develop applications for iPhone and iPad running iOS 7 or 8. The course is hands on and shows how to develop applications from scratch in Objective-C and HTML using the Xcode 5 or 6 IDE.  Development environment Native versus Web based Applications Development environment requirements Xcode and the iOS SDK Apple Developer registration Reasons why Applications get rejected Objective-C The Xcode IDE Objective-C basics Foundation Framework UIKit Framework Classes, Class Interfaces and Class Implementations Instance Variables Properties Methods Creating objects Xcode iOS Projects Human Interface Guidelines Creating an iOS project Running on simulator and real devices Memory management Strong and weak references Design Patterns and Frameworks Using Design Patterns Cocao Touch Framework Model View Controller (MVC) Pattern Other Design Patterns Protocols Views and Design Layout User Interface Views and Windows Building User Interfaces Automatic Layout View Controllers Using protocols for delegation Creating and connecting outlets and actions Working with user interface elements Implementing controllers Adding data and logic to the interface Gestures Working with data Saving and retrieving user data File system sandbox Archiving Usign SQLite Core Data Framework Navigation Controllers and Storyboards Multiple Views Tabbed View Controller Using the storyboard tool Static and dynamic prototype tables Navigation Controller Web Services URL Request and URL Connection Getting data from the server REST JSON Distributing Applications Moving applications to a device for testing Getting an application into AppStore
2578 Java Spring 35 hours Oriented programming interfaces Modeling and programming based on the interfaces idea Problems solved by the programming-oriented interfaces Component-oriented programming The role of the components in the web application model, the introduction of the concept of POJO objects as objects performing the function of the components in the web application Design Pattern Inversion of Control and Dependency Injection Pattern of inversion  Control and its variants Dependency Injection, IoC container Declarative as dependencies between the components of a web application Architectural Overview Spring Spring application context-a and its role as an IoC container. How to realize the function of an application framework? Where begins the life cycle of a web application based on Spring? Is it possible to use the Spring IoC container in your application not necessarily site? The configuration files Dependency Injection declaratively through XML files that define how the creation and application components imparting The dependencies between components File format description of the components and examples of Spring dependency injection Factory components and its use Mapping the components defined in the description file dependency injection and how to implement the injection mechanism by Spring plant components Distinction between the components of a singleton and prototype Component life cycle and identification of components Component life cycle Component identification Programming in Spring AOP Aspect-Oriented Programming (Aspect Oriented Programming) Declarative mapping application aspects in the design and definition of the intersection points Introduction to Spring AOP and application examples MVC Spring-a Discussion of abstraction controllers and views Spring Framework and examples of applications most of them. Introduction to the idea of ​​the model, view and controller Spring applications Create an application using Spring MVC Standard controllers and managers view the Spring web application Wiring properties model with a view and vice versa Introduction to the issue of trade and sustainability components Transaction management (especially Java EE) Transaction manager Light framework and persistence Spring transaction management mechanism Light Spring Framework transaction manager Spring mechanisms for managing transactions Mapping of table rows for POJO objects using Spring Use of data access methods Spring Framework to create database queries To define the data access Create Data Access Objects (DAO) Implementation and use DAO to stabilize application components
2474 Excel and VBA Programming for Audit and Finance Professionals 28 hours Please answer the following questions: Is your daily work in Excel is a never-ending string of commands copy-paste? Are you wasting time on repetition of similar operations to prepare the data for analysis? Do you know all the keyboard shortcuts in Excel, but you are not satisfied with the results? Rather than deal with data analysis and preparation of wasting time? Do you have to manually verify the correctness of such data obtained from different systems? Do you have to stay at work after hours or Excel to take books home because not doing during the day? Is Your job is to prepare reports based on a large data set? Do you feel that working in Excel, you come to a roundabout way of results? If you can answer YES to one of the questions then it's time stop this nightmare. This training is for you. Find out how you can speed up your daily operations and get most out of MS Excel. WARNING After the training, your life will change dramatically. Activities, which occupied the whole day will take just a few moments. Are you ready for this? Part I. Squeeze more from Excel Overview of tools on the Data tab Access to external data - do you really need to visit the bank's website every day to get to know the current exchange rate CHF? Defining connections to external data (Access, Web, Text, XML, ...) Sorting multi-level - the rules and the proper sorting options Efficient Advanced filtering - how to create Strainers having access to the filter criteria Fast text-to-column Delete duplicate data Forcing input the correct data - how to ensure that data were specific format Simulation Analysis - how to prepare a professional presentation of possible scenarios Simulation Analysis - how to estimate the result of the formula Grouping and autokonspekty - how to roll up the rows and columns and show different levels of detail PivotTable and PivotChart Calculated fields - how to add to the PivotTable field that is not on the sheet Computational elements in the table Grouping data and create professional-looking statements Part II. Automation ie VBA. Macros Recording and editing macros: Silence on the set - is recording Where to store macros - where best to write macros Introduction to procedural programming - the necessary basis Sub and Function - how to invoke them and what they are Data Types - what variables are needed and whether it is worth it to declare The conditional statement If ... Then .... ElseIf .... Else .... End If Case statement and the accompanying trap Loop for ... next, loop ... each Loops for ... loop while, until Instructions loop break (exit) Visual Basic in action Download and upload data to a spreadsheet (Cells, Range) Download and upload data to the user (InputBox, MsgBox) The extent and lifetime of variables Operators and their priorities Useful module options Securing code - code protection from tampering and preview Key Excel objects: Application, Workbook, Workbooks, Worksheet, Worksheets, ThisWorkbook, ActiveWorkbook, ActiveCell, Selection, Range, Cells, ... Debugging Immediate window Locals window The processing step - but what to do when something has stopped working Watches Call Stack Error handling Types of errors and ways to avoid Capturing and handling run-time errors, which is why properly written code can sometimes not work Construction: On Error Resume Next, On Error GoTo label, On Error GoTo 0
2181 Transact SQL Advanced 7 hours Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following: Use queries to return complex result sets Manage database objects to aid query performance Tune queries to perform more efficiently This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed. Analytical Functions Use of advanced summary functions Use of hierarchical queries Use of analytical summary functions, e.g. moving averages, running totals Use of ranking functions Useful Database Objects Principles of using indexes How to create and maintain an index Use of clustered tables Use of partitioned tables Use of metadata in the master database Query Performance Tracing Principles of query execution and optimisation Use of Execution Plan Use of table & index statistics Use of hints Basic Data Warehouse Techniques Use of Indexed Views Use of Dimension & fact tables Use of Star & Snowflake designs
2007 iOS Programming (iPhone/iPad) for Programmers 35 hours All the skills and knowledge you need to make your first iPhone/iPad application using the latest iOS SDK and tools. The environment The iPhone Developer program and the tools (SDK, Xcode, IB, the iPhone/iPad simulator) The language Essential Objective-C Using existing Cocoa classes and writing your own The essential patterns Performance and debugging Memory management Performance improvements Debugging and troubleshooting Multitasking Multithreading essential The User Experience The application templates The UI Controls Creating different multi-view applications The different gestures UX rules and guidelines Data management Saving state SQLite XML Core Data Settings Multimedia control and some special features The camera API The image picker Playing and recording video Playing and recording audio The accelerometer The proximity sensor Notifications and the Event Kit Quick intro on how to make 2D and 3D animations Making location aware applications Using core location Targets and application types iPhone vs iPad development Universal applications Intro to Web applications with HTML5 and CSS3 Interacting with a service Hybrid applications Delivering it to the public Understanding iAd Releasing to the App Store - The short path
1947 SQL in SQL Server 14 hours This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between T-SQL and other dialects practical skills for writing queries This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course. RDBMS (Relational DataBase Management System) Relational Operators SQL as Declarative Language SQL Syntax SQL Sublanguages DQL, DML, DDL, DCL DQL (Data Query Language) in Detail SELECT clause Column aliases Table aliases Date types and Date functions Group function Table joins JOIN clause UNION operator Nested queries Correlated subqueries DML (DataManipulationLanguage) Overview Inserting rows (INSERT) Inserting rows using subquery Updating rows (UPDATE) Deleting rows (DELETE) DDL (Data Definition Language) Overview Creating, altering and dropping objects (CREATE, ALTER, DROP) Creating tables using subquery (CREATE TABLE .... AS SELECT...) CONSTRAINTS Overview NULL i NOT NULL CONSTRAINT clause ENUM type SET type PRIMARY KEY UNIQUE FOREIGN KEY DEFAULT clause Transactions Overview COMMIT ROLLBACK SAVEPOINT Implicit and explicit rollbacks and commits T-SQL Dialects Overview What is Transact-SQL T-SQL and portability with other dialects (what to avoid) Handling Date
2168 ASP.Net 4.0 35 hours Delegates will be introduced to the .Net framework and will learn to develop web applications using C# 4.0. At course completion delegates should be familiar with the framework, experienced in developing basic web application and conversant with database access using LINQ. Applications will be created using Object Orientated programming. After completing this course, delegates will be able to: Use Visual Studio 2010 effectively Learn C# 4.0 Create commercial ASP.NET Web Applications Understand OO Programming, Classes, and Objects Debug Applications Develop user interfaces using Master Pages, Site Navigation and Themes Use ADO.Net and LINQ to read from and write to databases Develop rich internet applications using ASP.NET AJAX Create and call WCF services Introducing The .Net 4.0 Framework Integrated Development Environment (IDE) Languages In The .Net Framework The Common Language Runtime (CLR) Accessing Data With ADO.Net & XML Accessing The Web With ASP.Net Visual Studio 2010 Useful Visual Studio Windows Creating Projects Project Anatomy The Files In A Project Solution Explorer Code Snippets C# Language Syntax Data Types Variables Declaration Operators Conditional Statements Looping Structures Classes & Objects Building Models Creating Classes And Objects Adding Constructors To A Class Adding Methods, Properties And Events Overloading Methods Property Procedures Debugging Applications Setting Breakpoints Stepping Through Code Debug Windows Watch Windows Call Stack ASP.Net Introduction Starting An ASP.Net Project Project Files Server Controls Server Event Handling The Page Lifecycle User Interface Development Master Pages Themes And Skins User Controls Website Navigation Validation Controls Module 8: Configuration Website Configuration Settings Configuration Files Including The Web.Config Files Storing Application Settings And Configuration Strings The Website Administration Tool Membership & Personalisation Securing And Personalizing A Website Store User Details In The Membership Database Using Login Controls Website State Management Methods Using Viewstate To Store The State Of A Page Exception Handling Adding Try Catch Blocks To Code Page Level Exceptions Site Level Exceptions Custom Error Pages Tracing Data Access What Is ADO.Net Connection Object Command Object Data Readers Datasets And Dataadapters Using The Datasource Wizard Creating Responsive Pages With AJAX AJAX Architecture What Are Partial-Page Updates Using The Updatepanel Server Control Using Client-Side Scripts Data Access With LINQ Why Do We Need LINQ Querying The Database Language Syntax For Querying Using The LINQ To SQL Using Windows Communication Foundation (WCF) Services Service Orientated Architecture WCF Scenarios Mechanics Of Communication: Address, Contract, Binding Creating A Simple WCF Service Calling A WCF Service From A Client Application Deployment How To Deploy A Web Application Deployments Methods Using Visual Studios Copy And Publish Tools Using Setup Projects Installing Assemblies In The GAC
999 Python Programming 28 hours This course is designed for those wishing to learn the Python programming language. The emphasis is on the Python language, the core libraries, as well as on the selection of the best and most useful libraries developed by the Python community. Python drives businesses and is used by scientists all over the world – it is one of the most popular programming languages.  The course can be delivered using Python 2.7.x or 3.x, with practical exercises making use of the full power of both versions of the language. This course can be delivered on any operating system (all flavours of UNIX, including Linux and Mac OS X, as well as Microsoft Windows).  The practical exercises constitute about 70% of the course time, and around 30% are demonstrations and presentations. Discussions and questions can be asked throughout the course. Note: the training can be tailored to specific needs upon prior request ahead of the proposed course date. Introduction to Python Programming Running Python code Using Python Development Tools (IDEs and command line tools) Working with Python and iPython shells as well as iPython Notebook Data Types and Operations Integers and floats Strings and bytes Tuples and lists Dictionaries and ordered dictionaries Sets and frozen sets Organizing and Distributing Code Creating modules and packages Distributing code to repositories Object Oriented and Functional Programming Creating and using functions and classes Modifying functions and classes with decorators Introducing meta-classes Error Handling and Testing Handling and raising exceptions Writing and executing tests (doc tests and unit tests) Checking code coverage by tests Working with Files and Directories Accessing different types of files and file handling principles Creating, reading, updating and deleting files (including regular text files, csv, as well as Microsoft Word and Microsoft Excel files) Extracting data from text files using Regular Expressions Creating and deleting directories, listing and searching for files Accessing Databases Selecting, inserting, updating and deleting data Generic database API based on SQLite 3, PostgreSQL and MySQL Using the Object Relational Mapper (SQLAlchemy) Working with NoSQL databases Conquering The Web Retrieving web pages Parsing HTML and XML Filling web forms automatically Creating web applications in Python
1474 Git for Users 7 hours This course has been created for everyone who is going to use Git repository. Software developers, project managers, software architects and solutions architects, release managers, etc... Git Overview Installing Git Short History of Git What is Git? Git Concepts Focus and Design Git Object Types The Git Data Model Branching and Merging The Treeish The Git Directory Working Directory The Index Non-SCM Uses of Git Git in Practice Setting Up Your Profile Getting a Git Repository Normal Workflow Examples Log - the Commit History Browsing Git Searching Git Git Diff Branching Simple Merging Rebasing Stashing Tagging Exporting Git The Care and Feeding of Git Distributed Workflow Examples Sharing Repositories Hosted Repositories
287815 iPhone and iPad Development in Swift for iOS 8 and Xcode 6 35 hours This 5 day course is for developers who want to learn how to develop applications for iPhone and iPad running iOS8. The course is hands on and shows how to develop applications from scratch using Apple's new Swift programming language using the Xcode6 IDE. During the course a fully functional Tetris style block game will be developed from scratch using Swift. The course ends with developing a new application from scratch in Swift. The course assumes some programming experience. This course can only be run on Intel based Apple hardware such as a MacBook or a Mac Mini. Delegates need to have registered with Apple and have an Apple ID which is required to download software. Delegates wishing to run the applications developed during the course on an iPhone or iPad need to be registered as iOS developers with Apple and have registered their device for development. Apple charge $99 per year to register as an iOS developer. Development environment Development environment requirements Xcode and the iOS SDK Apple Developer registration Reasons why Applications get rejected Xcode iOS Projects Human Interface Guidelines Creating an iOS project Running on simulator and real devices Memory management Strong and weak references Swift Swift programming language overview Using Xcode to develop Swift applications Scenes Creating Scenes Implementing View Controllers Swift Classes Creating Swift classes Instance variables and initialisation Constructor types Protocols, Hashable and Printable Inheritance Working with Graphics Adding icons and images Using the SpriteKit API Animating sprites User Interaction Buttons and handler Pan gesture recognition Tap gesture recognition Case Study Develop a new application using Swift Distributing Applications Moving applications to a device for testing Getting an application into AppStore
2579 Java Advanced 28 hours During the training participant will know the specific use of selected issues, the basic problems encountered when using them, and the role of the application model. The training also includes a basic knowledge of the language standard library functions. Training requires knowledge of the development environment IDE used to build Java applications (e.g.. Eclipse, Netbeans). Training does not include a user interface issues. Abstract class Declaration principles and implementation of abstract classes Typical problems encountered when working with abstract classes The role of classes, abstract classes and interfaces in the application model Grades Java object-oriented abstraction The complete object model in Java Program model oriented  for interfaces, abstract classes and interfaces for application more flexibility and independence of each of its sub-systems from each other in their implementation Applications of abstract classes in order to extract common functionality extended by the implementation of the flexibility that they offer interfaces The role of dynamic and static objects in the application model Static Java classes and dynamic properties of these classes Making a distinction in the functionality of both types of entities within Java and typical uses, and their example of good practice in the design of solutions based on static and dynamic beings Java Introduction to the design patterns Introduction to the factory design pattern Operations with simple types and wrapper classes Very important facts and techniques to extend the use of simple types in the Java object model. Discussion of the role of wrapper classes simple types and typical applications of this type in the application Special Objects Java, the class String, StringBuilder and StringBuffer Reminder basic properties of the String class and discuss the treatment of String objects by the virtual machine The use of buffer classes and operate on chains Formatting and parsing, regular expressions Introduction to regular expressions in Java Discussion of both basic techniques for handling regular expressions (String class) as well as advanced techniques based on dedicated classes for this type of construction Tokenization, search and pattern matching for string types I / O operations A detailed discussion of the mechanisms I / O Java - class streaming, Writer and Reader class, class wrapper and buffering streams of Java. Opening, closing and writing to files and sockets Classes inside - detailed discussion Discusses how to implement and use inner classes in Java and so-called anonymous classes Topics - detailed discussion, applications and problems Discussion subject topics ranging from abstraction mechanism of threads in Java and ending with the synchronization of threads connecting threads in a group to present and discuss topics pools of common problems related to the work of threads, such as deadlocks Reflections Java - Introduction and application Introduction to Java reflection mechanism Lecture topics include discussion of the implementation of reflection in Java, load and run methods of classes, instantiation of classes and getting to know the structure of the classes Java Serialization Introduction to Java object serialization What is serialization, how to serialize an object, objects dependent on each other and how to avoid common problems encountered with these types of issues Typical uses the example of serialization and RMI CORBA
2471 Quality Assurance and Continuous Integration 14 hours Training is open to both developers, Scrum Masters, Product Owner and also some aspects of the business department. The purpose of training is to introduce topics Quality Assurance and Continuous Integration and their place in projects conducted agile methodologies. Participants will gain a broad perspective on the issues discussed as well as practical knowledge of the tools and processes of software development in line with the QA / CI. Representatives of business, will be able to know the benefits of implementing those tools and processes and translate into both the time and cost of software development. The issues presented are based on PHP or Java, depending on customer requirements. QA/CI What is QA? What is CI? The costs of software development, refactoring and fix errors Identifying and understanding the project Profit for the organization DDD Software development based on business requirements, assumptions DDD Problems in communication IT-Business Domain Model Best Practices KISS principle and DRY Coding standards Creating reusable code through OOP and design patterns Identifying and reducing cyclomatic complexity Software Metrics Weight Method per Class Response For a Class Depth of Inheritance Tree Coupling Between Objects Lack of Cohesion of Methods Number of Children Cyclomatic complexity Metrics class Model Metrics Metrics for use Software Testing What, when and how to test? The method of "white-box" and "black box" The role of testing in agile methodologies TDD only a potential increase in the cost of the project Unit testing with JUnit (Java), PHPUnit (PHP) Behavioral tests of JBehave (Java), Behat and Mink (PHP) Functional tests Refactoring What is refactoring? Debt technology Code smell Refactoring patterns Documentation The role of documentation in agile methodologies What to document? Types of documentation Documentation and agile methodologies, or you can call (Working software over comprehensive documentation)? Standard XMI Automatic generation of documentation from the Javadoc (Java), ApiGen (PHP) Tools and Environment CI Tools and Environment CI PMD (Java), phpmd (PHP) CPD (Java), phpcpd (PHP) Lines Of Code Counter (Java), phploc (PHP) UCDetector (Java), phpdcd (PHP) Jdepend (Java), phpdepend (PHP) Jenkins Continuous Integration Server Agile and CI/QA Planning and incremental development Embracing Change Short stages Interdisciplinary team Extreme Programming, Code Review Individuals and interactions over processes and tools Summation Discussion Questions How do you begin the process of implementation?
2175 Core Foundations of .NET 2.0 Development 21 hours Objectives After completing this course, students will gain the skills to: Develop applications that use system types and collections. Implement service processes, threading, and application domains in a .NET Framework application. Embed configuration, diagnostic, management, and installation features into a .NET Framework application. Implement serialization and input/output functionality in a .NET Framework application. Audience The audience for this course consists of Application Developers with the skills to develop business applications by using Visual Studio 2005 with either Visual Basic .NET or Visual C#. Implementing System Types and Interfaces Examining Primary System Types Working with Special System Types Working with Interfaces Implementing Collections and Generics Examining Collections and Collection Interfaces Working with Primary Collection Types Working with Generic Collections Working with Specialized Collections Working with Collection Base Classes Configuring and Installing Assemblies Working with an Assembly Sharing an Assembly by Using the Global Assembly Cache Installing an Assembly by Using Installation Types Configuring an Assembly by Using Configuration Type Performing Installation Tasks Monitoring and Debugging Applications Working with Application Processes Managing Application Performance Debugging Applications Tracing Applications Embedding Management Information and Events Reading and Writing Files Managing the File System Working with Byte Streams Compressing and Protecting Stream Information Managing Application Data Manipulating Strings Efficiently Working with Regular Expressions Serializing Data Generating Serialized Binary and Soap Formats Generating Serialized XML Formats Creating Custom Serialization Classes Implementing Delegates and Events Controlling Interaction Between Components by Using Delegates Controlling Interaction Between Components by Using Events
2003 Programming in Silverlight 5 21 hours Target group: Technical Team Leader, Software Developer Learning objective: The purpose of training is to acquire the ability to develop business RIA applications in Silverlight 5 technology and in C # language. During the course, students become familiar with the MSDN resources and tools to support the development process, such as Microsoft Visual Studio. IDE Introduction to Visual Studio 2012 First program - Hello Silverlight World ! Compilation, Debugging Silverlight What is .NET and what Silverlight? CLR and Garbage Collector DLL vs. EXE vs. XAP? Technologies within .NET Foundations of Silverlight Silverlight History MVVM design pattern - description Silverlight vs. WPF Differences between WPF 1.0, 2.0, 3.0, 4.0, 5.0 In and Out Silverlight project structure XAML, Layout, Dependency Properties Commands and Resources Events Styles and Behaviours Databinding, Data Streams Data Flow Data modelling in Silverlight Access to databases LINQ Entity Framework CRUD operations Data Validation Controls Controls  review Silverlight Toolkit User Controls a Custom Controls Templates Advanced topics Asynchronous and parallel operations, WCF Ria Services IoC (Inverse of Control) Unity 2, PRISM Complete Business Application - Real World Application Development of System Architecture in groups based on the specified Business Case Data modelling Implementation Application testing
1817 Programming for Biologists 28 hours This is a practical course, which shows why programming is a powerful tool in the context of solving biological problems. During the course participants will be taught the Python programming language, a language widely considered both powerful as well as easy to use. This course might be considered as a demonstration how bioinformatics improves biologists lives. The course is designed and aimed for people without computer science background who want to learn programming. This course is suited for: Researchers dealing with biological data. Scientists who would like to learn how to automate everyday tasks and analyse data. Managers who want to learn how programming improves workflows and conducting projects. By the end of the course, participants will be able to write short programs, which will allow them to manipulate, analyse and deal with biological data and present results in a graphical format. Introduction to the Python programming language Why Python? Using Python to deal with biological data Working with the iPython shell Your first programme Writing Python scripts Importing modules Working with protein and RNA/DNA sequences Finding motives Transcription and translation in silico Handling sequence alignments Parsing data in different biological formats Parsing FASTA Data format conversions Running biological analyses BLAST Accessing biological web services Dealing with biological 3D structures using Python Python facilitates statistical analysis Visualizing data Creating bar and scatter plots Calculating an Area Under Curve (AUC) Working with .xls and .csv files Importing data from and exporting to MS Excel / OpenOffice Calc Writing .xls and .csv files Using Python to create an automated data processing pipeline
2589 Programming in C++ 35 hours The course presents a comprehensive object-oriented language C++ and its use of simple examples. These are the standard mechanisms and library The history and development of C++ Object-oriented programming and procedural The basic elements of the language C++ Types and declarations Indicators, arrays, structures Expressions and Statements Features Namespaces Exceptions The source files, compile the program Object-oriented programming - abstraction Class Operator overloading Derived classes Templates Handling exceptions The class hierarchy Standard libraries The organization of libraries, containers Standard containers Algorithms and Function Objects Iterators and alokatory Chains Streams Figures
287862 Designing Inteligent User Interface with HTML5, JavaScript and Rule Engines 21 hours Coding interfaces which allow users to get what they want easily is hard. This course guides you how to create effective UI with newest technologies and libraries. It introduces idea of coding logic in Rule Engines (mostly Nools and PHP Rules) to make it easier to modify and test. After that the courses shows a way of integrating the logic on the front end of the website using JavaScript. Logic coded this way can be reused on the backend. Writing your rules Available rule engines Stating rules in a declarative manner Extending rules Create unit tests for the rules Available test frameworks Running tests automatically Creating GUI for the rules Available frameworks GUI design principles Integrating logic with the GUI Running rules in the browser Ajax Decision tables Create functional tests for the GUI Available frameworks Testing against multiple browsers
1475 Mercurial for Users 7 hours Mercurial and Alternatives CSV Subversion Git Bazaar Introduction to Distributed Repositories Differences between distributed and centralized repositories Committing, Branching, Tagging Locking Mercurial Mercurial in daily use Collaborating with other people Tracking Changes Merging File names and pattern matching Managing releases and branchy development Finding and fixing mistakes
287763 Visual Basic for Applications (VBA) and Databases 14 hours The training is designed for people using Excel and VBA for access to the databases. The use of external data sources Using ADO library Access to the database via ODBC References to external data sources Objects ADO: Connection Command Recordset Chain connection - connection string Create connections to different databases: Microsoft Access, Oracle, MySQL Advanced Access Database ADOX library and the ability to modify the database structure Calling parameterized queries Exporting a set of records to XML Importing XML file VBA Form Custom forms, access to databases Use the forms in the sheet Forms to run queries on the database share
2573 BASH Programming 14 hours The course answers questions: How does the shell works? How to write programs in a shell? The simplest script Choosing the shell (magic number #!, Sha-bang) Calling the script External and built-in commands Some special characters Comment (#) End of Line (;) An empty statement (:) Redirection of input output (>, <, >>) Redirecting output Redirection of input Stream (|) Start the process in the background (&) Variables and Parameters Destruction of variables (unset) Variable with a null value Save the result to a variable (backquotes ``) Parameters request ($ 0, $ #, $ 1, $ 2, $ 3 ...) Manual shift Quoting. Escape character (\) Regular Expressions Conditional statements The if / then The if / then / else Nesting if statements The if / elif case statement Operators Operators and, or (&&, | |) test command Completing scrypt The exit statement Use the status of completion of the program in a script ($?) Tests and Operators Operators text file Tests the file type Test file attributes Comparison operators Comparing arithmetic using the command if Integer comparison operators Comparing strings Comparing the complex (and, or) Nesting comparison operators The assignment operator Arithmetic operators Operators operations on bits (bitwise operators) Logical operators Numeric constants Loopa The loop for / in The command seq The while loop Loop until Controlling the loop (break, continue) Text Processing Command head, tail Sort, Uniq, Expand, Unexpand Cut, Paste, Join, Wc,Tr Text search (grep) Stream Editor (sed) Interactive programs Read command User select Features Sleep command If the script does not work? (debugging)
2468 Text Manipulation using PERL 21 hours This course focuses on text manipulation using regular expressions in PERL. Practical application for text manipulation like processing data files and code files like C and Java will be used. The course will be project oriented where each day ends with creating a small project that parse C files, extract data from comma separated files, generate HTML and XML files Programmer, Developer, Testing personnel, Quality assurance staff who are involved in dealing and generating scripts to control applications The course duration will be 30% lectures, 30% labs, 20% project development Day One PERL Programming Language Text functions in PERL creating files in PERL extracting Data from files Project 1 Day two Regular expression basics Text patterns Using Regular Expressions in text parsing Creating a flexible grammar Project 2 Day three code instrumentation using PERL introduction to HTML translating text and data into HTML and XML extracting data from XML and HTML files Project 3
2170 Comprehensive Lua 21 hours Lua is an easy to use scripting language that is used as an embedded plugin/extension language in different products. For example it is the embedded scripting language of network applications like nmap and wireshark, and can also be found as a scripting language in World of Warcraft, Orbiter and other games. Lua can also be used as a standalone language. It is a lightweight, multi-paradigm programming language and therefore the course teaches various concepts that students will find useful in other areas of software engineering as well. This course covers everything out there to know about Lua. We build up from the basic programming constructs, learn about advanced techniques and finally talk about embedding of Lua into other programming languages and embedding other programming languages into Lua. The course contains a lot of programming exercises, so that newcomers can gain proficiency with the language, starting from scratch. Introduction to Lua A bit of history Lua's goals, features and non-goals Resources of Lua documentation and tutorials Installing the Lua interpreter Setting up and using LuaRocks Basic syntax and semantics Identifiers Comments, block comments Global variables and enforcing of strictness Local variables Standalone programs, program arguments Compilation units, chunks, expressions, semicolons Data types and data structures Basic types: nil, boolean, number, string Object types: function, userdata, thread, table References/objects vs. basic values The importance of tables in Lua Introduction to tables and their versatility Tables as an associative array Tables as numeric arrays, sequences Basic control structures The if then elseif else end The while loop The repeat loop The simple for loop Error handling Return values vs exceptions Converting a return value to an exception Converting an exception to a return value Error levels Example programs Polynomial evaluation Breadth first search Additional exercises More about functions Named arguments Object-oriented calls Closures Currying Tail calls Multiple assignment and return Varargs Iterators and co-routines The generic for loop Stateless vs stateful iterators Differences between iterators and co-routines Metatables and metamethods The set example The __tostring metamethod Arithmetic metamethods The __index, __newindex metamethods The __len metamethod Modules and packages Using modules Creating modules Organizing modules into packages Advanced tables Tables for queues and stacks Tables describing graphs Matrices as tables Linked lists as tables String buffers Metatables through examples Proxies Readonly Memoization Dynamic programming with memoization The Fibonacci example Environments Relationship between global variables and environments Free variables The _ENV table and the _G table More about modules Different approaches to creating modules Modules that change the behavior Module initialization and arguments Using environments to implement safe modules Advanced iterators and co-routines Producer, consumer, filter Wrapping co-routines to get iterators Stateless iterator for linked lists Contributing to the Ecosystem Uploading packages to MoonRocks Functional paradigm in Lua The map function The reduce / fold function Object-oriented Programming Different approaches to OOP Different approaches to inheritance Examples A walkthrough of the Lua Standard Libraries Compilation Compilation Eval Relationship with the environment Binary chunks Garbage collection Weak tables Finalizers, the __gc meta-method Lua bytecode and virtual machine Generating bytecode from source code Reading and analyzing bytecode Quick tour of the source code of the Lua VM C modules Calling C from Lua Search path and loading of C modules Calling Lua from C The Stack Error handling Continuations Handling Lua values and types from C Arrays Strings Userdata Metatables Object oriented calls Light userdata Memory management Allocators GC API Threads in Lua Co-routines vs threads Real multi-threading and Lua states
2002 Programming in WPF 4.5 21 hours Target group: Technical Team Leader, Software Developer Learning objective: The purpose of training is to acquire the ability to develop business desktop applications in WPF 4.5 technology and in C # language. During the course, students become familiar with the MSDN resources and tools to support the development process, such as Microsoft Visual Studio. IDE Introduction to Visual Studio 2012 First program - Hello WPF World ! Compilation, Debugging Microsoft .NET What is .NET? CLR and Garbage Collector DLL vs. EXE? Technologies within .NET Foundations of WPF WPF History MVVM design pattern - description WPF vs. Windows Forms Differences between WPF 3.0, 3.5, 4.0, 4.5 In and Out WPF project structure XAML, Layout, Dependency Properties Commands and Resources Events Styles and Behaviours Databinding, Data Streams Data Flow Data modelling in WPF Access to databases LINQ Entity Framework CRUD operations Data Validation Controls Controls review WPF Toolkit Extended User Controls a Custom Controls Templates Advanced topics Asynchronous and parallel operations IoC (Inverse of Control) Unity 2, PRISM Complete Business Application - Real World Application Development of System Architecture in groups based on the specified Business Case Data modelling Implementation Application testing
1284 Subversion for Administrators 7 hours This course is for system administrators who need to install and maintain Subversion software and Subversion repository. The aim of this course is to widen the skills of system administrators so that they can administer Subversion repository servers and provide the best advice of the practices of Subversion. This course features a lot of lab exercises on Linux virtual machines. SVN server setup install the package and all dependences to create one repository or several repositories with sensible location considerations, initial import, migrate from CVS and other version control systems Fine-tune all kinds of access schemes, including http, https, svn, svn+ssh, file, specially to consider following how to configure Apache modules to use ssh environment variables to shorten svn+ssh:// urls to define proper user databases and design complex access control list or authorization patterns to integrate with LDAP / domain controller / MySQL / PAM / etc for user authentications Configure sensible repository layout each sub-project has complete tree structure such as trunk, branches and tags, suitable for sub-projects are inclusive and self-contained, not much inter-dependence, APIs of each sub-projects are stable and mature all modules exist on trunk / branches and tags, suitable for a logically compact project, there exists strong coupling among modules difference and benefits Backup strategy and disaster recovery backup strategy, including: native method with svn sync, third-party tools such as rsync, hot copy whole repository backup vs each revision checkout or dump disaster recovery permanently remove files and history Basic knowledge about managing repositories normal working cycle with subversion (hand-on practices) create branches and tags create locks and other controls design client-side tools and integrate them with IDEs choose and configure repository viewing facilities set general user policies, including set subversion hooks for those hard restrictions design automatic check-out and build or compilation, and even automatic testing
2467 Web Application Development in PHP 21 hours The course is designed for intermediate PHP developers who want to enrich their knowledge and learn best practices in programming and web development techniques based on object-oriented programming and design patterns. Object-Oriented Programming Terminology Object Declaring classes and constructors Creating and Using Objects Properties and methods Inheritance Access modifiers Magic methods Declaring and using interfaces exception Handling Databases Methods of data przechowywnia PDO extension Connecting to a database using PDO Operations on data Error Handling PDO Transactions Primary keys Joins Aggregate functions and grouping Programming interfaces Architecture services Adding to the system API The data format JSON and XML RESTful Services Designing Web Service Design Patterns What are design patterns Singleton Pattern Factory Pattern MVC model-view-controller Efficiency Research applications performance Code cache Safety Filtering input Session fixation Session hijacking SQL injection storing passwords SSL
287799 Administering and Optimizing HipHop Virtual Machine (HHVM) 14 hours This course focuses how to install, configure and optimize HipHop Virtual Machine (HHVM). Usually it uses Ubuntu/Apache stack, but can be also adjusted to Windows and other environments.Quick overview of HHVM JIT Transcompiler Community Installation Installing hhvm Installing and configuring Apache/Nginx as proxy Choosing running strategy Proxy Standalone Daemon Server Troubleshooting Stacktraces Automatically renewing after crash Optimization Basic parameters options Multiple hhvm servers versus one Socket vs ports Monitoring Profiling (xhprof)
287820 SOA Architect 35 hours This 5 day course is designed to give an understanding of the mechanics of Service Oriented Architecture. It includes the technical design of SOA based architectures and service oriented solutions to business problems. Service Oriented Architecture and Computing Service Oriented Computing Terminology Service Oriented Analysis and Design Requirements and impact of adopting SOA Enterprise Service Bus Web Service and REST Services SOA Connection Points SOA Technology XML and XML Schema Web Services JAX-WS and WSDL REST Services JAX-RS and WADL Discovery and Service Registries Enterprise Service Bus (ESB) SOA Design and Architecture SOA Model Services and Service Capabilities WSDL first or code first design Principles of Service Orientation Service coupling Handling state Service discovery Advanced SOA Design and Architecture SOA Architecture types SOA Design Patterns Message types Data transformation SOA Workshop This hands on workshop consists of a number of individual and group exercises which allow the technologies and principles described in the previous modules to be applied. Participants can also bring real world problems to the workshop.
2643 Comprehensive Git 21 hours This is a comprehensive course for people not familiar with any other distributed version control system. It starts with simple exercises for working in a local repository and finishes with practising working in a team. This course focuses on exercises. Git Basics Introduction to Git Git Repository Recording Changes to the Repository Viewing the Commit History Undoing Things Tagging Git Branching Branching and Merging Brance Management Branching Workflows Remote Branches Rebasing Git on the Server The Protocols Getting Git on a Server Generating SSH Public Key Setting up the Server Public Access Hosted Git (GitHUB) Working with Remotes Distributed Git Distributed Workflows Contributing to a Project Maintaining a Project Git Tools Revision Selection Interactive Staging Rewriting History Debugging with Git (bisect) Submodules Subtree Merging Customizing Git Git Configuration Git Attributes Git Hooks
2572 Website Development in PHP 21 hours The course familiarizes participants with the PHP language and its integration with the Web environment. The participant will learn how to make a dynamic page, write database applications and to protect applications from unauthorized access. PHP syntax Operators, variables basic functions, File operations, strings and arrays Data structures associative arrays session variables, form, url, cookie Object-Oriented Programming in PHP Classes, constructors, inheritance Object-oriented features Database Support creating connections password protection querying storage and display of results add, delete and modify data binding form to a database Protection Authentication and Authorization the use of cookies and session Graphics Support in PHP
2466 Javascript / jQuery - MVC frameworks / MVVM and multilayer applications on the client side 7 hours The training is designed for JavaScript developers, designing and implementing advanced Internet applications. Topics discussed during the training aims to provide the advantages of separation-related software layers, not only on the server side but also on the side of your browser. The idea of ​​decomposition systems OOP - the main ideas The need for system decomposition Profit from multi-tier architecture MVC i MVVM Fusing objects using JavaScript, the feasibility of Controller and Presenter Model! = DBMS Model and DDD Tasks view Documentation EmberJS BackboneJS Create a simple MVC application
2167 Flex 4 and LiveCycle Data Services 3 14 hours This training course is aimed at Developers wishing to extend their Flex knowledge using LiveCycle Data Services in Flex applications. It is a comprehensive 2 day in using LiveCycle Data Services 3 with the Adobe Flex 4 framework. Emphasized topics will include: Messaging, remoting, and web services Performance profiling and unit testing Client-side data manipulation Model-driven development using the Fiber Framework and Flash Builder 4 Introduction Course format Reviewing the course prerequisites Reviewing the course outline Accessing Web Services Using web services Process for calling web services Invoking web service methods and using the results Invoking the methods on a web service Understanding ArrayCollection class results Using web service results Handling results using an event handler Using the results event handler Handling faults Creating fault event handlers Displaying faults with an Alert pop-up Calling multiple methods from the same WebService object Using the <s:operation> tag Passing parameters to web services Passing parameters to a web service explicitly Passing parameters to a web service using parameter binding Using Remote Object Connections Introducing LCDS / BlazeDS Surveying the LCDS feature set Introducing BlazeDS Compare and contrast LCDS and Blaze DS Understanding the Remoting Service The Remoting Service and AMF Configuring a Remoting Service destination Using <s:RemoteObject> Accessing data from a remote method Handling RPC events Handling successful remote calls Handling faults in remote calls Complex remote method calls Handling events of multiple methods Passing parameters Type conversion during data transfer between ActionScript and Java Converting data from Java to ActionScript Converting data from ActionScript to Java Converting custom object types Managing RemoteObject events using AsyncToken Understanding dynamic classes Remoting Service Runtime Configuration Selecting a channel at runtime Managing Data on the Client Understanding collection classes Collection features Collection interfaces Specific collection classes Filtering data on the client Creating the filter function Using the function Sorting data on the client Understanding the sort classes Process for sorting data Simple sorting example Complex sorting example Using the IViewCursor interface Cursor operations Creating and using the cursor Code examples Using the Message Service Introducing the message service Creating a messaging destination Sending messages Creating a messaging producer Using the AsyncMessage class Tracing message traffic Receiving and processing messages Creating a messaging consumer Subscribing and unsubscribing to a destination Receiving messages Sending and receiving complex data Implementing message filtering Using selectors Using subtopics Using Flash Builder Development Tools Using logging Logging on the client Running the debugger Using breakpoints Introducing the profiler Introducing Flash Player garbage collection Profiling an application Using memory profiling Monitoring Flex RPC network traffic Using the Network Monitor Developing Applications Using Model Driven Development Introducing model driven development using LCDS 3 LCDS model driven development benefits Comparing code- and model-driven development Preparing to use model driven development Setup details Creating and using the data model Table joins representation in the model Modeling language Editing generated ActionScript value objects Flash Builder functionality for MDD Adding properties to the model Creating a derived property Updating changes to the database schema Creating a method to calculate a derived property Using styles in a form Implementing validation through styles Using styles to change other form behaviors Using global styles Filtering returned data Implementing a filter Implementing Advanced Model Driven Development Techniques Creating conditional properties with variants Implementing the variant in Flash Builder Selector expression Case Substructure Using resource bundles for localization Creating property files Compiling resources into the application Selecting a locale Altering the form generator template Extracting the client-side templates Generating the server side Java
2000 Subversion for Advanced Users 14 hours This course is aimed at advanced users of subversion, such as release managers, project leaders, or anyone who wants their svn repository to be in a streamlined production chain, who are involved heavily with branching management, automatic build/compilation and testing, even deployment and updating. The students would benefit from this course working more closely with their development team and deployment team, especially for large size companies or those with geographically distributed branches. This course features a lot of exercises on CentOS 5 virtual machines. Subversion design philosophy and its advantage Typical copy-modify-merge scenario, how to solve simple conflicts Set user policies and guild-line, make team collaboration smooth and consistent Compensation to copy-modify-merge method (i.e., lock and unlock) Branching and merging When to create branches, several usages of branches, How to resolve conflicts and do merging wisely, how to absorb changes in different directions How to make use of new features of subversion to do branching and merging How to encourage or discourage users' local branching Everyday digest and revision review Mailing list, RSS, digest Blaming, delegation Subversion properties Built-in properties, properties with SVN: prefixed keywords, global properties How to design and use these properties Customized SVN properties for company Creative usage of customised SVN properties Disadvantage of SVN properties (i.e., mind the constraints and not to over-engineer it) Subversion hooks Hook types General usage of already shipped hooks Self-defined hooks Be creative and imaginative Secondary SVN server For backup, fail-safe recovery For automatic background tasks For temporary arrangement (i.e., different locations, etc.) Integration with other tools Issue tracking systems (i.e., bugzilla, track, Jira, etc.) Content managing system (i.e., wiki, etc.)
1283 SQL Advanced in MySQL 7 hours This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features. DQL (Data Query Language) Correlation in FROM, WHERE, SELECT and HAVING clauses Correlation and performance Using CASE, IF, COALESCE functions Using variables Casting and converting Dealing with NULL, NULL-safe operators Using regular expression with REGEXP operator Useful MySQL specific group by functions (GROUP_CONCAT, etc.) GROUP BY WITH ROLLUP EXISTS, ALL, ANY Multitable OUTER JOIN Rewriting subqueries as joins DML (Data Modification Language) Multi-row inserts INSERT by SELECT Using subqueries in DML statements Using variables in DML queries Locking tables and rows Updating data in many tables IGNORE clause REPLACE clause DELETE versus TRUNCATE DDL (Data Definition Language) Creating tables with select Temporary tables Stored Procedures Short introduction to MySQL stored procedures
2600 Administering in Microsoft SQL Server 21 hours The course is designed for administrators, developers and database developers. The objectives of the training: acquire and strengthen the skills to create and manage databases knowledge of the syntax and use SQL to retrieve and modify data apply safety rules in the database the use of advanced elements (replication, automation, BI) the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers Basic information about databases Database files, Database Client / Server Relational database management systems (RDBMS) SQL Server versions and the differences between them Express, Standard, Enterprise Workgroup, Mobile , Developer SQL Server Tools SQL Server Management Studio SQL Server Agent Services in SQL Server Database Services Analysis Services Reporting Services Intergration Services Base system Master Model Msdb Tempdb Distribution Resource       Create a database The database files and their location File size and its growth Partitioning tables Data Modification Language (DML) INSERT UPDATE DELETE Data Definition Language (DDL) Designing Tables Columns and Attributes Determine the type of data Indexes and Keys Indexes Clustered Indexes Non-Clustered Indexes REBUILD vs. REORGANIZE  Creating a database application Server-side programming Procedures Views Functions Triggers Models play Simple Full Bulk logged Backup Full Differential Transaction Log Backup Strategies Strategy full copy of the database Strategy of full backups and transaction log The strategy of incremental database backup Strategy copy of the database files Basic security and administration of SQL Server Automation Maintenance Plan Jobs Basic security and administration of SQL Server Server Roles Database Roles SA Account Creating Accounts Schemes High Availability Log Shipping Database Mirroring Server Clustering Replication Snapshot Replication Transactional Replication Merge Replication Activity Monitor SQL Server SQL Server Profiler Upgrade In-Place vs. Side-By-Side Service-Pack Cluster Best Practices
106 Excel VBA Introduction 14 hours This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms. Macros Recording and Modifying Macros Assigning Macros to Toolbar, Buttons, Shortcut key Visual Basic for Applications Environment Visual Basic Editor and its options Component Management Shortcuts Environment Optimization Introduction to Procedural Programming Procedures: Functions and Sub-routines Data Types Control Flow If ...Then....Elseif....Else....Endif Case Do...Loop , While For... Next Exit Arrays and Loops Strings Visual Basic VBA and Sheet Data Exchange (Cells, Range Methods) Getting and Printing Data from Users (InputBox, MsgBox) Variable Declaration Scope and LifeTime of Variables and Objects Operators and Their Priorities Modules Options Creating Worksheet Functions Objects, Classes, Methods and Properties Locking Project for Viewing Debugging Run Time, Design Time, and Break Mode Brakes and Watches Local Window Immediate Window Call Stack Error Handling Errors Types On Error GoTo On Error Resume Next Excel Model Object Application Object Workbook Object and Workbooks Collection Worksheet Object and Worksheets Collection ThisWorkbook, ActiveWorkbook, ActiveCell, .... Selection Object Range Collection Cells Collection Using Status Bar Screen Updating and Optimizing Timer and Time Measuring Events Handling in VBA VBA Forms Creating and Using Forms Invoking Forms in VBA Code Using VBA Forms in Worksheet
287784 Node.js for JavaScript Developers 21 hours Overview Node.js is a platform for easily building fast, scalable network applications. Learn how to use the event-driven, non-blocking I/O model to build data-intensive real-time applications that run across distributed devices. We will explore the design choices that make Node.js unique, how this changes the way applications are built and how systems of applications work most effectively in this model. Learn how to create modular code that’s robust, expressive and clear. Understand when to use callbacks, event emitters and streams. Use streams to easily manipulate data that would be impossible to fit in application memory. Gain confidence in handling errors effectively to ensure runtime reliability. The course has extensive lab exercises to reinforce the concepts and techniques covered. Objectives On completion of this course, students will be able to: Clearly understand the platform design choices that led to Node.js choosing an event loop and what this means for applications built on that foundation. Understand the unique trade-offs present in event-driven programming. Create Node.js modules and express code modularity in an application. Understand the core flow control patterns in Node.js and know when it is appropriate to use callbacks, event emitters or streams. Create and manipulate buffers efficiently. Understand how to manage error state and know when a process should exit due to an error. Build network applications with Node.js.   Intro to Node.js RAM vs. I/O latency Blocking vs. Non-Blocking Event-driven Programming Event Loop Blocking The Event Loop Node.js Philosophy Installing Node.js Download and Install Node REPL First Hello World Modules and npm Anatomy of a module Private code Accessing and using modules npm commands package.json The Callback Pattern What are callbacks Callback-last Error-first Events When to use Event Emitters Binding Functions to Events Event Requests Event Listening Error Handling Callbacks: Error-first Errors in Event Emitters Uncaught Exceptions Using Domains Buffers Why Buffers exist Creating Buffers Reading and Writing Buffers Manipulating Buffers Streams What are streams Read and Write Stream API Flow Control Piping Duplex Stream Transform Stream Express.js Intro and Installing Express.js Building a Hello Express application Creating routes Rendering Layouts Using templates Adding partials Using locals and conditional templates Modularizing routes  Socket.io Listening for Broadcasting Answering questions Connecting to Databases No SQL and Document Stores Relational DBs
2641 Database Version Control (dbv) 7 hours This course show a solution for sharing and versioning your db schema. It contains exercises which cover: common scenarios in a software development with sharing database changes using the dbv to debug problems related to database schema changes dbv.php Installing Optional Settings Pushing schema objects Receiving schema objects Creating revisions Receiving revisions
2464 REST API - a pattern of exchange of information between sites 14 hours The course is designed for developers, web applications, aims to provide opportunities offered by the REST architectural pattern by which you can communicate between sites. REST - base The need for the exchange of information between sites HTTP POST / GET / PUT / DELETE Services such MushUp and popular applications Services using REST Conventions Rest Mapping CRUD operations on HTTP calls Conventions API URL structure Passing Parameters Return Values HTTP statuses JSON - a universal format for the exchange of information Using the API services - customer Examples of the popular API Create a REST API - Server Gathering requirements and identify functionality Design and API documentation Installing the required libraries Business Object - mapping the class Controller methods Representation of a business object as JSON HTTP Headers - as metadata Testing the API using cURL Authentication mechanisms
2142 MQL4 Programming 21 hours MetaQuotes Language 4 (MQL4) is a new built-in language for programming of trading strategies. This language allows creation of your own Expert Advisors that make trading management automated and are perfectly suitable for implementing one's own trade strategies. MQL4 can be used for the creation of one's own Custom Indicators, Scripts, and Libraries. Basics Standard constants Predefined variables Program Run Account information Array functions Checkup Client terminal Common functions Conversion functions Custom indicators Date & Time functions File functions Global variables Math & Trig Object functions String functions Technical indicators Timeseries access Trading functions Window functions Obsolete functions
1998 Release Management and Deployment with Distributed Version Control System 7 hours This course has been created for project managers, release managers, product managers, product owners, Scrum Masters, software architects and everyone who is responsible for planning releases and deployment of software. It shows how to move changes from requirements, through development and tests to production environment using distributed version control system (GIT in particular, but people using other distributed SCMs can benefit from this course as well). Show overview of Project Management methodologies Agile Methodologies Waterfall Automatic deployment via GIT Production repository Release branch Using Tags for releases Switching between releases Managing maintenance release Major releases Documentation, Release Change Log Using Repository History to create Change Log Using Tag description for major release summarising changes Aggregating smaller changes into bigger one (closer to the business) Aggregating commits Grouping commits into logical parts Central Repo Push and Pull Strategies Keeping Central repository clean Creating structure for aggregating and reviewing changes from developers Testing and Staging environment Software Architecture and Components How to divide logically application and the repository How to manage libraries and subprojects develop by third parties Using submodules to automate upgrades
1279 Java Fundamentals 28 hours The course covers the basics of Java development. It introduces students to Java technology and teaches them basic Java syntax and concepts, leading to the creation of a simple program. Training goes through the essential concepts and features of the Java Programming Language, focusing on exceptions, basic input/output, concurrency, regular expressions, Java collections framework and the platform environment. The course finishes when all basic Java features have been explained and trained. Getting Started The Java Technology Phenomenon How to write basic "hello world" application How to compile and execute Java code How to make the code a bit more complex Java Syntax Object-Oriented Programming Concepts Variables, arrays, data types, operators, and control flow What are reference variables Classes and objects What inheritance is and how it works What Interfaces are, why they are written and how How to use Java String and Number objects and how to format data for output What packages are for and why we must use import directive Java Objects Java classes overview Java class life cycle Class modifiers and inheritance Overloading" and overriding Class constructors Polymorphism Relationships: IS and HAS 'static' keyword When to use static members Java Collections Collection interface Lists, maps and sets Collections and arrays Concurrency Java Memory Garbage collector Heap and stack Object life cycle 'finalize()' method Java Exceptions The general idea of Java Exceptions Runtime and 'real' exceptions Throwing an exception 'try...catch' statements 'throws' declaration Designing your own exceptions Java Concurrency Threads and concurrency Threaded tasks Joining threads Class variables visibility
1993 Design Patterns in C# 14 hours Target group: Technical Team Leader, Software Developer Learning objective: The purpose of training is to acquire the ability to design advanced development / project structures in C #. During the course, students become familiar with the MSDN resources and tools to support the development process, such as Microsoft Visual Studio, ReSharper. IDE Introduction to Visual Studio 2012 Introduction to ReSharper Theoretical fundamentals of design patterns History of design patterns Microsoft .NET Framework and design patterns Design patterns categories Patterns (theory and practice) - Creational Design Patterns Abstract Factory Builder Factory Method Object Pool Prototype Singleton Patterns (theory and practice) - Structural Design Patterns Adapter Bridge Composite Decorator Facade Flyweight Private Class Data Proxy Patterns (theory and practice) - Behavioral Design Patterns Chain of responsibility Command Interpreter Iterator Mediator Memento Null Object Observer State Strategy Template method Visitor Complex Design Patterns MVC (Model - View - Controller) MVP (Model - View - Presenter) MVVM (Model -View -View Model) Architecture Design Simulation - Hands On Labs Development of System Architecture in groups based on the specified Business Case
287759 Angular JavaScript 28 hours This is a hands on course is for anyone wanting to create Web sites using Angular JS.  What is Angular JS? HTML5, CSS and JavaScript JSON and Ajax Angular JS Applications Bootstrap CSS Models Bindings Expressions Simple expressions Values Objects Arrays Maps Directives Data typing Looping over arrays and arrays of objects Creating tables Enabling and disabling HTML elements Hiding and showing HTML elements Handling HTML events Controllers Defining controllers Object property functions Controller methods Controllers in external files Namespaces Global namespace Modules Module dependencies Library loading Where to put scripts Application files Filters Convert to currency Array subsets Upper and lower case conversion Sorting HTTP Requests General requests Shortcuts Success and error handling Setting HTTP headers JSON and XSRF vulnerability protection Forms HTML input controls Browser versus Angular JS validation Validating input values Displaying input error messages Angular Modules Services Animation REST Cookies Mobile device support
1784 OMG Certified Real-time and Embedded Specialist (OCRES) - Intermediate Exam Preparation 28 hours The Intermediate Exam covers a range of concepts and knowledge from Real-time and Embedded modeling and programming standards. The OCRES Intermediate Examination covers several chapters of a textbook on real-time software engineering, plus portions of these seven OMG specifications: OMG MDA Guide UML Profile for Schedulability, Performance, and Time UML Profile for Quality of Service and Fault Tolerance Real-time CORBA with Static Scheduling CORBA for Embedded (CORBA/e) Lightweight CORBAservices Data Distribution Service
2635 Apache Tomcat and Java EE Administration 21 hours Teaches attendees the fundamentals of administering Apache Tomcat and other Java EE environments. The course is a mixture of lectures and hands-on exercises. Delegates learn by doing, with immediate opportunities to apply the material they learn to real-world problems. Introduction to the Java Platform The JVM, JRE, and JDK Java SE versus EE Apache Tomcat as a lightweight servlet/JSP container, and how this differs from full-blown Java EE application servers such as WebLogic, WebSphere, JBoss, and GlassFish Architecture of Applications installed to Tomcat Understanding classes versus JARs Servlets JSPs JavaBeans JNDI and datasources Resources that your applications may call on other servers (web services, EJBs, etc.) Installing Tomcat Installing the Java Runtime Environment (JRE) Tweaking the JRE for performance Performing the actual Tomcat installation Examining the Tomcat installation directories bin conf common (Tomcat 5.5 and earlier) lib (Tomcat 6 and later) logs server (Tomcat 5.5 and earlier) shared (Tomcat 5.5 and earlier) temp webapps work Configuring Tomcat server.xml (detailed walkthrough) web.xml context.xml Deploying Java EE Applications Packaging JARs for deployment to Tomcat Packaging WARs for deployment to Tomcat Application server-neutral configuration versus application server-specific configuration Overview of EARs and other archive types not supported by Tomcat, but supported by other Java EE application servers Versioning Java EE applications Managing the deployment of updated applications Tomcat Valves AccessLog and FastCommonAccessLog RequestFilterValve SingleSignOnValve (by request) RequestDumperValve (by request) Memory management and JMX monitoring Understanding Java garbage collection Using JAVA_OPTS, JMX and JConsole to monitor and tune Tomcat memory usage Sizing Tomcat's JVM memory heap Using JMX and JConsole to configure Tomcat via Tomcat's MBeans Updating Tomcat's configuration via JMX "on the fly" without restarting Tomcat Load testing with JMeter Using VisualVM (new monitoring tool built into JDK 6) and PSI Probe Controlling JMX MBeans via Ant Logging and Troubleshooting JULI logging log4j logging Understanding exceptions and thread dumps Troubleshooting errors that occur in Tomcat Troubleshooting errors generated by your deployed applications Troubleshooting strategies applicable to application servers other than tomcat Connecting databases with Tomcat applications Classic JDBC approach Better approach: JNDI resources Setting up and monitoring database connection pools Security File system security Java security manager Realms, authentication, and authorization SSL Java VM and Tomcat Performance tuning strategies Additional JVM tuning tips Enabling parallel garbage collection Building native connectors Disabling/removing unneeded applications Tuning incoming connections and database connection pools Turning off Jasper development mode Precompiling JSPs Preloading servlets Application-specific tuning suggestions Tuning levers available in other application servers The World Beyond Tomcat: Understanding Java EE Applications Explanation of the Java EE APIs not supported by Tomcat: EJB, JMS, and many others 3rd party application frameworks overview (what they are and what administrators should know): Spring, Struts 1/Struts 2, JSF (including a discussion of ICEfaces, RichFaces, etc.) Data tier frameworks and what administrators should know (Hibernate, JPA, etc.) Features offered by WebLogic, WebSphere, and JBoss that are not found in Tomcat Tomcat 7 New Features [optional] Memory leak prevention and detection Servlet 3.0, JSP 2.2, and EL 2.2 support (and the practical implications of this for Tomcat admins) Cross-site request forgery prevention (and how to configure) How Tomcat 7's new session management features prevent session fixation attacks Alias support (which allow static content to be stored outside the WAR file) Running Tomcat behind Apache httpd or IIS [this section would be taught using your web server and connector module of choice] Why run Tomcat behind Apache httpd or IIS? Installing mod_jk (Apache or Tomcat) or mod_proxy_ajp and mod_proxy_balancer (Apache 2.2 or later only) Proxying traffic to Tomcat via AJP Monitoring the status of your web server's connection to Tomcat Load balancing Tomcat via mod_jk or mod_proxy_balancer Tomcat Clustering Configuring mod_jk (in Apache or IIS) or mod_proxy_balancer (Apache 2.2 or later only) as a load balancer Hardware load balancing as an alternative to software load balancing Sticky sessions Configuring a shared session back-end FileStore/JDBCStore (older approach, generally not recommended) Using the <Cluster> tag Configuring the application to be distributable Setting up and testing failover
2465 PHP Patterns and Refactoring 21 hours The course is designed for experienced programmers who want to explore issues related to the use of patterns and refactoring. Each participant know the properties and practical examples of the use of these patterns, which in turn will enable the efficient build correct the application code. Introduction to Design Patterns What is a design pattern elements of pattern Advantages and disadvantages of using patterns GoF Design Patterns patterns creative Builder Factory (Abstract Factory, Factory Method) Prototype Singleton structural patterns Delegator Interface Facade Composite Immutable Adapter Decorator Proxy behavioral patterns Command Template method Observer Chain of responsibility (and Intercepting Filter) Observer (2 version) Strategy Patterns of Enterprise Application Architecture Web MVC - Model View Controller HMVC, MVP Inversion of Control Dependency Injection Container Active Record The concept of entity and Repositories Decomposition of the system Examples of component-based Symfony 2 and Zend Framework 2 Refactoring Debt technology What is refactoring? Tools to support refactoring phpmd (Software metrics) phpcpd phpc Typical code requires refactoring Jenkins Continuous Integration Server
2141 Administering GlassFish Server with Java EE applications introduction 21 hours Introduction to GlassFish Server Overview of the Java EE Architecture GlassFish Background GlassFish Basic Architecture GlassFish Basic Features Installing and upgrading Installation Upgrade Administering and deploying applications Administration High Availability Administration Security Application Deployment Message Queue Administration Troubleshooting Troubleshooting Error Message Scaling and tuning the performance Deployment Planning Performance Tuning Developing applications Your First Cup: An Introduction to the Java EE Platform The Java EE Tutorial Application Development Guide Message Queue Developer's Guide for Java Clients Message Queue Developer's Guide for JMX Clients Message Queue Developer's Guide for C Clients Extending and embedding Add-On Component Development Guide Embedded Server Guide
1997 Git for Victims of Subversion 7 hours This course shows Subversion users how to use Git. It helps to seamlessly migrate habits from SVN to Git and avoid common mistakes. Everyday Work (in centralized manner) Committing Browsing Tagging and Branching Merging Going Remote Sharing the Work Git Concepts Git Objects Distributed repositories Authors and Committers Merging works via e-mail Merging works from others repositories Octopus merge Habits Migration Process Mirroring Subversion Working with Git in a centralized manner Switching to distributed model Migration process examples (Open Source projects) Git Plumbing and Advanced topics Git Commands Signatures Ignores and Excludes Migrating and Bridging Using Git SVN clone Working with a Subversion repository and Git working copy
1263 jQuery 14 hours This course has been created for web developers who want to simplify JavaScript development. This course covers the basics of jQuery all the way up to building plugins. jQuery Background History Further development jQuery versions, development and compressed Preparing environment to support auto-completion and help Simplify JavaScript development with jQuery jQuery structure and components Core Selectors Attributes Traversing Manipulation Effects Ajax XMLHttpRequest object using HTTP GET, POST Using JSON objects jQuery Events Binding and unbinding events Convenient event helper methods jQuery event object Event features Plugins Finding a plugin How to use jQuery plugins How to minimize the size of the plugins jQueryUI
2624 Apache Solr - Full-Text Search Server 14 hours The course is intended for IT specialist that want to implement a solution that allows for elastic and efficient searching of big data sources. Introduction Apache Lucene What is Solr Installation Schema and textanalysis Schema modeling schema.xml Configuration Text analysis Working with index Importing data from other resources Indexing documents Querying Solr API Searching Basics of querying Sorting and Filtering Using scoring Functions Request handling Formatting Solr response Faceting Advanced topics Configuring and deploying Solr Integrating Solr with other libraries/technologies Search components Solr and scaling issues
287843 Advanced R Programming 7 hours This course is for data scientists and statisticians that already have basic R & C++ coding skills and R code and need advanced R coding skills. The purpose is to give a practical advanced R programming course to participants interested in applying the methods at work. Sector specific examples are used to make the training relevant to the audience R's environment Object oriented programming in R S3 S4 Reference classes Performance profiling Exception handling Debugging R code Creating R packages Unit testing C/C++ coding in R SEXPRs Calling dynamically loaded libraries from R Writing and compiling C/C++ code from R Improving R's performance with C++ linear algebra library
1983 OMG Certified Real-time and Embedded Specialist (OCRES) - Advanced Exam Preparation 28 hours The Advanced Exam covers a broader range of concepts and knowledge from Real-time and Embedded programming standards than the intermediate Exam. The OCRES Advanced Exam covers several additional chapters of a textbook on real-time software engineering, plus portions of these nine OMG specifications: OMG MDA Guide UML Profile for Schedulability, Performance, and Time UML Profile for Quality of Service and Fault Tolerance Real-time CORBA with Dynamic Scheduling CORBA for Embedded (CORBA/e) Data Distribution Service Lightweight CORBA Component Model Deployment and Configuration Extensible Transport Frameworks
2630 Programming in Windows 8 with XAML and C# 21 hours Target group: Technical Team Leader, Software Developer Learning objective: The purpose of training is to acquire the ability to develop business desktop applications in Windows 8 with XAML and C#. During the course, students become familiar with the MSDN resources and tools to support the development process, such as Microsoft Visual Studio. IDE Introduction to Visual Studio 2012 First program - Hello WPF World ! Compilation, Debugging Microsoft .NET What is .NET? CLR and Garbage Collector DLL vs. EXE? Technologies within .NET Foundations of Windows 8 Development Windows 8 Development History MVVM design pattern - description Windows 8 Development vs. WPF vs. Windows Forms Differences between XAML with  C#, and HTML 5 with JavaScript In and Out Windows 8 Development project structure XAML, Layout, Dependency Properties Commands and Resources Events Styles and Behaviours Databinding, Data Streams  Data Flow Data modelling in Windows 8 Development Access to databases LINQ Entity Framework CRUD operations Data Validation Controls Controls review User Controls a Custom Controls Templates Advanced topics Asynchronous and parallel operations IoC (Inverse of Control) Unity 2, PRISM Complete Business Application - Real World Application Development of System Architecture in groups based on the specified Business Case Data modelling Implementation Application testing
2561 Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 21 hours This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises. VB.NET Language in Visual Studio 2012 VB.NET Object Orientation VB.NET and Sql Server 2012 Part I. VB.NET Language in Visual Studio 2012 Module 1. Introduction to Visual Basic 2012 The Object-Oriented Programming The Visual Studio 2012 IDE Creating a new Application Using the Help System Module 2. The Microsoft .NET Framework The .NET Framework Classes Executing the Code Common Language Runtime Code Loading and Execution Application Isolation Security Interoperability Exception Handling Module 3. The Visual Basic 2012 Language Data Types Storing Variables Using Methods Making Decisions Working with Data Structures Using Arrays, Enumerations and Collections Module 4. Building Windows Applications Responding to Events Creating the Toolbar Creating the Status Bar Using Multiple Forms OpenFileDialog and SaveDialog controls PrintDialog and FolderBrowserDialog controls Understanding Menu Features Creating Menus Context Menus Part II. VB.NET Object Orientation Module 5. Building Objects Understanding Objects Encapsulation Methods and Properties Managing Events Building Classes Using Constructors Managing Inheritance Module 6. Advanced Language Constructs Using Lambda Expressions Using Async and Wait Using Iterators Module 7. Exception Handling and Debugging Handling Exceptions Try, Catch, Finally The Throw Keyword The Exit Try Statement Using Exit Try Statement Using Exception Properties Logging Errors Module 8. Parallel Programming Using Tasks and Threads Launching Parallel Tasks Transforming Sequential Code to Parallel Code Parallelizing Loops Specifying the Desired Degree of Parallelism Creating and Managing Tasks Part III. VB.NET and Sql Server 2012 Module 9. Database Programming with Sql Server 20012 and ADO.NET The ADO.NET architecture The Connection class The Command and DataReader Classes The ExecuteReader(), ExecuteScalar(), ExecuteNonQuery() methods Using Parameterized Commands Calling Stored Procedure Managing Transactions Module 10. Data Components and the DataSet Building a Data Access Component Managing Disconnected Data The DataSet Class The DataAdapter Class: Filling a DataSet, working with Multiple Tables and Relationships The DataView Class Module 11. Using Data Binding Basic Data Binding Data Source Controls The SqlDataSource Inserting, Updating, Deleting and Selecting records
2462 Introduction to Programming 35 hours The purpose of the training is to provide a basis for programming from the ground up to the general syntax of programming paradigms. The training is supported by examples based on programming languages ​​such as C, Java, Python, Scala, C #, Closure and JavaScript. During the training, participants gain a general understanding of both the programming patterns, best practices, commonly used design and review of the implementation of these topics through various platforms. Each of the issues discussed during the course are illustrated with examples of both the most basic and more advanced and based on real problems. Introduction What is programming and why should devote his attention History of programming Opportunity to automate tasks using the software The role of the programmer and the computer in the enterprise Programming today the development of the current market trends Declarative and imperative programming. How or What? Turing machine Consolidation, compilation and interpretation "on the fly". Reminder issues of logic and Boolean algebra predicates logical sentences tautologies Boolean algebra The first program structurally functionally object And how else? Simple types Representation of strings Integers Floating-point numbers Boolean Type Null A blank or Uninitialized Strong and weak typing Data structures Concepts FIFO and FILO Stacks Queues Declaring arrays and lists Indexing Maps Records Trees Operators Assignment Operators. Arithmetic operators. comparison Operators And a comparison of the values ​​in different languages Bitwise Concatenation Increment and decrement operators The most common errors Controlling the program The if, if else instructions Goto instructions, discuss the problems of application. The switch The for loop, for-in The while loop, do-while foreach loop Stopping loop Creating a reusable code Functional Programming Object-Oriented Programming Functional programming paradigms What is the function of Function and procedure Fundamentals of lambda calculus Function Arguments Returning values Functions as arguments Anonymous functions Closures Recursion The paradigms of object-oriented programming Representation of entities from the real world entities in philosophy, ontology Deciding what you want to object, or other types of Declaration of classes Creating instances of classes Fields, a state of the object Methods, as the behavior of an object abstraction Encapsulation Inheritance polymorphism Association and aggregation Delegation and separation of relationships between objects Modules, packages and libraries Sharing API The modeling of the system as classes and objects Describing and programming relationships between classes Program from a business perspective Good programming practice Pitfalls and common errors High-level code in the interpretation of low-level Code optimization KISS principle DRY principle Principle Worse is Better Separation abstraction of implementation Methods of error detection logic programs Conventions godowania Commenting the code Software Metrics Overview of these technologies and languages The area of application of these languages The main features of language Prospects for development The future direction of development: algorithmic, optimization of code, implementing patterns, design patterns, architectural patterns, analytical standards Reduction of the control structure - the use of artificial intelligence and automated decision-making Which platform to choose? Individual consultations
2138 Understanding Windows Communication Foundation (WCF) 14 hours A two-day instructor-led course to provide participants with the knowledge to understand and help develop distributed applications using WCF 4 and Microsoft Visual Studio 2010. At the end of the course students will have clear indication on how and when to use the various settings and techniques. Service-Oriented Architecture SOA - Definition, scenarios and benefits WCF and SOA First steps into Windows Communication Foundation The Service Contract and the Data Contract The implementation of the Contract Hosting a WCF service: why and how How to consume a service The endpoints The ABC (Address, Binding, Contract) Behaviors> Sharing a contract Proxy creation through Visual Studio When and how to use the Channel Factory Hosting a WCF service Understanding the role of the host The available options for hosting (custom vs. commercial) and how to choose Hosting on IIS, WAS, AppFabric Long running processes and Windows services hosts Creating a custom host - why and how Service host configuration and monitoring Contracts, endpoints and behaviors Contract types The central role of bindings Why having multiple endpoints Interoperability Default endpoints The communication model SOAP vs REST Messaging patterns, how to choose Instancing and Concurrency, combining the options The protocols Understanding the channel stack and the protocols Reliability Improve service reliability by using transactions, queues, and reliable messaging Using routing Discovery and announcements How to discover and make services available through WS-Discovery Testing and troubleshooting How to individuate errors and how to deal with them Exceptions vs Faults Using Fault Contracts How to write custom error handlers and why Message logging and tracing WCF services and security The holistic view Authentication and Authorisation The security model Transport and Message security Extending WCF How and when to extend WCF through behaviors, inspectors and host extensions
1994 Programming in C# 5.0 with Visual Studio 2012 28 hours Target group: Technical Team Leader, Software Developer Learning objective: The purpose of training is to understand the syntax of C # and topics related to object-oriented programming in C #. During the course, students become familiar with the MSDN resources and tools to support the development process, such as Microsoft Visual Studio. IDE Introduction to Visual Studio 2012 First program - Hello C# World ! Classes from System.Console namespace Compilation, Debugging Comments in C#, Main function, using Microsoft .NET What is .NET? CLR and Garbage Collector DLL vs. EXE? Technologies within .NET Foundations of C# C# History from 1.0 to 5.0 Pascal Case, Camel Case Keywords, Literals, Operators, Punctuators Statements, Comments Value Type, Reference Type Assignment vs. variable comparison Conditional operations - If, Switch Loops - for, foreach, while, do… while… Overview of C # keywords and operators C# 5.0 Namespaces and types Numerical and Boolean types Class theory (Encapsulation, Inheritance, Polymorphism) Fields, Properties, Indexers, Operators Methods, Delegates, Events, Anonymous Methods Interfaces, Structures, Enums Arrays, Collections, Exceptions Generic and Anonymous types Strings and chars Data Flow Data modelling in C# Access to databases LINQ Entity Framework CRUD operations .NET Class Library Files and Streams Serialization (binary, text, xml) Asynchronous operations Parallel programming Review of applications that can be developed in C # and .NET Framework 4.5
998 Android Applications Testing 21 hours This course aims at providing software testers with the required knowledge and skills in order to perform quality assurance tests for software applications that were developed for the Android platform. This course overviews the Android platform capabilities and provides you with up-to-date practices for performing the tests. Android Fundamentals - 20 Hours Introduction What is Android? Android SDK Android JVM The Software Stack The Development Tools (ADT) User Interface Installing Development Tools Content Providers Services Intents Activities Views Configuration File Simple Hello World Application Artifacts Asset Packaging Tool Entry Point Activity Intent Calling Other Activities The Activities Stack Paused & Stopped Activities SQLite Database System Management Separated Processes Component & Integration Architecture Application Resources What are Resources? String Resources Layout Resources Code Samples Resource Reference Syntax Compiled Resources Compiled Animation Files Compiled Bitmaps Compiled UI View Definitions Compiled Arrays Compiled Colors Compiled Strings Compiled Styles Compiled Arbitrary Raw XML Files Uncompiled Resources The .apk File Assets Assets & Resources Directory Structure The Intent Concept Introduction Intent Filter Use Intent to Start Activity Android Available Intentions Code Samples Intent Categories Late Run-Time Binding Use Intent to Start Service Broadcast Receivers The Intent Object Structure The Intent Component Name The Intent Action The Intent Data The Intent Category The Intent Extras The Intent Flags Intents Resolution Intent Filter Structure The Action Test The Category Test The Data Test Multiple Matches Android Predefined Intents Samples User Interface Controls Introduction GUI Sample in Source Code GUI Sample in XML GUI Sample in XML & Source Code TextView TextView Sample TextView Style Sample EditText EditText Sample AutoCompleteTextView AutoCompleteTextView Sample MultiAutoCompleteTextView MultiAutoCompleteTextView Sample Button Button Sample ImageButton ImageButton Sample ToggleButton ToggleButton Sample CheckBox Control CheckBox Control Sample RadioButton Control RadioButton Control Sample ListView ListView Sample GridView Control GridView Control Sample Date & Time Controls Gallery Controller MapView WebView Layout Managers Introduction LinearLayout Layout Weight Gravity Samples TableLayout Padding Properties RelativeLayout AbsoluteLayout FrameLayout TabsHost Menus and Dialogs Introduction Menu Interface MenuItem Interface SubMenu Interface Menu Items Group Menu Items Attributes Container Menu Items System Menu Items Secondary Menu Items Alternative Menu Items Creating Menu,Sample Menu Items Groups Menu Items Events Handling Overriding Callback Function Define Listener Using Intents Expanded Menu Icon Menus Sub Menus System Menus Context Menus Samples Handling Menu Events Creating Menu using XML Alert Dialog Prompt Dialog Samples Location Based Services Introduction The Map Key The MD-5 Signature Google Maps Key Required Permissions Code Sample The Map Controller Code Samples Maps Overlays Code Samples The Geocoder Class The Address Class The LocationManager Class The LocationListener Interface The Debug Monitor Service (DMS) Android Security Model Introduction Deployment The keytool Utility The jarsigner Utility Deployment using Eclipse Separated Processes Declarative Permission Model Application Life Cycle Introduction Activity Life Cycle Methods The onStart() and onResume() Methods The onPause() and onStope() Methods Return Back to Previous Activity The onStop() and onDestroy() Methods The onCreate() Method The onPause() Method SQLite Database Introduction SQLite Implementation The SQLiteOpenHelper Class The onCreate() Method The onUpgrade() Method The onOpen() Method The getWriteableDatabase() Method The getReadableDatabase() Method The SQLiteDatabase Class,The execSQL() Method The insert() Method,The delete() Method The rawQuery() Method() Code Samples The query() Method Code Samples Providers Introduction Android Built-In Content Providers SQLite Database Content Providers Architecture Content Providers Registration Content Providers REST Access Content Providers URL Structure Content Providers Mime Types Using Content Provider Retrieving Records Adding Records The Cursor Object The ContentValues() Object Content Provider Demo File Management Introduction Creating Files Accessing Simple Files Accessing Raw Resources XML Files Resources SD Card External Storage Background Applications Introduction Services Background Threads Making Toasts Notifications Other System Services Background Activity Sample Activity Data Introduction The Intent Class Start Activity Methods Passing Data between Activities Coherent User Experience Code Sample Web View Introduction The WebView Class The android.webkit Package The INTERNET Permission The loadUrl() Method JavaScript Support The loadData() Method The WebView Methods The WebViewClient Class The WebChromeClient Class Java Language Introduction The Limits Third Party Java Libraries Debugging Introduction Eclipse Java Editor Eclipse Java Debugger Logcat Android Debug Bridge Dalvik Debug Monitor Service Traceview Accelerometer Introduction The SensorManager Class The SensorListenr Interface Localization Introduction Default Resources Current Locale Testing Custom Locale Code Samples Speech Input Introduction The RecognizerIntent Class Start Speech Recognition Google Server Side The Language Model Free Form Language Model Web Search Language Model Development Tools Introduction The aapt Tool The adb Tool The android Tool The ddms Tool The dx Tool The draw9patch Tool The emulator Tool Android Applications Testing Practices - 4 Hours Automated Testing JUnit Testing Using Assertions Instrumentation Framework On Device Testing User Interface & Consistency Functionality of Interaction with the OS Networking Testing Stress Test Conditions International Support Testing General Requirements On Device Remote Testing DeviceAnywhere Platform Scenarios To Be Care Of
113 Developing Websites with PHP 14 hours This course deals with developing web applications in PHP. The course has be created for people already familiar with other procedural programming languages. During the course participants will learn how to create a simple dynamic application with PHP and a MySQL database. PHP Language Syntax and Basic Concepts PHP Install and Libraries PHP Syntax PHP Variables PHP String PHP Operators If...Else, Switch Arrays While Loops For Loops Functions Forms forms feedback, GET and POST PHP Include Data Structures associative arrays session variables, global variables, cookies Date> File and File Upload Cookies and Sessions E-mail Error Handling Exceptions Handling PHP Filter Object Oriented Programming (OOP) classes access modifiers constructors inheritance Using Databases connect to the database storing passwords executing queries processing data modifying and removing data binding form to records in the database Security authorization and authentication using cookies and sessions Dealing with Images GD Library and alternatives PHP XML SimpleXML Expat Parser XML DOM
2173 Advanced Foundations of .NET 2.0 Development 21 hours Objectives Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features. Implement interoperability, reflection, and mailing functionality in a .NET Framework application. Implement globalization, drawing, and text manipulation functionality in a .NET Framework application. Audience The audience for this course consists of Application Developers with the skills to develop business applications by using Visual Studio 2005 with either Visual Basic .NET or Visual C#. Creating Globalized Applications Culture Information by Using Globalization Classes Creating a Custom Culture Working with Primary Encoding Classes Working with Advanced Encoding Classes Working with GDI+ in Windows-based Applications Working with Graphics, Brushes, Pens, Colors, and Fonts Manipulating the Shapes and Sizes of Graphical Objects Working with Images, Bitmaps, and Icons Implementing Code Access Security Configuring Code Access Security Managing Security Policy Managing Permissions Managing Access Control Managing User Identity Information Implementing Cryptography Encrypting Data Hashing Data Extending the Cryptographic Behavior Interoperating Between COM Components and Assemblies Accessing COM Components by Using Interop Services Exposing an Assembly to COM Components by Using Interop Services Accessing COM Components by Using Platform Invocation Services Working with Service Applications and E-mail Messages Working with a Windows Service Application Working with E-mail Messages Working with Type Metadata Working with Type Metadata by Using Pre-defined Assembly Classes Working with Assemblies Dynamically by Using Custom Classes Creating Multithreaded Applications and Application Domains Managing Threads in a Synchronous Environment Synchronizing Threads Managing Threads in an Asynchronous Environment Working with Application Domains
34 SQL Fundamentals 14 hours This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases. RDBMS (Relational DataBase Management System) Relational Operators SQL as Declarative Language SQL Syntax SQL Sublanguages DQL, DML, DDL, DCL DQL (Data Query Language) in Detail SELECT clause Column aliases Table aliases Date types and Date functions Group function Table joins JOIN clause UNION operator Nested queries Correlated subqueries DML (Data Manipulation Language) Overview Inserting rows (INSERT) Inserting rows using subquery Updating rows (UPDATE) Deleting rows (DELETE) DDL (Data Definition Language) Overview Creating, altering and dropping objects (CREATE, ALTER, DROP) Creating tables using subquery (CREATE TABLE .... AS SELECT...) CONSTRAINTS Overview NULL i NOT NULL CONSTRAINT clause ENUM type SET type PRIMARY KEY UNIQUE FOREIGN KEY DEFAULT clause Transactions Overview COMMIT ROLLBACK SAVEPOINT Implicit and explicit rollbacks and commits SQL Dialects Overview MySQL Microsoft Access and SQL Server Oracle and PostgreSQL
2622 Programming using ASP.NET MVC 4 21 hours Objectives MVC Web applications offer a clean separation of concerns between the business-logic classes, Web pages, and the controller. Microsoft ASP.NET MVC 4 offers Web developers all the benefits of MVC allied with all the power of the .NET platform. This course provides full coverage of ASP.NET MVC 4, including Test Driven Development and JQuery. After completing this course, delegates will be able to Understand the Role of the Model, View, and Controller Design Pattern Create Industrial-Strength Applications Apply Test Driven Development Methods Implementing Navigation Between Pages Implement Rich User Interfaces with JQuery and Ajax Audience ASP.NET developers who want to use the MVC architecture. Module 1: Getting Started with ASP.NET MVC ASP.NET MVC project templates Understanding the structure of an ASP.NET MVC project Naming conventions Creating views Defining controllers Defining a data model Module 2: Creating a Complete ASP.NET MVC Application Creating strongly-typed views Understanding URLs and action methods Using HTML helpers Handling form post-backs Data validation Module 3: Using the Razor View Engine Razor design goals Implementing a Razor view Razor syntax Accessing model data in Razor views Module 4: Industrial-Strength ASP.NET MVC Applications ASP.NET application architecture best practices Implementing a repository and Entity Framework data model Using Dependency Injection Implementing a custom controller factory Module 5: Test Driven Development with ASP.NET MVC Recap of TDD Unit Testing frameworks Walk-through of using TDD with ASP.NET MVC Module 6: View Techniques Defining and using custom HTML helpers Defining a layout/master page Using styles Defining and using partial views Razor helper method syntax Module 7: Implementing Navigation Defining view-model classes Implementing data filtering in a controller Understanding the routing mechanism Adding custom entries to a route table Defining defaults, parameters, and validation Generating URLs and hyperlinks Custom route constraints Module 8: State Management Using hidden fields Session and application state Custom model bindings Module 9: Additional Techniques View scaffold templates Controller scaffold templates Global filters Model binding Asynchronous controllers Authentication options, including enabling logins from Facebook etc. Module 10: Using Ajax and jQuery with ASP.NET MVC Overview of Ajax and ASP.NET MVC Unobtrusive Ajax Using Ajax action links Overview of jQuery jQuery techniques Using jQuery UI
2559 Design Patterns in PHP 14 hours The course will cover the design patterns with particular emphasis on patterns used in PHP. Introduction to Design Patterns What is a design pattern Elements of pattern Advantages and disadvantages of using patterns GoF Design Patterns Patterns creative Builder Factory (Abstract Factory, Factory Method) Prototype Singleton Structural patterns Delegator Interface Facade Composite Immutable Adapter Decorator Proxy Behavioral patterns Command Template method Observer Chain of responsibility (oraz Intercepting Filter) Observer (2 version) Strategy Patterns of Enterprise Application Architecture Web MVC - Model View Controller HMVC, MVP Inversion of Control Dependency Injection Container Active Record The concept of entity and Repositories Decomposition of the system Examples of component-based Symfony 2 and Zend Framework 2
2461 Programming in Scala 14 hours The training aims to provide opportunities Scala language, learning the syntax of programming paradigms and space applications. Introduction What is Scala The paradigms of object-oriented programming Functional programming paradigms Scala and Java Language runtime environments Basics of Scala data Types Operators The control instructions and loops Object-Oriented Programming Classes Fields Methods Objects and instances Inheritance, abstraction, encapsulation, polymorphism Features Functional Programming A function declaration function Arguments closures anonymous functions recursion delayed initialization Packages Packages Scala language Importing packages Create your own packages Other aspects of the Scala language general types exceptional service case of the class. collections, data structures parameters alleged metaprogramming concurrent programming
2073 PostgreSQL Administration 28 hours This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching. What is PostgreSQL? A Brief History of PostgreSQL Conventions Further Information Bug Reporting Guidelines Introduction to PostgreSQL Installation and Creating Database The SQL Language Advanced Features The SQL Language SQL Syntax Data Definition Data Manipulation Queries Data Types Functions and Operators Type Conversion Indexes Full Text Search Concurrency Control Performance Tips Server Administration Installation from Source Code Installation from Source Code on Windows Server Setup and Operation Server Configuration Client Authentication Database Roles Managing Databases Localization Routine Database Maintenance Tasks Backup and Restore High Availability, Load Balancing, and Replication Recovery Configuration Monitoring Database Activity Monitoring Disk Usage Reliability and the Write-Ahead Log Regression Tests Client Interfaces libpq - C Library Large Objects ECPG - Embedded SQL in C The Information Schema Server Programming Extending SQL Triggers The Rule System Procedural Languages PL/pgSQL - SQL Procedural Language PL/Tcl - Tcl Procedural Language PL/Perl - Perl Procedural Language PL/Python - Python Procedural Language Server Programming Interface Internals Overview of PostgreSQL Internals System Catalogs Frontend/Backend Protocol PostgreSQL Coding Conventions Native Language Support Writing A Procedural Language Handler Writing A Foreign Data Wrapper Genetic Query Optimizer Index Access Method Interface Definition GiST Indexes GIN Indexes Database Physical Storage BKI Backend Interface How the Planner Uses Statistics
1987 Cross Train to Android 35 hours A comprehensive course for Java application developers to cross train to Android Overview The Android Framework Dalvik & Linux Principles Getting it all up and Running Eclipse and the ADK Using the DDMS debugger Core Android – The Concepts The Manifest Widgets Activities - the basic types Intents Services Content Providers & SQLite Broadcast Receivers The Application Context Essential Internals Bundles and Intents The Activity Lifecycle Notifications Alarms The User Interface What Android has to offer – Widgets & Views in detail Program vs Declarative XML – Layouts of all kinds Styles & Stateful Drawables AlertDialogs & Menus The AppWidget Events and Event Handling Short Touch and Long Touch Context Menus Other Events Handling Gestures A First Practical Project Preferences Files and Databases Lists, Adapters and ListViews Services & Broadcast Receivers Using Other Apps From Your Own Threading The UI thread Background threads Async task Handlers and Loopers - Custom Pipeline Threads Local Persistence - SQLite in depth DBHelper Content Providers The Android File System Exception Handling Custom Exception Handlers Uncaught Exceptions Consuming Web Services – SOAP and REST kSOAP2 rest.org JSON XML Location Based Services GPS service Mapping Phone Location Services Phone Orientation Augmented Reality Applications Graphics SurfaceView OpenGL Graphics2D Using the Camera Signature Capture Media Framework Audio & Video Best Practice and Open Source add-ons Using Custom Base Classes CommonsWare Additions Application Deployment - The Market and Signing
997 Android Effective Programming 14 hours The android platform targets various handsets of different screen size and different capabilities. This course overviews the recommended practices based on android applications developers experience and based on the official guidelines published by the google android team. Introduction User Interface Performance Responsiveness Seamlessness Architecture
2001 Programming in ASP.NET MVC 4 21 hours Target group: Technical Team Leader, Software Developer Learning objective: The purpose of training is to acquire the ability to develop business internet applications in ASP.NET MVC 4 technology and in C # language. During the course, students become familiar with the MSDN resources and tools to support the development process, such as Microsoft Visual Studio. IDE Introduction to Visual Studio 2012 First program - Hello ASP.NET MVC World ! Compilation, Debugging, Publish Microsoft .NET What is .NET? CLR and Garbage Collector DLL vs. EXE? Technologies within .NET Foundations of ASP.NET MVC ASP.NET History MVC design pattern - description MVC vs. Web Forms Differences between MVC 1.0, 2.0, 3.0, 4.0 In and Out ASP.NET MVC project structure Resources URLs and Routing Controller, Action, View Filters POST and GET methods Data Forms Data Flow Data modelling in ASP.NET MVC Access to databases LINQ Entity Framework CRUD operations Data Validation WCF – short introduction to SOA Advanced topics IoC (Inverse of Control) Asynchronous and parallel operations Unity 2 Complete Business Application - Real World Application Development of System Architecture in groups based on the specified Business Case Data modelling Implementation Application testing
2618 WildFly Server Administration 14 hours This course is created for Administrators, Developers or anyone who is interested in managing WildFly Application Server (AKA JBoss Application Server). This course usually runs on the newest version of the Application Server, but it can be tailored (as a private course) to older versions starting from version 5.1. Module 1: Installing Core Components Installing the Java environment  Installing JBoss AS Application server features Creating a custom server configuration Module 2: Customizing JBoss AS Services How to monitor JBoss AS services JBoss AS thread pool Configuring logging services Configuring the connection to the database Configuring the transaction service Module 3. Deploying EJB 3 Session Beans Developing Enterprise JavaBeans Configuring the EJB container Module 4: Deploying a Web Application Developing web layout Configuring JBoss Web Server Module 5: Deploying Applications with JBoss Messaging Service The new JBoss Messaging system Developing JMS applications Advanced JBoss Messaging Module 6: Managing JBoss AS Introducing Java Management Extension JBoss AS Administration Console Managing applications Administering resources
46 Design Patterns 14 hours There are plenty of tried and tested patterns widely available to everyone. Sometimes it is a matter of changing the names and implementing the pattern in a specific technology. It can saves hundreds of hours, which otherwise would be spent on design and testing. Training Goals This course has two goals: first, it allows you to reuse widely-known patterns, second, it allows you to create and reuse patterns specific to your organization. It helps you to estimate how patterns can reduce costs, systematize the design process and generate a code framework based on your patterns. Audience Software designers, business analysts, project managers, programmers and developers as well as operational managers and software division managers. Course Style The course focuses on use cases and their relationship with a specific pattern. Most of the examples are explained in UML and in simple Java examples (the language can change if the course is booked as a closed course). It guides you through the sources of the patterns as well as showing you how to catalogue and describe patterns which can be reused across your organization. Introductions Patterns and tiered architectures Pattern description Design patterns and design Finding and selecting design patterns Design pattern implementation Well-known patterns Object Creation Factory Builder Factory Method Prototype Singleton Structural Patterns Adapter Bridge Composite Decorator Facade Flyweight Proxy Behavioural Patterns Chain of Responsibility Command Interpreter Iterator Mediator Memento Observer State Strategy Template Method Visitor Observer Creating Patterns To pattern or not to pattern Formal pattern description Organizing the pattern catalogue Particular goal and abstracted goal Publishing your patterns to a pattern community
2621 Symfony2 - enterprise web framework 21 hours OOP, common information OOP paradigm Decomposition of code PHP 5.3 and 5.4, new features Symfony Short overview Symfony2 and other framework comparison Symfony 1.x and 2.x - ne concept Symfony + Doctrine  = enterprise tool MVC Twig Basics of Yaml Routing Doctrine ORM Repository Pattern, Entity Manager, DDD Testing your code Creating custom bundles Security How to debug your code Console tools Dependency management IoC and DIC Creating REST API Silex Symfony2 and business Development plan for 2.x Symfony and enterprise systems Support and trainings Community Framework popularity Estimating costs of implementing simple CRUD system Symfony alternatives
2558 Introduction to CSS3 7 hours The course provides an introduction to the latest standard CSS (Cascading Style Sheets). We will present new elements of style sheets, providing greater opportunities for formatting and the current level of support for standard browsers. Introduction to CSS What is CSS CSS capabilities and applications CSS history CSS3 new CSS3 standard elements support from different browsers media selectors pseudo classes / components text - styling, effects, use of web fonts color, transparency, gradient background images and Decoration transformations animation distribution management (columns, box layout, template layout) Future extension of CSS3
2459 JavaScript - Advanced Programming 14 hours The training is designed for JavaScript developers, designing and implementing advanced Internet applications. Topics discussed during the training aimed at bringing best practices in JavaScript programming and highlight the most common mistakes. An important point of the training is to discuss the available object-oriented programming with JavaScript syntax. JavaScript - object orientation Creating classes and objects The most important pre-defined objects Prototyping and constructors Encapsulation polymorphism Inheritance Aggregation Design Patterns Singleton Factory Observer Factory Decorator Strategy Advanced JavaScript programming patterns Self-timer features Create an alias objects Namespaces module Pattern Switching Libraries "on demand" Basics of designing your own library AJAX Fundamentals of asynchronous communication The XMLHttpRequest object JSON And server response error handling JSONP
2072 OpenESB-Java CAPS for developers and architects advanced level 14 hours This course is dedicated to developers and architects who want to be operational immediately on OpenESB and want to start and be involved on real OpenESB projects. The training scope covers the advanced OpenESB concepts frequently used in projects like correlation and compensation. This 2 day course will allow you to serenely tackle your integration in operational OpenESB projects. SOA development Process Introduction to Pymma service oriented development process Rebecca based on TOGAF principle Fault and exception management in BPEL Faults and Exception management in BPEL Faults, exceptions, Catch, Handlers Advanced concept and exercises BPEL Compensation Introduction to compensation in a BPEL process Advanced concept and exercises BPEL Correlation Introduction to Correlation in a BPEL process Advanced concept and exercises BPEL mapper advanced Features BPEL mapper advanced Features (Predicate, Java calls…) Transaction, Guarantee of delivery, consistency with OpenESB Advanced lecture on Guarantee of delivery consistency concept with OpenESB Exercises 50% of the time is dedicated to practical use cases and exercises
1979 Struts 2 Framework 21 hours This course deals with developing MVC (Model-View-Controller) web application using the features of Struts2 framework. The participants will learn how to work with the actions and the data, how to develop interceptors and the OGNL for type conversion. This course will also cover concepts like validation, internationalization and how to persist data. Introduction to Struts2 Web applications: a quick study Why use a framework for web applications The Struts2 framework and the declarative architecture The support of annotations Actions and Interceptors The role of actions Implementing and packaging actions How to dialogue with data The role of interceptors Developing and declaring interceptors The request/response life cycle OGNL (Object-Graph Navigation Language) The common tasks in a web application Data transfer and type conversion The built-in converters How to build a custom type converter How to validate data The validation framework Using the built-in rules Writing a custom validator Writing the actions for validation Internationalization Java i18n and Struts2 framework How to use Struts2 i18n The default local determination Struts2 integration and the persistence layer Using Spring with Struts2 The concept of injection Why use the JPA with Struts2 Integrating Struts2 with Hibernate
996 Android Hybrid Applications 35 hours One of the android platform available user interface control, is the web view. The web view functions as a small web browser and is capable of parsing and displaying data similarly to any web browser. Its implementation is based on the WebKit open source browser. The same engine Chrome and Safari are based on. The methods we can call on a web view object allows us having a smooth integration between the data displayed within the web view and the native part of our application. This integration allows us to enjoy both worlds. This course focuses on these new types of applications, also known as hybrid applications. XHTML CSS DOM HTML5 JavaScript Ajax jQuery jQuery Mobile WebView
107 Visual Basic for Applications (VBA) in Excel - Advanced 21 hours The course reveals the secrets of effective writing advanced applications in VBA application MsExcel. After the course you can: Write an advanced object-oriented application Convert text files Use of external data sources Use external libraries Excel Object Model The protection sheet from VBA Object Workbook, Workbooks collection Worksheet Object, Collection Worksheets Validation sheets Practical methods of the Range object Copy, paste, paste special Property CurrentRegion Find, replace Sorting ranges Charts (Object Chart) Events Application-level events Boards Dynamic arrays Table arrays Variant Optimizing arrays and memory Multi-dimensional arrays Object-Oriented Programming Classes and Objects Creating classes Creating and Destroying Objects Create methods Create property Validation data using property The default properties and methods Error handling in the classroom Create and manage collections Create a collection Adding and removing items References to the components (using a key and an index) Advanced structures and functions VBA Passing parameters by value and reference (ByRef and ByVal) Procedures with a variable number of parameters Optional Parameters and Defaults Procedures of unknown number of parameters (ParamArray) Enumeration, convenient parameter passing Type the user (User-defined Type) Service Null, Nothing, empty string "", Empty, 0 Type conversion (Conversion) File Operations Opening and closing text files Reading and writing text and binary data Processing of records in the CSV file Efficient processing of text files Use VBA functions in other applications Extras Create your own add-ons Create a toolbar for addition Installing your own add-ons and their protection Using external libraries Connecting to external databases (ODBC, OLEDB)
287824 MariaDB Galera Cluster Administration 21 hours This course is intended for database administrators. The course presents options for High-Availability solutions using Galera Cluster. You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster. Topic overview Why I need them and what are High-Availability solutions? Cluster concepts ​What is MariaDB Galera Cluster and what it offers to my organization? Galera Cluster Management How to start with Galera - what should I now before installation? Architecture and functionality First steps - Installation Going deeper - Configuration and Set-up Almost like a pro - Administration Performance Operations and operation modes Upgrade Galera Backups and restoring ​Controlling state transfer between nodes Load balancing Monitoring How to deal with Galera multi- master configuration Advanced features Security Scalability Replication ​Advanced configuration
287977 MATLAB Fundamental 21 hours This three-day course provides a comprehensive introduction to the MATLAB technical computing environment. The course is intended for beginning users and those looking for a review. No prior programming experience or knowledge of MATLAB is assumed. Themes of data analysis, visualization, modeling, and programming are explored throughout the course. Topics include: Working with the MATLAB user interface Entering commands and creating variables Analyzing vectors and matrices Visualizing vector and matrix data Working with data files Working with data types Automating commands with scripts Writing programs with logic and flow control Writing functions Part 1 A Brief Introduction to MATLAB Objectives: Offer an overview of what MATLAB is, what it consists of, and what it can do for you An Example: C vs. MATLAB MATLAB Product Overview MATLAB Application Fields What MATLAB can do for you? The Course Outline Working with the MATLAB User Interface Objective: Get an introduction to the main features of the MATLAB integrated design environment and its user interfaces. Get an overview of course themes. MATALB Interface Reading data from file Saving and loading variables Plotting data Customizing plots Calculating statistics and best-fit line Exporting graphics for use in other applications Va​riables and Expressions Objective: Enter MATLAB commands, with an emphasis on creating and accessing data in variables. Entering commands Creating variables Getting help Accessing and modifying values in variables Creating character variables Analysis and Visualization with Vectors Objective: Perform mathematical and statistical calculations with vectors, and create basic visualizations. See how MATLAB syntax enables calculations on whole data sets with a single command. Calculations with vectors Plotting vectors Basic plot options Annotating plots Analysis and Visualization with Matrices Objective: Use matrices as mathematical objects or as collections of (vector) data. Understand the appropriate use of MATLAB syntax to distinguish between these applications. Size and dimensionality Calculations with matrices Statistics with matrix data Plotting multiple columns Reshaping and linear indexing Multidimensional arrays Part 2 Automating Commands with Scripts Objective: Collect MATLAB commands into scripts for ease of reproduction and experimentation. As the complexity of your tasks increases, entering long sequences of commands in the Command Window becomes impractical. A Modelling Example The Command History Creating script files Running scripts Comments and Code Cells Publishing scripts Working with Data Files Objective: Bring data into MATLAB from formatted files. Because imported data can be of a wide variety of types and formats, emphasis is given to working with cell arrays and date formats. Importing data Mixed data types Cell arrays Conversions amongst numerals, strings, and cells Exporting data Multiple Vector Plots Objective: Make more complex vector plots, such as multiple plots, and use color and string manipulation techniques to produce eye-catching visual representations of data. Graphics structure Multiple figures, axes, and plots Plotting equations Using color Customizing plots Logic and Flow Control Objective: Use logical operations, variables, and indexing techniques to create flexible code that can make decisions and adapt to different situations. Explore other programming constructs for repeating sections of code, and constructs that allow interaction with the user. Logical operations and variables Logical indexing Programming constructs Flow control Loops Matrix and Image Visualization Objective: Visualize images and matrix data in two or three dimensions. Explore the difference in displaying images and visualizing matrix data using images. Scattered Interpolation using vector and matrix data 3-D matrix visualization 2-D matrix visualization Indexed images and colormaps True color images Part 3 Data Analysis Objective: Perform typical data analysis tasks in MATLAB, including developing and fitting theoretical models to real-life data. This leads naturally to one of the most powerful features of MATLAB: solving linear systems of equations with a single command. Dealing with missing data Correlation Smoothing Spectral analysis and FFTs Solving linear systems of equations Writing Functions Objective: Increase automation by encapsulating modular tasks as user-defined functions. Understand how MATLAB resolves references to files and variables. Why functions? Creating functions Adding comments Calling subfunctions Workspaces  Subfunctions Path and precedence Data Types Objective: Explore data types, focusing on the syntax for creating variables and accessing array elements, and discuss methods for converting among data types. Data types differ in the kind of data they may contain and the way the data is organized. MATLAB data types Integers Structures Converting types File I/O Objective: Explore the low-level data import and export functions in MATLAB that allow precise control over text and binary file I/O. These functions include textscan, which provides precise control of reading text files. Opening and closing files Reading and writing text files Reading and writing binary files Note that the actual delivered might be subject to minor discrepancies from the outline above without prior notification. Conclusion Note that the actual delivered might be subject to minor discrepancies from the outline above without prior notification. Objectives: Summarise what we have learnt A summary of the course Other upcoming courses on MATLAB Note that the course might be subject to few minor discrepancies when being delivered without prior notifications.
2607 Using and managing the database in MySQL 14 hours Participant will learn: Can I use MySQL for free? What do I offer a commercial license? How to install a MySQL database? How to perform basic operations on the installation? What are the available tools for managing and programming in a MySQL database? Legal aspect MySQL MySQL's dual license policies Commercial License Open Source License Installing MySQL Standard installation of MySQL (binary files) Installing MySQL on Windows or Unix-like (GNU / Linux, FreeBSD) Tuning the server after installation, testing Upgrading MySQL Connecting to the server Making queries Creating and using databases Creating and selecting a database Creating tables Importing data into the table Obtaining information about the database and tables Using the mysql command in batch (Batch Mode) Discussion of the utilities Ways to call the program Setting program options (command line, the configuration file, environment variables) Setting the program variables via command line GUI tools for managing and programming the database MySQL Administrator MySQL Query Browser Toad for MySQL
2549 Basics of C # language based on object model 35 hours Object oriented Features of the object model The object type in the context of the object Task: Object Modeling Summary of tasks Task: identify the characteristics and behaviors of an object Summary of tasks: clarifying the concept of "accumulation" Task: refactoring the model with "collection" Summary of tasks Task: development of an object model Summary of tasks The relationship of the object model Associations Association described the direction and range Relationships of composite and partial aggregation Task: Identification of associations in the object model Summary of tasks Task: Identification of aggregation Summary of tasks Simple types and collections in C # Characteristics of simple types Collections in C # Task: completion of an object model Summary of tasks: aggregation = collection Object Features: Encapsulation = VISIBILITY Characteristics of visibility in C # Presentation of the visibility of the object model Task: completion of the object model of the visibility Summary of tasks Implementation of the object model in C # Define a reference type = class Task: Create a class Summary of tasks Define component classes: characteristics and behavior = features and functions Task: Define component classes Summary of tasks Implementation of logic in C # Characteristics of arithmetic and logical operators in C # Characteristics of conditional statements IF and SWITCH Cyclic data processing foreach, for and types while "Contract" the difference between function and method Task: Implementation of logic Summary of tasks Starting the application Introduction to keep track of the program Task: Review the program Task: the use of tracking and STACK TRACE WATCH Tracking Summary Object Features: Inheritance Task: change requirements Summary of tasks Characteristics of the inheritance relation Task: the use of inheritance in object model Summary of tasks Inheritance from the perspective of C # Task: implementation inheritance Summary of tasks: the advantages of inheritance Overriding, overwrite and new versions of components in C # = overload, OVERRIDE, NEW Task: detailing the implementation Summary of tasks Polymorphism Characteristics of polymorphism Task: to understand the polymorphism A summary of the task: tracing of the polymorphism in DEBUG mode type casting in C # = operator AS, explicit and implicit projection Task: the use of polymorphism Summary of tasks Pattern object type = abstract class Characteristics of abstract classes Use an abstract class for the object model Task: the definition of abstract classes Summary of tasks Components of an abstract type = ABSTRACT Task: completion of the implementation Summary of tasks Protection of abstract classes from changes in the derived classes in C # Interface Interface Characteristics Difference between abstract class and interface Task: Identification of interfaces Summary of tasks Task: the choice between an interface and abstract class Summary of tasks Task: implement interfaces Summary of tasks Task: change requirements Summary of tasks: the advantages of interfaces "Solid" in C # Characteristics of continuous variables in C # - CONST, READONLY Task: completion of the implementation of a continuous variable Summary of tasks Structured types and enumerations in C # Characteristics of structured types - STRUCT Characteristics of the calculations - ENUM Task: to enrich the implementation of the calculation Summary of tasks
2439 Android App Delivery (bespoke) 28 hours The aim of this training course is to enhance the delivery and experience of native Android applications with a mixture of presentations and exercises. Billing – understanding more about the Google Play billing system Optimisation – best way to optimise the app by optimising images, reusing views correctly Publishing and using Proguard – gain a better understanding of using Proguard and the publishing processes Fragments best practice – understanding the best way to use fragments and a greater understanding of the fragments lifecycle Thread management and networking – improve how we handle network tasks, manage threads and being able to manage the lifecycle of a task Database Q&A – more of a session to run over our own implementation to see if it's viable Profiling –how can we incorporate profiling into what we do so that we can identify speed improvements Grid layouts – we'd like to take a look to see if it would help us make more efficient layouts Tablet best practice – see how a tablet app is best made and what pitfalls can be avoided before we implement our own experience
2071 OpenESB-Java CAPS for developers and architect expert level 14 hours This advanced training is mainly dedicated to architects and developers working on critical projects where high availability is required. In this course, we will tackle NMR properties and dynamic addressing; you will learn new components like POJO, IEP and advanced features on classical component (ex: File BC). JBI architecture will be reviewed in detail too. In the second part, we will go deeper in Glassfish and OpenESB basic and advanced concepts useful in this kind of environment. Cluster and High Availability best practice will be tackled during the course. Around 60% of the training will be dedicated to practical exercises on Linux and Windows. OpenESB advanced component Intelligent Event Process Plain Object Java Object… Normalised Message Properties What are the Normalised Message Properties? Ex with Http SE, JMS BC, file BC BPEL dynamic addressing Introduction to Dynamic addressing How it works? How to use it in which context JBI Architecture JBI Architecture first approached Clustering basic concepts Technical concepts on clustering, high availability Business process behaviour in multi instance environment Glassfish Application server in cluster GF V2.x cluster hierarchy Domain Cluster Instance Node-agent OpenESB in a clustered environment OpenESB constraints in a clustered environment Components behaviour in a multi instance mode File BC, JMS BC, HTTP BC, JDBC BC et BPEL SE Administrative tools Glassfish console Asadmin Practice ex: 1 IEP simple exercise Practice ex: 2 Dynamic addressing with Http BC Practice ex: 3 Set up a cluster and OpenESB applications deployment using the Glassfish admin console Practice ex: 4 Set up a cluster and OpenESB applications deployment using Asadmin Practice ex: 5 JMS Cluster Setting: Embedded and External cluster
1978 Java Persistence with Hibernate 14 hours This course teaches the practical use of Hibernate for persisting Java objects in a relational database. Introduction to Hibernate Introducing Hibernate The Object/Relational Mapping Problem JDBC The Users-Roles Schema Tools and Environment Setup Creating the Database Configuring Hibernate Hibernate Distributions Required Libraries Configuration Files hibernate.properties hibernate.cfg.xml Hibernate Persistence The Hibernate Architecture SessionFactory Methods Hibernate Sessions Object States State Transitions Session Methods Transactions Session-Per-Operation Session-Per-Request The Data Access Object Pattern Object/Relational Mapping Object-Oriented Design Relational Mapping Bidirectional Association O/R Mapping Techniques The Mapping Document The Mapping XML Model Primary Keys and Identity Generating Identifiers Other Mapping Elements Components Mapping Associations The Mapping XML Model for Associations Unidirectional Many-to-One Eager Fetching Bidirectional One-To-Many Bidirectional One-To-One Mapping Inheritance Inheritance and Databases Single-Table Inheritance Mapping Single-Table Inheritance Table-Per-Subclass Table-Per-Subclass Mapping Table-Per-Concrete-Class The Hibernate Query Language The Hibernate Query Language Fundamentals HQL Queries Polymorphism Named Parameters Entity Parameters Joining on Associations Aggregate Methods Updates and Deletes Named Queries Using Native SQL
995 Java Fundamentals for Android 14 hours Applications for the Android platform are developed primarily in Java. This course was developed for software programmers with a strong OOP background (whether in PHP, Scala, C++, C# or Objective C) that plan to learn how to develop Java applications for the android platform. This course covers the Java programming language grammar and focuses on those specific Java capabilities the android platform uses more than others. Let's Start History JVM JDK JRE Hello World JavaDoc Classes & Packages API Documentation The Basic Java comparing with C++ Simple Output Remarks Native Data Types Variables Keywords Identifiers Expressions & Operators Simple & Compound Statements Control Statements Looping Statements Assignments Local Variables Assertion Annotations Introduction to OOP Software Development Cycle Objects & Classes Key Features of OOP Relationships between Objects Object Oriented Programming Objects Classes & Class Type Variables Declaring Classes, Class Type Variables Calling a Method The 'this' Special Keyword Class Declaration Declaring Attributes Declaring Methods Methods Overloading Declaring Constructors Default Constructors Overloading Constructors Using 'this' within Constructors Static Variables Static Methods Static Initializers Final Variables Software Packages Package Statement The 'import' Statement Declaring Enums Java API Documentation Arrays & Strings Array of Native Type Values Array of Objects Square Brackets Position Copying Array Values Multi Dimensional Array The 'length' Variable The 'String' Class Instantiating String Comparing Strings The 'toString()' Method The StringBuffer Class The StringBuilder Class The StringTokenizer Class Passing Arguments to 'main' Method Inheritance Introduction to Inheritance Inheritance in Java Derivation Syntax Inheritance Meaning Constructors & Inheritance Access Modifiers Overriding Methods Polymorphism Constructors & 'super' Keyword Abstract Class Interfaces The 'instanceof' Operator Casting References Deprecated Methods The 'object' Class Inner Classes Inner Classes Types In-Depth Meaning Inner Classes within Methods Anonymous Inner Class Static Inner Class Exceptions Handling The Exceptions Handling Mechanism Exceptions Classes Hierarchy Three Types of Exceptions Try&Catch Statement The 'throw' Command The Throwing Chain The 'finally' Block The 'throws' Adding The 'Handle or Declare' Rule Methods Overloading, Samples Threads Basics What is a Thread? The Thread Parts Creating New Thread Starting The Thread Multiple Threads I/O Streams Java I/O Overview I/O Streams Categories Byte & Char Streams The InputStream Abstract Class The OutputStream Abstract Class Writing/Reading To/From Files Generics Introduction Subtypes Wildcards Collections Introduction Performance Set List Queue Map
2201 Mobile Development - An Overview for Decision Makers 7 hours A tour of the technologies which can be used to efficiently target smartphones and tablets users. The pros and cons, the skills required, the business implications. Audience This course is intended for decision makers such as company directors, CTO’s, business analysts, project managers, software architects and all the ones who need to understand the implications of a technology choice before committing into one or another. After completing this course, participants will be able to: Identify the main actors on the mobile development arena Understand the major implication of a technology from the user point of view Understand in broad terms the skills required to develop and maintain each technology What does mobile application mean? An overview over the markets Native vs web vs hybrid application What are the options available today and the skills/resources needed for each What is the average cost of a mobile application What is the average length of a project A few sample scenarios of business implementations Questions and answers
2010 PHP Web Sites Optimization 7 hours This course has been created for PHP programmers and web site developers interested in PHP code optimization. The course shows how to find a bottleneck and how to refactor or change the code in the appropriate way. During this course participants will deal with real web page examples, which will be tracked, analysed and optimized. Stress Testing with JMeter Identifying what you need to test Mimicking the real world in JMeter Extracting and reading the results Finding Bottlenecks Introduction to Debuggers Stack Traces Function Traces Code Coverage Analysis Profiling PHP Scripts Remote Debugging Profilers Use Code Caches, Shared memory and Opcodes Tuning Opcode APCu Alternatives to shared memory XDebug Zend Optimizers Other solutions Parallel Processing Ajax Curl PHP 7 new features More advanced Big Data integration (R, Hadoop, etc...) MySQL Optimization Finding slow queries Finding most frequent queries Caching Indexing
287866 Building Web Apps using the MEAN stack 35 hours Course Objective: MEAN stack is a full-stack JavaScript solution that helps you write scalable, robust, and maintainable web applications quickly and easily using MongoDB, express, AngularJS, and Node.js. By the end of this hands-on intensive training course, the students will be able to: Store the data in NoSQL, document-oriented MongoDB database that brings performance and scalability. Use Node.js, the server-side platform built on Google V8’s runtime for building fast, scalable network applications. Use Express, a simple yet powerful web application development HTTP server framework built on top of Node.js. Use AngularJS framework that offers declarative, two-way data binding for web applications. Take advantage of the ‘full-stack JavaScript’ paradigm i.e. store documents in JSON-like format in MongoDB, author JSON queries in Node.js/Express.js, and forward these JSON documents back to an Angular-based frontend. Get acquainted with the latest web application development trends in the IT industry. Node.js Getting started with Node.js Node Package Manager Modules Asynchronous Programming Callbacks Events Streams Web Sockets Angular.js Angular Architecture Modules, Controllers and Scope Views Two-way Binding Built-in and Custom Directives Event Directives Expressions Built-in and Custom Filters Understanding the Digest Loop Forms and Validation AngularJS Service Types Factories, Providers, Decorators, DI Creating Custom Services Consuming Ajax Web Services via $http and $resource Routing, Redirects, and Promises Express.js MVC Pattern Introduction to Express Routing HTTP Interaction Handling Form Data Handling Query Parameters Cookies and Sessions User Authentication Error Handling Creating and Consuming RESTful Services Using Templates MongoDB Understanding NoSQL MongoDB Finding Documents Update, Insert, and Upsert Indexing Data Modeling Aggregation
2605 Spring and Hibernate in Java Applications 21 hours The course covers issues related to the creation of Java applications with particular emphasis on technology widely used today in applications such as application frameworks for building Spring and Hibernate. The participants at the end will have knowledge to design applications and to select the appropriate technology for a specific solution. Enable understanding of known issues discussed in the course of libraries, specifications and technologies. Component-oriented programming Design Pattern Inversion of Control and Dependency Injection Architectural Overview Spring Spring Application Context Configuration files Mapping objects Factory components and its use Programming in Spring AOP The use of new technologies in the Spring MVC Spring Create an application using Spring MVC Combining Spring MVC with Java Server Faces Introduction to Hibernate Architecture/Structure The life cycle of objects and identify objects Hibernate in Action Mapping tables on POJO category Construction of POJO category Mapping properties of the columns in the tables Establishing relationships between objects Transactions in Hibernate Local and global transactions Overview of API transactions Levels of transaction Language HQL - Hibernate Query Language Combining Hibernate and Spring applications
2518 Visual Basic for Applications (VBA) in Excel (intermediate level) 14 hours Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities. Facilities Create your own toolbar and menu The data types Conversion to other types The extent and lifetime of variables Operators and their priorities Options modules Conditional statements Select Case If ... Then ... ElseIf ... Else Loops When reversing loops For Each loop Instructions loop break (exit) Debugging Processing step Traps Watches Locals Window Immediate Window Call Stack Error handling Capturing and handling run-time errors Structures: On Error Resume Next, On Error GoTo label, On Error GoTo 0 Data display on the statusbar Basic optimization ScreenUpdating Measurement of the duration of the macro by the method Timer VBA Forms Create your own forms Calling a form from the code Use the forms in the spreadsheet
2425 Java fundamentals with Maven 28 hours The course covers the basics of Java development and introduces the Apache Maven software project management and comprehension tool. Getting Started The Java Technology Phenomenon How to write basic "hello world" application How to compile and execute Java code How to make the code a bit more complex Introducing Apache Maven Convention over Configuration Maven Plugins Conceptual Model of a Project Installing and Running Maven Downloading and Installing Maven Testing a Maven Installation Getting Help with Maven A Simple Maven Project Creating a Simple Project Building a Simple Project Simple Project Object Model Java Syntax Object-Oriented Programming Concepts Variables, arrays, data types, operators, and control flow What are reference variables Classes and objects What inheritance is and how it works What Interfaces are, why they are written and how How to use Java String and Number objects and how to format data for output What packages are for and why we must use import directive Java Objects Java classes overview Java class life cycle Class modifiers and inheritance Overloading" and overriding Class constructors Polymorphism Relationships: IS and HAS 'static' keyword When to use static members Using objects within an application deployed with Maven Customizing a Maven Project Customize Project Information Add New Dependencies Add Resources Building a Packaged Command-Line Application Optimizing and Refactoring Maven POMs POM Cleanup Optimizing Dependencies Optimizing Plugins Final POMs Java Collections Collection interface Lists, maps and sets Collections and arrays Concurrency Manage collections with an application deployed with Maven Java Memory Garbage collector Heap and stack Object life cycle 'finalize()' method Java Exceptions The general idea of Java Exceptions Runtime and 'real' exceptions Throwing an exception 'try...catch' statements 'throws' declaration Designing your own exceptions Test and manage exceptions with an application deployed with Maven A multimodule project with Maven Building the Multimodule project Running the Multimodule application Java Concurrency Threads and concurrency Threaded tasks Joining threads Class variables visibility Build and run a multithread application with Maven
2070 OpenESB-Java CAPS for developers and architects entry level 14 hours This course is dedicated for technical people who want to learn OpenESB. The training details the technical concepts required for a good understanding of service integration design and development. It covers standard specifications like XML Schemas, WSDL and BPEL used by OpenESB. This 2 day course provides you with the basic knowledge to understand OpenESB principles and designs. For an immediate operational knowledge, OpenESB Training T02 is required. Basic concepts Key concepts used for a good understanding of OpenESB IT Teams constrains   Intermediation principles Bus Architecture Contract of services Encapsulation et Integration Strong and weak coupling Orchestration CAP theorem Netbeans and Glassfish Introduction Netbeans introduction and first exercises Web services creation et Java implementation JBI Introduction Bus architecture advantages Components and orchestration JBI Architecture Message NMR Service Engine Binding component JBI management Service unit Service Assembly XML Schemas and WSDL Basics and advanced concepts used during OpenESB developments WSDL abstract part WSDL concrete part WSDL extension Partner Links Type Partner Link Role BPEL Basic concepts OpenESB BPEL engine at a glance Principles Activities Mapper Graphical editor BPEL advanced concepts This chapter covers in detail BPEL activities  Basic Activities Structured Activities BPEL proprieties Compensation Legacy integration with OpenESB Integration architecture with OpenESB Design and Use cases Mainframe and Legacy systems Practice 50% of the time will be dedicated to practical works
1977 Java Performance Tuning 28 hours What will you learn? Performance tips all come with a shelf life that is linked to the particular technology to which they are applied. Once that technology changes or is no longer used, the tips become useless at best and harmful at worst. For this reason we have purposely designed a course that focuses on providing you with something more than just tricks to get the latest and greatest framework to meet your performance needs. One of the tools we aim to leave you with is a methodology that we've used over the years on a regular basis. This methodology has helped us quickly identify and solve hard performance issues. The other equally important aspect of performance tuning is tooling. A good portion of the course focuses on a number of open source tools that we have found to be useful in our campaigns to stamp out performance bottlenecks. Beyond methodology and tooling, we look at some of the fundamentals of Java technology. This includes the inner workings of the Java memory management and HotSpot/JIT technologies. Objectives how to apply rigor to the task of performance tuning how to setup a performance tuning environment importance of performance tuning requirements and goals tools needed to conduct a performance investigation benchmarking and micro-benchmarking skills Java memory and execution models Tools & Methodology Defining performance and performance tuning Common performance problems Load testing with Apache JMeter Execution, memory and thread profilers System level monitoring Java Management eXtentions Architecture Planning for performance Patterns and anti-patterns Messaging Architectures for performance Coding Best Practices Big gains user perceptions Macro and micro benchmarking Selected Java Libraries including String, I/O and Collections XML parsing Serialization Concurrency Memory Management Sun and IBM Java Virtual Machine heap spaces Garbage collection algorithms Object life-cycle Garbage collection logging and monitoring Heap tuning strategies
994 Android App Widgets Development 7 hours Android app widgets are small application views that we can embed into other activities, such as the home screen. This short course teaches you how to develop android app widgets so the user will be able to add them into their android phone home screen. App Widgets Overview App Widget, App Widget Provider App Widget Host, Real World Samples Basic App Widgets The AppWidgetProviderInfo Class The App Widget Layout The onUpdate Method App Widgets Installation App Widgets Execution Configuration Activity Configuration Activity Role Launching Configuration Activity App Widget Provider Role Developing Configuration Activity Updating The App Widget Configuration Activity Returned Value Design Guidelines Design Guidelines Importance Google Android Design Guidelines Standard App Widget Frames Drawing Buttons
2008 MariaDB Database Administration 14 hours MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties. The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery. Installing MariaDB server Installing in Ubuntu/Debian Installing in other Linux Distributions Installation on Windows MariaDB Server Files and Scripts MariaDB Programs MariaDB Server MariaDB Client GUI Tools MariaDB Server Configuration Server Options The Server SQL Mode Server System Variables Dynamic System Variables Server Status Variables Shutdown Process MariaDB Security Issues Securing MariaDB Against Attacks Security-Related Options Security Issues with LOAD DATA LOCAL MariaDB Access Privilege System MariaDB Privilege System Overview Privileges Provided by MariaDB Connecting to the MariaDB Server - Stages Access Control, Stage 1: Connection Verification Access Control, Stage 2: Request Verification Access Denied Errors MariaDB User Account Management Users and Passwords Creating New Users Deleting User Accounts Limiting User Resources Changing Passwords MariaDB Database Maintenance Backup and Recovery Point-in-Time Recovery Maintenance and Crash Recovery myisamchk Syntax and Options Getting Table Information MariaDB Local Setting National Characters and Sorting MariaDB Server Time Zone MariaDB Log Files Error Log General Query Log Update Log Binary Log Slow Query Log Log File Maintenance and Rotation Running Multiple MariaDB Servers on the Same Machine Running Multiple Servers in Windows Running Multiple Servers in Windows as Services Running Multiple Servers in Unix and Linux Using Client Tools in a Multi-Server Environment MariaDB Query Cache The Concept of Query Cache Testing Query Cache with SELECT Configuring Query Cache Checking Query Cache Status and Maintenance The CONNECT Storage Engine Installing the CONNECT storage engine Creating and dropping CONNECT tables Reading and writing CSV data using CONNECT Reading and writing XML data using CONNECT Accessing MariaDB tables using CONNECT Using the XCOL table type Using the PIVOT table type Using the OCCUR table type Exploring Dynamic and Virtual Columns in MariaDB Creating tables with dynamic columns Inserting, updating, and deleting dynamic column data Reading data from a dynamic column Using virtual columns Performance and Usage Statistics Installing the Audit Plugin Using the Audit Plugin Using engine-independent table statistics Using extended statistics Enabling the performance schema Using the performance schema Optimizing and Tuning MariaDB Using SHOW STATUS Controlling MariaDB optimizer strategies Using extended Keys with InnoDB and XtraDB Configuring the MyISAM segmented key cache Configuring threadpool Configuring the Aria pagecache Optimizing queries with the subquery cache Optimizing semijoin subqueries Using microseconds in DATETIME columns Updating the DATETIME and TIMESTAMP columns automatically  
287760 MediaWiki for Developers 21 hours This course jumps into the deep end of the pool; we are going to go over every essential aspect of MediaWiki development, including: Mapping out the core code Creating extensions Modifying and Creating Custom Skins This course is for intermediate-level LAMP developers and up, preferably with some styling experience. The Structure and Purpose of MediaWiki Where we are now How it ended up this way Current efforts, and the future The path router The startup and shutdown of MediaWiki The Includes Directory 'Here be dragons': a map to the includes directory Walking through Marking out your points of interest Essential files, classes, and methods Database The parser Image Handling The API The Job Queue Pages, articles, revisions, and titles Global functions Extensions What you need to know A Game of Chess: Choosing your moves wisely Hooks The limitation of hooks Object-oriented extension versus hooking Dead ends, and how to avoid them When you have no other choice: modifying the core code Special Pages Troubleshooting Where did it go? Tracing the path of an object What went wrong? Debugging in MediaWiki Finding the root of an error Exceptions Skins We're extensions too! Vector, and the current skinning efforts in MediaWiki What is changing Creating a skin from scratch The classes you must work with (or around) Creating the raw skin Theming, and CSS classes at your disposal JavaScript modules and page output MediaWiki and the Database The schema Contributing, Gerrit, and working with the team
287863 Top 4 Linux/Unix Servers - DNS,Web,Mail and Database 35 hours Created Linux/Unix Administrators and developers who are interested with getting involved in LInux/Unix Servers Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Managing Linux Servers and to show it is very easy to understand Linux/Unix servers. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities. You'll learn how to deploy and manage Top 4 Linux Servers that provide highly useful network services to a mission-critical enterprise environment. It can be deliver on any distribution (Fedora, CentOS are commonly used) This course covers these kinds of topics: Bind as a ;DNS server Apache as a Web Server Postfix as a Mail Server MariaDB as a Database Server Through this course, you will learn from the installation to High level features of each server.
287764 Haskell Fundamentals 14 hours This course covers the basics of Haskell programming language. The course introduces the ideas of Functional Programming and teaches the essential concepts of it, and by this introduces the student to the Haskell programming language. The course explores the fundamental differences with imperative programming and teaches the skill of thinking functionally. Students should expect to learn all the necessary tools and concepts to start writing and understanding simple Haskell programs. Course and outline author: Gergely Risko. Introduction to Haskell Platform and tools Hello World program A bit of history Haskell syntax Functions Case distinction and pattern matching Layout (indentation) Control structures (if, case, let, where) Type system Basic types Simple function types Polymorphism Higher order functions Custom types Numbers in Haskell Type classes Building programs IO handling Module system Packages and libraries Compiling applications Examples and case studies Eight queens puzzle in Haskell Dynamic programming and memoization in Haskell Simplified parsing of CSV files An HTTP client
287787 Lua Fundamentals 14 hours Lua is an easy to use scripting language that is used as an embedded plugin/extension language in different products. For example it is the embedded scripting language of network applications like nmap and wireshark, and can also be found as a scripting language in World of Warcraft, Orbiter and other games. Lua can also be used as a standalone language. It is a lightweight, multi-paradigm programming language and therefore the course teaches various concepts that students will find useful in other areas of software engineering as well. This course covers the basic programming constructs in Lua and contains a lot of programming exercises, so that newcomers can gain proficiency with the language, starting from scratch. After completing the course the students will be able to write middle sized standalone Lua programs and script software products where Lua is the embedded language. Course and outline author: Gergely Risko. Introduction to Lua A bit of history Lua's goals, features and non-goals Resources of Lua documentation and tutorials Installing the Lua interpreter Setting up and using LuaRocks Basic syntax and semantics Identifiers Comments, block comments Global variables and enforcing of strictness Local variables Standalone programs, program arguments Compilation units, chunks, expressions, semicolons Data types and data structures Basic types: nil, boolean, number, string Object types: function, userdata, thread, table References/objects vs. basic values The importance of tables in Lua Introduction to tables and their versatility Tables as an associative array Tables as numeric arrays, sequences Basic control structures The if then elseif else end The while loop The repeat loop The simple for loop Error handling Return values vs exceptions Converting a return value to an exception Converting an exception to a return value Error levels Example programs Polynomial evaluation Breadth first search Additional exercises More about functions Named arguments Object-oriented calls Closures Currying Tail calls Multiple assignment and return Varargs Iterators and co-routines The generic for loop Stateless vs stateful iterators Differences between iterators and co-routines Metatables and metamethods The set example The __tostring metamethod Arithmetic metamethods The __index, __newindex metamethods The __len metamethod Modules and packages Using modules Creating modules Organizing modules into packages Object-oriented programming The building blocks of OOP in Lua Examples Discussion on more advanced language features Weak tables Finalizers Compilation, eval, loading
287765 Advanced Haskell 14 hours This course is for those users of Haskell who have a good grasp of the basics and want a deeper understanding of the language and be able to tackle serious, larger-scope problems in Haskell. Participants should expect to get a working understanding of the most important features of modern Haskell; be able to read and write advanced Haskell programs and libraries. Course and outline author: Gergely Risko. Basic Typeclassopedia Functor Applicative Foldable, Traversable Monads Other (Arrow, etc.) Advanced types Algebraic data types in depth Advanced Type classes Type families GADTs Debugging and code optimizing Strictness in data types and functions Memory and CPU profiling Efficient data structures (bytestring, text, vector and co.) Note on "unsafes" Understanding the Runtime System Memory layout in GHC Unpacking strict fields Understanding and reading Core Concurrency in Haskell Haskell threads MVars and co. STM Parallelism Foreign Function Interface FFI basics Safe vs. unsafe Globals in Haskell Template Haskell Splicing and quotation The Q monad Reification
287786 Advanced Lua 14 hours This is an advanced course on Lua, where basic knowledge of the programming language is already assumed. Therefore this course gives the participant a more profound understanding of Lua internals and the "why" behind the used Lua idioms. These advanced topics are demonstrated by plenty of examples and in-class exercises. Course and outline author: Gergely Risko. Advanced tables Tables for queues and stacks Tables describing graphs Matrices as tables Linked lists as tables String buffers Metatables through examples Proxies Readonly Memoization Dynamic programming with memoization The Fibonacci example Environments Relationship between global variables and environments Free variables The _ENV table and the _G table More about modules Different approaches to creating modules Modules that change the behavior Module initialization and arguments Using environments to implement safe modules Advanced iterators and co-routines Producer, consumer, filter Wrapping co-routines to get iterators Stateless iterator for linked lists Contributing to the Ecosystem Uploading packages to MoonRocks Functional paradigm in Lua The map function The reduce / fold function Object-oriented Programming Different approaches to OOP Different approaches to inheritance Examples A walkthrough of the Lua Standard Libraries
287785 Lua Embedding 14 hours This Lua course teaches how to interact with Lua from C (and/or other programming languages). We discuss integration in both directions: how to embed C code in Lua (eg. for performance gains), and how to make a C/C++/Java program extensible with Lua. As an in-class exercise we create a small program that is extensible with Lua. The course also tackles the Lua virtual machine and teaches how to understand the bytecode underpinning the language. This course can serve an add-on to the Lua Fundamentals or Lua Advanced courses in which case a shorter (1 day) version can be organized. Course and outline author: Gergely Risko. Compilation Compilation Eval Relationship with the environment Binary chunks Garbage collection Weak tables Finalizers, the __gc meta-method Lua bytecode and virtual machine Generating bytecode from source code Reading and analyzing bytecode Quick tour of the source code of the Lua VM C modules Calling C from Lua Search path and loading of C modules Calling Lua from C The Stack Error handling Continuations Handling Lua values and types from C Arrays Strings Userdata Metatables Object oriented calls Light userdata Memory management Allocators GC API Threads in Lua Co-routines vs threads Real multi-threading and Lua states
17 OCUP2 UML 2.5 Certification - Foundation Exam Preparation 21 hours OCUP2 Content Developer NobleProg has official OMG OCUP 2 Content Developer status, which means that our course outlines and training materials were developed by the same experts who prepared questions for OCUP 2 exams. Audience Developers, programmers, business analysts, project managers, software architects, testers, people responsible for documentation or anyone involved in the software development process. Objectives Prepares you to work with the most commonly encountered UML elements Teaches you how to create simple UML models Prepares you to be a member of a UML Development Team Why we model The Class Diagram Common Structure Type Dependency Namespace VisibilityKind (public, private, protected) MultiplicityElement Constraint Comment Simple Classifiers PrimitiveType DataType Enumeration EnumerationLiteral Interface InterfaceRealization Signal Reception Structured Classifiers Association Class Classification Generalization Feature Structural Feature Behavioral Feature Property Operation Parameter AggregationKind (Composition, Aggregation) Values LiteralBoolean LiteralInteger LiteralReal LiteralUnlimitedNatural LiteralNull LiteralString Opaque Expression The Object Diagram InstanceSpecification Slot The Package Diagram Packages Package PackageImport The Use Case Diagram Use Cases UseCase Actor Include The Activity Diagram Activities Activity ActivityFinalNode ActivityParameterNode ControlFlow InitialNode DecisionNode FlowFinalNode ForkNode JoinNode MergeNode ObjectFlow ObjectNode Actions Action CallBehaviorAction CallOperationAction, SendSignalAction AcceptEventAction Pin InputPin, OutputPin OpaqueAction The Sequence Diagram Interactions Interaction OccurrenceSpecification ExecutionSpecification ExecutionOccurrenceSpecification DestructionOccurrenceSpecification Lifeline Message MessageOccurrenceSpecification MessageSort MessageEnd Common Behavior CallEvent SignalEvent Trigger OpaqueBehavior The State Machine Diagram State Machines StateMachine State Transition Pseudostate: choice, junction, initial FinalState  
2566 Oracle SQL for beginners 21 hours Listeners This training is addressed for people starting to work with the SQL language in Oracle database The course answer for questions: How to build a query? What possibilities have SQL? What is a relational database? What is the structure and SQL commands Relational database models The structure of a relational database Connection types of tables The normalization and denormalization database Relational Operators Download the data Rules for writing SQL queries The syntax for the SELECT Selecting all columns Inquiries from arithmetic operations Aliases columns Literals Concatenation operator Limiting results The WHERE clause Comparison operators LIKE Condition Prerequisite BETWEEN ... AND IS NULL condition Condition IN Boolean operators AND, OR and NOT Many of the conditions in the WHERE clause The order of the operators. DISTINCT clause Sorting Data The ORDER BY clause Sorting by multiple columns or expressions SQL functions The differences between the functions of one and multilines Features text, numeric, date, Explicit and implicit conversion Conversion functions Nesting functions Viewing the performance of the functions - dual table Getting the current date function SYSDATE Handling of NULL values Aggregating data using the grouping Grouping functions How grouping functions treat NULL values Create groups of data - the GROUP BY clause Grouping multiple columns Limiting the function result grouping - the HAVING clause Retrieving data from multiple tables Types of connectors The use NATURAL JOIN Aliases tables Joins in the WHERE clause INNER JOIN Inner join External Merge LEFT, RIGHT, FULL OUTER JOIN Cartesian product Subqueries Place subqueries in the SELECT command Subqueries single and multi-lineage Operators Subqueries single-line Features grouping in subquery Operators Subqueries multi-IN, ALL, ANY How NULL values ​​are treated in subqueries Operators collective UNION operator UNION ALL operator INTERSECT operator MINUS operator Insert, update, and delete data INSERT command Copy data from another table UPDATE command DELETE command TRUNCATE command Transactions Commands COMMIT, ROLLBACK, and SAVEPOINT DDL commands The main database objects Rules for naming objects Creating tables The data types available for columns DEFAULT option Option NULL and NOT NULL Managing tables Referential integrity CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE Create a table by the query Delete a table DROP TABLE DESCRIBE command Other schema objects Sequences Synonyms Views
2565 Oracle SQL Advanced 14 hours Listeners This course is designed for people who want to use the advanced features of SQL in Oracle The course answers the questions How to build advanced queries? How to create advanced reports? Control user access User Management System permissions and object Granting Receiving permission Roles Using the links Managing schema objects ALTER TABLE command Adding, modifying, and deleting columns Add, remove, turn off constraintów Create indexes Flashback operations External tables Operations on large data sets MERGE command DML operations of podzapytaniami DML operations with RETURNING clause INSERT command multi tables Conditional expressions CASE expression DECODE expression Generate reports by grouping related data The GROUP BY clause The HAVING clause Aggregating data - ROLLUP and CUBE operators Identification summaries - GROUPING function Aggregating data - GROUPING SETS operator Managing data in different time zones Time zones Variations TIMESTAMP Differences between DATE and TIMESTAMP Conversion operations Advanced subqueries Subqueries Multi-column subqueries The subquery in the FROM clause Correlated subqueries WITH clause - re-use query blocks Join tables Inequality in the WHERE clause and the FROM clause Semijoin Antijoin The processing of hierarchical data The tree structure hierarchical Queries Pseudo column Sort data in a hierarchical query Useful functions Regular expressions Simple and complex patterns
Programming coaching, Programming instructor,Weekend Programming courses, Programming one on one training, Programming trainer, Programming training courses, Programming classes, Programming private courses, Programming boot camp, Weekend Programming training, Evening Programming training, Programming instructor-led , Evening Programming courses

Some of our clients