Learn SQL +Security(pen) testing from Scratch
Step by step Tutorial to learn SQL and Web Security testing with real time examples
Lo que serás capaz de hacer
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 .A nd 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 examples And 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 approach Course 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 application This 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 topics Security 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
- You will gain the ability to design any complex SQL to query a database- (SQL)
- Indepth understanding of GROUP BY,Subqueries,aggregate functions, SQL Server functions,HAVING clauses -(SQL)
- Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN- (SQL)
- You will understand the Importance of Session Hijacking Mechanisim and their confidential data use -(Security Testing)
- You can investigate application behavior with Parameter Tampering and Brute force attacks-(Security Testing)
- You will get the knowledge of all basics with Http that might cause attacking malicious inputs-(Security Testing)
Temario
UNIDAD 1 - Course FAQ's · 2 leccionesUNIDAD 1 - Course FAQ's
UNIDAD 1 - Course FAQ's
- Why to learn SQL and Security Testing? and how this course is designed
- Please Note
UNIDAD 2 - Introduction to SQL · 5 leccionesUNIDAD 2 - Introduction to SQL
UNIDAD 2 - Introduction to SQL
- Introduction to DataBase
- Introduction to SQL and MySQL
- Downloading MySQL server with workbench
- Overview of SQL Editor with basic features
- SQL basic Material for reference
UNIDAD 3 - CRUD operations on Database with Practical examples · 5 leccionesUNIDAD 3 - CRUD operations on Database with Practical examples
UNIDAD 3 - CRUD operations on Database with Practical examples
- creating Database and pointing to it
- Creating Tables in database
- Inserting records into Table
- Retrieving records from the Table
- SQL commands glossary on discussed Topics
UNIDAD 4 - Altering Table Schema operations · 5 leccionesUNIDAD 4 - Altering Table Schema operations
UNIDAD 4 - Altering Table Schema operations
- Adding and modifying records in a table
- Deleting records and droping database
- Updating rows in a table
- Modifying operations example
- SQL Glossary on discussed topics
UNIDAD 5 - SQL Logical operators to retrieve Data · 4 leccionesUNIDAD 5 - SQL Logical operators to retrieve Data
UNIDAD 5 - SQL Logical operators to retrieve Data
- Select Distinct keyword in queris
- SQL WHERE command usage
- Logical operators on Queries AND OR - 1
- Logical operators 'In' 'Between'- 2
UNIDAD 6 - Regular expressions in writing Smart SQL Queries · 4 leccionesUNIDAD 6 - Regular expressions in writing Smart SQL Queries
UNIDAD 6 - Regular expressions in writing Smart SQL Queries
- Regular expressions Introduction
- Wild cards usage in Qeuries -1
- SORT by usage in Queries
- SQL glossary on discussed topics
UNIDAD 7 - Deeper Understanding on GroupBy, Aggregate functions with practical examples · 7 leccionesUNIDAD 7 - Deeper Understanding on GroupBy, Aggregate functions with practical examples
UNIDAD 7 - Deeper Understanding on GroupBy, Aggregate functions with practical examples
- Importance of Group By in SQL
- Combination of GroupBy and SQL functions(Min,Max,Avg)
- Usage of Having keyword with GroupBy and Aggregate functions
- Difference between Having and Where keyword and when to use them
- Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword -1
- Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword- 2
- SQL glossary on discussed topics
UNIDAD 8 - Building SQL Sub queries with examples · 2 leccionesUNIDAD 8 - Building SQL Sub queries with examples
UNIDAD 8 - Building SQL Sub queries with examples
- SubQueries syntax and usage
- SubQueries Example
UNIDAD 9 - SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions · 6 leccionesUNIDAD 9 - SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions
UNIDAD 9 - SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions
- SQL Joins usage and its advantages
- SQL Joins Example
- Relation on subqueries and Joins
- Practical examples on Joins and subqueries
- Left and Right joins importance in SQL
- Practical example on Inner joins, Left join, Right Join
UNIDAD 10 - Understand SQL String functions and Views with examples · 6 leccionesUNIDAD 10 - Understand SQL String functions and Views with examples
UNIDAD 10 - Understand SQL String functions and Views with examples
- Importance of views in Database
- views example on Database
- String functions - 1
- String functions - 2
- String functions -3
- SQL glossary on discussed topics
UNIDAD 11 - Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage · 5 leccionesUNIDAD 11 - Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage
UNIDAD 11 - Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage
- Importance of Union and Union All SQL Keyword
- Query to intersect records from two tables
- Exists keyword usage in SQL
- CASE Statement in SQL with example
- SQL GLossary
UNIDAD 12 - Importance of Data constraints for Database Validations · 6 leccionesUNIDAD 12 - Importance of Data constraints for Database Validations
UNIDAD 12 - Importance of Data constraints for Database Validations
- NOT NUll constraint -1
- Not Null Constraint Validations and Testing - 2
- Default Constraint Validations and Testing - 3
- Unique Constraint Validations and Testing - 4
- Primary Key Constraint validaton and Testing -5
- SQL glossary on discussed topics
UNIDAD 13 - Importance of Foreign Key and Primary key with real time examples · 4 leccionesUNIDAD 13 - Importance of Foreign Key and Primary key with real time examples
UNIDAD 13 - Importance of Foreign Key and Primary key with real time examples
- Importance of Foreign Key constraint in SQL
- Understand Foreign key rules and constraints with examples
- On DELETE CASCADE Keyword to force rules on Foreign key deletion
- SQL Glossary
UNIDAD 14 - Practise Exercises for Interviews with Solutions · 5 leccionesUNIDAD 14 - Practise Exercises for Interviews with Solutions
UNIDAD 14 - Practise Exercises for Interviews with Solutions
- Practise Practise Practise !!!
- Practise Exercise/Interview Questions- 1
- Practise Exercise/Interview Questions- 2
- Solutions for Exercise - 1
- Solutions for Exercise -2
UNIDAD 15 - JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req · 4 leccionesUNIDAD 15 - JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req
UNIDAD 15 - JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req
- Jdbc odbc programming-Creating Project
- Creating Database Tables and connecting to Jdbc java code
- Retrieving data from Database with Java code
- jdbc code download
UNIDAD 16 - SQL Injection · 5 leccionesUNIDAD 16 - SQL Injection
UNIDAD 16 - SQL Injection
- What is SQL Injecting
- How to identify SQL loop holes in web application
- Exposing Security loop holes with malcious SQL syntax
- List of urls Pattern which can cause attack with SQL
- Material for reference
UNIDAD 17 - Complete Unix Material · 1 leccionesUNIDAD 17 - Complete Unix Material
UNIDAD 17 - Complete Unix Material
- Unix for Beginners- 2
UNIDAD 18 - Important Note · 1 leccionesUNIDAD 18 - Important Note
UNIDAD 18 - Important Note
- Important Note
UNIDAD 19 - Introduction to Security Testing - Phase 2 · 1 leccionesUNIDAD 19 - Introduction to Security Testing - Phase 2
UNIDAD 19 - Introduction to Security Testing - Phase 2
- Why security Testing gaining Importance day by day!
UNIDAD 20 - Security Testing Basic Terminologies · 6 leccionesUNIDAD 20 - Security Testing Basic Terminologies
UNIDAD 20 - Security Testing Basic Terminologies
- What is Http and Https?
- How can we avoid Man in middle attacks?
- Http Methods overview in talking to servers
- Fiddler Demo- Monitoring Network traffic
- Understanding Fiddler to intercept requests
- Material for Reference
UNIDAD 21 - XSS - Cross Site Scripting Vulnerability Testing · 9 leccionesUNIDAD 21 - XSS - Cross Site Scripting Vulnerability Testing
UNIDAD 21 - XSS - Cross Site Scripting Vulnerability Testing
- What is XSS? How it can damage Web sites
- Detecting XSS Vulnerability for Websites - 1
- Detecting XSS Vulnerability for Websites - 2
- ByPassing Client Validation to perform XSS
- Encoding all the inputs to avoid Attacks
- Types of Attack - Reflected XSS
- Types of Attack - Persisistence XSS
- How to handle cross site scripting in IE browser
- Material for Reference
UNIDAD 22 - Importance of Cookies and their role in Security · 8 leccionesUNIDAD 22 - Importance of Cookies and their role in Security
UNIDAD 22 - Importance of Cookies and their role in Security
- What are cookies and where are they stored
- Session cookie sensitive data Threats
- How can we stop Cookies hijacking
- Methods to Prevent cookie steal -Secure Attribute
- Preventing cookies steal -Http Attribute flag
- Domain and path attribute to restrict cookies
- Setting Timeperiod for Sessions- Security Safety Tip
- Material for Reference
UNIDAD 23 - Session Hijacking and Cross Site Forgery Attacks · 5 leccionesUNIDAD 23 - Session Hijacking and Cross Site Forgery Attacks
UNIDAD 23 - Session Hijacking and Cross Site Forgery Attacks
- What is CSRF? How can it cause threat
- Session Hijacking with illegal requests
- Avoid Cross SIte forgeries with Token Mechanisim
- Checklist for Pen Testers to check CSRF Attacks
- Material for Reference
UNIDAD 24 - Parameter Tampering to steal sensitive data · 4 leccionesUNIDAD 24 - Parameter Tampering to steal sensitive data
UNIDAD 24 - Parameter Tampering to steal sensitive data
- Different sources to intercept requests
- Importance of having Server side Validations
- Intercepting requests with fiddler tool
- Material for Reference
UNIDAD 25 - Account Security · 7 leccionesUNIDAD 25 - Account Security
UNIDAD 25 - Account Security
- Steps to be taken for Password setting
- List of Hacking Passwords and Precautions which need to be taken
- Sources of Attacking Passwords
- Best Practices to be followed in securing Account
- Bruteforce attack handler Mechanism
- Material for Reference
- BONUS LECTURE
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
25 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
Cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Rahul Shetty Academy - 1.3 Million Learners.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 25 unidades · 117 lecciones · 60 h
- 12 meses de acceso
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Rahul Shetty Academy - 1.3 Million Learners; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
