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 - 08064444451 for directly attending Interview Drive

Course Details

SQL

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.


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 Testing Campus which certifies that you completed a particular course. This certificate is issued to all the learners participating in this course.

Do you provide job assistance?

Testing Campus 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 Testing Campus online job portal. You will get job assistance till you get placed.

Have to clear doubts?

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

What are the payment options?

You can pay by credit card, debit card, net banking or even deposit cheque

Who are our instructors?

All our instructors have 12 to 15 years of experience in relevant domain and have experience training thousands of students every year

Do we get practise test facility?

yes, we will give you access to our LMS(Learning Management System) through which you can take hundreds of practise test.

From where to access study material?

You can access study material in LMS(Learning Management System)

From where to access study material?

You can access study material in LMS(Learning Management System)

What about course completion certificate?

Once the project work is completed you will get course completion certificate

BATCH SCHEDULES

Click here for batch schedules

Contact us for any other queries
08064444451

GIVE US ENQUIRY

Contact Us

Back to Top
WISH TO HIRE OUR
TRAINED STUDENTS ?

Quick Register Now