What is LinkedIn Learning?
LinkedIn Learning, an upgraded platform of Lynda.com, features thousands of video tutorials and training resources about business, technology, and creative skills.
Rutgers provides free access to LinkedIn Learning for active faculty, staff, and students. LinkedIn Learning offers industry-leading content and courses taught by expert instructors in leadership, project management, graphic design, photography, software development, and more. Courses range from beginner to advanced and can be taken to obtain a professional certificate or learn more about a personal hobby.
Courses and playlists about the most popular SC&I Domains applications have been curated for rutgers-sci.domains users and can be found below.
Master SQL for Data Science
Complete the Master SQL for Data Science Learning Path to earn a LinkedIn Learning Badge by mastering the skills needed for data science project specialists and develop a solid foundation of knowledge for working with SQL engineers.
SQL Essential Training (2018)
Learning SQL Programming
SQL: Data Reporting and Analysis (2016)
Advanced NoSQL for Data Science
SQL Tips, Tricks, & Techniques
NoSQL for SQL Professionals
Presto Essentials: Data Science
SQL Essential Training (2018)
Whatever database application you create—whether it’s for bookkeeping, sales, inventory, or even the lowly to-do list—it’s all about the data. Completely updated for 2018, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple and complete database application using SQL.
Learning SQL Programming
SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. Instructor Scott Simpson also shows how to perform simple math operations and transform data into different formats.
SQL: Data Reporting and Analysis (2016)
Do you rely on IT to get you the data you need? Do you wish you could retrieve it yourself? SQL for Data Reporting and Analysis teaches you how to get the data you want by writing a bit of SQL code. You won’t just be able to pull data out of the database; you’ll be able to manipulate it: merging it, multiplying it, grouping it, and relabeling it to get just the report you want.
Join Emma Saunders as she shows you how to design and write simple SQL queries for data reporting and analysis. Review the different types of SQL, and then learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Learn a bit about data types and database design. Discover how to perform more complex queries, such as joining data together from different database tables. Last but not least, Emma shows how to save your queries as views, so you can run them again and again.
Advanced NoSQL for Data Science
Many organizations are turning to NoSQL databases to store large volumes of complex data, sparking an increased need for data scientists and analysts to understand non-relational data stores. If you’re a data scientist or business analyst who needs to work with NoSQL, then this course is for you. Learn about the differences between relational and NoSQL databases, review types of NoSQL databases, and see how to perform common data science tasks, including data preparation, exploration, and building and applying models.
The course begins with an introduction to NoSQL, and then delves into the specifics of document, wide-column, and graph databases. Learn key details for performing data preparation, exploration, and extraction for each type of NoSQL database. Review case studies that show how to use various NoSQL databases with popular data science tools, including the document database MongoDB, the wide-column database Cassandra, and the graph database Neo4j.
SQL Tips, Tricks, & Techniques
Get Ben Sullins’s 12 must-have SQL techniques for data science pros—engineers, DevOps, data miners, programmers, and other systems specialists. Ben’s tips focus on practical applications of SQL queries for data analysis. Learn how to retrieve data, join tables, calculate rolling averages and rankings, work with dates and times, use window functions, aggregate and filter data, and much more. Each tip is short, relevant, and up to date with current industry best practices—making this the perfect course for busy analysts who normally struggle to find time to build their skills.
NoSQL for SQL Professionals
NoSQL databases can store non-relational data on a super large scale, and can solve problems regular databases can’t handle: indexing the entire Internet, predicting subscriber behavior, or targeting ads on a platform as large as Facebook. But with over 150 NoSQL database types, it can be hard for a SQL professional to know where to start. In this course, Lynn Langit breaks these types down into five main categories and shows how to get your own NoSQL database up and running with easy-to-configure cloud solutions. You’ll learn how to add and query data and also examine case studies where NoSQL was used to solve real-world data storage management issues. The final chapter contains tips just for startup businesses that are considering their first NoSQL solution.
Presto Essentials: Data Science
Netflix and Airbnb both use Presto—an open-source SQL query engine developed by Facebook—for their ever-expanding big data querying needs. In this course, learn how to harness the power of your big data system using the Presto platform, which breaks the false dilemma of having to choose between an expensive commercial solution that offers fast analytics, and a slow, ostensibly free solution that requires excessive hardware.
Data science expert Ben Sullins helps you get up to speed with Presto, and leverage it to accomplish a wide-range of data science and analytics tasks. He uses different interfaces with Presto—such as R and Tableau—and digs into the expressive SQL language that Presto offers for your analysis. At the end of this course, you’ll know the key concepts of Presto and how to use them to take full advantage of your modern big data system.
WordPress playlist
WordPress powers millions of blogs and websites. Available in 180 languages, WordPress can be hosted on any server, accessed in any browser, and built into almost anything you imagine: blog, portfolio, website, or online store. Learn how to create your own with this curated list of WordPress tutorials.
WordPress, WordPress.org, and WordPress.com: What is the difference?
What is WordPress?
WordPress 5 Essential Training
WordPress: Workflows
WordPress Themes: Twenty Seventeen
WordPress: Backing Up Your Site
WordPress 5: Site Administration
WordPress:Ask the Instructor
WordPress, WordPress.org, and WordPress.com: What is the difference?
Learn the difference between WordPress, WordPress.org, and WordPress.com and how to differentiate between the three terms.
What is WordPress?
What is WordPress? The term is often ubiquitous with blogging but in reality it is so much more. This video will give you a basic synopsis of how WordPress can be used for building a variety of websites. If you are looking for the difference between WordPress, WordPress.org and WordPress.com see the embedded video above.
WordPress 5 Essential Training
WordPress powers millions of blogs and websites. Available in 180 languages, WordPress can be hosted on any server, accessed in any browser, and built into almost anything you imagine: blog, portfolio, website, or online store. Learn how to create your own web experiences with this powerful and open-source publishing platform. Instructor Morten Rand-Hendriksen helps you get the most out of WordPress and create feature-rich blogs and websites. Morten explains how to create and publish posts and pages; create and edit blocks; and define reusable content blocks to take full advantage of the new block editor codenamed “Gutenberg.”
Note: This course covers WordPress 5. The training will be updated as WordPress evolves.
WordPress: Workflows
If your WordPress workflow is streamlined from the start, development is simpler, more organized, and more efficient—all the way through to publication. In this course, lynda.com staff author Morten Rand Hendriksen covers three common WordPress workflows. First he’ll tackle building a simple WordPress site: from host setup to basic content management. Then he shows how to take that basic workflow a step further by customizing a theme. Last, Morten covers the professional tools and techniques you need to use when you’re developing sites for clients, including setting up a staging environment and version control.
WordPress Themes: Twenty Seventeen
Twenty Seventeen is the default WordPress theme released in December 2016. It’s a blog-centric theme with a heavy focus on the front page, mobile first design, and accessibility. Join Morten Rand-Hendriksen as he introduces the out-of-the-box features and some hidden options that will help you get the most from the theme. Learn how to install Twenty Seventeen and give a fresh look to your blog or website today.
WordPress: Backing Up Your Site
Backups are critical to getting a WordPress site running again when it’s broken or, even worse, hacked. In this course, Morten Rand-Hendriksen covers four different methods for backing up and restoring your WordPress site: manual backups, host-managed backups, third-party plugins, and migration plugins. Morten explores the benefits and drawbacks of each approach, details how they work, and shows how to use each option to restore your site to a stable state. Devote some time to learning how to start backing up your WordPress data now, and save hours of frantic scrambling later.
WordPress 5: Site Administration
WordPress is an easy way to get a website up and running, but sometimes you want to take a WordPress site further. This course shows how to administer a self-hosted WordPress site. Learn how to work with the settings, including important privacy settings, and configure your site’s style, menus, widgets, and theme with the Customizer. Find out how to extend WordPress with plugins, add and manage users, and manage comments and spam. Instructor Morten Rand-Hendriksen also provides tips for keeping your WordPress site secure and up to date—and troubleshoot it when something goes wrong.
WordPress:Ask the Instructor
Got WordPress questions? Here are some answers. In this short course, instructor Morten-Rand Hendriksen answers several frequently asked questions about WordPress. Get practical insights on WordPress security and plugins, advice on choosing a WordPress host, and more.