Software Testing Course in bangalore|Testing Campus infotech
  • Courses

Quick Enquiry

  Latest Updates
Happy Alert! Now take testing campus classes in 125+ cities of India and 25 countries abroad. Placements going on with our major clients coming week...Call - 08026781955 for directly attending Interview Drive

SQL

Software testing has very high job demand across the globe.The worldwide software testing outsourcing market has grown to $30 Billion in 2010 and is expected to be $50 Billion in 2020 according to NASSCOM report. In simple words software development is incomplete without quality check and software testing helps to deliver quality software so that the risk can be minimised.

BATCH SCHEDULES

Contact us for any other queries
08064444451


Enroll Now

Standard Query Language (SQL) is at the heart of all relational databases, including IBM's DB2, Oracle, Microsoft's SQL Server, and open source database MySQL. SQL perennially tops the Computer Weekly/SSL Survey of Appointments Data and Trends as the IT skill most sought-after by employers.

Course Objective -

This course will provide strong foundation for developing complex SQL queries. We will cover hundreds of examples to make sure that the candidate is well equipped will all that knowledge required to interact with database more effectively.

SQL

  1. Downloading MySQL
  2. Installing MySQL
  3. Connecting from Command prompt to MySQL
    • Creating databases
    • Create Tables
    • Executing various SQL queries on
  4. Insert
  5. Update
  6. Delete
  7. Select
  8. Drop
  9. Distinct etc.
  10. Why SQL is called as structured query language
  11. Built-in functions in SQL
  12. Length
  13. Trim
  14. Rtrim
  15. Ltrim
  16. Count
  17. Max
  18. Min
  19. Avg
  20. Sum
  21. Lcase
  22. Ucase
  23. Now
    • Using limit keyword in MySQL
    • Sorting of Data
    • Using % and _ in queries
    • Data types
    • Constraints
    • Difference between DBMS and RDBMS
    • Joins
    • Sub queries
    • Normalisation
    • Interview questions

A course completion certificate is issued by Pankaj Sir's Academy which certifies that you completed a particular course. This certificate is issued to all the learners participating in this course.

Pankaj Sir's Academy is biggest online training solution provider and is tied up with 400 IT companies. After completion of course you will get access to our in-house job portal through which you can starting applying for jobs all over india. Every day hundreds students appear for placements through Pankaj Sir's Academy online job portal. You will get job assistance till you get placed.
In case of any doubts you can reach of subject matter experts(Technical Trainers) 24X7. You can also opt for one to one doubt clearing session with out subject matter expert
You can pay by credit card, debit card, net banking or even deposit cheque
All our instructors have 12 to 15 years of experience in relevant domain and have experience training thousands of students every year
yes, we will give you access to our LMS(Learning Management System) through which you can take hundreds of practise test.
You can access study material in LMS(Learning Management System)
You can access study material in LMS(Learning Management System)
Once the project work is completed you will get course completion certificate