MOBILE APPLICATION TRAINING INSTITUTE IN PONDICHERRY | SQL TRAINING INSTITUTE IN PONDICHERRY - OCEANACADEMY

SQL

SQL Certification Training | Course | Ocean Academy

Course Description

  • What's the focus of this course?

    In this course, you'll walk through installation steps for XAMPP and creating a MySql Database. We covers the In-depth understanding of SQL queries and its types as well as database design with multiple tables, foreign keys, and the JOIN operation.

     

  • Who should take this course?

Course preview

    • Lesson 1 - Introduction to Basic Database concepts

      • 1. What is database?
      • 2. What is Field?
      • 3. What is Record?
      • 4. Difference between Mysql and SQL
      • 5. Limitations of File Management System.
      • 6. Basic Concepts of Advantages of DBMS.
    • Lesson 2 - Introduction to Sql

    • Lesson 3 - DDL statement

    • Lesson 4 - Working with Constraints

    • Lesson 5 - DML statement

    • Lesson 6 - Working with Queries(DQL)

    • Lesson 7 - Aggregate Functions

    • Lesson 8 - Joins Operations

       Inner join  Left join  Right Join  Full join
    • Lesson 9 - PL/SQL

Success Stories

Name:Janarthanan
Course:Core Java
Company: Sodexis Pvt Ltd
Position: Juniorconsultant

Name:Balaji.G
Course:C,C++,Java
Company:TCS
Position:System Engineer

Name:Keerthika
Course:J2EE
Company:TCS
Position:ASE

Name:Jayavelan
Course:J2EE
Company:TCS
Position:ASE

Name:Sindukavi
Course:Advanced Java
Company:InfoView
Position:S/W Developer

Name:Hemalatha
Course:J2EE
Company:SrikeshInfoTeech
Position:S/W Developer

Name:RenukaDevi
Course:PHP
Company:SSC
Position:Web App Devloper

Name:Sivagokula Thilagar.D
Course:.NET
Company:Tulir Technology
Position:S/W Devloper

Name:Shankar.V
Course:PHP
Company:Blackhole Solutions
Position:Web Devloper

Name:Dhivya.A
Course:.Net
Company:CTS
Position:S/W Programmer

Name:Abirami.P
Course:C,C++
Company:TCS
Position:ASE

Name:Karpagavalli.J
Course:C,C++
Company:TCS
Position:ASE

Name:Subashini.S
Course:C,C++
Company:TCS
Position:ASE

Name:Geetha
Course:J2EE,Angular
Company:Tech Mahindra
Position:Associative SE

Name:Devi.D
Course:Advanced Java
Company:Tech Mahindra
Position:Associative SE

Ocean Academy-IT Academy