Instant Cassandra Query Language -- Instant Cassandra Query Language -- Credits -- About the Author -- About the Reviewers -- www.packtpub.com -- Support files, eBooks, discount offers and more -- packtlib.packtpub.com -- Why Subscribe? -- Free Access for Packt account holders -- 1. Instant Cassandra Query Language -- So, what is CQL? -- Where will you use CQL? -- Installation -- Step 1 - what do I need? -- Step 2 - download Cassandra -- Step 3 - install Cassandra -- Step 4 - configure Cassandra -- Step 5 - start Cassandra server -- What may go wrong? -- And that's it -- Quick start - running CQL queries -- Step 1 - start CQL shell (cqlsh) -- On Unix -- On Windows -- Install and configure Python -- Run cqlsh -- Step 2 - create and use a keyspace -- Step 3 - describe and list keyspace -- Step 4 - create table and insert records -- Step 5 - display records -- How is data actually stored? -- Step 6 - deleting data -- DELETE -- TRUNCATE -- USING TTL -- Dropping TABLE and KEYSPACE -- CQL versions -- Step 7 - building facebook -- Creating keyspace for facebook -- Storing facebook data using tables -- Storing user profiles -- Create table -- Insert records -- Update row -- View rows -- Alter table (add collections columns) -- Storing facebook posts -- Create table -- Add records -- Creating table for user wall (timeline) -- How data is stored -- Connecting users with their friends -- Counting friends and posts -- Top 3 features you need to know about -- TTL (time to live) -- Syntax -- Gone in 60 seconds! -- CQL for client applications -- Using the Thrift API -- Using the Datastax Java driver -- Using high-level clients -- Batch operations -- Syntax -- Three flavors of the batch operation -- People and places you should get to know -- Official sites -- Articles and tutorials -- Community -- Blogs -- Twitter.