Cash, American Express, Mastercard, & Visa.
Will Call is located at the Box Office.
Box Office Telephone: 323-468-1770
The Pantages Box Office opens daily at 10am. NO ONE UNDER THE AGE OF 5 ADMITTED
There is no elevator in the Pantages Theatre. Disabled seating is reserved for the exclusive use of the disabled patron and their companion. The purchase or use of disabled seating locations by non-disabled individuals is strictly prohibited and may result in ejection and/or forfeiture of the ticket price.
SQL Intermediate 2-Day Course
2 consecutive days, the first thereof listed
By storing data in SQL, one can easily and quickly, with the use of queries, retrieve valuable information, trends, summaries, statistics and insights from your company data. In this SQL Course you will learn how to get valuable information, trends, summaries, statistics and insights from your company data using SQL. This course is ideal for managers and data analysts who need to get business intelligence from data
Course Overview:
Candidate who would like to gain a basic understanding of a SQL database and SQL commands and move on the next stage. The content of the course covers the topics required for the Certified SQL Developer I examination.
Prerequisites:
Familiarity with relational database concepts is helpful but not required. No existing knowledge on SQL is required, but will help.
.
SQL Course Desciption
Session 1: Database Concepts Brief revision of database basics. Tables, rows and columns, Indexes, primary keys, foreign keys, Supported data types, table types.
Session 2: Using the SQL client
Selecting a database, Executing SQL statements.
Session 3: Basic SQL SELECT statement The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions, The select clause, The FROM clause, Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,
The ORDER BY clause.
Column aliases.
LIMIT / TOP. Distinct.
Session 4: Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”),
Session 4:SQL AGGERGATE Functions:
Aggregate (Sum, Average, Maximum, Minimum, Count), Group By, Having.
Joins:
SQL Cartesian products, SQL Joins (Inner join, Left join, Right join, Full join) Table aliases.
Multi-table joins
Union, Union All, Except, Intersect
Session 5: Built-in Functions:
SQL Numeric Functions (ABS, SIGN, MOD, etc.)
String Functions (Locate, Left, Right, Concat, etc.)
DATE and TIME functions.
Formatting numbers and dates. Converting.
Session 6: SQL Subqueries, Basic Subqueries, Nested Subqueries, CTE Tables.
Session 7:
SQL Views (Create, alter and drop)
Stored Procedures (Create, alter and drop, Input and Output parameters)
Custom Functions (Create, alter and drop)
Session 8: Managing Data:Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints.
Session 10: SQL Indexes.
Session 9:Creating Databases and Tables.
Session 11:Import data into SQL and Export from SQL.
Session 12: Exporting using SQL, Importing using SQL, Exporting from the command line, Importing from the command line.
cash, visa, mc, amex & discover - no checks
TO PICK UP Will Call -- you must present your confirmation number, a picture ID and the credit card used to purchase your tickets. You must wait 48 hours after ordering to pick up your tickets.
For NRG Stadium information 832-667-1400.
Monday-Friday 10am-5pm Saturday 10am-2pm. Hours subject to change.
TREx | The Garden Retail Experience is een uniek tweejaarlijks informatie- en inspiratie-event voor de (inter)nationale tuinretail. Op TREx worden de laatste inzichten en ideeën op het gebied van de verkoop van levend groen, tuin- en decoratie-artikelen gedeeld. Met als doel om samen de consument beter te bedienen en meer verkoop te genereren – vandaag, morgen en in de toekomst.
Ruim 130 toonaangevende leveranciers heten u van harte welkom, delen met u hun retailkennis en tonen hoe hun collecties in de winkel kunnen worden gepresenteerd.
Openingstijden12 februari 2020 | 09.00 - 18.0013 februari 2020 | 09.00 - 17.00
Parkeren en openbaar vervoerParkeren is mogelijk op de eventlocatie, het parkeertarief bedraagt € 10, -. De locatie is ook gemakkelijk bereikbaar met het openbaar vervoer, kijk op www.tr-ex.eu voor meer informatie.
TREx | The Garden Retail Experience is a unique biennially information and inspiration event for the (inter)national garden retail industry. At TREx, the latest insights and ideas for the sale of living green, garden and decorative articles are shared, with the aim of providing improved service to the customer and improving sales – today, tomorrow, and in the future.
Over 130 leading suppliers welcome you, share their retail knowledge and show how their collections can be presented in the shop.
Opening hours12 February 2020 | 09.00 - 18.0013 February 2020 | 09.00 - 17.00
Parking and public transportParking is available at the event location, the parking fee amounts to € 10,- . The location is also easily accessible by public transport, check www.tr-ex.eu for more information.
The Box Office accepts MasterCard, Visa, Discover, American Express, and Cash.
Box Office Phone Number: (313) 471-7929
The Xfinity Box Office at Little Caesars Arena is open Monday thru Friday, from 11:00am to 5:30pm, and also on Event Days from 11:00am until Intermission.
The Addams Family Musical by Andrew Lippa, Marshall Brickman, and Rick Elice Directed by Rebecca Campbell October 9 November 8 Based on the popular family tv show, Addams Family is a kooky, spooky Halloween show perfect for the young and the young at heart. All your favorite characters are here and this time they sing!