Apple Pay, Visa, AMX, MC, and Discover. We do not accept cash or checks.
WILL CALL LOCATION: SW Corner of Climate Pledge Arena on 1st & Thomas. WILL CALL OPENS: 2 hours prior to event time. DOORS OPEN: 1 hour prior to event time (Varies by Event).
The Box Office is open 3 hours prior to the start of an event, located at the southwest corner of the Climate Pledge Arena Grounds at 1st & Thomas. It is open 2 hours prior to an event on Day Of Show for will call and sales for that day's performance only. We are a paperless venue and tickets will be sent via text.
Parking - The 1st Ave N Garage is located 1 block south of Climate Pledge Arena. It is fully accessible with easy access to Climate Pledge Arena. Street parking & pay lots are also available but not as conveniently located. Drop Off - All Main Entrance doors to Climate Pledge Arena are accessible. The West entrance is the most convenient for drop off. 1st Ave N directly runs in front of the facility. Drop off location for the East entry is about 1/2 block away from Climate Pledge Arena at 2nd and Thomas. Entry - For most events, the West, South and East doors are open for entry.
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.
This two-day course prepares current Scrum Masters for their leadership role in facilitating Agile team, program, and enterprise success in a Scaled Agile Framework (SAFe®) implementation. The course covers facilitation of cross-team interactions in support of program execution and relentless improvement. It enhances the Scrum paradigm with an introduction to scalable engineering and DevOps practices; the application of Kanban to facilitate the flow of value; and supporting interactions with architects, product management, and other critical stakeholders in the larger program and enterprise contexts.
The course offers actionable tools for building high-performing teams and explores practical ways of addressing Agile and Scrum anti-patterns in the enterprise.
Learning Goals
To perform the role of a SAFe® Advanced Scrum Master attendees should be able to:
Apply SAFe principles to facilitation, enablement, and coaching in a multi-team environment
Build a high-performing team and foster relentless improvement at scale
Address Agile and Scrum anti-patterns
Support the adoption of engineering practices, DevOps, and Agile architecture
Learn to apply Kanban eXtreme Programming (XP) frameworks to optimize flow and improve the team’s work
Facilitate program planning, execution, and delivery of end-to-end systems value
Support learning through participation in Communities of Practice and innovation cycles
Topics Covered
Exploring the Scrum Master role in the SAFe enterprise
Applying SAFe Principles: A Scrum Master’s perspective
Exploring Agile and Scrum anti-patterns
Facilitating program execution
Improving flow with Kanban and XP
Building high-performing teams
Improving program performance with Inspect and Adapt
What Attendees Get
The class registration includes:
Attendee workbook
Preparation and eligibility to take the SAFe® 4 Advanced Scrum Master (SASM) exam
One-year membership to the SAFe Community Platform
Course certificate of completion
Attendees must attend both days of the course in order to qualify for the exam.
This one day or two day workshop will guide you to getting fantastic images of Venice Carnival and the city itself. Starting at 8am to catch the early morning light and before the crowds build we will start with going through settings and equipment together with ideas for composition of images. We will then head in to St Marks Square and the lagoon front area for a session shooting the many carnival characters- some free time will also be given.
We then will proceed from St Marks Square to the Rialto area where we will have time for lunch (not included) and a debrief on the morning's activities. With it's bustling market and of course the fantastic Grand Canal and Rialto bridge this area is a vibrant and interesting location and again full instruction will be given on making the most of the opportunity.
We then head in to lesser known and quieter areas of Venice where we will look for some atmospheric images of the wonderful architecture and expect to meet up with more carnival characters in a more relaxed locations before heading back towards the St Marks's square area in time to capture the later afternoon and early evening light as it glances across the fantastic architecture and carnival characters. The workshop will conclude at around 6pm when you can then capture Venice in the evening, at night or do whatever you wish. Following the course, you will receive a full set of notes, hints and tips together with a link to view the images taken by the tutor, plus you can submit your images (up to 10) for a critique by the tutor withing 14 days.
If you have booked the two day workshop this covers the same format as this course on the first day but then moves on to capture more of Venice and the beatiful islands of Murano, Burano and Torcello on the second day. again concluding back in St Mark's square around 6pm.