LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

PluralSight – Managing SQL Server Database Maintenance

Leave a Comment

PluralSight – Managing Sql Server Database Maintenance-JGTiSO
English | Size: 218.39 MB
Category: CBTs


Database backups, index maintenance, and integrity checks are crucial tasks in any SQL Server environment. This course covers what database maintenance is, why it is necessary, why you should plan it, and how you can optimize it. [Read more…]

ZDResearch Advanced SQL Injection

Leave a Comment

ZDResearch Advanced SQL Injection
English | Size: 291.01 MB
Category: Programming | E-learning


Advanced SQL Injection is the first module in our larger course Advanced Web Hacking. In this course, which includes more than 15 lectures with assignments, labs and a a final exam, you will learn everything about SQL Injection, from bypassing firewalls to extracting data through errors.
[Read more…]

Packt – Date and Time Fundamentals in NET and SQL Server

Leave a Comment

Packt – Date and Time Fundamentals in NET and SQL Server-XQZT
English | Size: 2.23 GB
Category: Tutorial


This course will help you build a solid foundation in working with dates and times in software development.

Almost all software works with dates and times in one form or another. However, dates and times give rise to many pitfalls even in very simple scenarios. We all know that security and logging are regular aspects of almost any program. Most developers have no idea how many bugs are concealed behind dates and times; they lie dormant in programs and can suddenly blow up your production code, causing very unfortunate repercussions. That’s why working with dates and times is a fully fledged and very important aspect of software development. [Read more…]

Linkedin Learning – SQL Data Reporting and Analysis-XQZT

Leave a Comment

Linkedin Learning – SQL Data Reporting and Analysis-XQZT
English | Size: 415.97 MB
Category: Tutorial


Do you rely on IT to get the data you need? Are you often stuck waiting in line for data, and wish you could just retrieve it yourself? In this course, learn 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, grouping it, and relabeling it to get just the report you want. Join Emma Saunders as she shows how to write simple SQL queries for data reporting and analysis. Learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Discover how to perform more complex queries, such as joining data together from different database tables. Last but not least, she introduces views, procedures, functions, and variables. [Read more…]

Technics Publications – NoSQL Data Modeling

Leave a Comment

Technics Publications – NoSQL Data Modeling-ZH
English | Size: 260.24 MB
Category: Tutorial


Recorded live at Data Modeling Zone!
Follow along with MongoDB expert Austin Zellner and become competent in NoSQL data modeling in this sixth topic in the NoSQL Complete course. Know the difference between referencing data and embedding data. When in doubt, embed your data. Learn how to combine data and state in the same collection. Learn about modern use case patterns including microservices. Know how to model multi-document ACID transactions. Learn about master files and working files in MongoDB. [Read more…]

Technics Publications – NoSQL Query Languages

Leave a Comment

Technics Publications – NoSQL Query Languages-ZH
English | Size: 189.98 MB
Category: Tutorial


Recorded live at Data Modeling Zone!
Follow along with MongoDB expert Austin Zellner and be able to explain at a high level the different ways to query the various NoSQL databases in this third topic in the NoSQL Complete course. See how data is retrieved from Document, Tabular, Graph, Key-Value, GeoSpatial, and Text databases. Learn about querying data with MongoDB MQL and all about Compass and the aggregation pipeline. Explore how various types of indexes help with queries, including compound indexes, single field indexes, multi-key indexes, and unique indexes. [Read more…]

Addison-Wesley Professional Getting Started with MongoDB and NoSQL

Leave a Comment

Addison-Wesley Professional Getting Started with MongoDB and NoSQL-ZH
English | Size: 4.71 GB
Category: Tutorial


Description:
4+ Hours of Video Instruction Overview The need for unstructured data management has grown beyond what many have expected with overwhelming amounts of data being generated from social media, cell phones, voice and video data, cars, smart technology, and IoT. How can we store this data and allow
ourselves to build applications not strictly tied to a structure defined by columns in a table? You can do so with unstructured databases such as MongoDB! MongoDB is the premier database in the NoSQL landscape, and this course provides the fundamental concepts and tools needed to make use of dynamic database systems. If you have SQL experience and want to expand to NoSQL databases, or if you’re fairly new to databases but you want to understand what all the hype around MongoDB is about, this course is your ticket! [Read more…]