SQL

PluralSight – Managing SQL Server Database Maintenance

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.

ZDResearch Advanced SQL Injection

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.

Linkedin Learning – SQL Data Reporting and Analysis-XQZT

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.