RDBMS – SQL | MYSQL Training
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 Details
Sql Server / PL SQL
Session 1
- Step1-About management studio
- Step2-Creating tables
- Step3-Insert data into tables
- Step4-Identity and its properties .
Session-2
- 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
- Step4-Creating relationships
- Step5-creating constraints
- Step6-Learn foreign key value errors
- Step7-On cascade delete
- Step8-Drop
Session-3
- 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
Having
Order by
Session-4
- Step1-Procedures
-In parameters
-Out parameters - Step2-Functions
-Predefine functions
-Built in functions
-UDF
-Table functions
-Scalar functions - Step3-CTE
- Step1-While loop
- Step2-If conditions
- Step3-Using all those prepare procedures
- Step4-String Manipulations
- Step5-Dynamic SQL
-Exce
-Sp_excesql
Session-6
- Step1-Triggers
-DML Triggers
-DDL Triggers - Step2-Cursors
- Step3-Temp tables
- Step4-Eliminate Cursors with temp tables
Course Duration
- 2 Months
- Class Duration : 2 Hrs