SQL COURSE OFFERED IN BASAVESHWAR NAGAR AT BANGALORE

SQL Server

1. An Overview to SQL Server
Introduction to SQL Server
Role of the Database server
SQL Server components
Features of SQL Server
SQL statements


2. Connecting to SQL Server using SSMS
Server Type
Server Name
Authentication
Login
Password


3. Creating, Altering & Dropping Database

4. Managing Tables
SQL Constraints
Adding Not Null Constraint
Adding Primary Key Constraint
Adding Foreign Key Constraint
Adding Default Constraint
Adding Check Constraint
Adding Unique Key Constraint


5. Manipulating Data though DML statements
Storing data in a table
Updating data in a table
Deleting data from a table


6. Querying Data
Select, From, Where
Distinct
SQL Operators
Arithmetic Operators
Comparison Operators
Logical Operators


7. Summarizing and Grouping Data
Use of Aggregate Functions
Grouping Data


8. Querying Data using sub queries
Using the IN and EXISTS keywords
Using modified comparison operators
Using Aggregate Functions
Using Nested Subqueries
Using Correlated Subqueries
Using the APPLY operator


9. Querying data using joins
Using an Inner join
Using an Outer join
Using a cross join
Using an equi-join
Using a self-join


10. Built-in Functions
String Functions
Date Time Functions
Aggregate Functions
Mathematical Functions


11. Creating and managing views
Creating Views
Managing Views