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

Subcategories

Programming Course Outlines

ID Name Duration Overview
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
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
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
287836 AngularJS Basics 14 hours 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
287864 MariaDB 10 Developer Course 35 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
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
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
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
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
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)
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)
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
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

Upcoming Courses

CourseCourse DateCourse Price [Remote/Classroom]
Programming in ASP.NET MVC 4 - LisbonWed, 2015-08-12 09:30$3770 / $5020
Programming in WPF 4.5 - KievTue, 2015-08-18 09:30$3610 / $4560
Programming in C++ - ZagrebMon, 2015-08-31 09:30$5930 / $7380
Weekend Programming courses, Weekend Programming training, Evening Programming training, Evening Programming courses, Programming coaching, Programming boot camp, Programming instructor, Programming instructor-led , Programming training courses, Programming classes, Programming on-site, Programming private courses, Programming one on one training