Duration: 19:01 min

Summary: In this video, we will continue our discussion of tabstrip be exploring the other properties and functions we have available. First, we will create the unordered list to represent the actual tabs, but we will not create the divs for the contents. Those divs will be created using the dataSource property. The content will be retrieved from HTML files using the contentUrl property. We will also append a tab dynamically using the append function. Since the text will not be encoded, we will add some HTML to spice the text up a bit. In addition to other set up properties, we will also look at the animation option and see how to animation the open and close functionalities.

One more discussion of the tabstrip will take us into the contentUrls property. Here, we will not add the divs either, but we will provide an array of contents (array of html files) that will correspond to the tabs provided in the unordered list. We will also keep the animation options, and handle the contentLoad event. We will log some formatted content as this event is triggered.

Duration: 19:55 min

Summary: In this video, we will discuss the tabstrip widget. As we always do, we start by setting up the HTML. In this case, the HTML is made up of unordered list (with list items) and a list of divs. Each div will represent the tab content and the list items will be text on the tab. By initializing a kendoTabStrip we will end up with as many tabs as we have list items. Then we will hook up the select and activate events and log the text to the console. Then we will see how to dynalically add tabs using the insertBefore and insertAfter functions. There are two cases to select/activate a tab: (1) by using the k-state-active class, and (2) by calling the select function. We will explore those as well.

Duration: 19:36 min

Summary: In this video, we will continue our discussion on catalog views. As we quick recap: we know that there are many ways of getting information about the database (the list of tables, views, functions, stored procedures, columns…). In our case within T-SQL, we are looking at three source of information: (1) Catalog views. We will continue this discussion today to learn more ways of getting database metadata. (2) Information schema: this information schema is more ANSI compliant. So we can see that being standard across other database venders (like Oracle). Today, we will also see how to use this schema to get database information. (3) System stored procedures. Those procedures will give us tons of information about the database objects. For example, we will see how to use sp_help to get lots of details about specific tables.

Duration: 17:30 min

Summary: In this video, we will start our discussion with iif and coalesce. Iif is a shortcut for the if statement. It returns one of two values depending on whether the Boolean expression evaluates to true or false. Coalesce takes a list of parameters, and returns that first one that is not null. This is very powerful because the list of parameters is not limited. After we are done with iif and coalesce, we move to an important concept of catalog views. It is very important to know information about the objects that exist within the database. Objects could be tables, views, stored procedures, functions…. In some situations we need to know the schema name, the table name, it the views that exist within the database. We will see how we can retrieve that information using catalog views. This discussion will continue in the next video.

Duration: 16:39 min

Summary: In this video, we will discuss the use of the ‘case statement’. The case statement is very powerful because it lets you make decisions as you are building your statement. It has a wide use within T-SQL. In our case, we will use the case statement to decide on what grade to assign and print out on the screen. Then, when we are retrieving data from the Product table, we are selecting a category base on the product line. We will also decide on a price range depending on a list price. All this case be done using the case statement while building the select statement.

Duration: 16:35 min

Summary: In this video, we will discuss the use of the ‘if statement’. SQL supports the use of the ‘if statement’ like other programming languages do. We start with an expression that needs to be evaluated. If that expression evaluates to true, the statements in the begin/end block after the’ if’ are executed. Otherwise, the statements in the begin/end block after the else are executed. Notice that we are using the ‘print’ statements to write text. I use that often while testing some SQL code and printing content out. After the ‘if statement’, we will talk about using ‘null’. We know that some data is not available. It is not 0 or empty string. It is simply not provided. SQL treats that as ‘null’. It is important that your account for null values while writing your SQL code. We will see how to use ‘IsNull’ to test for null values.

Duration: 17:58 min

Summary: In this video, we will wrap up our data type discussion. Working with characters is very important to us. So, we need to make sure we are able to declare variables with character data types. We have two options: (1) Fixed-length string data, and (2) variable-length string data. In the case of fixed-length, as the name implies, we are declaring using the same length consistently. For example, we know that the state abbreviation is 2. So we can declare a variable of type char(2). But in most cases, we know that we do not have control over the length of the data. For that we use ‘varchar’. If we do not specify the length (as in ‘declare x as char), the default is 1 character. In our discussion, we will talk about the difference between char/varchar and nchar/nvarchar. Finally, we will see how to declare variables of type ‘uniqueidentifier’, and how sql server supports the xml data type.

