Udemy – MS SQL SERVER (T-SQL) Concepts – Raise above beginner level

Udemy – MS SQL SERVER (T-SQL) Concepts – Raise above beginner level
English | Size: 1.23 GB
Category: Tutorial

Join this course and learn the concepts below by building 8 Stored Procedures
UNDERSTAND and APPLY inside Stored Procedures T-SQL concepts like:
XML Parsing
3 Ways of Creating Dynamic Queries
The concept and utility of Cursors
SQL Server Pivot Operator
[Read more…]

PA – Abusing SQL Server Trusts in a Windows Domain

PA – Abusing SQL Server Trusts in a Windows Domain
English | Size: 732.86 MB
Category: CBTs

MS SQL Server is widely used in enterprise networks. Due to its use by third party applications, support for legacy applications and use as a database, SQL Server is a treasure trove for attackers. It gets integrated with in an active directory environment very well, which makes it an attractive target for abuse of features and privileges.
[Read more…]

Lynda – Migrating Access Databases to SQL Server

Lynda – Migrating Access Databases to SQL Server
English | Size: 389.93 MB
Category: CBTs

At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server’s advanced features, and maintain a link to the data in Access.
[Read more…]

Udemy – The Complete SQL Bootcamp (2018)

Udemy – The Complete SQL Bootcamp (2018)
English | Size: 1.61 GB
Category: Tutorial

What Will I Learn?
Use SQL to query a database
Use SQL to perform data analysis
Be comfortable putting SQL and PostgreSQL on their resume

Requirements
No prior technical experience is required! All you need a computer!

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…]

Udemy – Learn Advanced Transact-SQL (T-SQL) Using SQL Server 2017

Udemy – Learn Advanced Transact-SQL (T-SQL) Using SQL Server 2017
English | Size: 264.03 MB
Category: CBTs

Transact-SQL is also popularly refereed to as T-Sequel .This is Microsoft’s own implementation of the international Structural Query Language (SQL).
This course assumes you have some basic knowledge of SQL or T-SQL and will provide you with more advanced knowledge of Transact-SQL (T-SQL). I will be using the latest free version of Microsoft SQL Server 2017 Express edition and a sample adventureworks 2014 database. We will be installing and using SQL Server Management Studio as part of the SQL Server Express edition 2017 [Read more…]

SQL Interview Questions – 156 Quiz Questions & Answers

SQL Interview Questions – 156 Quiz Questions & Answers
English | Size: 341.36 MB
Category: Tutorial

Are you stressed out of losing a big job opportunity? . Or are you afraid of making a bad impression? That’s totally normal before an interview. The best way to overcome interview anxiety is to prepare yourself.

Our SQL Interview Questions course is here to help.

Prepare with 156 popular, real world SQL Interview Questions and walk in confidently knowing exactly what types of questions you will be asked. Impress the interviewer and become the no. 1 candidate on their list.
[Read more…]

Lynda – Oracle Database 12c Advanced SQL


Lynda – Oracle Database 12c Advanced SQL
English | Size: 340.19 MB
Genre: eLearning

[Read more…]

Learn SQL with Microsoft SQL Server

Learn SQL with Microsoft SQL Server
English | Size: 309.08 MB
Category: Tutorial

In this course I’ll teach you Structured Query Language – SQL for short – the fast and easy way.
We’ll download and use the free trial version of Microsoft SQL Server and I’ll teach you exactly how to use it like a pro.
Databases are incredibly important in our modern world, and they remain a mystery to most people. But they’re actually pretty easy to use if you know just a few things.and I’ll teach you those things in this course.
We’ll start out by learning fundamental database concepts, like. what is a database, what is a table, what are rows and columns, and what are data types.
After that I’ll show you how to set up and use Microsoft SQL Server. [Read more…]

Packt SQL Server 2016 Maintenance and Automation

Packt SQL Server 2016 Maintenance and Automation
English | Size: 815.64 MB
Category: Tutorial

Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. [Read more…]

Practical Guide for Oracle SQL, T-SQL and MySQL – Preston Zhang

Practical Guide for Oracle SQL, T-SQL and MySQL – Preston Zhang
English | Size: 16.55 MB
Category: Programming | Storage | others

SQL is a widely used to access most databases, therefore database developers and system administrators should be familiar with it. This hands-on SQL book will help beginner and intermediate users to write queries that apply complex conditions on a table. The book’s unique side by side approach makes it easy for the reader to learn three major query languages in the IT industry. The author has over 20 years of experience in database design. [Read more…]