Szkolenia Bazy danych
Baza danych (DB) lub System Zarządzania Bazą Danych (DBMS) to system do przechowywania danych. Termin zazwyczaj odnosi się do relacyjnych baz danych, które przechowują dane w formacie tabelarycznym. Popularne bazy danych to MySQL, Oracle i MS SQL. Szkolenia z bazy danych NobleProg na żywo Szkolenia z bazy danych skierowane są zarówno do administratorów systemu, jak i programistów, i demonstrują poprzez praktyczną praktykę administrowania systemami baz danych oraz zintegrowania bazy danych z aplikacjami. Trening baz danych jest dostępny w różnych formatach, w tym szkolenia na żywo na miejscu i szkolenia z instruktorem na żywo za pomocą interaktywnej, zdalnej konfiguracji pulpitu. Szkolenia w zakresie lokalnej bazy danych można przeprowadzać na żywo w siedzibach klientów lub w lokalnych centrach szkoleniowych NobleProg.
Opinie uczestników
Podkategorie
Plany Kursów
| Kod | Nazwa | Czas trwania | Charakterystyka kursu |
|---|---|---|---|
| mariadbadmin | MariaDB Database Administration | 14 godz. | 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. |
| 3119 | Business Intelligence w MS SQL Server 2008 | 14 godz. | Szkolenie poświęcone jest podstawom tworzenia hurtowni danych bazujących na środowisku MS SQL Server 2008. Uczestnik zdobędzie podstawy dotyczące projektowania i budowy hurtowni danych pracującej pod MS SQL Server 2008. Zdobędzie wiedzę jak zbudować prosty proces ETL w oparciu o SSIS a następnie zaprojektować i zaimplementować kostkę danych za pomocą SSAS. Uczestnik będzie potrafił zarządzać bazami OLAP: tworzenie i usuwanie baz OLAP, procesowanie partycji, modyfikacje on-line. Uczestnik nabędzie wiedzę o skryptach XML/A i języku MDX. |
| osqlint | Oracle SQL - poziom średniozaawansowany | 14 godz. | Słuchacze Każdy, kto chce poszerzyć i uporządkować swoją wiedzę z zakresu Oracle SQL Forma kursu 25% wykład, 75% warsztaty |
| mariadbdev | MariaDB 10 Developer Course | 28 godz. | 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) |
| mongodbau | MongoDB for Advanced Users | 14 godz. | This course covers the advanced areas in the use of programming languages related to MongoDB, the goal is for the participant to have the ability to completely master the tool. |
| SQL12c1 | Oracle 12c – wprowadzenie do języka SQL | 14 godz. | Szkolenie dedykowane jest jako pierwszy krok dla użytkowników, administratorów, programistów i projektantów aplikacji opartych na bazach danych Oracle. Uczestnicy nie muszą posiadać żadnej wstępnej wiedzy na temat bazy danych Oracle, ani innych systemów relacyjnych baz danych, choć wiedza taka może okazać się przydatna. Warsztaty mają na celu zapoznanie uczestników z bazą danych Oracle, technikami budowania struktur bazy danych oraz operowania na danych. Szczególny nacisk położony jest na to, aby uczestnik zobaczył przekrojowo, jakie możliwości oferuje przy projektowaniu i budowaniu aplikacji System Zarządzania Relacyjną Baza Danych Oracle, oraz aby był w stanie samodzielnie z nią pracować, a także samodzielnie pogłębiać i uszczegóławiać swoją wiedzę. |
| bigddbsysfun | Big Data & Database Systems Fundamentals | 14 godz. | The course is part of the Data Scientist skill set (Domain: Data and Technology). |
| meanangular2 | Angular 2: Building Web Apps using the MEAN stack | 35 godz. | MEAN stack is a full-stack JavaScript solution that helps you write and deploy scalable, robust, and maintainable web applications quickly and easily using MongoDB, Express, Angular, 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 Angular 2 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. Notes: Angular is available in different versions, for example: AngularJS ( a.k.a. Angular.js, AngularJS 1, and Angular 1) Angular 2 Angular 4 etc. This training covers Angular 2. For all other components (Node.js, Express, MongDB) we cover the latest stable version. If you wish to customize the versions taught in this training, please contact us to arrange. |
| deckgl | deck.gl: Visualizing Large-scale Geospatial Data | 14 godz. | deck.gl is an open-source, WebGL-powered library for exploring and visualizing data assets at scale. Created by Uber, it is especially useful for gaining insights from geospatial data sources, such as data on maps. This instructor-led, live training introduces the concepts and functionality behind deck.gl and walks participants through the set up of a demonstration project. By the end of this training, participants will be able to: Take data from very large collections and turn it into compelling visual representations Visualize data collected from transportation and journey-related use cases, such as pick-up and drop-off experiences, network traffic, etc. Apply layering techniques to geospatial data to depict changes in data over time Integrate deck.gl with React (for Reactive programming) and Mapbox GL (for visualizations on Mapbox based maps). Understand and explore other use cases for deck.gl, including visualizing points collected from a 3D indoor scan, visualizing machine learning models in order to optimize their algorithms, etc. Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| rforfinance | R Programming for Finance | 28 godz. | R is a popular programming language in the financial industry. It is used in financial applications ranging from core trading programs to risk management systems. In this instructor-led, live training, participants will learn how to use R to develop practical applications for solving a number of specific finance related problems. By the end of this training, participants will be able to: Understand the fundamentals of the R programming language Select and utilize R packages and techniques to organize, visualize, and analyze financial data from various sources (CSV, Excel, databases, web, etc.) Build applications that solve problems related to asset allocation, risk analysis, investment performance and more Troubleshoot, integrate deploy and optimize an R application Audience Developers Analysts Quants Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note This training aims to provide solutions for some of the principle problems faced by finance professionals. However, if you have a particular topic, tool or technique that you wish to append or elaborate further on, please please contact us to arrange. |
| nosql | A Practical Introduction to NoSQL Databases | 28 godz. | Relational databases have been the technology of choice for storing, retrieving and querying data. Relational databases allow users to organize their data using a structured, well-defined set of patterns (model). While this approach works well for storing data that is standardized and well-understood in advance (think of a hospital check-in application that holds patient records with the same consistent set of pre-defined fields...patient id, first name, last name, date of last visit, etc.), there are limitations to this model. For organizations whose incoming data is not well-defined (think of a online inquiry form for a startup whose still in the process of experimenting with different fields for collecting visitor data, removing and adding fields as they go to accommodate for the changing nature of the business), any established definitions for how the data should fit into an existing database would need to be re-defined regularly. This would require recreating the data model (schema) that dictates the structure of the data and its allowed data types to support different types of data inputs, etc., before any new data could be saved to the database. Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease. NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balancing the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps In this instructor-led, live training , participants will understand the architecture, design principles and functionality of the most popular NoSQL databases on the market as they setup, operate and asses a number of NoSQL databases in a live lab environment. The goal of this training is to equip participants with the ability to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization. By the end of this training, participants will be able to: Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j Understand the benefits and disadvantages of NoSQL databases vs relational databases Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT) Perform create, insert, update, delete operations in a NoSQL database Setup a mixed environment with both a relational database and NoSQL working in tandem Configure a cluster of NoSQL database for distributed processing of very large datasets Understand the security implications of using a NoSQL database Deploy and scale a NoSQL database in a production environment Audience Database professionals Data architects Data strategists Project managers Application developers wishing to integrate a flexible database solution in their application Format of the Course Part lecture, part discussion, exercises and heavy hands-on practice Note To request a customized training for this course, please contact us to arrange. |
| mongodbadmin | MongoDB for Administrators | 14 godz. | This course covers everything a database administrator needs to know to successfully deploy and maintain MongoDB databases. Diagnosing performance issues, importing and exporting data, and establishing the proper backup and restore routines, overview of the MongoDB CRUD API, the command shell, and the drivers. are also covered. The audience of this course include people who want to: Understand MongoDB from a developer's perspective, including its command shell, query API, and driver tools. Deploy MongoDB in all its configurations - as a single server, with master/slave replication, as a replica set, and as a sharded cluster. Evaluate applications and choose hardware appropriately. Monitor MongoDB instances and integrate with standard monitoring software (Munin, Nagios, etc.) Plan for backups and manage large data imports and exports. Troubleshoot the most common developer issues and failure scenarios. Each delegate will need to perform a series of practical exercises. |
| 3092 | Język SQL w bazie danych MSSQL | 14 godz. | Kurs odpowiada na pytania Jak budować zapytania? Jakie możliwości posiada język SQL? Co to są relacyjne bazy danych? Jaka jest struktura i polecenia języka SQL? |
| cassdbfun | Fundamentals of Cassandra DB | 21 godz. | This course introduces the basics of Cassandra 2.0 including its installation & configuration, internal architecture, tools, Cassandra Query Language, and administration. Audience Administrators and developers seeking to use Cassandra. This course serves as a foundation and prerequisite for other advanced Cassandra courses. |
| mean1 | Building Web Apps using the MEAN stack | 35 godz. | 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. |
| repsvc | Reporting Services | 14 godz. | |
| SQL12cadv | Oracle 12c – zaawansowany SQL | 21 godz. | Szkolenie dedykowane dla użytkowników, którzy pracują już z baza danych Oracle i znają proste metody pozyskiwania danych. Szkolenie przedstawia zaawansowane sposoby raportowania, a także wprowadza w obszar y wiedzy dla programistów i projektantów aplikacji bazodanowych. Szkolenie to ma na celu zapoznanie uczestników z zaawansowanymi sposobami pozyskiwania danych instrukcją SLECT a także technikami budowania struktur bazy danych oraz operowania na danych. Szczególny nacisk położony jest na to, aby uczestnik zobaczył przekrojowo, jakie możliwości oferuje przy projektowaniu i budowaniu aplikacji System Zarządzania Relacyjną Baza Danych Oracle, oraz aby był w stanie samodzielnie z nią pracować, a także samodzielnie pogłębiać i uszczegóławiać swoją wiedzę. |
| SQL100 | T-SQL Fundamentals with SQL Server Training Course | 16 godz. | This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn: How to work with SQL Server and SQL Server Management Studio. Meaning of Databases, SQL and RDBMS etc. How to create tables, use DDL, DML and DAL. Which are the various RDBMS Packages in the market and how they compare with each other. An Introduction to NoSQL and how they are organizations are changing into hybrid databases. |
| ORABI | Wstęp do Oracle Business Intelligence i BI Publisher | 35 godz. | |
| embeddingprojector | Embedding Projector: Visualizing your Training Data | 14 godz. | Embedding Projector is an open-source web application for visualizing the data used to train machine learning systems. Created by Google, it is part of TensorFlow. This instructor-led, live training introduces the concepts behind Embedding Projector and walks participants through the setup of a demo project. By the end of this training, participants will be able to: Explore how data is being interpreted by machine learning models Navigate through 3D and 2D views of data to understand how a machine learning algorithm interprets it Understand the concepts behind Embeddings and their role in representing mathematical vectors for images, words and numerals. Explore the properties of a specific embedding to understand the behavior of a model Apply Embedding Project to real-world use cases such building a song recommendation system for music lovers Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| orientdb | OrientDB for Developers | 14 godz. | OrientDB is a NoSQL Multi-Model Database that works with Graph, Document, Key-Value, GeoSpatial, and Reactive models. Its flexibility allows users to manage different kinds of data under one centralized database. In this instructor-led, live training, participants will learn how to start using OrientDB and utilize its flexibility to manage data. By the end of this training, participants will be able to: Install OrientDB Learn how to create and manage a database with OrientDB Explore the different features and functionalities of OrientDB Learn how to work with different APIs on OrientDB Deploy OrientDB using Distributed Architecture Audience Software engineers and technicians Technical people in all industries IT people Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| arrow | Apache Arrow for Data Analysis across Disparate Data Sources | 14 godz. | Apache Arrow is an open-source in-memory data processing framework. It is often used together with other data science tools for accessing disparate data stores for analysis. It integrates well with other technologies such as GPU databases, machine learning libraries and tools, execution engines, and data visualization frameworks. In this onsite instructor-led, live training, participants will learn integrate Apache Arrow with various Data Science frameworks to access data from disparate data sources. By the end of this training, participants will be able to: Install and configure Apache Arrow in a distributed clustered environment Use Apache Arrow to access data from disparate data sources Use Apache Arrow to bypass the need for constructing and maintaining complex ETL pipelines Analyze data across disparate data sources without having to consolidate it into a centralized repository Audience Data scientists Data engineers Format of the Course Part lecture, part discussion, exercises and heavy hands-on practice Note To request a customized training for this course, please contact us to arrange. |
| mongodbdev | MongoDB for Developers | 14 godz. | This course covers everything a database developer needs to know to successfully develop applications using MongoDB. |
| 3082 | Microsoft Access - pobieranie danych | 14 godz. | Szkolenie przeznaczone jest dla osób pobierających informacje z gotowych baz danych za pomocą kwerend lub zapytań SQL |
| zamysql | Zaawansowana administracja MySQL | 14 godz. | Grupa docelowa: Kierowane jest do osób, które mają podstawy w posługiwaniu się windows/linux jako serwer, znają SQL, |
| wdneo4j | Wprowadzenie do Neo4j - grafowej bazy danych | 7 godz. | |
| bigdatastore | Big Data Storage Solution - NoSQL | 14 godz. | When traditional storage technologies don't handle the amount of data you need to store there are hundereds of alternatives. This course try to guide the participants what are alternatives for storing and analyzing Big Data and what are theirs pros and cons. This course is mostly focused on discussion and presentation of solutions, though hands-on exercises are available on demand. |
| SQL12cstro | Oracle 12c – Strojenie Poleceń SQL - warsztaty | 28 godz. | Warsztaty przeznaczone są dla zaawansowanych programistów i użytkowników Oracle, którzy poszukują wiedzy i informacji na temat wydajnego tworzenia systemów informatycznych w bazie danych Oracle, oraz strojenia i badania problemów wydajnościowych w już istniejących aplikacjach. Szkolenie to bazuje na wiedzy często niedostępnej lub błędnie przedstawianej w dokumentacji technicznej, a zebranej podczas wielu lat praktyki prowadzących je instruktorów. Warsztaty te mogą być zakończeniem ścieżki szkoleń dla programistów, lub stanowić pojedynczy krok dla osób z dużym doświadczeniem w projektowym i programowaniu w Oracle. Warsztaty mają na celu przedstawienie mechanizmów zachodzących w bazie danych Oracle podczas wykonywania poleceń SQL. Pozwalają uczestnikom unikać błędów podczas tworzenia oprogramowania, a także poszukiwać, diagnozować i rozwiązywać problemy wydajnościowe w już istniejących aplikacjach. Szczególny nacisk kładziemy na część warsztatową, gdzie pokazujemy metodykę i praktyczne aspekty tuningu aplikacji i poleceń SQL |
| osqldevdm | Oracle SQL for development and database management | 35 godz. | This 5-day course demonstrates how to use Oracle SQL for database development and database management. |
| danagr | Data and Analytics - from the ground up | 42 godz. | Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions: What has happened? processing and analyzing data producing informative data visualizations What will happen? forecasting future performance evaluating forecasts What should happen? turning data into evidence-based business decisions optimizing processes The course itself can be delivered either as a 6 day classroom course or remotely over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs. |
| kdbplusandq | kdb+ and q: Analyze time series data | 21 godz. | kdb+ is an in-memory, column-oriented database and q is its built-in, interpreted vector-based language. In kdb+, tables are columns of vectors and q is used to perform operations on the table data as if it was a list. kdb+ and q are commonly used in high frequency trading and are popular with the major financial institutions, including Goldman Sachs, Morgan Stanley, Merrill Lynch, JP Morgan, etc. In this instructor-led, live training, participants will learn how to create a time series data application using kdb+ and q. By the end of this training, participants will be able to: Understand the difference between a row-oriented database and a column-oriented database Select data, write scripts and create functions to carry out advanced analytics Analyze time series data such as stock and commodity exchange data Use kdb+'s in-memory capabilities to store, analyze, process and retrieve large data sets at high speed Think of functions and data at a higher level than the standard function(arguments) approach common in non-vector languages Explore other time-sensitive applications for kdb+, including energy trading, telecommunications, sensor data, log data, and machine and network usage monitoring Audience Developers Database engineers Data scientists Data analysts Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| webdevonboarding | Web Developer On-boarding Training | 420 godz. | In this instructor-led, live training, participants will learn the foundations of web development as they step through the creation and deployment of a sample application. By the end of this training, participants will be able to: Design and implement new user facing features Optimize web applications to maximize speed and scale Write client-side code for web-based applications Create fast, easy to use, high volume production applications and develop prototypes quickly Audience Beginner web developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| postgresadminoptimrepl | PostgreSQL Administration, Optimization and Replication | 35 godz. | PostgreSQL (or Postgres) is one of the most popular open-source relational databases. In this instructor-led, live training (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting. By the end of this training, participants will be able to: Use advanced administration techniques to configure and manage a PostgreSQL server Optimize the database and queries for maximum performance Replicate and scale a PostgreSQL server Audience Database administrators Systems administrators Developers with database experience Format of the Course Part lecture, part discussion, exercises and heavy hands-on practice Note This course is based PostreSQL 9 but can be adapted for a different version. To request a customized training for this course, please contact us to arrange. |
| pgsqladm | PostgreSQL Administration | 28 godz. | 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. |
| mariadbgc | MariaDB Galera Cluster Administration | 21 godz. | 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. |
| trafodionadm1 | Administering Trafodion | 14 godz. | The objective of the course is to enable participants to gain a mastery of NewSQL Concepts and how to administer Trafodion. |
| cassdev | Cassandra for Developers | 21 godz. | This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics. Audience : Developers |
| cassadmin | Cassandra Administration | 14 godz. | This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics. |
| osqlide | Oracle SQL Intermediate - Data Extraction | 14 godz. | The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level. |
| prcmysql | Percona Server dla MySQL | 14 godz. | Percona Server dla MySQL jest częścią zintegrowanego systemu rozwiązań dla baz danych, który zapewnia lepszą wydajność, niezawodność oraz niższe koszty użytkowania (w przypadku użytkowania pakietu). Jest to unikatowo opracowane dla Platformy Percona Software narzędzie, które gwarantuje tworzenie kopii zapasowych online, kompresję danych oraz błyskawiczną diagnozę i rozwiązywanie problemów. |
| riak | Riak: Build Applications with High Data Accuracy | 14 godz. | Riak is an Erlang based open-source document database, similar to CouchDB. It is created and maintained by Basho. In this instructor-led, live training, participants will learn how to build, run and operate a Riak based web application. By the end of this training, participants will be able to: Extend the number of hardware nodes and partition data across multiple servers Use bucket/key/values to organize and retrieve documents Use full-text search like query syntax Understand other Riak related technologies, such as Riak KV and Riak TS Test, secure, optimize and deploy a sample web application Audience Developers Database engineers Operations staff Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| bigdatabicriminal | Big Data Business Intelligence for Criminal Intelligence Analysis | 35 godz. | Advances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these challenges; effectively analyzing it is another. In this instructor-led, live training, participants will learn the mindset with which to approach Big Data technologies, assess their impact on existing processes and policies, and implement these technologies for the purpose of identifying criminal activity and preventing crime. Case studies from law enforcement organizations around the world will be examined to gain insights on their adoption approaches, challenges and results. By the end of this training, participants will be able to: Combine Big Data technology with traditional data gathering processes to piece together a story during an investigation Implement industrial big data storage and processing solutions for data analysis Prepare a proposal for the adoption of the most adequate tools and processes for enabling a data-driven approach to criminal investigation Audience Law Enforcement specialists with a technical background Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| qgis | QGIS for Geographic Information System | 21 godz. | A geographic information system (GIS) is a system designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The acronym GIS is sometimes used for geographic information science (GIScience) to refer to the academic discipline that studies geographic information systems and is a large domain within the broader academic discipline of geoinformatics. QGIS functions as geographic information system (GIS) software, allowing users to analyze and edit spatial information, in addition to composing and exporting graphical maps. QGIS supports both raster and vector layers; vector data is stored as either point, line, or polygon features. Multiple formats of raster images are supported, and the software can georeference images. To summarize it allows the users to Create, edit, visualise, analyse and publish geospatial information on Windows, Mac, Linux, BSD. This program, in its first phase, introduces the QGIS interface for general usage. In the second phase, we introduce PyQGIS - the python libraries of QGIS that allows the integration of GIS functionalities in your python code or your python application, so that you may even create your own Python Plugin around a particular GIS functionality. |
| 416 | Introduction to Firebird | 14 godz. | |
| ddavsvbsqls | Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 | 21 godz. | 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 |
| 68962 | MySQL Administration | 32 godz. | Audience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms. Format: 40% theoretical/lectures, 60%Practical/hands on lab |
| hbasedev | HBase for Developers | 21 godz. | This course introduces HBase – a NoSQL store on top of Hadoop. The course is intended for developers who will be using HBase to develop applications, and administrators who will manage HBase clusters. We will walk a developer through HBase architecture and data modelling and application development on HBase. It will also discuss using MapReduce with HBase, and some administration topics, related to performance optimization. The course is very hands-on with lots of lab exercises. Duration : 3 days Audience : Developers & Administrators |
| datapyth | Data Analysis in Python using Pandas and Numpy | 14 godz. | Pandas is a Python package that provides data structures for working with structured (tabular, multidimensional, potentially heterogeneous) and time series data. |
| berkeleydb | Berkeley DB for developers | 21 godz. | Berkeley DB (BDB) is a software library intended to provide a high-performance embedded database for key/value data. Berkeley DB is written in C with API bindings for C++, C#, Java, Perl, PHP, Python, Ruby, Smalltalk, Tcl, and many other programming languages. Berkeley DB is not a relational database.[1] This course will introduce the architecture and capabilities of Berkeley DB and walk participants through the development of their own sample application using Berkeley DB. Audience Application developers Software engineers Technical consultants Format of the course Part lecture, part discussion, hands-on development and implementation, tests to gauge understanding |
| scilab | Scilab | 14 godz. | Scilab is a well-developed, free, and open-source high-level language for scientific data manipulation. Used for statistics, graphics and animation, simulation, signal processing, physics, optimization, and more, its central data structure is the matrix, simplifying many types of problems compared to alternatives such as FORTRAN and C derivatives. It is compatible with languages such as C, Java, and Python, making it suitable as for use as a supplement to existing systems. In this instructor-led training, participants will learn the advantages of Scilab compared to alternatives like Matlab, the basics of the Scilab syntax as well as some advanced functions, and interface with other widely used languages, depending on demand. The course will conclude with a brief project focusing on image processing. By the end of this training, participants will have a grasp of the basic functions and some advanced functions of Scilab, and have the resources to continue expanding their knowledge. Audience Data scientists and engineers, especially with interest in image processing and facial recognition Format of the course Part lecture, part discussion, exercises and intensive hands-on practice, with a final project |
| hypertable | Hypertable: Deploy a BigTable like database | 14 godz. | Hypertable is an open-source software database management system based on the design of Google's Bigtable. In this instructor-led, live training, participants will learn how to set up and manage a Hypertable database system. By the end of this training, participants will be able to: Install, configure and upgrade a Hypertable instance Set up and administer a Hypertable cluster Monitor and optimize the performance of the database Design a Hypertable schema Work with Hypertable's API Troubleshoot operational issues Audience Developers Operations engineers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Part lecture, part discussion, exercises and heavy hands-on practice |
| mlfinancepython | Machine Learning for Finance (with Python) | 21 godz. | Machine learning is a branch of Artificial Intelligence wherein computers have the ability to learn without being explicitly programmed. Python is a programming language famous for its clear syntax and readability. It offers an excellent collection of well-tested libraries and techniques for developing machine learning applications. In this instructor-led, live training, participants will learn how to apply machine learning techniques and tools for solving real-world problems in the finance industry. Participants first learn the key principles, then put their knowledge into practice by building their own machine learning models and using them to complete a number of team projects. By the end of this training, participants will be able to: Understand the fundamental concepts in machine learning Learn the applications and uses of machine learning in finance Develop their own algorithmic trading strategy using machine learning with Python Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| gfsjeeint | Administering GlassFish Server with Java EE applications introduction | 21 godz. | GlassFish is an open-source application server. This three-day course provides an introduction to administering GlassFish Server with Java EE applications. |
| hadoopmapr | Hadoop Administration on MapR | 28 godz. | Audience: This course is intended to demystify big data/hadoop technology and to show it is not difficult to understand. |
| 68403 | Introduction to SQL Server 2012 Integration Services (SSIS) | 28 godz. | |
| hivehiveql | Data Analysis with Hive/HiveQL | 7 godz. | This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive |
| neo4j | Beyond the relational database: neo4j | 21 godz. | Relational, table-based databases such as Oracle and MySQL have long been the standard for organizing and storing data. However, the growing size and fluidity of data have made it difficult for these traditional systems to efficiently execute highly complex queries on the data. Imagine replacing rows-and-columns-based data storage with object-based data storage, whereby entities (e.g., a person) could be stored as data nodes, then easily queried on the basis of their vast, multi-linear relationship with other nodes. And imagine querying these connections and their associated objects and properties using a compact syntax, up to 20 times lighter than SQL. This is what graph databases, such as neo4j offer. In this hands-on course, we will set up a live project and put into practice the skills to model, manage and access your data. We contrast and compare graph databases with SQL-based databases as well as other NoSQL databases and clarify when and where it makes sense to implement each within your infrastructure. Audience Database administrators (DBAs) Data analysts Developers System Administrators DevOps engineers Business Analysts CTOs CIOs Format of the course Heavy emphasis on hands-on practice. Most of the concepts are learned through samples, exercises and hands-on development. |
| accumulo | Apache Accumulo: Building highly scalable big data applications | 21 godz. | Apache Accumulo is a sorted, distributed key/value store that provides robust, scalable data storage and retrieval. It is based on the design of Google's BigTable and is powered by Apache Hadoop, Apache Zookeeper, and Apache Thrift. This courses covers the working principles behind Accumulo and walks participants through the development of a sample application on Apache Accumulo. Audience Application developers Software engineers Technical consultants Format of the course Part lecture, part discussion, hands-on development and implementation, occasional tests to gauge understanding |
| sqladvals | SQL Advanced level for Analysts | 21 godz. | The aim of this course is to provide a clear understanding of the use of SQL for different databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the way how to join different tables in a database will help delegates to move data analysis operations to the database side, instead of doing this in MS Excel application. This can also help in creating any IT system, which uses any relational database. |
| globalsight | Globalsight: Automate the Localization Process | 7 godz. | Globalsight is an open-source, Java based application server for automating, streamlining, and managing the localization process. In this instructor-led, live training, participants will learn about Globalsight's architecture and functionality as they install, configure and deploy a demonstration server. By the end of this training, participants will be able to: Understand the benefits of Globalsight relative to other Translation Management Systems Install Globalsight server and related components Set up Globalsight to work behind a reverse proxy Deploy Globalsight to a production environment Troubleshoot and optimize Globalsight Use Globalsight's APIs to integrate it with third party applications, including JBPM, etc. Audience System administrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| ApacheIgnite | Apache Ignite: Improve speed, scale and availability with in-memory computing | 14 godz. | Apache Ignite is an in-memory computing platform that sits between the application and data layer to improve speed, scale and availability. In this instructor-led, live training, participants will learn the principles behind persistent and pure in-memory storage as they step through the creation of a sample in-memory computing project. By the end of this training, participants will be able to: Use Ignite for in-memory, on-disk persistence as well as a purely distributed in-memory database Achieve persistence without syncing data back to a relational database Use Ignite to carry out SQL and distributed joins Improve performance by moving data closer to the CPU, using RAM as a storage Spread data sets across a cluster to achieve horizontal scalability Integrate Ignite with RDBMS, NoSQL, Hadoop and machine learning processors Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| 1126 | Database Version Control (dbv) | 7 godz. | 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 |
| 3044 | Używanie i zarządzanie bazą danych MySQL | 14 godz. | Uczestnik szkolenia dowie się: Czy można używać MySQL bezpłatnie? Co oferuję licencja komercyjna? Jak zainstalować bazę danych MySQL? Jak wykonywać podstawowe operacje po instalacji? Jakie są dostępne narzędzia do zarządzania i programowania w bazie danych MySQL? |
| 564 | Java SE 7 Programmer Certification Preparation | 21 godz. | |
| 67592 | SQL Server 2008 Administration | 28 godz. | This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing of database requests Create and use full-text indexes Secure SQL Server and implement policy-based management Recover data Automate administrative tasks with the SQL Server Agent Use Dynamic Management Views to monitor the database and troubleshoot problems Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication |
| ADSQL | SQL Advanced | 14 godz. | Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes. |
| kdd | Knowledge Discover in Databases (KDD) | 21 godz. | Knowledge discovery in databases (KDD) is the process of discovering useful knowledge from a collection of data. Real-life applications for this data mining technique include marketing, fraud detection, telecommunication and manufacturing. In this course, we introduce the processes involved in KDD and carry out a series of exercises to practice the implementation of those processes. Audience Data analysts or anyone interested in learning how to interpret data to solve problems Format of the course After a theoretical discussion of KDD, the instructor will present real-life cases which call for the application of KDD to solve a problem. Participants will prepare, select and cleanse sample data sets and use their prior knowledge about the data to propose solutions based on the results of their observations. |
| druid | Druid: Build a fast, real-time data analysis system | 21 godz. | Druid is an open-source, column-oriented, distributed data store written in Java. It was designed to quickly ingest massive quantities of event data and execute low-latency OLAP queries on that data. Druid is commonly used in business intelligence applications to analyze high volumes of real-time and historical data. It is also well suited for powering fast, interactive, analytic dashboards for end-users. Druid is used by companies such as Alibaba, Airbnb, Cisco, eBay, Netflix, Paypal, and Yahoo. In this course we explore some of the limitations of data warehouse solutions and discuss how Druid can compliment those technologies to form a flexible and scalable streaming analytics stack. We walk through many examples, offering participants the chance to implement and test Druid-based solutions in a lab environment. Audience Application developers Software engineers Technical consultants DevOps professionals Architecture engineers Format of the course Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding |
| storm | Apache Storm | 28 godz. | Apache Storm is a distributed, real-time computation engine used for enabling real-time business intelligence. It does so by enabling applications to reliably process unbounded streams of data (a.k.a. stream processing). "Storm is for real-time processing what Hadoop is for batch processing!" In this instructor-led live training, participants will learn how to install and configure Apache Storm, then develop and deploy an Apache Storm application for processing big data in real-time. Some of the topics included in this training include: Apache Storm in the context of Hadoop Working with unbounded data Continuous computation Real-time analytics Distributed RPC and ETL processing Request this course now! Audience Software and ETL developers Mainframe professionals Data scientists Big data analysts Hadoop professionals Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| flockdb | Flockdb: A Simple Graph Database for Social Media | 7 godz. | FlockDB is an open source distributed, fault-tolerant graph database for managing wide but shallow network graphs. It was initially used by Twitter to store relationships among users. In this instructor-led, live training, participants will learn how to setup and use a FlockDB database to help answer social media questions such as who follows whom, who blocks whom, etc. By the end of this training, participants will be able to: Install and configure FlockDB Understand the unique features of FlockDB, relative to other graph databases such Neo4j Use FlockDB to maintain a large graph dataset Use FlockDB together with MySQL to provide provide distributed storage capabilities Query, create and update extremely fast graph edges Scale FlockDB horizontally for use in on-line, low-latency, high throughput web environments Audience Developers Database engineers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| memsql | MemSQL | 28 godz. | MemSQL is an in-memory, distributed, SQL database management system for cloud and on-premises. It's a real-time data warehouse that immediately delivers insights from live and historical data. In this instructor-led, live training, participants will learn the essentials of MemSQL for development and administration. By the end of this training, participants will be able to: Understand the key concepts and characteristics of MemSQL Install, design, maintain, and operate MemSQL Optimize schemas in MemSQL Improve queries in MemSQL Benchmark performance in MemSQL Build real-time data applications using MemSQL Audience Developers Administrators Operation Engineers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| 6552 | Administracja bazą danych Microsoft SQL Server 2012 | 21 godz. | Szkolenie skierowane do administratorów, projektantów i programistów baz danych. Cele szkolenia: zdobycie i ugruntowanie umiejętności z zakresu tworzenia i zarządzania bazami danych poznanie składni i wykorzystania języka SQL do pobierania i modyfikowania danych stosowanie zasad bezpieczeństwa w bazie danych wykorzystanie elementów zaawansowanych (replikacja, automatyzacja, BI) wykorzystanie możliwości Microsoft SQL Server do tworzenia złożonych raportów i rozwiązań dla programistów |
| sqlmysql | Język SQL w bazie danych MySQL | 14 godz. | Jak budować zapytania? Jakie możliwości posiada język SQL w bazie danych MySQL? Co to są relacyjne bazy danych? Jaka jest struktura i polecenia języka SQL |
| transsqladv | Transact SQL Advanced | 7 godz. | 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. |
| 66437 | Microsoft SQL Server 2008/2012 (MSSQL) | 14 godz. | This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables. |
| Imp | Impala for Business Intelligence | 21 godz. | Cloudera Impala is an open source massively parallel processing (MPP) SQL query engine for Apache Hadoop clusters. Impala enables users to issue low-latency SQL queries to data stored in Hadoop Distributed File System and Apache Hbase without requiring data movement or transformation. Audience This course is aimed at analysts and data scientists performing analysis on data stored in Hadoop via Business Intelligence or SQL tools. After this course delegates will be able to Extract meaningful information from Hadoop clusters with Impala. Write specific programs to facilitate Business Intelligence in Impala SQL Dialect. Troubleshoot Impala. |
| scylladb | Scylla database | 21 godz. | Scylla is an open-source distributed NoSQL data store. It is compatible with Apache Cassandra but performs at significantly higher throughputs and lower latencies. In this course, participants will learn about Scylla's features and architecture while obtaining practical experience with setting up, administering, monitoring, and troubleshooting Scylla. Audience Database administrators Developers System Engineers Format of the course The course is interactive and includes discussions of the principles and approaches for deploying and managing Scylla distributed databases and clusters. The course includes a heavy component of hands-on exercises and practice. |
| nlpwithr | NLP: Natural Language Processing with R | 21 godz. | It is estimated that unstructured data accounts for more than 90 percent of all data, much of it in the form of text. Blog posts, tweets, social media, and other digital publications continuously add to this growing body of data. This course centers around extracting insights and meaning from this data. Utilizing the R Language and Natural Language Processing (NLP) libraries, we combine concepts and techniques from computer science, artificial intelligence, and computational linguistics to algorithmically understand the meaning behind text data. Data samples are available in various languages per customer requirements. By the end of this training participants will be able to prepare data sets (large and small) from disparate sources, then apply the right algorithms to analyze and report on its significance. Audience Linguists and programmers Format of the course Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding |
| kylin | Apache Kylin: From classic OLAP to real-time data warehouse | 14 godz. | Apache Kylin is an extreme, distributed analytics engine for big data. In this instructor-led live training, participants will learn how to use Apache Kylin to set up a real-time data warehouse. By the end of this training, participants will be able to: Consume real-time streaming data using Kylin Utilize Apache Kylin's powerful features, including snowflake schema support, a rich SQL interface, spark cubing and subsecond query latency Note We use the latest version of Kylin (as of this writing, Apache Kylin v2.0) Audience Big data engineers Big Data analysts Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| fsharpfordatascience | F# for Data Science | 21 godz. | Data science is the application of statistical analysis, machine learning, data visualization and programming for the purpose of understanding and interpreting real-world data. F# is a well suited programming language for data science as it combines efficient execution, REPL-scripting, powerful libraries and scalable data integration. In this instructor-led, live training, participants will learn how to use F# to solve a series of real-world data science problems. By the end of this training, participants will be able to: Use F#'s integrated data science packages Use F# to interoperate with other languages and platforms, including Excel, R, Matlab, and Python Use the Deedle package to solve time series problems Carry out advanced analysis with minimal lines of production-quality code Understand how functional programming is a natural fit for scientific and big data computations Access and visualize data with F# Apply F# for machine learning Explore solutions for problems in domains such as business intelligence and social gaming Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| apachedrill | Apache Drill for On-the-Fly Analysis of Multiple Big Data Formats | 21 godz. | Apache Drill is a schema-free, distributed, in-memory columnar SQL query engine for Hadoop, NoSQL and other Cloud and file storage systems. The power of Apache Drill lies in its ability to join data from multiple data stores using a single query. Apache Drill supports numerous NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. Apache Drill is the open source version of Google's Dremel system which is available as an infrastructure service called Google BigQuery. In this instructor-led, live training, participants will learn the fundamentals of Apache Drill, then leverage the power and convenience of SQL to interactively query big data across multiple data sources, without writing code. Participants will also learn how to optimize their Drill queries for distributed SQL execution. By the end of this training, participants will be able to: Perform "self-service" exploration on structured and semi-structured data on Hadoop Query known as well as unknown data using SQL queries Understand how Apache Drills receives and executes queries Write SQL queries to analyze different types of data, including structured data in Hive, semi-structured data in HBase or MapR-DB tables, and data saved in files such as Parquet and JSON. Use Apache Drill to perform on-the-fly schema discovery, bypassing the need for complex ETL and schema operations Integrate Apache Drill with BI (Business Intelligence) tools such as Tableau, Qlikview, MicroStrategy and Excel Audience Data analysts Data scientists SQL programmers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| 3041 | Access dla zaawansowanych | 21 godz. | Na kursie uczestnik dowie się, jak przyśpieszyć działanie bazy danych, jak napisać zaawansowane zapytania, stworzyć wygodny system formularzy i raportowania. Kurs wprowadza także uczestnika w automatyzacje wszelkich czynności za pomocą makr i języka VBA. |
| transsqlbas | Transact SQL Basic | 14 godz. | 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. |
| 3134 | Oracle Application Express Introduction | 21 godz. | Audience Course aimed at developers Format of the course 35% lectures, 65% labs |
| seqdb | SequoiaDB for Developers | 14 godz. | SequoiaDB is a document-oriented NewSQL database that supports JSON transaction processing and SQL query. SequoiaDB can directly interface with applications to provide high performance and horizontally scalable data storage and processing functions, or serve as the frontend to Hadoop and Spark for both real-time query and data analysis. Audience This course assumes prior knowledge of SQL and is targeted at engineers seeking to deploy and integrate SequoiaDB instances. After completing this course, delegates will: understand SequoiaDB’s structure and deployment mechanisms be able to carry out installation / production environment / architecture tasks and configuration be able to assess code quality, perform debugging, monitoring be able to implement advanced production like integration, migration and development |
| DM7 | Getting started with DM7 | 21 godz. | Audience Beginner or intermediate database developers Beginner or intermediate database administrators Programmers Format of the course Heavy emphasis on hands-on practice. Most of the concepts are learned through samples, exercises and hands-on development |
| voldemort | Voldemort: Setting up a key-value distributed data store | 14 godz. | Voldemort is an open-source distributed data store that is designed as a key-value store. It is used at LinkedIn by numerous critical services powering a large portion of the site. This course will introduce the architecture and capabilities of Voldomort and walk participants through the setup and application of a key-value distributed data store. Audience Software developers System administrators DevOps engineers Format of the course Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding |
| TalendDI | Talend Open Studio for Data Integration | 28 godz. | Talend Open Studio for Data Integration is an open-source data integration product used to combine, convert and update data in various locations across a business. In this instructor-led, live training, participants will learn how to use the Talend ETL tool to carry out data transformation, data extraction, and connectivity with Hadoop, Hive, and Pig. By the end of this training, participants will be able to Explain the concepts behind ETL (Extract, Transform, Load) and propagation Define ETL methods and ETL tools to connect with Hadoop Efficiently amass, retrieve, digest, consume, transform and shape big data in accordance to business requirements Upload to and extract large records from Hadoop, Hive, and NoSQL databases Audience Business intelligence professionals Project managers Database professionals SQL Developers ETL Developers Solution architects Data architects Data warehousing professionals System administrators and integrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| tidyverse | Introduction to Data Visualization with Tidyverse and R | 7 godz. | The Tidyverse is a collection of versatile R packages for cleaning, processing, modeling, and visualizing data. Some of the packages included are: ggplot2, dplyr, tidyr, readr, purrr, and tibble. In this instructor-led, live training, participants will learn how to manipulate and visualize data using the tools included in the Tidyverse. By the end of this training, participants will be able to: Perform data analysis and create appealing visualizations Draw useful conclusions from various datasets of sample data Filter, sort and summarize data to answer exploratory questions Turn processed data into informative line plots, bar plots, histograms Import and filter data from diverse data sources, including Excel, CSV, and SPSS files Audience Beginners to the R language Beginners to data analysis and data visualization Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| aifortelecom | AI Awareness for Telecom | 14 godz. | AI is a collection of technologies for building intelligent systems capable of understanding data and the activities surrounding the data to make "intelligent decisions". For Telecom providers, building applications and services that make use of AI could open the door for improved operations and servicing in areas such as maintenance and network optimization. In this course we examine the various technologies that make up AI and the skill sets required to put them to use. Throughout the course, we examine AI's specific applications within the Telecom industry. Audience Network engineers Network operations personnel Telecom technical managers Format of the course Part lecture, part discussion, hands-on exercises |
| AccIntr | Access - projektowanie baz danych | 21 godz. | Na kursie uczestnik dowie się, jak zaprojektować bazę danych oraz jak przystosować ją do pracy z użytkownikiem końcowym. |
| osqlfun | ORACLE SQL Fundamentals | 21 godz. | 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. |
| 838 | Oracle Database 10g: Administration Workshop I Release 2 | 35 godz. | What you will learn This course is designed to give you a firm foundation in basic database administration. Expert instructors will teach you how to install and maintain an Oracle database. Learn To: Install the Database. Back up and recover data. Administer users and manage data. Transport data between databases. Configure the network. Understand the Oracle database architecture and how its components work and interact with one another. Use performance monitoring, database security, user management and backup/recovery techniques. Create an Operational Database This course will also teach you how to create an operational database and properly manage the various structures efficiently. The lesson topics are reinforced with structured, hands-on practices that solidify your understanding. Prepare for Oracle Certification Exams This course is designed to prepare you for the corresponding Oracle Certified Associate exam. It counts towards the hands-on course requirement for the Oracle Database 10g Administrator Certification Audience Database Administrators Database Designers Project Manager Sales Consultants Support Engineer Technical Consultant Course Objectives Install Oracle Database 10g and configure a database Manage the Oracle instance Manage the Database storage structures Create and administer user accounts Perform backup and recovery of a database Monitor, troubleshoot, and maintain a database Configure Oracle Net services Move data between databases and files |
| couch | Apache CouchDB for Developers | 14 godz. | Adobe CouchDB is a scalable, fault-tolerant, and schema-free document-oriented database written in Erlang. It's used in large and small organizations for a variety of applications where a traditional SQL database isn't the best solution for the problem at hand. Audience This course is directed at engineers and developers seeking to deploy and develop with a CouchDB instance. |
| acas1 | Apache Cassandra 2.x Core Internals | 21 godz. | This is a fast-paced, vendor agnostic, technical Apache Cassandra course that focuses on the key aspects of the technology for developers and system operations staff, covering core internal and distributed architecture fundamentals. What you will learn + Identifying the correct use cases for Cassandra + Introducing attendees to the core concepts of the distributed architecture of the Cassandra database + Deep diving into the internal architecture of the read/write paths of Cassandra: bloom filters, block indexes, commit-log, memtables, sstables, compaction, etc. + The fundamentals of how to write Java code to interact with Cassandra + Data modelling using CQL using the newest features of Cassandra 2.x and how to apply these concepts to build real applications on top of Cassandra + Spark/Cassandra integration |
| meteor | Meteor: Use JavaScript to develop cross-platform mobile applications | 14 godz. | Meteor (aka MeteorJS) is an open-source JavaScript web framework written in Node.js. It integrates with MongoDB and enables rapid prototyping of Android and iOS applications. This course introduces the fundamentals of Meteor and walks participants through the creation of a real-time web applications for both desktop and mobile platforms. Audience Front-end developers Anyone interested in learning Meteor Format of the course Overview of Meteor's features and capabilities along with step-by-step development of a mobile application for iOS and Android. |
| pythonmultipurpose | Advanced Python | 28 godz. | In this instructor-led training, participants will learn advanced Python programming techniques, including how to apply this versatile language to solve problems in areas such as distributed applications, data analysis and visualization, UI programming and maintenance scripting. Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Notes If you wish to add, remove or customize any section or topic within this course, please contact us to arrange. |
| datastorageoverview | Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems | 7 godz. | This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches. |
| mongoana | MongoDB dla analityków | 14 godz. | Po szkoleniu będziesz umieć pisać zapytania - wyszukiwać i modyfikować dane w bazie MongoDB. Nauczsz się także posługiwać Aggregation Pipeline - elastyczne i szybkie narzędzie do agregacji i analizy danych. Poznasz także sposób łączenia narzędzi BI jak Tableasu czy Excel do danych zgromadzonych w Mongo. |
| 3033 | Administracja bazą danych Microsoft SQL Server | 21 godz. | Szkolenie skierowane do administratorów, projektantów i programistów baz danych. Cele szkolenia: zdobycie i ugruntowanie umiejętności z zakresu tworzenia i zarządzania bazami danych poznanie składni i wykorzystania języka SQL do pobierania i modyfikowania danych stosowanie zasad bezpieczeństwa w bazie danych wykorzystanie elementów zaawansowanych (replikacja, automatyzacja, BI) wykorzystanie możliwości Microsoft SQL Server do tworzenia złożonych raportów i rozwiązań dla programistów |
| oplsqlfun | Oracle 11g - Programowanie w PL/SQL - wprowadzenie | 21 godz. | 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. |
| 471 | Oracle Database 11g: SQL Fundamentals I (IZO-051) | 28 godz. | Audience Managers, database developers, Programmers. Format of the course 50% lectures, 40% labs, 10% tests |
| aerosdev | Aerospike for Developers | 14 godz. | This course covers everything a database developer needs to know to successfully develop applications using Aerospike. |
| percsera | Administrating Percona Server for MongoDB | 7 godz. | Percona Server for MongoDB is a free, enhanced, fully compatible, open source, drop-in replacement for MongoDB 3.2 Community Edition with enterprise-grade features. It requires no changes to MongoDB applications or code. Audience This course is suitable for sysadmins and engineers seeking to switch to Percona Server from preexisting MongoDB instances, or deploy and administrate new Percona Server for MongoDB instances. After completing this course, delegates will: understand Percona Server’s structure and deployment mechanisms be able to carry out installation / production environment / architecture tasks and configuration be able to assess code quality, perform debugging, monitoring be able to implement advanced production like replication, performance tuning and logging |
| BigData_ | A Practical Introduction to Data Analysis and Big Data | 35 godz. | Participants who complete this training will gain a practical, real-world understanding of Big Data and its related technologies, methodologies and tools. Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class. The course starts with an introduction to elemental concepts of Big Data, then progresses into the programming languages and methodologies used to perform Data Analysis. Finally, we discuss the tools and infrastructure that enable Big Data storage, Distributed Processing, and Scalability. Audience Developers / programmers IT consultants Format of the course Part lecture, part discussion, hands-on practice and implementation, occasional quizing to measure progress |
| PentahoDI | Pentaho Data Integration Fundamentals | 21 godz. | Pentaho Data Integration is an open-source data integration tool for defining jobs and data transformations. In this instructor-led, live training, participants will learn how to use Pentaho Data Integration's powerful ETL capabilities and rich GUI to manage an entire big data lifecycle, maximizing the value of data to the organization. By the end of this training, participants will be able to: Create, preview, and run basic data transformations containing steps and hops Configure and secure the Pentaho Enterprise Repository Harness disparate sources of data and generate a single, unified version of the truth in an analytics-ready format. Provide results to third-part applications for further processing Audience Data Analyst ETL developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| mariadbadv | Advanced MariaDB for High Availability and Performance | 28 godz. | MariaDB is a fork of MySQL and one of the most popular database servers. In this instructor-led, live training, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering. Audience Developers Database administrators System administrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| dremio | Dremio for Self-Service Data Analysis | 21 godz. | Dremio is an open-source "self-service data platform" that accelerates the querying of different types of data sources. Dremio integrates with relational databases, Apache Hadoop, MongoDB, Amazon S3, ElasticSearch, and other data sources. It supports SQL and provides a web UI for building queries. In this instructor-led, live training, participants will learn how to install, configure and use Dremio as a unifying layer for data analysis tools and the underlying data repositories. By the end of this training, participants will be able to: Install and configure Dremio Execute queries against multiple data sources, regardless of location, size, or structure Integrate Dremio with BI and data sources such as Tableau and Elasticsearch Audience Data scientists Business analysts Data engineers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Notes To request a customized training for this course, please contact us to arrange. |
| mysqladm | Administracja bazą danych MySQL | 14 godz. | Uczestnik szkolenia dowie się: Jak zarządzać procesami serwera? Jak bezpiecznie startować i zamykać serwer? Jak przekazywać parametry do serwera? Jak zabezpieczyć serwer przed nadużyciami i włamaniami? Jak używać systemu uprawnień w MySQL? Jak tworzyć i zarządzać kontami użytkowników? Jak tworzyć kopie zapasowe bazy danych? Jak zarządzać plikami dziennika? Jak dostosować MySQL do języka polskiego? Jak uruchomić kilka serwerów MySQL na jednej maszynie? |
| sqlmsa | SQL in Microsoft Access | 14 godz. | 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. |
| 453 | Oracle: (1ZO-147) Program with PLSQL | 28 godz. | |
| redisadev | Redis for Developers and System Administrators | 14 godz. | Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker. |
| couchad | Apache CouchDB for Administrators | 21 godz. | Adobe CouchDB is a scalable, fault-tolerant, and schema-free document-oriented database written in Erlang. It's used in large and small organizations for a variety of applications where a traditional SQL database isn't the best solution for the problem at hand. Audience This course is directed at administrators and developers seeking to maintain a CouchDB instance. |
| elasticsearchfordevs | Elasticsearch for Developers: Building Search and Analytics Solutions with Elasticsearch | 14 godz. | Elasticsearch is an open-source, distributed search engine. It is commonly used together with Logstash (data-collection and log-parsing engine) and Kibana (analytics and visualization platform) to make up the "ELK stack". This training is aimed at software developers who wish to build search and analytics solutions using Elasticsearch. The training starts with a discussion of the Elasticksearch architecture, including its distributed model and search API. This is followed by an explanation of Elasticsearch's functionality and how to best integrate it into an existing application. Hands-on exercises make up an important part of the training, and give participants a chance to put into practice their knowledge while receiving feedback on their implementation and progress. Audience Software developers Format of the course Heavy emphasis on live practice. Most of the concepts are learned through samples, exercises and hands-on development. |
| hdp | Hortonworks Data Platform (HDP) for administrators | 21 godz. | Hortonworks Data Platform is an open-source Apache Hadoop support platform that provides a stable foundation for developing big data solutions on the Apache Hadoop ecosystem. This instructor-led live training introduces Hortonworks and walks participants through the deployment of Spark + Hadoop solution. By the end of this training, participants will be able to: Use Hortonworks to reliably run Hadoop at a large scale Unify Hadoop's security, governance, and operations capabilities with Spark's agile analytic workflows. Use Hortonworks to investigate, validate, certify and support each of the components in a Spark project Process different types of data, including structured, unstructured, in-motion, and at-rest. Audience Hadoop administrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| powerbiforbiandanalytics | Power BI for Business Analysts | 21 godz. | Microsoft Power BI is a free Software as a Service (SaaS) suite for analyzing data and sharing insights. Power BI dashboards provide a 360-degree view of the most important metrics in one place, updated in real time, and available on all of their devices. In this instructor-led, live training, participants will learn how to use Microsoft Power Bi to analyze and visualize data using a series of sample data sets. By the end of this training, participants will be able to: Create visually compelling dashboards that provide valuable insights into data Obtain and integrate data from multiple data sources Build and share visualizations with team members Adjust data with Power BI Desktop Audience Business managers Business analystss Data analysts Business Intelligence (BI) and Data Warehouse (DW) teams Report developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| pythonexcel | Python for Excel | 14 godz. | Python is a high-level programming language famous for its clear syntax and code readability. Excel is a spreadsheet application developed by Microsoft which is widely used in many industries. Adding Python to Excel makes it a powerful tool for data analytics. In this instructor-led, live training, participants will learn how to combine the capabilities of Python and Excel. By the end of this training, participants will be able to: Install and configure packages for integrating Python and Excel Read, write, and manipulate Excel files using Python Call Python functions from Excel Audience Developers Programmers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note To request a customized training for this course, please contact us to arrange. |
| sqlmysqladv | SQL Advanced in MySQL | 7 godz. | 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. |
| sqlsqlsvr | SQL in SQL Server | 14 godz. | 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. |
| 452 | R12.x Extend Oracle Applications: Building OA Framework Applications | 35 godz. | |
| PLSQL12cadv | Oracle 12c – Zaawansowane programowanie w PL/SQL | 21 godz. | Warsztaty dedykowane są programistom, użytkownikom końcowym oraz administratorom, którzy do tej pory nie mieli kontaktu z językiem PL/SQL, a potrzebują wykorzystywać jego ogromne możliwości w pracy z bazą danych, automatyzacji procesów oraz przy budowaniu aplikacji. Warsztaty mają na celu zapoznanie uczestników z językiem programowania PL/SQL, jego możliwościami i ograniczeniami. Warsztaty niniejsze obejmuje pełną wiedzę na temat mechanizmów związanych z językiem programowanie PL/SQL potrzebną do swobodnej implementacji logiki aplikacji, automatyzacji procesów przetwarzania danych oraz zarządzania bazą danych |
| seqdba | SequoiaDB for Administrators | 14 godz. | SequoiaDB is a document-oriented NewSQL database that supports JSON transaction processing and SQL query. SequoiaDB can directly interface with applications to provide high performance and horizontally scalable data storage and processing functions, or serve as the frontend to Hadoop and Spark for both real-time query and data analysis. |
| rekit | Szkolenie dla rekruterów IT - programowanie i bazy danych | 7 godz. | Kurs skupia się na przeglądzie języków programowania i baz danych. Rekomendowany dla rekruterów z branży IT oraz pozostałych osób zainteresowanych technologiami w programowaniu. |
| magellan | Magellan: Geospatial Analytics on Spark | 14 godz. | Magellan is an open-source distributed execution engine for geospatial analytics on big data. Implemented on top of Apache Spark, it extends Spark SQL and provides a relational abstraction for geospatial analytics. This instructor-led, live training introduces the concepts and approaches for implementing geospacial analytics and walks participants through the creation of a predictive analysis application using Magellan on Spark. By the end of this training, participants will be able to: Efficiently query, parse and join geospatial datasets at scale Implement geospatial data in business intelligence and predictive analytics applications Use spatial context to extend the capabilities of mobile devices, sensors, logs, and wearables Audience Application developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| mlbankingr | Machine Learning for Banking (with R) | 28 godz. | In this instructor-led, live training, participants will learn how to apply machine learning techniques and tools for solving real-world problems in the banking industry. R will be used as the programming language. Participants first learn the key principles, then put their knowledge into practice by building their own machine learning models and using them to complete a number of live projects. Audience Developers Data scientists Banking professionals with a technical background Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| qlikviewfordev | QlikView for Developers | 14 godz. | QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this instructor-led, live training, participants will learn how to start developing with QlikView. By the end of this training, participants will be able to: Install and configure QlikView Transform data from various sources through QlikView scripting Build data models with QlikView Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note To request a customized training for this course, please contact us to arrange. |
| 66538 | Build applications with Oracle Application Express (APEX) | 35 godz. | |
| advsqlpt | Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server | 14 godz. | 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. For more in depth coverage of the topics this course can be run as a three day course. |
| 378 | Oracle Service Bus 11g - Design and Integration | 21 godz. | This course is targeted to SOA architects and developers. It consists of theory classes and hands-on sessions on each of the topics to cover all essential features of Oracle Service Bus 11g. This course will be delivered by industry experts with vast knowledge of Oracle SOA Suite, Web services, ESB, XML, SOA and related topics for example Java/J2EE. |
| PLSQL12cintro | Oracle 12c – Wprowadzenie do programowania w PL/SQL | 14 godz. | Warsztaty dedykowane są programistom, użytkownikom końcowym oraz administratorom, którzy do tej pory nie mieli kontaktu z językiem PL/SQL, a potrzebują wykorzystywać jego ogromne możliwości w pracy z bazą danych, automatyzacji procesów oraz przy budowaniu aplikacji. Warsztaty mają na celu zapoznanie uczestników z językiem programowania PL/SQL, jego możliwościami i ograniczeniami. Warsztaty niniejsze obejmuje pełną wiedzę na temat mechanizmów związanych z językiem programowanie PL/SQL potrzebną do swobodnej implementacji logiki aplikacji, automatyzacji procesów przetwarzania danych oraz zarządzania bazą danych. |
| postgresdev | PostgreSQL for Developers | 14 godz. | This course provides programmatic interaction with PostgreSQL databases and writing PostgreSQL extensions. Target audience includes developers who want to use or extend PostgreSQL, as well as database architects. |
| ApHadm1 | Apache Hadoop: Manipulation and Transformation of Data Performance | 21 godz. | This course is intended for developers, architects, data scientists or any profile that requires access to data either intensively or on a regular basis. The major focus of the course is data manipulation and transformation. Among the tools in the Hadoop ecosystem this course includes the use of Pig and Hive both of which are heavily used for data transformation and manipulation. This training also addresses performance metrics and performance optimisation. The course is entirely hands on and is punctuated by presentations of the theoretical aspects. |
| zeppelin | Zeppelin for interactive data analytics | 14 godz. | Apache Zeppelin is a web-based notebook for capturing, exploring, visualizing and sharing Hadoop and Spark based data. This instructor-led, live training introduces the concepts behind interactive data analytics and walks participants through the deployment and usage of Zeppelin in a single-user or multi-user environment. By the end of this training, participants will be able to: Install and configure Zeppelin Develop, organize, execute and share data in a browser-based interface Visualize results without referring to the command line or cluster details Execute and collaborate on long workflows Work with any of a number of plug-in language/data-processing-backends, such as Scala ( with Apache Spark ), Python ( with Apache Spark ), Spark SQL, JDBC, Markdown and Shell. Integrate Zeppelin with Spark, Flink and Map Reduce Secure multi-user instances of Zeppelin with Apache Shiro Audience Data engineers Data analysts Data scientists Software developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| mlbankingpython_ | Machine Learning for Banking (with Python) | 21 godz. | Machine Learning is a branch of Artificial Intelligence wherein computers have the ability to learn without being explicitly programmed. Python is a programming language famous for its clear syntax and readability. It offers an excellent collection of well-tested libraries and techniques for developing machine learning applications. In this instructor-led, live training, participants will learn how to apply machine learning techniques and tools for solving real-world problems in the banking industry. Participants first learn the key principles, then put their knowledge into practice by building their own machine learning models and using them to complete a number of team projects. Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| qlikviewforbusiness | QlikView for Business Users | 7 godz. | QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this instructor-led, live training, participants will learn how to use QlikView to support decision making in their organization. By the end of this training, participants will be able to: Install and configure QlikView Analyze and display data using QliKView Use data discoveries from QlikView to support decision making Audience Managers Business users Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note To request a customized training for this course, please contact us to arrange. |
| 6550 | Business Intelligence w MS SQL Server 2012 | 14 godz. | Szkolenie poświęcone jest podstawom tworzenia hurtowni danych bazujących na środowisku MS SQL Server 2012. Uczestnik zdobędzie podstawy dotyczące projektowania i budowy hurtowni danych pracującej pod MS SQL Server 2012. Zdobędzie wiedzę jak zbudować prosty proces ETL w oparciu o SSIS a następnie zaprojektować i zaimplementować kostkę danych za pomocą SSAS. Uczestnik będzie potrafił zarządzać bazami OLAP: tworzenie i usuwanie baz OLAP, procesowanie partycji, modyfikacje on-line. Uczestnik nabędzie wiedzę o skryptach XML/A i języku MDX. |
| sqlfun | SQL Fundamentals | 14 godz. | 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. |
| oracleperftun | Oracle Database 11g: Performance Tuning | 28 godz. | Oracle is a multi-model database management system. |
| SQL_AN1 | Oracle 12c – Język SQL dla analityków I - warsztaty | 28 godz. | Szkolenie ma na celu zapoznanie uczestników z bazą danych Oracle, podstawowymi i zaawansowanymi narzędziami i technikami analizy danych. Szczególny nacisk na tym szkoleniu położony jest na pozyskiwanie merytorycznie poprawnych i wiarygodnych danych. Uczestnicy zdobędą wiedzę zarówno teoretyczną jak i poznają praktyczne aspekty operowania na danych. Szkolenie to pozwala zapoznać się i przećwiczyć praktycznie mechanizmy pozyskiwania danych instrukcją SELECT od najprostszych zapytań do najbardziej skomplikowanych mechanizmów rozszerzenia analitycznego języka SQL. |
| postgresadmin | PostgreSQL dla administratorów | 14 godz. | Ten kurs obejmuje administrację oraz strojenie wydajności baz danych PostgreSQL. Grupa docelowa to administratorzy oraz architekci baz danych. Uczestnicy poznają wykorzystanie wyspecjalizowanych modułów PostgreSQL (Postgres), takich jak replikacja, pula połączeń (connection pool) i wyszukiwanie pełnotekstowe. |
| cassdev1 | Cassandra for Developers - Bespoke | 21 godz. | This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics. Duration : 3 days Audience : Developers |
| meanangular4 | Angular 4: Building Web Apps using the MEAN stack | 35 godz. | Angular 4 (previous versions referred to as: Angular.js, AngularJS, AngularJS 1, Angular 1, Angular 2, etc.) is a JavaScript-based front-end web application framework for developing single-page applications. It boasts better performance over its predecessor, more APIs to tap into, and improved design and responsiveness on mobile devices. MEAN stack is a full-stack JavaScript solution for writing scalable, robust, and maintainable web applications quickly and easily using MongoDB, Express, Angular, and Node.js. In this instructor-led, live training, participants will learn how to use the MEAN stack, specifically using Angular 4, as they step through the creation and deployment of a sample web application. By the end of this training, participants will be able to: Create, build, debug and deploy a MEAN-based Angular 4 application Unit test their Angular 4 application Write Angular code using TypeScript Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| graphcomputing | Introduction to Graph Computing | 28 godz. | A large number of real world problems can be described in terms of graphs. For example, the Web graph, the social network graph, the train network graph and the language graph. These graphs tend to be extremely large; processing them requires a specialized set of tools and processes -- these tools and processes can be referred to as Graph Computing (also known as Graph Analytics). In this instructor-led, live training, participants will learn about the technology offerings and implementation approaches for processing graph data. The aim is to identify real-world objects, their characteristics and relationships, then model these relationships and process them as data using a graph computing approach. We start with a broad overview and narrow in on specific tools as we step through a series of case studies, hands-on exercises and live deployments. By the end of this training, participants will be able to: Understand how graph data is persisted and traversed Select the best framework for a given task (from graph databases to batch processing frameworks) Implement Hadoop, Spark, GraphX and Pregel to carry out graph computing across many machines in parallel View real-world big data problems in terms of graphs, processes and traversals Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| dataanalysisformkt | Data Analysis for Marketers | 14 godz. | A business' marketing strategy is one of its most essential tools to ensure success. The rise in technology and advances in data gathering and analysis has led to a continuous transformation of marketing. Data analysis is now considered to be a crucial skill for marketers to learn. Likewise, applying data science to marketing principles is also important in helping data science professionals maximize their contributions. In this instructor-led, live training, participants will learn how to gain valuable insights from large data sets and how to use these for marketing strategies. By the end of this training, participants will be able to: Install and configure tools for data-driven marketing tools (Tableau, Google Analytics, Zarget, etc) Measure, test, and optimize the performance of their marketing strategies using data Use data to segment their customers and prospects Use predictive modeling to improve response rates Implement step-by-step data analytics to drive better marketing decisions Audience Marketers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note To request a customized training for this course, please contact us to arrange. |
| 3165 | Visual Basic for Applications (VBA) w Excel - praca z bazami danych | 14 godz. | Szkolenie jest przeznaczone dla osób korzystających z Excela i VBA pod kątem pracy z zewnętrznymi bazami danych. Szkolenie kładzie duży nacisk na pobieranie danych do arkusza z zewnętrznych źródeł (dowolne bazy danych) przy użyciu kodu VBA. Po szkoleniu uczestnik potrafi: połączyć się z dowolną bazą danych korzystająć z języka VBA wysyłać zapytania do baz danych sprawnie modyfikować dane w bazie przy użyciu VBA genrować raporty |
| dnswebmaildb | Top 4 Linux/Unix Servers - DNS,Web,Mail and Database | 28 godz. | 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) |
| 373 | Oracle Database 11g: New Features for Administrators DBA Release 2 | 28 godz. | |
| SQL_AN2 | Oracle 12c – Język SQL dla analityków II - warsztaty | 28 godz. | Warsztaty te są kontynuacją i dopełnieniem szkolenia SQL_AN1 (Oracle 12c –Język SQL dla analityków I – warsztaty) dedykowaną użytkownikom końcowym, analitykom danych oraz testerom oprogramowania, dla których realizacja obowiązków zawodowych wymaga bardziej zaawansowanych technik pracy z bazą danych. Podobnie jak w przypadku szkolenia SQL_AN1, uczestnicy nie muszą być informatykami, lecz osobami potrzebującymi sprawnie, a przede wszystkim wydajnie posługiwać się bazą danych Oracle, przetwarzając i analizując składowane w niej duże ilości danych. Warsztaty mają na celu rozszerzenie wiedzy uczestników o elementy programowania w języku PL/SQL i zagadnienia związane z optymalizacją poleceń SQL. Szczególny nacisk na tym szkoleniu położony jest na wydajność pozyskiwania danych w celu umożliwienia sprawnego, elastycznego i wydajnego operowania na bardzo dużych ilościach danych. Dodatkowo warsztaty pozwalają uzupełnić wiedzę o elementy niezbędne każdemu zaawansowanemu użytkownikowi Oracle w codziennej pracy, takie jak kopiowane i ładowanie dużych ilości informacji, modelowanie danych, modyfikacje istniejącego modelu danych oraz techniki inżynierii odwrotnej przy użyciu narzędzi Oracle. |
| mssql2016 | MS SQL Server 2016 | 14 godz. | As a core of the Microsoft data platform, SQL Server is a leading operational database management system. |
| teraintro | Teradata Fundamentals | 21 godz. | Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications. Teradata achieves this by the concept of parallelism. This course introduces the delegates to Teradata |
| datameer | Datameer for Data Analysts | 14 godz. | Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion. In this instructor-led, live training, participants will learn how to use Datameer to overcome Hadoop's steep learning curve as they step through the setup and analysis of a series of big data sources. By the end of this training, participants will be able to: Create, curate, and interactively explore an enterprise data lake Access business intelligence data warehouses, transactional databases and other analytic stores Use a spreadsheet user-interface to design end-to-end data processing pipelines Access pre-built functions to explore complex data relationships Use drag-and-drop wizards to visualize data and create dashboards Use tables, charts, graphs, and maps to analyze query results Audience Data analysts Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| pythonfinance | Python Programming for Finance | 35 godz. | Python is a programming language that has gained huge popularity in the financial industry. Adopted by the largest investment banks and hedge funds, it is being used to build a wide range of financial applications ranging from core trading programs to risk management systems. In this instructor-led, live training, participants will learn how to use Python to develop practical applications for solving a number of specific finance related problems. By the end of this training, participants will be able to: Understand the fundamentals of the Python programming language Download, install and maintain the best development tools for creating financial applications in Python Select and utilize the most suitable Python packages and programming techniques to organize, visualize, and analyze financial data from various sources (CSV, Excel, databases, web, etc.) Build applications that solve problems related to asset allocation, risk analysis, investment performance and more Troubleshoot, integrate, deploy, and optimize a Python application Audience Developers Analysts Quants Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note This training aims to provide solutions for some of the principle problems faced by finance professionals. However, if you have a particular topic, tool or technique that you wish to append or elaborate further on, please please contact us to arrange. |
| datascienceintro | A Practical Introduction to Data Science | 35 godz. | Participants who complete this training will gain a practical, real-world understanding of Data Science and its related technologies, methodologies and tools. Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class. The course starts with an introduction to elemental concepts of Data Science, then progresses into the tools and methodologies used in Data Science. Audience Developers Technical analysts IT consultants Format of the Course Part lecture, part discussion, exercises and heavy hands-on practice Note To request a customized training for this course, please contact us to arrange. |
| osqlbgn | Oracle SQL dla początkujących | 21 godz. | Słuchacze Kurs ten przeznaczony jest dla osób rozpoczynających pracę z językiem SQL w bazie danych Oracle Kurs odpowiada na pytania Jak budować zapytania? Jakie możliwości posiada język SQL? Co to są relacyjne bazy danych? Jaka jest struktura i polecenia języka SQL |
| osqladv | Oracle SQL dla zaawansowanych | 14 godz. | Słuchacze Kurs ten przeznaczony jest dla osób chcących wykorzystać zaawansowane możliwości języka SQL w bazie danych Oracle Kurs odpowiada na pytania Jak budować zaawansowane zapytania? Jak tworzyć zaawansowane raporty? |
| 3057 | Język SQL w bazie danych Oracle | 14 godz. | Kurs odpowiada na pytania Jak budować zapytania? Jakie możliwości posiada język SQL? Co to są relacyjne bazy danych? Jaka jest struktura i polecenia języka SQL |
| 3308 | Oracle 11g - Język SQL dla administratorów - warsztaty | 21 godz. | Dla kogo Warsztaty przeznaczone są dla osób początkujących, rozpoczynających pracę z baza danych Oracle, przyszłych administratorów i użytkowników systemów opartych o tę bazę potrzebujących sprawnie posługiwać się językiem SQL w zakresie ekstrakcji i modyfikacji informacji zawartych w systemach informatycznych. Egzaminy i certyfikaty Plan szkolenia pokrywa się z materiałem wymaganym do zdania egzaminu: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, będącego pierwszym krokiem do uzyskania większości certyfikatów z grupy Oracle Database Cel szkolenia Warsztaty mają na celu wprowadzenie uczestników do pracy z bazą danych Oracle, zapoznanie ich z językiem SQL w zakresie wymaganym do sprawnej pracy z tym systemem i do podjęcia w przyszłości obowiązków administratorów aplikacji bazodanowych i baz danych Oracle. Zawartość szkolenia Organizacja środowiska pracy Wprowadzenie do relacyjnych baz danych Ekstrakcja danych przy użyciu instrukcji SELECT Modyfikowanie danych przy użyciu instrukcji INSERT, UPDATE, DELETE Przegląd obiektów schematu Uwagi Warsztaty realizowane są w oparciu o oprogramowanie 11g XE |
| o11gadm | Oracle 11g - Administracja - warsztaty | 35 godz. | Dla kogo Warsztaty przeznaczone są dla przyszłych administratorów baz danych i aplikacji opartych na Oracle, w skład obowiązków których będzie wchodził nadzór i bieżąca konserwacja systemów bazodanowych i aplikacji opartych na bazach danych Oracle. Egzaminy i certyfikaty Plan szkolenia pokrywa się częściowo z materiałem wymaganym do zdania egzaminu 1Z0-052 Oracle Database 11g: Administration I, pozwalającym uzyskać certyfikat Oracle Database 11g Administrator Certified Associate Cel szkolenia Warsztaty mają na celu zapoznanie uczestników z potrzebną wiedzą i gruntowne przećwiczenie wszystkich zagadnień, z którymi spotykają się administratorzy aplikacji bazodanowych podczas bieżącej konserwacji i utrzymywania systemów Zawartość szkolenia Instalacja i konfiguracja bazy Zapoznanie z architekturą systemu Bieżąca obsługa systemów bazodanowych Administracja użytkownikami, uprawnieniami Zarządzanie strukturami danych Monitorowanie bezpieczeństwa i wydajności Uwagi Warsztaty realizowane są w oparciu o oprogramowanie w wersji 11g XE |
| 3319 | Oracle 11g - Analiza danych - warsztaty | 35 godz. | Dla kogo Warsztaty dedykowane są użytkownikom końcowym, analitykom danych oraz testerom oprogramowania. Uczestnicy warsztatów nie muszą być informatykami, lecz pracownikami potrzebującymi sprawnie i wydajnie posługiwać się bazą danych Oracle, przetwarzając i analizując zawarte w niej informacje. Egzaminy i certyfikaty Plan szkolenia zawiera m.in. materiał wymagany do zdania egzaminu: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, będącego pierwszym krokiem do uzyskania większości certyfikatów z grupy Oracle Database Cel szkolenia Szkolenie ma na celu zapoznanie uczestników z bazą danych Oracle, podstawowymi narzędziami i technikami pozyskiwania danych. Szczególny nacisk na tym szkoleniu położony jest na pozyskiwanie merytorycznie poprawnych i wiarygodnych danych. Zawartość szkolenia Organizacja środowiska pracy Wprowadzenie do relacyjnego modelu składowania danych Techniki pozyskiwania, analizy i syntezy informacji składowanych w bazie danych Modyfikowanie informacji składowanych w bazie danych Uwagi Warsztaty realizowane są w oparciu o oprogramowanie w wersji 11g XE |
| 3331 | Oracle 11g - Zaawansowana analiza danych - warsztaty | 35 godz. | Dla kogo Warsztaty te są kontynuacją i dopełnieniem szkolenia Oracle 11g –Analiza danych – warsztaty dedykowaną użytkownikom końcowym, analitykom danych oraz testerom oprogramowania, dla których realizacja obowiązków zawodowych wymaga bardziej zaawansowanych technik pracy z bazą danych. Podobnie jak w przypadku szkolenia Oracle 11g –Analiza danych – warsztaty, uczestnicy nie muszą być informatykami, lecz osobami potrzebującymi sprawnie, a przede wszystkim wydajnie posługiwać się bazą danych Oracle, przetwarzając i analizując składowane w niej duże ilości danych Cel szkolenia Warsztaty mają na celu rozszerzenie wiedzy uczestników o elementy programowania w języku PL/SQL i zagadnienia związane z optymalizacją poleceń. Szczególny nacisk na tym szkoleniu położony jest na wydajność pozyskiwania danych w celu umożliwienia sprawnego operowania na bardzo dużych ilościach danych. Dodatkowo warsztaty pozwalają uzupełnić wiedzę o elementy niezbędne każdemu zaawansowanemu użytkownikowi Oracle w codziennej pracy, takie jak kopiowane i ładowanie dużych ilości informacji, modelowanie danych, modyfikacje istniejącego modelu danych oraz techniki inżynierii odwrotnej przy użyciu narzędzi Oracle. Zawartość szkolenia Przenoszenie i ładowanie danych Język proceduralny PL/SQL pozwalający poszerzyć możliwości analityczne instrukcji SELECT Poprawa wydajności zapytań SQL Modelowanie danych oraz pozyskiwanie i modyfikacja istniejącego modelu danych w oparciu o narzędzia Oracle SQL Modeler Uwagi Warsztaty realizowane są w oparciu o oprogramowanie w wersji 11g XE |
| 3358 | Oracle 11g - Język SQL dla programistów - warsztaty | 35 godz. | Dla kogo Warsztaty dedykowane są jako pierwszy krok dla programistów i projektantów aplikacji opartych na bazach danych Oracle. Uczestnicy nie muszą posiadać żadnej wstępnej wiedzy na temat bazy danych Oracle, ani innych systemów relacyjnych baz danych, choć wiedza taka może okazać się przydatna. Egzaminy i certyfikaty Plan szkolenia pokrywa się materiałem wymaganym do zdania egzaminu 1Z0-047 Oracle Database SQL Expert i uzyskania tytułu Oracle Database SQL Certified Expert Cel szkolenia Warsztaty mają na celu zapoznanie uczestników z bazą danych Oracle, technikami budowania struktur bazy danych oraz operowania na danych. Szczególny nacisk położony jest na to, aby uczestnik zobaczył przekrojowo, jakie możliwości oferuje przy projektowaniu i budowaniu aplikacji System Zarządzania Relacyjną Baza Danych Oracle, oraz aby był w stanie samodzielnie z nią pracować. Zawartość szkolenia Wprowadzenie w technologię baz danych oraz organizacja środowiska pracy Pozyskiwanie i modyfikacja danych Budowa repozytorium aplikacji Zasady bezpieczeństwa i współbieżności pracy aplikacji Uwagi Warsztaty realizowane są w oparciu o oprogramowanie w wersji 11g XE |
| 3410 | Oracle 11g - Programowanie w PL/SQL I - warsztaty | 28 godz. | Dla kogo Warsztaty dedykowane są programistom, użytkownikom końcowym oraz administratorom, którzy do tej pory nie mieli kontaktu z językiem PL/SQL, a potrzebują wykorzystywać jego ogromne możliwości w pracy z bazą danych, automatyzacji procesów oraz przy budowaniu aplikacji. Egzaminy i certyfikaty Plan szkolenia pokrywa się materiałem wymaganym do zdania egzaminu 1Z0-144 Oracle Database 11g Program with PL/SQL i uzyskania tytułu Oracle PL/SQL Developer Certified Associate Cel szkolenia Warsztaty mają na celu zapoznanie uczestników z językiem programowania PL/SQL, jego możliwościami i ograniczeniami. Warsztaty niniejsze obejmuje pełną wiedzę na temat mechanizmów związanych z językiem programowanie PL/SQL potrzebną do swobodnej implementacji logiki aplikacji, automatyzacji procesów przetwarzania danych oraz zarządzania baza danych. Zawartość szkolenia Wprowadzenie do języka PL/SQL, architektura rozwiązań opartych na tym języku, organizacja środowiska pracy Tworzenie skryptów i składowanych jednostek programowych operujących na danych Uwagi Warsztaty realizowane są w oparciu o oprogramowanie w wersji 11g XE |
| 3419 | Oracle 11g - Programowanie w PL/SQL II | 21 godz. | Dla kogo Szkolenie to jest uzupełnieniem i kontynuacją szkolenia "Oracle 11g – Programowanie w PL/SQL I - warsztaty", ale może być również przeznaczona dla praktyków, programistów PL/SQL posiadających już doświadczenie w pracy z tym językiem, a pragnących usystematyzować swoją wiedzę i poznać zaawansowane mechanizmy oraz rozwiązania tworzone w tym języku. Zawartość szkolenia Obiekty, strumienie i złożone struktury danych Zaawansowane rozwiązania oparte na języku PL/SQL Egzaminy i certyfikaty Plan szkolenia pokrywa się materiałem wymaganym do zdania egzaminu 1Z0-146 Oracle Advanced PL/SQL i uzyskania tytułu Oracle Advanced PL/SQL Developer Certified Professional Cel szkolenia Szkolenie ma na celu zapoznanie uczestników z zaawansowanymi aspektami programowania w środowisku baz danych Oracle. Szczególny nacisk kładziemy na elastyczność i wydajność rozwiązań opartych o PL/SQL. Uwagi Warsztaty realizowane są w oparciu o oprogramowanie w wersji 11g XE |
| 3457 | Oracle 11g - Strojenie Aplikacji - warsztaty | 28 godz. | Dla kogo Warsztaty przeznaczone są dla zaawansowanych programistów i użytkowników Oracle, którzy poszukują wiedzy i informacji na temat wydajnego tworzenia systemów informatycznych w bazie danych Oracle, oraz strojenia i badania problemów wydajnościowych w już istniejących aplikacjach. Szkolenie to bazuje na wiedzy często niedostępnej lub błędnie przedstawianej w dokumentacji technicznej, a zebranej podczas wielu lat praktyki prowadzących je instruktorów. Warsztaty te mogą być zakończeniem ścieżki szkoleń dla programistów, lub stanowić pojedynczy krok dla osób z dużym doświadczeniem projektowym i programistycznym w Oracle. Cel szkolenia Warsztaty mają na celu przedstawienie mechanizmów zachodzących w bazie danych Oracle podczas wykonywania poleceń SQL. Pozwalą uczestnikom unikać błędów podczas tworzenia oprogramowania, a także poszukiwać, diagnozować i rozwiązywać problemy wydajnościowe w już istniejących aplikacjach. Szczególny nacisk kładziemy na część warsztatową, gdzie pokazujemy metodykę i praktyczne aspekty tuningu aplikacji i poleceń SQL. Zawartość szkolenia Mechanika wykonywania poleceń SQL Zarządzanie procesem optymalizacji kosztowej Metody składowania i indeksowania danych Monitorowanie wydajności bazy danych i procesów w oparciu o słowniki systemowe i śledzenie aplikacji Analiza przypadków powodujących najczęstsze problemy wydajnościowe Uwagi Warsztaty realizowane są w oparciu o oprogramowanie w wersji 11g XE |
Upcoming Courses
| Szkolenie | Data Kursu | Cena szkolenia [Zdalne / Stacjonarne] |
|---|---|---|
| SQL in Microsoft Access - Kielce, ul. Warszawska 19 | pon., 2018-06-04 09:00 | 1990PLN / 2740PLN |
| Oracle 11g - Strojenie Aplikacji - warsztaty - Zielona Góra, ul. Reja 6 | pon., 2018-06-04 09:00 | 3990PLN / 5240PLN |
| Wprowadzenie do Neo4j - grafowej bazy danych - Łódź, ul. Tatrzańska 11 | pon., 2018-06-04 09:00 | 3330PLN / 3830PLN |
| Scylla database - Katowice ul. Opolska 22 | pon., 2018-06-04 09:00 | 4990PLN / 5990PLN |
| SQL Advanced - Szczecin, ul. Sienna 9 | wt., 2018-06-05 09:00 | 1990PLN / 2740PLN |
Other regions
BiałystokBielsko-BiałaBydgoszczChorzówCzestochowadolnośląskieGdańskGdyniaGliwiceGorzów WielkopolskiKatowiceKielceKrakówkujawsko-pomorskielubelskieLublinlubuskiemazowieckiemałopolskieOlsztynOpoleopolskiepodkarpackiepodlaskiepomorskiePoznańRzeszówśląskieświętokrzyskieSzczecinTarnówToruńtrójmiastowarmińsko-mazurskieWarszawawielkopolskieWrocławZabrzezachodniopomorskieZakopaneZielona GóraŁódźłódzkie
Other countries
Konsultacje
Szkolenie Bazy danych, Bazy danych boot camp, Szkolenia Zdalne Bazy danych, szkolenie wieczorowe Bazy danych, szkolenie weekendowe Bazy danych
, nauka przez internet Bazy danych, e-learning Bazy danych, kurs online Bazy danych, wykładowca Bazy danych
, edukacja zdalna Bazy danych, instruktor Bazy danych, kurs zdalny Bazy danych, nauczanie wirtualne Bazy danych,Kursy Bazy danych, lekcje UML,Kurs Bazy danych