SQL

Linkedin Learning – SQL Non-Programmers-QUiD

Linkedin Learning – SQL Non-Programmers-QUiD
English | Size: 265.00 MB
Category: Tutorial


Do you want to learn about SQL but aren t sure where to start? In this beginner-level course, instructor Julianne Thouin covers basic concepts of relational database design and explains how to write simple SELECT statements using joins and proper filtering Julianne explains what SQL Server is and what it is used for. Next, she shows how tables in a relational database relate to one another through surrogate, primary, and foreign keys. Julianne teaches you how to tackle the most basic query possible. She explains how AND and OR logic applies to filtering queries on more than one data point, then discusses INNER joins and OUTER joins. Julianne covers how to use subqueries for filtering your results. She walks you through some commonly used examples of built-in functions. In conclusion, Julianne shows you how aggregate functions work using the GROUP BY and HAVING clauses

Linkedin Learning – SQL Analysis for Data Developers

Linkedin Learning – SQL Analysis for Data Developers-QUASAR
English | Size: 190.73 MB
Category: Tutorial


If you re looking to get Structured Query Language into your application development, but your story is more prequel than SQL, you need to build a solid foundational knowledge of SQL analysis. In this course, instructor Nikiya Simpson starts with a quick review of SQL basics, then focuses on fundamental SQL queries used in beginning data analysis. Nikiya explains the importance of asking the right questions of your data, as well as how those questions translate into SQL. She also shows how these concepts can be used to derive quick insights from your data to help drive effective decision-making. Nikiya finishes the course by demonstrating how to incorporate queries into tools like Microsoft Power BI to help bring your data to life

Duckademy – Mastering SQL injection

Duckademy – Mastering SQL injection
English | Size: 2.65 GB
Category: Tutorial


Though SQL injection is not a new hacking technique, it still remains an alarming threat to a great proportion of web applications, so every good ethical hackers should know it in depth.