Requirements
- Students should already know what Apache Cassandra and CQL are
- You should already know something about the primary keys, and how partitions work
- You should already have some background in a query language such as SQL or CQL
Features
- Learn and/or better understand Apache Cassandra and its CQL (Cassandra Query Language)
- Help you pass DataStax certification exams with a better understanding of Apache Cassandra overall
- Test your knowledge on CQL and become an expert in Apache Cassandra, through practice tests
- Learn how to properly use partition, clustering and primary keys, in data definition or in queries
- Keep yourself motivating with two interactive puzzles, with 50 questions each
- Check the major differences between SQL and CQL, with plenty of examples
- Learn how to avoid CQL traps, gotcha situations, hidden issues you may not know about.
Target audiences
- Cassandra developers who want to master the CQL and know more about the product overall
- Those preparing for DataStax professional certification exams
- Database practitioners who want to better understand why and how CQL is different from SQL
- All those puzzled and a bit confused by the partition and clustering keys in Cassandra
- All those baffled by the different query-first approach of the Cassandra data modeling
TWO original and high-quality practice tests of 50 questions each must help you learn and/or better understand Apache Cassandra, especially its CQL (Cassandra Query Language):
- Each practice test has 50 questions. To challenge you, we timed them for 60 minutes, with a 80% passing score.
- Domains: Data Modeling, Data Definition, Data Types, Data Search, Data Modification, Functions, CQL Shell, Performance, Security.
- Every question offers 3-4 choices. Most questions are single-select, a few with variable multi-selections.
- Every question is unique and original, elaborated, meant to teach you something essential, with no waste of time.
- Detailed explanations with external references for any possible choice, in each practice test question.
- Reference links to relevant pages from the Apache Cassandra Documentation, DataStax documentation, StackOverflow questions.
- While this will also help you pass DataStax certifications exams, the questions here may be very different from the exams.
What you will learn or better understand
- How to properly design tables in CQL. Data modeling with Chebotko diagrams and proper key choices.
- How to properly query Cassandra tables without paying a price in performance.
- How to properly use the partition, clustering or primary keys, in WHERE and ORDER BY clauses.
- When and what keys you may skip in a filter expression or in an explicit query sort order.
- When to create a new denormalized table, secondary index or materialized view.
- Major differences between SQL and CQL, with plenty of examples.
- How to avoid traps, gotcha situations, hidden issues you may not know about.
- What the mysterious TTL actually does. When whole rows may suddenly disappear or not.
How should I use these tests?
- Try first practice test. And do not worry about the time or if you fail. You are expected to fail, this is how you learn…
- Stop the exam anytime, if you’re not patient enough to go over all 50 questions.
- Once done, you get your total score, plus per domain.
- Click Review Questions and scroll down to both the right and wrong choices for each individual question.
- Read the detailed Explanation for each question.
- Repeat with the second practice test.
- Repeat these tests again and again, until you score at least 90% on each.
Also Available on Amazon as a Book (click for a Very Low Price!)
