SQL Advanced

SQL Advanced
English | Size: 1.05 GB
Category: Tutorial

Senior SQL Developers are in high demand and demand 100k+ salary in the IT industry.
If we have to advance in our career and earn a good salary, we need these Advanced SQL skills. So let’s take the next step of learning these advanced concepts of Oracle SQL.
Learning these advanced SQL concepts would position you better in your working environment.
What will we learn? [Read more…]

SQL on Hadoop – Analyzing Big Data with Hive

SQL on Hadoop – Analyzing Big Data with Hive
English | Size: 406.67 MB
Category: Tutorial

This course will teach you the Hive query language and how to apply it to solve common Big Data problems. This includes an introduction to distributed computing, Hadoop, and MapReduce fundamentals and the latest features released with Hive 0.11
[Read more…]

Pluralsight – SQL Server Indexing for Performance

Pluralsight – SQL Server: Indexing for Performance
English | Size: 1.35 GB
Category: Tutorial

The most important feature in SQL Server when it comes to getting the required workload performance is probably indexing. But the indexing possibilities you have can be bewildering, and it’s easy to make the wrong choice, leading to wasted resources and maybe even worse performance! In this course, SQL Server: Indexing for Performance, you’ll learn how to correctly choose indexes for your environment. First, you’ll discover how clustered and nonclustered indexes work and how they are used by SQL Server, both of which are crucial when choosing the correct indexes to create. Next you’ll explore the tipping point – when an index can be used or not, the benefits of covering queries, and how to use the INCLUDE option to more effectively cover queries. Finally, you’ll learn how to use filtered indexes and get an introduction to index consolidation for effective server tuning. When you’ve finished this course, you’ll have the skills and knowledge to start adding and changing indexes in your environment for better performance! [Read more…]

LiveLesson MCSA SQL Server 70-761 Querying Data with Transact SQL Tutorial OXBRiDG

LiveLesson: MCSA SQL Server 70-761 Querying Data with Transact SQL Tutorial OXBRiDG
English | Size: 21.07 GB
Category: Tutorial

Training material for the MCSA 70-761 exam. [Read more…]

O’Reilly – Create an Azure SQL Data Warehouse in Minutes

O’Reilly – Create an Azure SQL Data Warehouse in Minutes
English | Size: 3.72 GB
Category: Tutorial

Microsoft’s Azure SQL Data Warehouse is a massively parallel processing (MPP) distributed database system that integrates across the Cortana Intelligence Suite platform. In this video, you’ll learn about MPP, how to create a data warehouse instance in minutes, and how to establish supporting databases and tables. You’ll explore Azure SQL data warehouse’s underlying architecture and learn how to adapt your data warehouse designs and loading strategies to take advantage of the scale that is available. The video includes a working case study that demonstrates the creation and loading of a data warehouse from start to finish. You’ll also learn how to utilize key features of Azure SQL DW and discover how to load, import, and export data using various methods.
[Read more…]

Lynda – Learning SQL Programming

Lynda – Learning SQL Programming
English | Size: 183.82 MB
Category: CBTs

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.
[Read more…]

Lynda – Advanced SQL for Data Scientists

Lynda – Advanced SQL for Data Scientists
English | Size: 171.34 MB
Category: CBTs

There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common data science tasks, including finding, exploration, and extraction within relational databases.
[Read more…]

Learning Path SQL for Business Users

Learning Path SQL for Business Users
English | Size: 7.38 GB
Category: CBTs

If you’re looking for “just enough” SQL knowledge to wrangle data and do sophisticated analysis, this Learning Path is for you. You’ll get a solid understanding of basic database design principles and normalization. You’ll learn how to pipeline data to other analysis tools (R, Python, even Excel). You’ll be able to prototype a database that suits your business needs, and form accurate queries and database updates in several SQL environments-all without getting bogged down in the deeply technical aspects of SQL that you will never use. [Read more…]

Pluralsight – SQL Server Understanding and Using Azure SQL Database

Pluralsight – SQL Server Understanding and Using Azure SQL Database
English | Size: 314.03 MB
Category: Tutorial

Azure SQL Database is finally on a par with on-premises SQL Server! This course describes and demonstrates using Azure SQL Database and its features as well as migration strategies for migrating existing SQL Server databases to Azure SQL Database.
Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this course, SQL Server: Understanding and Using Azure SQL Database, you’ll learn the fundamentals of Azure SQL Database from a DBA perspective. [Read more…]

Pluralsight – Getting Productive with SQL Developer

Pluralsight – Getting Productive with SQL Developer
English | Size: 685.48 MB
Category: CBTs

Oracle SQL Developer is a very popular free Graphical user interface. This course will teach you about this tool and see how it makes database development and management a breeze, for database developers, DBAs, and analysts.
This IDE is packed with tons of cool features to significantly boost productivity and making executing the day to day tasks for both the database developers and DBAs a breeze. This tool allows you to write complex queries, explore the database and provides a complete development platform for Oracle PL/SQL applications.
[Read more…]