T-SQL Archives - Page 3 of 3 - LEARNING FOR LIFE

SAMS T-SQL FUNDAMENTALS LIVELESSONS

23/12/2018 Learning for Life Leave a Comment

SAMS T-SQL FUNDAMENTALS LIVELESSONS
English | Size: 4.78 GB
Category: CBTs

In just six hours, you’ll gain the in-depth practical understanding of T-SQL you need to create superior solutions with SQL Server. Your video instructor, Alison Balter, has spent nearly 25 years building Microsoft database solutions for top organizations she’s the world’s #1 Microsoft database author. Now, Balter guides you step-by-step through every skill you’ll need, from simple SELECT statements to powerful query and view techniques flexible stored procedures, triggers, and UDFs even query analysis and optimization. Whether you’re a DBA, database or web developer, or power user these LiveLessons deliver practical knowledge for writing high-quality T-SQL code fast! [Read more…]

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

21/10/2018 Learning for Life Leave a Comment

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

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

13/03/2018 Learning for Life Leave a Comment

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