Corsi nobleprog

...i partecipanti avranno una conoscenza delle funzioni di base e alcune funzioni avanzate di Scilab e avranno le risorse per continuare ad espandere le proprie...

...File Maintenance and Rotation Running Multiple MySQL Servers on the Same Machine Running Multiple Servers in Windows Running Multiple Servers in Windows...

...configurare e gestire MariaDB per l'alta disponibilità e le prestazioni Altri argomenti includono backup e ripristino, sicurezza e clustering Pubblico...

...invece di farlo in MS Excel Questo può anche aiuto nella creazione di qualsiasi sistema IT, che utilizza qualsiasi database relazionale . Machine Translated...

...Durante la migrazione dei database esistono metodi comuni di gestione della logica inseriti in query SQL specifiche del database o del linguaggio procedurale...

...experimenting with queries and supported data types Section 4: Data Modeling – part 2 Creating and using secondary indexes composite keys...

...Performance tips Benchmarking Redis Commands to avoid Debugging latency problems Problems with big DEL requests - what to use instead Pipelining Mass insertion...

...i settori Persone IT Sviluppatori Formato del corso Lezione di parte, discussione parziale, esercitazioni e pratica intensiva . Machine Translated Introduction...

...(Hadoop/Hive/Map Reduce) Basic Operators with reference Administrating SequoiaDB Database Management Replication Cluster Reference Operator SequoiaDB Shell...

...Performance Monitoring and Tuning Monitoring Slow Queries SQL Tuning Table Partitioning Operating System Best Practices Parameter Tuning Extensions Benchmarking...

...and constraints How to create tables How to alter tables How to create views Use of synonyms How to remove tables and views...

...Machine Translated Analytical Functions Use of advanced summary functions Use of hierarchical queries Use of analytical summary functions...

...and performance Using CASE, IF, COALESCE functions Using variables Casting and converting Dealing with NULL, NULL-safe operators Using regular expression...

...CONSTRAINT clause ENUM type type SET PRIMARY KEY condition UNIQUE condition FOREIGN KEY condition DEFAULT clause Transactions The command COMMIT...

...(CREATE TABLE . AS SELECT...) CONSTRAINTS Overview NULL i NOT NULL CONSTRAINT clause ENUM type SET type PRIMARY KEY UNIQUE FOREIGN KEY DEFAULT clause Transactions...

...functions FIRST/LAST functions Reverse percentile functions hypothetical rank functions WIDTH_BUCKET functions Statistical functions...

...in database ibridi. Machine Translated Course Outline: What is the meaning of Databases. Comparison of RDBMS and DBMS Different RDBMS available in the market...

...Authentication Database Roles Managing Databases Localization Routine Database Maintenance Tasks Backup and Restore High Availability, Load Balancing...

...backup to Azure Migration SQL Server to Azure SSIS and Data Factory...

...Procedures Altering Stored Procedures Triggers Creating Triggers Transactional Error Handling Using Inserted and Deleted Tables... Impara:: Microsoft SQL Server...