|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-testing-tutorial/
课程评论：没有评论
课程名称：从零开始学习SQL与安全（渗透）测试 课程概述： SQL和安全测试是每位软件工程师无论在项目中担任什么角色都必须具备的额外技能。本课程通过教授这两个主题，填补了技能空缺，同时为您的职业生涯增添竞争优势。这些技能在每次软件工程师面试中都是常见的考察内容。本课程特别适合初学者，提供了有趣的教学方式，避免了枯燥的幻灯片和定义。我将在每节课中实时编写SQL查询，并用实例讲解所需的每一个主题，以帮助学员掌握SQL。此外，本教程将为您提供调查和修补Web应用程序中的安全漏洞所需的知识与技能，采用强大的渗透测试方法。 课程内容包括： **MySQL部分：** - SQL入门 - MySQL概述 - 数据库和表的启动命令 - 数据库测试以验证模式 - 更改表模式的操作 - 数据检索查询和逻辑操作符 - 查询中的通配符使用 - SQL函数与实时场景 - SQL中的分组的重要性 - 高级SQL概念 - 子查询的语法和用法 - SQL连接的使用及其优点 - 数据库视图的重要性 - SQL字符串函数 - 从数据库测试的角度看数据约束 - 面试练习及解决方案 - 讨论主题的SQL术语表 **安全测试部分：** - 安全测试基础术语 - 安全领域相关的核心OWASP原则 - 跨站脚本（XSS）示例 - Cookies的重要性及其被盗的危险 - 会话劫持与跨站请求伪造攻击 - 参数篡改方法 - 请求拦截技术 - 账户管理 - 密码安全指南 - 暴力破解机制 - 客户端验证的重要性 该课程结构清晰，注重概念的根本解释，帮助学习者达到能够编写任意SQL查询和检测任何类型安全漏洞的水平。
SQL and Security Testing are Additional skills which every software Engineer need to have irrespective of their role in Project. And this course fulfills the gap by teaching both these topics and also gives you an edge compared to other Engineers at your work.And of course these are one of the common skills which are tested in every Software Engineer Interview.What make this course special for beginners?"No more Boring slides or Definitions. I will write every SQL query before you in lecture and teach every topic needed to master in SQL with Practical examplesAnd also This Tutorial will give all the weapons you needed to investigate and unlock the Security Holes in the Web application with powerful Penetration testing approachCourse lectures are conceptually driven with root level explanations and bring you to the level where you can write any kind of SQL query and detect any kind of security bugs in the applicationThis course covers:MYSQL:Introduction to SQL - MySQLOverview - Start up commands to Setup Database andTables - Database testing to validate Schema - Altering Table Schema operations - Queries to retrieve Data Logical operators on Queries - Wild cards usage in Queries - SQL Functions with real time scenarios - Importance of Group By in SQL - Advanced SQL Concepts - SubQueries syntax and usage - SQL Joins usage and its advantages - Importance of views in Database - SQL String functions - Dataconstraints with DataBase Testing perspective - Practise Exercises for Interviews with Solutions - SQL glossary on discussed topicsSecurity Testing:Course Contents: Basics of Security Testing Terminologies involved in Security Domain Top OWASP principles Cross site Scrpiting Xss examples Cookies Importance Danger with stealing of cookies Session Hijacking Cross site forgery Attacks Parameter Tampering Methods to Intercept requests Account Management Password security guidelines Brute force mechanism Importance of Client side validations
