ABOUT THE COURSE
SQL Server is a relational database management system (RDBMS) from Microsoft that’s designed for the enterprise environment. SQL Server runs on T-SQL(Transact -SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handling, row processing, and declared variables.
SQL Server Training Syllabus
Introducing Database
- Basic Database Concepts
- Concepts Of DBMS And RDBMS
Overview of SQL Server
- Introduction To SQL Server And Features Of SQL Server
- SQL Server Data Types
- Basics Of SQL
- Management Studio
- Data Types, Expressions, Operators
Working With Queries & Clauses
- Database Design
- Creating Databases
- SELECT Into Statement
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- Sub Queries
- DISTINCT Clause
- FROM Clause
- WHERE Clause
- ORDER BY Clause
- GROUP BY Clause
- HAVING Clause
SQL Server SQL Functions
- SUM Function
- COUNT Function
- AVG Function
- MIN Function
- MAX Function
SQL Server Conditions
- AND Condition
- OR Condition
- LIKE Condition
- IN Condition
- NOT Condition
- IS NULL Condition
- IS NOT NULL Condition
- BETWEEN Condition
- EXISTS Condition
Introduction To JOIN and Subqueries
- INNER JOIN
- OUTER JOIN
- CROSS JOIN
- UNION and UNION ALL
- Nested Sub Queries
- Correlated Sub Queries
Managing Database and tables
- Create Table
- select Into
- Alter Table
- Drop Table
- Local Temp Tables
- Global Temp Tables
Working With Stored Procedures and functions
- Operators, Built-In Functions, Grouping
- Introduction To Stored Procedures
- Creating, Executing, Modifying, Dropping Store Procedures
Working With Indexes & Views
Working with Triggers and Transactions
Monitoring and Optimizing Performance
WHO CAN JOIN
- 10/+2
- Any Bachelor Degree
CERTIFICATE
Training completion certificate
DURATION AND FEE
Duration: 45 days
Are you interested in training from Readyedge Technologies wants to know more about fees and details click here to fill the form and arrange a call back
Contact Phone: 099142-42403 / 0172-4683377
Email: Training@readyedgetechnologies.com
Address: E57, Industrial Area, Phase 8, Mohali, Punjab
