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

* Sinet course can be customized as per student requirement.

JOB PROFILE

Database Administrator

Data Server Manager

Microsoft DBA Executive

1. Introduction in SQL SERVER

DBMS (Database Management System), RDBMS (Relational Database Management System), Oracle DB, 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 databases

2. Creating Query in SQL SERVER

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. Conditional Query 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. Primary Constraints 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. Foreign Key Constraints 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 and 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 and the various select, updates and deletes issued on a table, Clustered index: Create index using CLUSTERED INDEX, Remove index 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

Predefined functions and complexity, Mathematical function: ROUND(), CEILING(), FLOOR(). String functions: DATALENGTH(), UPPER(), LOWER(), etc. Date function: GETDATE(), DATEPART(), DATENAME(), DATEADD() etc Aggregate function: SUM(), AVG(), MIN(), MAX(), COUNT() etc.

10. GROUP BY 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

11. PROCEDURE in SQL SERVER

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

12. BACKUP - RESTORE in SQL SERVER

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