Vi ste ovdje
Overview/Description
Microsoft SQL Server 2012 Transact-SQL offers advanced query techniques, such as built-in aggregate, analytic, scalar, and ranking functions, as well as common table expressions, or CTEs and derived tables to manipulate the result set for a query. To manipulate the result sets and generate summarization information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. The UNION, INTERSECT, and EXCEPT operators can be used to combined the result set of multiple queries. SQL Server 2012 also offers the use of CTEs and...
Overview/Description
SQL Server 2012 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio tool. Using Transact-SQL you can select data from a databaseâs tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic Transact-SQL statements that can be used to...
Overview/Description
Microsoft SQL Server 2012 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2012 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then mapping the logins to the databases within the instance. Administrators also have the ability to encrypt a SQL Server instance using transparent data encryption (TDE) and to encrypt the data within a database using encryption certificates...
Overview/Description
This course covers concepts in JavaScript object-oriented programming and HTML5 form creation and validation. Instruction is provided for implementing JavaScript objects and methods, as well as for creating HTML5 forms and validating them using both JavaScript and new HTML5 form attributes.
Target Audience
Students with at least five months of experience programming in an OOP language, preferably JavaScript, and must also have previous experience creating and validating HTML forms.
Prerequisites
None
Expected Duration (hours)
1.5
Lesson ObjectivesMicrosoft Visual Studio...
Overview/Description
Working with Web applications often requires the accessing, transmission and security of data. From server to client and back again, secure data transfer is one of the many powerful features of the Web. When programming data transfers, application developers need to understand the several technologies, particularly JavaScript Object Notation (JSON), AJAX (Asynchronous JavaScript and XML), and related technologies. This course introduces learners to the consumption of data using JSON, and XML, AJAX, and retrieving data with XMLHTTPRequest. It also considers the...
Overview/Description
JavaScript is a powerful client-side programming language that can be used to implement interactivity, graphics and animation, and other useful features that make the modern Web application function in much the same way as desktop applications. This course introduces the learner to JavaScript, providing a brief history of the language and how it differs from other object-oriented programming (OOP) languages like Java. The course considers how JavaScript can be used with HTML5, the importance of browser compatibility, and how different browsers handle JavaScript. The...
Overview/Description
One of the many powerful features of HTML5 is the inclusion of native APIs â application programmer interfaces â which simplify the development process, eliminate the need for third-party plugins, and provide a common set of methods that programmers can use to develop feature-rich, standalone web applications. This course introduces learners to some of the notable APIs, including the Selectors API, the Drag and Drop API, the Geolocation API. It also discusses working with HTML5's Audio and Video APIs, the File and Storage APIs, and creating offline applications using...
Overview/Description
This course covers concepts in using the HTML5 Canvas and implementing SVG to create and/or modify graphics for an HTML5 application, in addition to concepts in applying CSS transitions and 2-D or 3-D transformations.
Target Audience
Individuals with the desire to use new HTML5 elements and features to render and modify on-screen graphics within a browser; individuals preparing for the Exam 70-480: Programming in HTML5 with JavaScript and CSS3.
Prerequisites
None
Expected Duration (hours)
2.0
Lesson ObjectivesMicrosoft Visual Studio 2012: HTML5 Graphics and Animation...
Overview/Description
This course covers advanced techniques in styling HTML5 text and block properties, using CSS3 selectors with jQuery, using custom fonts and flexible grid layouts, and implementing adaptive user interfaces.
Target Audience
Individuals with the desire to use new HTML5 elements and features to render custom fonts, flexible grid layouts, and adaptive user interfaces in addition to working with color gradients and CSS3 selectors using jQuery; individuals preparing for the Exam 70-480: Programming in HTML5 with JavaScript and CSS3.
Prerequisites
None
Expected Duration (hours)
2...
Overview/Description
This course introduces the key new features of HTML5 and CSS3, and how to apply these features to create a simple HTML5 web application styled with CSS3. This course is one of a series in the SkillSoft learning path that covers the objectives for the Exam 70-480: Programming in HTML5 with JavaScript and CSS3. Passing this exam will earn the learner the Programming in HTML5 with JavaScript and CSS3 Specialist certification.
Target Audience
Individuals who wish to use HTML5 with JavaScript and CSS3 to develop web-based client applications; individuals preparing for the...