Mastercard/Visa/AMEX/Cash
Tickets can be collected from the SEC Centre box office on the day of the event from the advertised doors opening time. Please take the credit card used to make the booking and your Ticketmaster reference number
Box Office: 0844 395 4000 Calls will cost 7 ppm plus your network access charge.
Monday - Friday: 9am to 5.30pm Saturday: 9am to 5pm Sunday: closed* *Please note these are the standard opening times of the main SEC Box Office. Out with standard opening hours, the venue box office will be open in line with any events taking place. The SSE Hydro box office opens one hour before doors to the arena opens and closes 30 minutes after the main act starts or at the end of the interval, unless otherwise stated.
Accessible tickets are available to book online, but for larger or more complex groups, please call our dedicated accessible booking line on 0800 952 0110. The venue is easily accessible for visitors with mobility difficulties and accessible needs and currently holds an Attitude is Everything Gold award for access. The first two floors of SEC Hydro are fully accessible with lifts and automated doors. Important: There is no lift to the 3rd and final floor of the venue, there are stairs along with handrail assistance to gain access to this floor. Please take this into consideration when booking tickets. People with mobility issues are recommended to book tickets on the ground, level 1 or level 2 front, as these have lifts to access. All Entry doors East, South and West into the Hydro are wide for easy access. Broad, flat, accessible concourse The venue has multiple accessible toilets and one fully equipped Changing Place with ceiling hoist, changing bed and height adjustable basin. Entry is by RADAR key visitors can use their own or ask a steward to unlock for them. The venue offers a wide range of additional accessibility services, such as sunflower lanyards, sensory packs, infra-red induction loop, etc. For more information visit the venue website at www.thessehydro.com
Due to current COVID-19 restrictions by our local food pantries, donations this year are virtual. Between now and Sunday, November 22nd, drop off your donation by calling 414-939-7619 to schedule a time. All donations will be used to purchase food online for one of our local food banks. No donation is too small! Please donate to help make a difference in our community. Thanks for your consideration!
Visa, American Express, Mastercard
Will Call tickets may be picked up at the Visa Box Office at Levi's® Stadium. The Will Call windows open three (3) hours prior to the event. Will call tickets can be claimed only by the person whose name appears on the Will Call envelope. Government issued photo identification is required. ***** Bag Policy - All Events ***** In compliance with the NFL's Bag Policy, Levi's® Stadium prohibits all bags, backpacks and other carriers from being brought into the stadium with the following exceptions: NFL approved clear plastic bags (12 x 6 x 12) One gallon clear plastic zip lock type bags Small Clutch Bag (the size of an adult hand) (4.5 x 6.5) All approved bags are subject to inspection upon entry and are subject to additional inspections within the stadium.
415-GO-49ERS (415-464-9377)
9AM to 5PM Monday through Friday,
Accessible seating for patrons requiring wheelchair access is available with up to 3 companions. FOR ALL OTHER ACCESSIBLE AND LIMITED MOBILITY CONCERNS, PLEASE CALL (415) 467-9377
Tickets left at the box office for collection may be picked up on the day, during the hour before the performance starts. Please take the credit card used to make the booking and the Ticketmaster booking reference number as proof of purchase.
Ticketmaster UK: 0870 154 40 40, International: 00 44 161 385 3500
Monday - Saturday 10:00 - 18:00 and occasionally on Sunday.
Infra red hearing system with no deposit required. For special needs seating please call 0844 412 4648. Disabled toilet situated in the rear Stalls with ground level access There is no limit to the amount of Guide Dogs (within reason of course)
cash, amex, mc, visa, discover
Location at venue: Main Box Office – East side of the Arena with access from both Trade and Fifth Streets. Hours of Operation: Same as Box Office Hours
704-688-8600 For general group sales questions for Spectrum Center: 704.688.9047
M-F: 10:00 am – 6:00 pm Sat & Sun: Event days only
This venue is accessible. For sight impaired and hearing patrons please contact the Box Office. Spectrum Center is committed to providing every guest with a comfortable and enjoyable experience. The arena is one of the most accessible arenas in the U.S. Seating throughout the venue allows guests with accessible needs flexibility in seat locations and price levels.
You can use our proud partner’s Chase Cards for payment at the Box Office. We also accept, Cash, MasterCard, Visa, American Express, Discover
Will Call tickets may be picked-up at the Chase Center box office with a valid government issued photo I.D. that matches the name on the order, the credit card used to make the purchase, and the confirmation number given at the time of purchase are provided. VIP PACKAGES are subject to the package providers rules for pick up. For the box office to release tickets not in your name you need to submit a written letter of authorization along with a copy of the driver’s license of the party whose name is on the account.
For Golden State Warriors: Ticket Sales: 1-888-GSW-HOOP (option 1) Group Sales: 1-888-GSW-HOOP (option 2) Account Service: 1-888-GSW-HOOP (option 3) Grandview Suites 1-888-GSW-HOOP (option 4) Administration: (510) 986-2200
Monday-Friday: 10AM - 4PM // Weekends: Only on event days pending door times.
Accessible seating is available online through Ticketmaster.com, by calling Ticketmaster phone agents or coming to the Chase Center Box Office. Interpreters are available by request and are dependent upon availability. Please call the Chase Center for further information. Interpreters need to be reserved a minimum of 10 days in advance of the show. Service dogs are allowed at the Chase Center.
Cash, Visa, MC, Discover, American Express
Available at Box Office during regular hours.
Holiday Box Office Hours: Christmas Eve (12/24/19) - 10:00am-2:00pm Christmas Day (12/25/19) - CLOSED New Year's Eve (12/31/19) - CLOSED New Year's Day (1/1/20) - 12:00pm-7:00pm Box office hours: Monday - Saturday 10:00am-8:00pm Sunday 11:00am - 7:00pm THE BOX OFFICE WILL BE OPEN FOR SALES IN PERSON ONLY.
There are no steps into the theatre from the sidewalk. Please be advised that where there are steps within the theatre we are unable to provide assistance. Orchestra: Seating is accessible to the Orchestra without steps, but there are 1-2 steps up to access rows Q-T in the Center and Right Orchestra. Wheelchair seating is in the Orchestra only. Mezzanine: On the 2nd Level: up 29 steps from the Orchestra. There is no elevator to the Mezzanine. Entrance is behind row F. There are approximately 2 steps up/down per row. There are handrails along both sides of every aisle in the mezzanine. Balcony: On the 3rd level: up 76 steps from the Orchestra. There is no elevator to the Balcony. There are approximately 2 steps up/down per row. There are handrails along both sides of every aisle in the Balcony.
Cash, Money Order, AMEX, MC, VISA, Personal Check (must be received 10 days prior to event).
Will Call is located on the southwest corner of the stadium on the corner of Brush & Beacon Street outside Gate A. (This location may change depending on event. Please call 313-262-2000 with any questions) Ford Field Address: 2000 Brush St. Detroit, MI 48226
General Information: 313-262-2000 Ticket Information: 313-262-2002 Accessible Seating Ticket Information: 313-262-2167 Event Information: 313-262-2003 (press option 5) Detroit Lions Pro Shop: 313-262-2200 guestservices@detroitlions.com
Monday - Friday: 10:00 AM - 6:00 PM Located at Gate G off St. Antoine 2000 Brush St. Suite 200 Detroit, MI 48226
Wheelchair accessible seating is available at the box office at 313-262-2167. Policy: One companion for each wheelchair patron allowed in wheelchair designated seating areas.
Cassandra training is a 16 hours long LIVE Instructor-led training delivered from January 11 - February 2, 2020 over 4 weekends, 8 sessions, 2 sessions per weekend, 2 hours per session.
Cassandra Training Overview
Cassandra training course is designed to help you master the key concepts of Apache Cassandra including Architecture, features, Data Model, and its Administration. During this Cassandra course, you will learn how to install, configure, and monitor Cassandra. You will also learn about its integration with other Apache frameworks like Hadoop, Spark, and Kafka.
Weekly Schedule
4 weekends | Saturday and Sunday every weekend
7:30 - 9:30 AM US Pacific time each day
January 11 - February 2, 2020 US Pacific time
Please check your local date and time for first session
Features and Benefits
4 weeks, 8 sessions, 16 hours of total Instructor-led LIVE training
Training material, instructor handouts and access to useful resources on the cloud provided
Practical Hands on Lab exercises provided
Actual code and scripts provided
Real-life Scenarios
What are the Objectives of the Course ?
Creating Sample Application in Cassandra
Configuring, Reading and Writing Data in Cassandra
Integrating Cassandra with Hadoop
Cassandra Data Model
Cassandra Environment
Understanding Cassandra Architecture
Who should take this course?
IT Professionals looking for a career in Cassandra
IT Developers
Testing professionals
Those looking to refresh their Cassandra skills
Analyst/Researcher
Project Managers
Course Outline
1. What is Big Data
Technology Landscape
Big Data Relevance
Distributed Systems and Challenges
2. Why NoSQL Databases
Relational DB vs. NoSQL
Type of NoSQL Databases
NoSQL Landscape
CAP Theorem and Eventual Consistency
Key Characteristics of NoSQL Database systems
ACID vs BASE
3. Cassandra Fundamentals
Distributed and Decentralized
Elastic Scalability
High Availability and Fault Tolerance
Tuneable Consistency
Row-Oriented
Schema-Free
High Performance
4. The Cassandra Data Model
The Relational Data Model
A Simple Introduction
Clusters
Keyspaces
Hands-on Session
5. Installation and Setup of Cassandra
Single Node Setup
Multi-Node Cluster Setup
Key Configurations for Cassandra
CLI and Hands-On with Cassandra
6. Cassandra Modeling
Cassandra (Column Family NoSQL DB)
Key Concepts – Key Space – Column Family – Column Family Options – Wide Rows, Skinny Row – Column Sorting – Super Columns – Counter Column Family – Composite Keys and Columns – Time To Live –
Secondary Indexes in Cassandra
Difference between Custom Indexes and Secondary Indexes
Difference between Relational Modeling and Cassandra Modeling
Key Points to note while modeling a Cassandra Database
Patterns and Anit-Patterns in Cassandra Modeling
7. Cassandra Architecture & Intro to CQL
Anatomy of Reading operation in Cassandra
Anatomy of the Write operation in Cassandra
How is Deletes handled in Cassandra
System Keyspace
Peer to Peer Model Logical Data Model: Keyspace, Column Family/Table, Rows, Columns
Traditional Ring design vs. VNodes
Partitioners: Murmer3, Random (md5) and ByteOrdered
Gossip and Failure Detection
Anti-Entropy and Read Repair
Memtables, SSTables and Commit Log
Compaction fundamentals to reduce SSTable data files
Hinted Handoff
Compaction
Bloom Filters, Tombstones
Managers and Services
VNodes
Indexes and Caches
Coordinator node
Seed nodes
Write/Read consistency levels: Any, One, Two, Three, Quorum
Snitches: Dynamic snitching, Simple Snitch, Rack Inferring Snitch, Property File Snitch, Gossiping Property File Snitch
Routing Client requests
Nodetool commands: gossipinfo, cfstats, describing
YAML file fundamentals
Operations management web GUI
Stress testing Cassandra
CQL command fundamentals
8. Cassandra API
Key concepts for Reading and Write in Cassandra
Tunable Consistency
Simple-Get, Multi-get Slice
Range and Slice
Slice Predicate
Delete
Hands-on CLI commands
9. Cassandra CQSHL
SQL over Cassandra
Composite Keys
Hands-on examples on CQL 3.0
10. Cassandra Clients
How to establish Client Connections
Thrift Client
Connection Pooling
Auto-discovery and Failover in Hector
Client with CQL
11. Cassandra Monitoring and Administration
Tuning Cassandra
Backup and Recovery methods
Balancing
Bootstrapping
Node Tools Commands
Upgrades
Monitoring critical metrics
Bulk Loading Data to Cassandra
Bulk Export of Data from Cassandra
Hands-on Examples for each of them
12. Cassandra Analytics and Search Clusters
Cassandra Hadoop Integration
Integration of Solr with Cassandra
Search Query on Cassandra