Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Introduction
- ClickHouse vs MySQL vs Oracle
- Overview of ClickHouse features and architecture
Understanding Column-Oriented Databases
Getting Started
- Setting up the environment
- Installing ClickHouse
- Connecting to the database
Managing Users and Roles
- Role-Based Access Control (RBAC)
- XML vs SQL configuration
- Users, roles, and privileges
Working with the ClickHouse Database
- SQL syntax, functions, and operators
- Creating and modifying tables
- Loading data
- Creating a schema
- Running analytic queries
- Using views, indexes, and arrays
Administering the ClickHouse Database
- Replication and sharding
- Resource utilization
- Backing up and restoring data
- Optimizing performance
Integrating ClickHouse with External Systems
- ODBC and JDBC
- HDFS, Amazon S3, and EmbeddedRocksDB
- MySQL, PostgreSQL, SQLite, and Hive
- MongoDB and RabbitMQ
- Apache Kafka
Troubleshooting
Summary and Next Steps
Requirements
- An understanding of relational databases
- Experience with SQL
Audience
- Developers
- IT professionals
Related Courses
Data Management
35 hours
Pivotal Greenplum for Developers
21 hours
MarkLogic Server
14 hours
SAP ASE for Database Administrators
28 hours
Access Intermediate
14 hours
Access VBA
21 hours
Access Advanced
21 hours
Microsoft Access - download the data
14 hours
Access - Data Base Designing
21 hours
SQL in Microsoft Access
14 hours
VBA For Access & Excel
21 hours
MERN Fullstack Development
14 hours
MongoDB for Analysts
14 hours
MongoDB for Administrators
14 hours