Course Details
- Category
- Database Administration
- Mode of Training
- Online/Offline
- Duration
- 3 -4 months
- Fees
- ₹ 25K
Course Features
Instructor led Sessions
Real-life Case Studies
Assignment
Certification
Instructor led Sessions
MS SQL Server DBA
Oranium Tech introducing some amazing content on MS SQL DBA. Oranium Tech is one of its kind Institute which not only equips you with technical skills but will train you for free in Aptitude skills, Soft Skills, Mock Interviews, Interview Skills, Work ethics, and Corporate Values that you need to know to get into IT Industry. Our training is given by expert real-time development experienced trainers and we enable each and every student of ours to do their own real-time projects by the end of the program. We do not buy you a job by bribing companies to secure a place in IT, instead, we equip you with the skills needed to get employed in IT and will support you with an unlimited number of relevant interview opportunities so that your career in IT becomes assured. Our support will be there until you get placed in an IT Company as that’s our mission too.
Course Syllabus
• What is Data, Field, Record and database?
• Limitations of File Management System.
• Basic Concepts of Advantages of DBMS.
• Exploring Relational DBMS
• Understanding Client and Server
• Analyzing the Requirement
• Identify Entities and their Relationships
• Drawing E-R Diagram
• Conversion of E.R. Diagrams into Tables
• First Normal Form
• Second Normal Form
• Third Normal Form Practically Normalizing Tables
• What is SQL Server Version history and different editions
• Basic Features Components and Tools
• Starting and Stopping SQL Server Instances / Services
• Introduction to Management Studio
• Types of System Databases in SQL
• Basics of SQL Types of SQL Statements
• DDL, DML, DQL, DCL and TCL
• Create Database using Management Studio
• Datatypes in SQL Server
• Exploring DDL Statements on Table using Management Studio
• Why write statements in Frontends?
• Create, Alter and Drop Table Insert,
• Update and Delete Statement Truncate Statement
• Understanding Select Statement
• Usage of Top, Distinct, Null etc…keywords
• Using String and Arithmetic Expressions
• Exploring Where Clause with Operators
• Using Advanced Operators
• Sorting data using Order By clause
• Working with basic of Sub Queries
• Using functions in Queries
• Count, Sum, Min, Max, Avg Group By and Having Clause
• Using Group By with Rollup and Cube
• Introduction to Joins Cross Joins
• Inner Join
• Outer Join
• Self Join
• Co-related Sub Queries
• Set Operations using Unions, Intersect and Except
10)Implementation of Data integrity
• Entity integrity
• Domain integrity
• Referential integrity
• Types of constraints
• Introduction to Joins Cross Joins
• Inner Join
• Outer Join
• Self Join
• Co-related Sub Queries
• Set Operations using Unions, Intersect and Except
10)Implementation of Data integrity
• Entity integrity
• Domain integrity
• Referential integrity
• Types of constraints
• Entity integrity
• Domain integrity
• Referential integrity
• Types of constraints
• Unique
• Not NULL
• Primary Key
• Introduction & Advantages of Views
• Creating, Altering, Dropping Views
• Advance Options while Creating a View
• SQL Server Catalogue Views
• Creating Users & Roles
• Granting & Revoking of Roles & privileges
• Managing using Management Studio
• Introduction Clustered and Non Clustered Index
• Creating and Dropping Indexes
• What is T-SQL?
• Scripts and Batches Declaring Variables
• Using Statements
• Working with Temp tables
• Error Handling
• Using System Functions / Global Variables Using Dynamic SQL