Duration: 20:13 min

Summary: In this video, we will discuss the splitter. With the splitter, we will get a dynamic layout where we can add panes that can be collapsed and resized. Although in this example, we will create 2 panes, we can make that more complex by creating nested layouts. We have control over the orientation by setting it to vertical or horizontal. As you will see, the panes array will give us a lot of flexibility in setting properties such as the content URL, size, and whether the pane is collapsible or not. We will get the content of the panes from another HTML file. We will also handle some of the events like expand, collapse, contentLoad, and resize.

Duration: 17:32 min

Summary: In this lesson, we will discuss the range slider. This is similar to the slider that we have recently discussed. However, and as the name implies, the range slider has a range of values to work with. You can specify the min and max values, the orientation (vertical or horizontal), as well as the small and large steps. But you can also specify the selectionStart and selectionEnd. Besides the properties, there are events that we can handle. For example, we will handle the change and slide events. We will also log the values to the console. But since the range is by default separated with a comma (example [5,10]), we will replace the comma with a '-' as in [5-10].

Technologies and Resources: Kendo UI, kendoSlider, kendoRangeSlider, smallStep, largeStep, tickPlacement, selectionStart, selectionEnd

Duration: 17:44 min

Summary: In this case, we will discuss the slider. The slider provides the ability to select a value, but the range is controlled by the developer, which makes validating input unnecessary. You can specify the min and max values, the orientation (vertical or horizontal), as well as the small and large steps, in addition to other interesting properties. Besides the properties, there are events that we can handle. For example, we will handle the change and slide events. We will also log the values to the console.

Technologies and Resources: Kendo UI, kendoSlider, smallStep, largeStep.

Duration: 20:25 min

Summary: In this lesson, we will continue our discussion of the PanelBar by tapping into more detailed features. We will see how to interact with the panel dynamically. We will experiment with the append() function. This function is very powerful and flexible. We will also try to insert before and after elements as well as removing elements from the panel based on an id. Then, we will see how to use the contentUrls option to specify some html files that will serve as the content for the PanelBar.

Technologies and Resources: Kendo UI, kendoPanelBar, expandMode, kendoConsole, insertBefore, insertAfter, contentUrls.

Duration: 17:45 min

Summary: In this lesson, we will learn how to work with PanelBar. A PanelBar is like an Accordion in jQuery UI, but in this case you have more flexibility with the properties and events. For example, the option expandMode can be 'single' and 'multiple' so you can expand more than one panel at a time. We will start with setting up the HTML using unordered lists. Then, we will use the initialization list to set up the expand mode and the animation. We will trigger the animation for collapse and expand. We will also tap into the following events: select, expand, collapse, activate. We will log these events as the user is testing the PanelBar.

Technologies and Resources: Kendo UI, kendoPanelBar, expandMode, kendoConsole.

Duration: 18:01 min

Summary: In this lesson, we will discover the numeric textbox. As a developer, one of the most important items on your list is data validation. The numeric textbox will be great help because it provides a min and a max that you specify so the user can select valid input. We will experiment with this widget today. We will create two numeric textboxes: one that we will initialize as usual (in the initialization list), and another that will have some of the values specified in the input element. After we experiment with the properties, we will create a reference to the first input box and call some of the available methods/functions. We will also bind to two events and log them to see the difference between “spin” and “change”.

Technologies and Resources: Kendo UI, Notepad++, kendoMenu, closeOnClick, kendoConsole, imageUrl, upArrowText, downArrowText, kendoConsole.

Duration: 16:34 min

Summary: In this video, we will continue our data type discussion. Of course there are more data types that we can use than we already listed. These data types will allow us to work with decimal values and date and times. It is important to understand the scale and precision of decimal data types to make sure we are declaring the variable correctly. In some cases, when the data precision is not critical, we can declare variables of type ‘real’ and ‘float’. Today, we will also discuss the different ways we can declare variables when it comes to date and time. Finally, we will see an example of how we can convert from one type to another using ‘cast’.

Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012.

Duration: 16:36 min

