Articles by "Lynda"

Showing posts with label Lynda. Show all posts




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.

Topics include:

  • Comparing SQL Server editions
  • Installing SQL Server 2014
  • Creating a database
  • Creating tables and relationships between tables
  • Writing SQL statements
  • Creating views
  • Using stored procedures and functions
  • Working with XML
  • Backing up and restoring a SQL Server database
  • Monitoring SQL Server
  • Authenticating users
  • Importing and exporting data
  • Indexing a database

More Info : View

Download : Full Course




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.


Topics include:

  • What is Node.js?
  • Installing Node.js
  • Understanding the global object and global timing
  • Importing the core modules
  • Handling events
  • Creating child processes
  • Reading, writing, and removing files
  • Working with file streams
  • Making http requests
  • Serving files and JSON data
  • Installing npm, the node package manager
  • Working with Express, the web server framework
  • Using WebSockets
  • Testing and debugging Node.js code
  • Working with Grunt and Browserify
  • Automating tasks with npm scripts


More Info : View

Download : Full 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.

Topics include:

  • Working with the Excel interface
  • Entering data
  • Creating formulas and functions
  • Formatting rows, columns, cells, and data
  • Working with alignment and text wrap
  • Adjusting rows and columns
  • Finding and replacing data
  • Printing and sharing worksheets
  • Creating charts and PivotTables
  • Inserting and deleting sheets
  • Using power functions such as IF and VLOOKUP
  • Password-protecting worksheets and workbooks
  • Sorting data
  • Analyzing data with Goal Seek and Solver
  • Creating and running macros

More Info : View

Download : Full Course



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.

Topics include:

  • Reviewing the Inventor workflow and file types
  • Creating a project
  • Sketching and working with origin geometry
  • Creating and modifying sketch geometry
  • Projecting and importing geometry
  • Modeling parts
  • Building parts with placed features
  • Creating feature patterns and sculpted objects
  • Adding parts to an assembly
  • Using constraints to position parts
  • Creating drawing views
  • Adding annotations


More Info : View

Download : Full Course


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


More Info : View

Download : Full Course



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.

Topics include:

  • Naming variables
  • Storing text as strings
  • Doing calculations with PHP
  • Using conditional statements to make decisions
  • Creating custom functions
  • Deciphering error messages
  • Emailing the contents of an online form
  • Dealing with multiple-choice form fields


More Info : View

Download : Full Course

Contact Form

Name

Email *

Message *

A Shubham And Narendra Product. Powered by Blogger.