Corsi nobleprog

...a seconda della domanda Il corso si concluderà con un breve progetto incentrato sull'elaborazione delle immagini Alla fine di questa formazione...

...as Services Running Multiple Servers in Unix and Linux Using Client Tools in a Multi-Server Environment...

...Active-active clustering with Galera Cluster Load balancing Performance tuning in MariaDB Hardware and performance Schema tuning Indexing SQL query Tuning...

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

...logic which should be migrated out of database and the logic which can stay Scalability issues Creating unit tests Migration strategies analysis...

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

...Redis è un archivio open source (con licenza BSD), inmemory data structure, utilizzato come database, cache e broker di messaggi. Machine Translated Module...

...Using the ETL Module Building the VehicleHistoryGraph Database Using the Demonstration Database Troubleshooting Closing Remarks...

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

...Installation Configuration Pool Setup HA Setup Demos and Labs Database Upgrades PostgreSQL Versioning Plan for Upgrade Upgrade using pg_dump Upgrade using...

...data Selection of calculated and derived values How to control column headings in query results How to send query results to external files Joining Tables...

...clustered tables Use of partitioned tables Use of metadata in the master database Query Performance Tracing Principles of query execution and optimisation...

...Creating tables with select Temporary tables Stored Procedures Short introduction to MySQL stored procedures...

...Machine Translated Relational database models Relational operators Characteristics of declarative SQL language SQL syntax Division language...

...Overview COMMIT ROLLBACK SAVEPOINT Implicit and explicit rollbacks and commits SQL Dialects Overview MySQL Microsoft Access and SQL Server Oracle and PostgreSQL...

...ROLLUP and CUBE operators Identifying summaries - GROUPING GROUPING SETS operator Retrieving data from multiple tables Different types of joints NATURAL...

...Questo corso di formazione SQL è rivolto a persone che desiderano acquisire competenze di base per gestire database SQL Server. Il corso aiuterà i membri a imparare...

...Language Handler Writing A Foreign Data Wrapper Genetic Query Optimizer Index Access Method Interface Definition GiST Indexes GIN Indexes Database Physical...

...Enhanced SSIS Enhanced MDS Reporting Services New Report Server Mobil Reports SQL Server Mobile Report Publisher Cloud and Hybrid Stretch Database Enhanced...

...Lo scopo di questo corso è quello di fornire una chiara comprensione dell'uso avanzato di (SQL) per Microsoft SQL Server e l'uso avanzato di Transact-SQL... Impara:: Microsoft SQL Server...