The Introduction to SQL training course is ideal for data analysts, data engineers, database administrators, and SQL developers.
The Introduction to SQL training program can also be taken by professionals at various levels in the organization.

What to Know Before Learning SQL
If you are interested in studying SQL, you may start by working with the following programs or skill-sets to help with your learning process:
Knowledge of Databases
In addition to basic computer skills, a critical prerequisite to working with SQL is a knowledge of databases. A database is a collection of structured data or information, commonly stored in a computer system. Database management systems generally control databases, and the data stored in a database is usually modeled in columns and rows in tables so it is easy to access, organize, and manage.

Database and SQL

Duration: 30 days

                                                                                  Session: 1 hr

Syllabus

• Introduction
• E-R Diagram
• What is RDBMS
• What is SQL
• Query for data retrieval
• RETRIEVE SPECIFIC DATA (uses of WHERE)
• AND, OR, NOT operators
• BETWEEN Operator
• In & Not In operators
• Like operators
• Order By (arrange data ascending or descending)
• Limit Query
• Function in MySQL
• Aggregate Functions
  • Count
  • Avg
  • Max
  • Min
  • Sum
• Text Function
• Date functions
• Numeric Functions
• is Null or is not Null
• Group by clause
• Having Clause (difference between Where and Having)
• Joins
  • Cross
  • Inner
  • Left
  • Right
  • Full
• Subquery
• Views