Learn SQL and Database Testing from Scratch+ Unix material

Every IT Job needs SQL Knowledge, and this course fullfills that requirement by teaching everthing from scratch
4.5 (147 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,520 students enrolled Bestselling in SQL
$19
$65
71% off
Take This Course
  • Lectures 64
  • Length 6.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course Description

You are about to Master in SQL QUERIES AND DATABASE TESTING

"No more Boring slides or Definitions. Understand how things work Practically with real time scenarios"

********************************************************************************************************* .Get Access to Top class 60 + Lectures on SQL + Database Testing + Material + Interview Questions + Resume Preparation + Life Time Instructor Support *********************************************************************************************************

On course completion You will be Mastered in SQL Language with DataBase Testing and can implement Successfully it in your work place or will surely land on High Paying Job

This course covers :

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

What are the requirements?

  • ******You need NOT have any proir SQL knowledge to start this course*********
  • Though these are online Lectures.You will have Life Time instructor support.You can contact me any time for your Queries,Will respond back with in 12 hours
  • All Installation setup including Database basics is taken care as part of course
  • Theoretical Material,Code dump and Interview Guide are available for download

What am I going to get from this course?

  • You will be able to create Databases and modify them
  • You will get proficient knowledge on writing SQL Queries
  • You can validate and test Database Schema
  • Indepth understanding of advanced SQL concepts to test Database
  • JDBC ODBC Java programming knowledge to handle database
  • You can Clear any Interview on SQL with the Interview questions covered

What is the target audience?

  • Any IT professional no matter in what field they are into
  • QA Testers who want to enhance their skill on Data base Testing
  • Freshers/Graduates who want to learn computer science foundations

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to SQL and DataBase Testing
Course FAQ's (Must watch)
Preview
10:12
Introduction to DataBase
Preview
09:55
Introduction to SQL and MySQL
Preview
06:27
Downloading MySQL server with workbench
Preview
07:29
Overview of SQL Editor with basic features
Preview
05:26
SQL basic Material for reference
Preview
Article
Section 2: Getting Started with Queries to retrieve Data
creating Database and pointing to it
Preview
04:47
Creating Tables in database
Preview
08:01
Inserting records into Table
Preview
07:55
Retrieving records from the Table
06:22
SQL commands glossary on discussed Topics
Preview
Article
Section 3: Altering Table Schema operations
Adding and modifying records in a table
06:57
Deleting records and droping database
04:48
Updating rows in a table
07:32
Modifying operations example
05:55
SQL Glossary on discussed topics
Preview
Article
Section 4: Getting Started with Queries to retrieve Data
Select Distinct keyword in queris
06:50
SQL WHERE command usage
09:27
Logical operators on Queries AND OR - 1
07:07
Logical operators 'In' 'Between'- 2
08:37
Regular expressions Introduction
07:18
Wild cards usage in Qeuries -1
08:04
SQL glossary on discussed topics
Preview
Article
Section 5: Advanced SQL Concepts - 1
SORT by usage in Queries
05:23
SQL Functions Introduction with real time scenarios
08:53
SQL Functions Part - 2
06:58
Importance of Group By in SQL
08:50
Combination of GroupBy and SQL functions
06:26
Practical Examples on Group By
04:51
SQL glossary on discussed topics
Preview
Article
Section 6: Advanced SQL Concepts -2
SubQueries syntax and usage
Preview
08:08
SubQueries Example
06:07
SQL Joins usage and its advantages
05:46
SQL Joins Example
07:30
Relation on subqueries and Joins
09:34
Practical examples on Joins and subqueries
10:25
Importance of views in Database
07:55
views example on Database
07:18
String functions - 1
09:23
String functions - 2
03:43
String functions -3
06:11
SQL glossary on discussed topics
Preview
Article
Section 7: Dataconstraints with DataBase Testing perspective
NOT NUll constraint -1
06:12
Not Null Constraint Validations and Testing - 2
08:10
Default Constraint Validations and Testing - 3
06:28
Unique Constraint Validations and Testing - 4
05:43
Primary Key Constraint validaton and Testing -5
09:45
SQL glossary on discussed topics
Article
Section 8: Practise Exercises for Interviews with Solutions
Practise Practise Practise !!!
04:54
Practise Exercise/Interview Questions- 1
Article
Practise Exercise/Interview Questions- 2
Article
Solutions for Exercise - 1
Article
Solutions for Exercise -2
Article
Section 9: JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req
Jdbc odbc programming-Creating Project
07:03
Creating Database Tables and connecting to Jdbc java code
16:48
Retrieving data from Database with Java code
07:39
jdbc code download
Article
Section 10: SQL Injection - Database Security Testing
What is SQL Injecting
07:32
How to identify SQL loop holes in web application
13:19
Exposing Security loop holes with malcious SQL syntax
09:20
List of urls Pattern which can cause attack with SQL
07:34
Material for reference
Article
Section 11: Complete Unix Material
Unix for Beginners- 1
Article
Unix for Beginners- 2
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Rahul Shetty, The "Testing school" to boost your career

Nothing is Impossible . It all depends on how you are Trained on it!

Teaching is our Passion. And its our Profession. The only Business We know is Spreading the Knowledge

So Our Testing school is here at Udemy to share all our 10 Years IT Experience Knowledge to QA Colleagues and Students

As an Director , Coming to my Teaching Profile I  have had Trained over 21000+ students in the below Technologies

**********************************************************************************************************

Selenium -Web Automation in Java and Python Soap UI - Webservices/ REST API Testing Appium - Mobile Automation in Android and IOS Jmeter - Performance Testing Software Testing Process Security Testing Automation Framework Building

********************************************************************************************************* Worked with various CMM level orgranizations. Managed in setting up of QA Process for the projects

Ready to start learning?
Take This Course