SQL , MYSQL, Training

SQL , MYSQL, Training

SQL training gurgaon

MySQL/SQL skills are a must for any database developer today Furthermore, because of the standard nature of the SQL language syntax, one can use these skills even for working with a MS SQL Server database as well.

SQL DBAs are primarily responsible for the setup, management and optimization of SQL /MySQL servers in corporate structures. They provide assistance to teams that consist of MySQL programmers and users. The certification was previously called SCMDBA, i.e. Sun Certified MySQL Database Administrator. Students need to clear Part 1 and Part 2 exams in order to obtain this credential.

The several course objectives include:
  • Understanding SQL Architecture
  • Installing and upgrading SQL
  • Using INFORMATION_SCHEMA database for accessing metadata
  • Performing start and end operations of SQL
  • Evaluating character sets and data types for performance-related concerns
  • Understanding the effective way of SQL installation
  • Using triggers for management tasks
  • Understanding views
  • Performing backup and recovery activities
  • Understanding data locking concepts in SQL
  • Describing tuning techniques related to introductory performance

Database is collection of large information or records to manage online by computer software program. With helps of database software like My Sql, Oracle, Sql etc, we can easily manage customer information and other important data. Database management systems (DBMSs) are specially designed software applications that interact with the user, other applications, and the database itself to capture and analyze data. MySQL is open source Relational Database Management System (RDMS) and ships with no GUI tool to administer MY Sql databases or managed data contented within the database.

Course Duration

  • 2 Months
  • Class Duration : 2 Hrs

Course Details

Sql Server / PL SQL

Session 1
  • Step1-About management studio
  • Step2-Creating tables
  • Altering tables
    Adding new columns
    Altering existing columns
    Data type Decrease/Increase
  • Step3-Insert data into tables
  • Simple insert
    Columns by insert
    Bulk insert
    Insert using union
  • Step4-Identity and its properties .
  • Step1-Inserting data from existing tables to newly created table
  • Step2-inserting data from one table to other table (both should be existing)
  • Step3-Creating new tables from existing table
  • With data
    Without data
  • Step4-Creating relationships
  • Step5-creating constraints
  • Step6-Learn foreign key value errors
  • Step7-On cascade delete
  • Step8-Drop
  • Truncate
  • Step1-Joins
    Inner join
    Outer join
    Cross join
    Self join
  • Step2-Sql syntax
  • Step3-Sub Queries(inline views)
  • Step4-Correlated sub queries
  • Step5-Views
  • Step6-Difference between views & inline views
  • Step7-Group by
    Order by
  • Step1-Procedures
    -In parameters
    -Out parameters
  • Step2-Functions
    -Predefine functions
    -Built in functions
    -Table functions
    -Scalar functions
  • Step3-CTE
  • Session-5
  • Step1-While loop
  • Step2-If conditions
  • Step3-Using all those prepare procedures
  • Step4-String Manipulations
  • Step5-Dynamic SQL
  • Step1-Triggers
    -DML Triggers
    -DDL Triggers
  • Step2-Cursors
  • Step3-Temp tables
  • Step4-Eliminate Cursors with temp tables