Summary:In this video, we will discuss data types. Data types are very important when it comes to creating tables and working with variables. As you are designing a database and creating the tables, one of the important decisions you need to make is: what data types you need to use for specific columns? Would an ‘int’ be the correct choice? Or since the table will contain a small number of records, a ‘tinyint’ will be enough?

You might be thinking that since memory is available, it does not really matter. I would select the largest data type available and get it over with. But, as you will see later, this might have an impact on the database index and might affect performance.

Today, we will start discussing these data types. We will talk about: bigint, int, smallint, tinyint, and bit. But before, we start the discussion, we will look at some existing tables and see where the data types fit. Finally, we will see how to declare variables using the ‘declare’ keyword.

Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012.

Duration: 28:54 min

Summary: In this video, we will talk about paging. If you have done any work with web page technologies, you would know that paging is an important concept. Say you have a grid that displays 500 records. You can load a specific number of records first (say 25) and then the other records will be loaded on demand as the user is moving from one page of 25 items to the next. SQL Server 2012 helps in this regard. This feature has been added to fetch a specific number of records. Then move to the next set as the user demands it. We will see the new syntax to do that.

Then we will discuss the "real" order the select statement is being interpreted and the importance of this order on how some items will / will not work in the where clause.

Finally, we will discuss how to use "in" in a where clause.

Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012, Database, Schema.

Duration: 20:22 min

Summary: In this lesson, we will wrap up the menu discussion. We will use the same menu we created in the previous video, but we will add more properties and events. First, we will talk about the animation effects and duration. We will also explore the idea of a menu direction (top, bottom, left, right). We will also see that we can combine these options for menus and submenus. These options come handy when we are displaying a menu on the edge of a browser and we need more control over the direction. Second, we will discuss the events that are available. We will trigger the open, close, and select. The associated information is logged to the console. Finally, we will add a menu dynamically after the last menu item. This new menu will have submenus with images.

Technologies and Resources: Kendo UI, Notepad++, kendoMenu, closeOnClick, kendoConsole, imageUrl, element.

Duration: 16:54 min

Summary: In this lesson, we will learn about the menu. You know that you can create a menu with sub-menus. And every sub-menu can have a menu of its own. With this type of hierarchy, we can use the unordered list in HTML. This is helpful because in a list item I can create another unordered list, and I can keep going deeper and deeper to create more complex menus. This is what we will do here. We will start with an unordered list and create all the items that we need. We will have a “File” and “Edit” menu items with the corresponding items below them. After we finish creating the list, we will instantiate a new kendoMenu object. That will transform the list into a menu. Then, we will add some more properties to modify the animation and allow the menu to open when the user clicks (instead of the default hovering behavior). Finally, we will experiment with the orientation behavior to see how to display the menu vertically and horizontally.

Technologies and Resources: Kendo UI, Notepad++, kendoMenu, openOnClick, animation, hoverDelay.

Duration: 19:16 min

Summary: In this lesson, we will learn about the editor widget. This is a powerful control because it allows the user to type text and format it the way the user needs. This is a text area with a powerful set of tools. You can select the kind of tools you need to show. You can even customize your own tools. In our case, we will start with the default editor, and then add a list of available tools. Then we will customize the editor with some properties and hook it to some events. We will also add some buttons to interact with the editor control. As always, we will use the log functionality to track what events have been triggered and even how many.

Technologies and Resources: Kendo UI, Notepad++, kendoEditor, insertHtml, kendoConsole.

Duration: 20:26 min

Summary: In this video, we will continue the select statement discussion. When we left of in the previous video, we were talking about the ‘top’ statement. We saw how we can retrieve the top ‘x’ rows from a table. Today, we will add to that by discussing the use of the ‘percent’ keyword. That will help us determine which ‘%’ of the table to return (i.e. 2%, 5%...). After that, we will talk about the use of ‘with ties’ when using ‘top’ and what effect it will have on the result. We will also discuss the use of comments (single line and multi-line comments). SQL Server has easy buttons to comment/uncomment code. Finally, we will build a statement that contains most of the clauses: we will see how to select from a table using where clause, aggregate functions (Sum), group by clause, order by clause, and the having clause.

Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012, Database, Schema.