Learn everything you need to know to start building databases with SQL Server. Martin Guidry reviews the major features of SQL Server 2014 and shows developers how to architect efficient, high-performance solutions for organizations of any scale. Watch and learn how to install and configure SQL Server, create databases and tables, automate common tasks like backups, and use the SQL query language to retrieve and manipulate data.
Node.js is a powerful tool for controlling servers, building web applications, and creating event-driven programs. And it takes JavaScript—a language familiar to all web developers—out of the browser. With Node.js, you can build applications that run on your laptop or even the cloud. Learn the essentials of Node.js and start creating your own JavaScript applications in this introductory training course.
Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.
Get an in-depth look at Autodesk Inventor 2016. In this course, author John Helfen takes you through the interface and key processes of this parametric design system, including sketching, drawing, modeling parts, and building assemblies. With Inventor and these tutorials, you can create parts and assemblies and document them for manufacturing. Throughout the course, John touches on more complex topics such as sweeps and lofts, T-splines, and assembly visualization techniques that will take your documentation to the next level.
Single-page applications are fluid, responsive, and beautiful. They look and perform great—like native mobile apps—without constant calls to the server. With WordPress and a client-side framework like AngularJS, you can create a simple single-page app quickly.
Topics include:
Setting up WordPress
Creating the AngularJS components, including the controller and route
Connecting WordPress and AngularJS
Connecting views
Adding and displaying custom data
Using a plugin to show advanced custom field (ACF) data on the template
PHP is the most popular server-side language used to build dynamic websites, and though it is not especially difficult to use, nonprogrammers often find it intimidating. This introductory workshop from David Powers is designed to change that by teaching you PHP through a series of clear, focused, easy-to-follow lessons. After briefly explaining what PHP is and how it integrates with HTML, David introduces the features of the language. He covers variables, conditional statements, calculations, loops, and functions, as well as server-side includes and error handing, in a series of hands-on exercises. He then moves to a larger project that involves building a script to validate and email user input from an online form. By following along, you'll come to understand the value of creating reusable code, the importance of PHP security, and how to deal with multiple-choice form fields.