O’Reilly – Learning Path SQL Commands, Joins, and Views

O’Reilly – Learning Path SQL Commands, Joins, and Views
English | Size: 329.88 MB
Category: Tutorial

If you need to understand how to query relational databases, this Learning Path will get you up and running quickly. Commands, joins, and views are the most fundamental elements of SQL (Structured Query Language) and with them you can make powerful insights into your data. In the just an hour and a half, you will learn how to use SQL to manage data that is held in relational databases. This Learning Path is designed for beginners who have no previous experience with SQL of any kind. Working files are included, allowing you to follow along with the instructor. [Read more…]

O’Reilly – Oracle SQL and JSON

O’Reilly – Oracle SQL and JSON
English | Size: 765.14 MB
Category: Tutorial

Introduced as part of Oracle 12, Oracle JSON SQL makes it possible to convert the JSON data world of keys and values into the relational data world of columns and rows. At its core, this course teaches you how to use Oracle JSON SQL.

You’ll learn the key JSON SQL functions that tell you: If the JSON data is valid, if a particular element and/or value exists in the JSON data, how to extract a specific scalar value from JSON data, and how to translate JSON keys and values into relational rows and columns. But this is more than a how-to-use JSON SQL course, it’s a refresher course for those who need a solid understanding of the distinctions between the relational data world and the JSON data world, and how SQL can act as a bridge between the two.
[Read more…]

Lynda – Designing Database Solutions for SQL Server 2016

Lynda – Designing Database Solutions for SQL Server 2016
English | Size: 383.89 MB
Category: Tutorial

When you’re working with a team to design a SQL Server 2016 database solution for your organization, there are certain advanced concepts you need to know. In this course, Adam Wilbert introduces you to some of the concepts you’ll need to design elegant database solutions that set up your team for success. He covers how to prepare the server for efficient usage, use backup strategies to minimize the impact of a failure, and follow security concepts to ensure users are granted the appropriate permissions for their roles. Plus, Adam covers some of the optimization strategies you can implement in SQL Server to help the system run smoothly in the future. [Read more…]

O’Reilly – Querying Data with Transact-SQL – Exam 70-761 Certification Training

O’Reilly – Querying Data with Transact-SQL – Exam 70-761 Certification Training
English | Size: 1.53 GB
Category: Tutorial

Microsoft’s SQL Server database platform is dominant in the enterprise database marketplace, making those with MS SQL Server skills highly sought after in any job market. Possessing a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Database Development certificate tells employers worldwide that you have these skills. Earning the certificate requires you to pass two exams: The MS 70-761 and the MS 70-762. This course prepares you to pass MS 70-761. MS 70-761 is all about Transact-SQL, the programming language central to working with MS SQL Server.
[Read more…]

The-Complete-SQL-Bootcamp

The-Complete-SQL-Bootcamp
English | Size: 1.09 GB
Category: Tutorial

Learn how to use SQL quickly and effectively with this course! You’ll learn how to read and write complex queries to a database using one of the most in demand skills – PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.
[Read more…]

Pluralsight – SQL Server Reporting Services Playbook

Pluralsight – SQL Server Reporting Services Playbook
English | Size: 487.88 MB
Category: Tutorial

Looking to generate and share reports with your organization? In this course you’ll get up and running with SQL Server Reporting Services quickly, or just refresh yourself on specific techniques when creating reports.
SQL Server Reporting Services is a fantastic tool for generating and sharing reports across your organization. This course, SQL Server Reporting Services Playbook, is designed for two types of people. The first is the busy IT Pro, who needs to come up to speed quickly with SSRS. [Read more…]

Pluralsight – SQL Server Introduction to Query Store

Pluralsight – SQL Server Introduction to Query Store
English | Size:644.29 MB
Category: Tutorial

One of the most highly anticipated new features in SQL Server 2016 is Query Store. It’s been referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and run-time statistics.
The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. This is the first time Microsoft has provided the ability to natively capture baseline data within SQL Server.
[Read more…]

ITPro TV – Azure SQL

ITPro TV – Azure SQL
English | Size: 6 GB
Category: Video Training


This show explores the foundational concepts and workings of Azure SQL. We start by defining why you might decide to implement a hosted database in Azure SQL vs an on-premise solution; detailing some of the benefits of moving to Azure SQL. We then describe some of the more advanced benefits of using Azure SQL like using Resource Groups, Geo-Restore, Point-In-Time Restore, and Self-Service Restore. Finally they take a look at the performance tiers as well as Database Throughput Units or DTUs. [Read more…]

InfiniteSkills – SQL – Beyond The Basics Training Video

InfiniteSkills - SQL - Beyond The Basics Training Video

Title: InfiniteSkills – SQL – Beyond The Basics Training Video
Video Format: MP4
File Size: 688 MB
[Read more…]

InfiniteSkills – Oracle Database 12c Certified Professional – SQL Foundations

InfiniteSkills - Oracle Database 12c Certified Professional - SQL Foundations

Title: InfiniteSkills – Oracle Database 12c Certified Professional – SQL Foundations
Video Format: MP4
File Size: 639 MB
[Read more…]