Nobleprog Limited courses

...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...

...and as a sharded cluster. Evaluate applications and choose hardware appropriately. Monitor MongoDB instances and integrate with standard monitoring software (Munin... Learn about: Database training, Monitoring Tools...

...types Participants will also learn about XQuery's support for filtering, sorting, and grouping data, as well as how to use FLWOR expressions... Learn about: XML training, IDS training...

...This course is usually deliver with following databases: DB2, Oracle, MySQL, MariaDB, SQL Server, etc... but can be tailored to a specific migration project... Learn about: Database training...

...and administration. Audience Administrators and developers seeking to use Cassandra. This course serves as a foundation and prerequisite for other advanced Cassandra courses... Learn about: Communication Training...

...storage engine Creating and dropping CONNECT tables Reading and writing CSV data using CONNECT Reading and writing XML data using CONNECT Accessing MariaDB... Learn about: Database Administration, Database training...

...Audience All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge. Format of the course 25% lectures... Learn about: Basic Skills...

...Cursor Two Phase Commits Auto-incrementing Sequence field Aggregation Distinct Aggregation Pipelines Map-reduce Indexes Default _id Single Field Compound...

...Sets & Sorted sets Hashes Bit arrays HyperLogLogs Redis Pub/Sub Expiration Redis transactions & Lua scripts Performance tips Benchmarking Redis Commands...

...This course covers everything a database developer needs to know to successfully develop applications using Aerospike. Data Management Data Model Primary...

...Publishing Service virtualization Security Service Pooling... Learn about: XML training...

...+ 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... Learn about: Database training, Java API, System Operations...

...working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables... Learn about: Database training...

...operator Nested Subqueries (the WHERE clause, the table name, column name) Correlated subqueries Data Modification Language Inserting... Learn about: Oracle SQL Language, Database Management, Database training...

...Overview External Authentication Commands Environment Setup and Configuration Percona TokuBackup Architectural Overview Making a Backup Checking Backup... Learn about: Quality Training, IT Auditing...

...Tables The ORDER Tables The FILM Tables PL/SQL What is PL/SQL? Why Use PL/SQL? Block Structure Sample Code SELECT Statement Using Variables Accepting... Learn about: Database training, Microsoft Access...

...Group by, Having clause What are inbuilt functions? Math, String and Datetime functions. Working with Views. How they are used for data access...

...of the command execution plan Hypothetical plan (EXPLAIN PLAN, SQLPlus AutoTrac XPlane) The actual execution plan (V $ SQL_PLAN, XPlane,... Learn about: Database training...

...(Batch Mode) Discussion of the utilities Ways to call the program Setting program options (command line, the configuration file, environment variables)... Learn about: Database training...

...Procedures and Functions Workshop Triggers Creating Triggers Statement Triggers Row Level Triggers WHEN Restriction Selective Triggers - IF Showing Errors... Learn about: Database training, Application Development...