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.
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)
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
The role of the process engineer working with hydroprocessing, both hydrotreating and hydrocracking, is becoming increasingly more important, as the refiner strives for optimal solutions to obtain high-quality fuel products. To be able to optimize the yield and quality of the products, it is crucial to understand the theory and practice of hydroprocessing. Topsoe offers you our popular intensive hydroprocessing course specifically designed for refinery engineers. The objective of this course is to equip engineers with tools, enabling right decision-making to obtain the highest possible benefit of the units. Furthermore, it offers plenty of opportunities for discussing hydroprocessing issues with Topsoe’s experts and other hydroprocessing peers.
Course topics
Hydroprocessing reactions
Catalyst selection and fundamental understanding
Reaction kinetics and feedstock dependency
Effect of operating conditions, optimal performance
Yield and hydrogen consumption
Understand your hydrotreater/hydrocracker layout
Hydroprocessing overview (naphtha, kerosene, diesel-HDA, biodiesel, VGO)
Catalyst loading and activation, monitoring, and troubleshooting
Pressure drop control
Reactor internals and scale catchers
Renewable feeds
Dewaxing
Course activities
During the course, the following activities will be included:• Topsoe will host a welcome dinner on day 1 (January 14)• Lunch and coffee breaks for both days (breakfast included in hotel)
Who should attend?
This course is exclusively for Haldor Topsoe customers.
The course is designed for refinery engineers who work with hydroprocessing and related catalysts and processes, as well as more experienced engineers interested in a refresher course. A further major benefit is the opportunity to converse with Topsoe specialists about specific technical and operational issues.
Practical information
Date: January 14-16, 2020 (will finish at 1.00 pm on the 16th)Location: Jalan Batu Ferringhi, Kampung Tanjung Huma, 11100 George Town, Pulau PinangHotel: Golden Sands Resort by Shangri-LaFee: None (all course materials, meals and drinks during the course are included)Dress code: Business casualContacts: Nur Elyana Ishak, Executive Assistant, nei@topsoe.com
Last sign-up
Deadline for course sign-up: December 15, 2019Deadline for hotel sign-up: December 13, 2019
Hotel accommodation
Topsoe has secured rooms at the Golden Sands Resort by Shangri-La located in Jalan Batu Ferringhi, Kampung Tanjung Huma, George Town, Pulau Pinang at a special rate.
The rate per night is (Single/Twin):Superior Room: RM350.00nett (~85 USD) (incl. service charge, tax and breakfast)
Deluxe Room: RM450.00nett (~110 USD) (incl. service charge, tax and breakfast)
Once you have filled out this registration form online you will receive a confirmation email which will include a link to the hotel reservation. In order to secure your room, you will need to click the link and complete the reservation details and submit it directly to the hotel.
For any further enquries on the room reservation, you may contact Mr.Gerald Wan Tom (geraldwan.tom@shangri-la.com)
• Deadline for reservation is December 13, 2019• Payment for the hotel accommodation will take place on departure
Guarantee
In order to guarantee your reservation in connection with the hotel booking, you will be asked to inform your credit card details. Your credit card will not be charged prior to your arrival and will only be used to guarantee your accommodation. You will need to present the same credit card when you check in. Please note that if you do not show up at the hotel on the day of arrival, a cancellation fee equivalent to the full pre-booked stay will apply as per hotel policy.
Disclaimer
We/organizer have the rights to decline any registration that is deem not relevant to the event.
American Express, Discover, MasterCard, and Visa are accepted. Honda Center is a cashless venue.
A photo ID matching the name the tickets are placed under is required. VIP, Artist, Promoter, or other special will call requirements and locations are subject to change. Will call windows are located at the Box Office. Will call is generally available beginning 1-1/2 hours prior to the event, and closes after the start of the event (after the first intermission for Anaheim Ducks games). Late pick up will be available at the East Entrance after the box office closes.
Box office phones are answered during regular box office hours. Please note, the box office does not sell tickets by phone. Call (714) 704-2500 for general information
Monday through Friday 10am to 3pm. The box office will remain open through the beginning of weeknight events. On event Saturdays and event Sundays, the box office will open three (3) hours prior to the event and remain open through the beginning of the event. The box office is located on the east side of the building, near the East Entrance, facing the Santa Ana riverbed.
Wheelchair accessible seating is available in most areas of Honda Center including Plaza, Club, and Terrace levels. Availability of locations is dependent upon event seating configuration. For availability and exact locations based on a particular event, please toggle the Accessibility icon in the seat map filters on the Ticketmaster.com event page. The box office will have the same availability as Ticketmaster. Please note, semi-ambulatory or limited mobility seating is also available and requires the guest to navigate some steps. Wheelchair accessible seats have no steps. Hearing Impaired Guests: Assistive listening devices are available, with a picture ID as a deposit, at the Guest Services Desk located at Section 214. Requests for sign language interpreters must be received at least 14 business days prior to the event you are attending. To arrange for courtesy sign language interpreters, please either email accessibilityservices@hondacenter.com or call 714-704-2400. For a full list of ADA policies, please visit https://www.hondacenter.com/arena-info/ada-accessibility/