Wise Owl courses

..."Column by example" transform If time Advanced charts Combination charts Regression and trendlines Picture charts Sparklines If time Scenarios Creating... Learn about: Advanced Lookup Functions, Lookup functions, Text Functions...

...Using HAVING to filter results Views The view designer Limitations of the designer Scripting views If time Subqueries The concept of a subquery Using... Learn about: Simple Queries, Using SQL Server, More exotic joins...

...Testing conditions IF / ELSE statement Using CASE where possible Looping Syntax of WHILE Breaking out of a loop Error-handling Using TRY / CATCH System... Learn about: Parameters and return variables, Stored procedures, Deleting using SQL...

...Visual Studio Creating a project Creating a data source Data Source Views Keys and relationships Exploring data Named queries Named calculations Dimensions... Learn about: Hierarchies and Relationships, Data Source Views, Parent-child Hierarchies...

...to ArcGIS Calculated columns Adding columns IF and SWITCH The RELATED function Calendars Creating calendars Using multiple calendars Working days Publishing... Learn about: Formatting visualisations, Data sources, Action buttons...

...with blanks Basic measures Creating measures Understanding filter context Using a measures table AggregateX functions The CALCULATE function Filter context... Learn about: Understanding EARLIER, Calendars and dates, The CALCULATE function...

...3-tier applications Creating a data layer Methods to change data Using data classes User controls Creating and referencing Exposing methods/properties...

...Triggers and animations Property triggers Event triggers Storyboards and animations... Learn about: Data sources...

...You can create ASP.NET websites using either webforms (for which we run separate 3-day courses in either VB or C#) or MVC (standing for Model View Controller...