Microsoft SQL Server

Sinet has well experienced academic team to deliver datbase administration using SQL Server..



COURSE DETAILS

Duration: 30 hours *

Class: Regular / Week ends / Evening / Sundays

Daily Time: 1.5 hours / 3 hours / half day / Full day

Certification: Sinet Merit Certification

JOIN NOW
* Sinet course can be customized as per student requirement.

JOB PROFILE

Database Administrator

Data Server Manager

Microsoft DBA Executive




MICROSOFT SQL SERVER
COURSE CONTENTS

( Can be customized )



1. Introduction in SQL SERVER

What is DBMS (Database Management System).What is RDBMS (Relational Database Management System).What is oracle. Client / Server Architecture. Login Authentication. Handling data in a data base. Data types, IDE, Database creation using Object Explorer Table creation, insert values ,display table data, edit values, delete rows, insert new columns, delete columns,Delete table and database

2. Query (1) in SQL SERVER

What id query?Create Database using CREATE DATABASE, Table creation using CREATE TABLE. Insert value into table using INSERT, delete values from table using DELETE command, edit value into table using UPDATE commands, Delete table using DROP command, Delete database using DROP command

3. Query (2) in SQL SERVER

Limiting rows using a selection, Restrict the rows returned by Using where clause, Comparison conditions- =,<,>,<=,>=,<>, Other comparison operators-Between… And(between two values), IN(match any of a list of values), LIKE (match a character pattern), IS NULL (is a null value) Logical conditions-AND(returns true if both conditions are true), OR(returns true if either conditions is true), NOT(returns true if conditions is false)- Not In(match not of a list of values) Sorting-sort in ascending order and descending order, sorting by multiple columns

4. Rename using Stored Procedures And Constraints in SQL SERVER

Rename table and column using SP_RENAME procedure, ALTER Command: Add new column, remove column , change the data type of a column . Define constriants: Create rule (range of valid values for column) and default value for columns. Bind and unbind rule using SP_BINDRULE and SP_UNBINDRULE procedures respectively . Bind and unbind default using SP_BINDEFAULT and SP_UNBINDEFAULT procedures respectively Remove rule and default using DROP Command

5. Constraints (1) in SQL SERVER

Primary key- requires the values in the column, to which it is attached to be unique and contain values other than NULL. Set primary key on table creation.Remove primary key from table.Set primary key to existing table, Unique key-- requires the values in the column, to which it is attached to be unique. Set unique key on table creation.Remove unique key from table.Set unique key to existing table

6. Constraints (2) in SQL SERVER

Foreign key-refers to a column of another table or another column of the same table. Set foreign key on table creation. Remove foreign key from table.Set foreign key to existing table

7. View And index in SQL SERVER

View: Views are logical representation of data contained in a table . Create View , edit view using ALTER VIEW,remove view using DROP VIEW Index: The process of retrieving data, index also quickens the various select, updates and deletes issued on a table Clustered index-Create index using CLUSTERED INDEX .,Remove index is using DROP INDEX. Non clustered index Create index using NONCLUSTERED INDEX .,Remove index is using DROP INDEX. Unique index Create index using UNIQUE INDEX .,Remove index is using DROP INDEX

8. Data corelation [Joins]in SQL SERVER

Cross join:joins one or more table not specify criteria,Inner join:joins one or more tables specify criteria Left outer join:joins two tables, includes all rows from the first table and matching. Right outer join:joins tables, includes all rows from the second table and matching. Full outer join: joins tables, includes all rows from first and second table corresponding matching rows Union, Unionall:combines the result of SELECT statement into one final result set.

9. Functions in SQL SERVER

The Group by clause is returns an aggregate value for the groups defined by the select statement. The Having Clause is used to select particular rows from the result set obtained using the group by clause. Rollup and Cube are two new operators in SQL Server .These operators are used to obtain Super-Aggregate values to the result set

10. group by in SQL SERVER

What is procedure.Define procedure using CREATE PROCEDURE.Calling Procedure using EXEC, Argument Passing in procedure definition etc…

11. Procedure in SQL SERVER

Database Backup and Restore using Object Explorer.Generate script, import data, export data etc..




SINET IS AN ISO 9001 : 2015 CERTIFIED SOFTWARE TRAINING INSTITUTE

(Division of Sinet Education)

www.sinetedu.com