AKHIL REDDY TECHNOLOGIES
8-3-214/3/2/4, above Karachi bakery,
Opp. Mythrivanam, Ameerpet,Hyd.
INTRODUCTION
What is a database?
Fundamentals of DBMS
SQL Server 2012
Versions in SQL Server
Editions of SQL Server
Features of SQL Server
Requirements to install SQL Server
Introduction to SQL Server Management Studio
DATA TYPES in SQL Server 2012
Numeric data types
String data types
Date time data types
Special data types
DATA BASES in SQL Server 2012
Master database
Model database
Ms Database
Temp database
Sample database
T-SQL (TRANSACT STRUCTURED QUERY LANGUAGE)
DDL (Data Definition Language)
DML (Data Manipulation Language)
DCL (Data Control Language)
TCL (Transaction Control
Language)
JOINS
Definition
Advantages of JOINS
INNER JOIN
OUER JOIN
CROSS JOIN
INDEXES
Definition
Guidelines to create the INDEXES
Types of INDEXES
SET OPERARTORS
UNION ALL
UNION
INTERSECT
EXCEPT
SUB-QUERIES
What is sub
query?
Types of
sub queries
RETRIEVING DATA
SELECT
STATEMENT
WHERE
CLAUSE
GROUP BY CLAUSE
HAVING CLAUSE
ORDER BY CLAUSE
STORED PROCEDURES
Definition
Types of
Stored Procedures
Creating
Stored Procedures
Executing
Stored Procedures
User
defined Stored Procedures
VIEWS
What is
view?
Considerations
while creating
Creating a
view
FUNCTIONS
Mathematical
functions
String
functions
Date &
time functions
Group or
aggregate functions
User
defined functions
DATA INTEGRITY
What is
DATA INTEGRITY?
Types of
DATA INTEGRITY
What is Constraint?
Types of Constraints
Levels of Constraints
BATCH STATEMENTS
Definition
Anonymous Batch/Name
less Batch
Named batch
STATEMENTS
What is Variable?
Types of variables
Advantages of variables
Constants
Conditional statements
Looping statements
CURSORS
Definition
ADVANTAGES OF CURSORS
Types of CURSORS
TRIGGERS
Definition
Considerations while creating
Types of triggers
TRANSACTIONS
Types of transactions
COMMIT
ROLLBACK
SAVE
NORMALIZATION
Definition
Normal forms
Advantages and disadvantages
DIFFERENCE BETWEEN ORACLE
& SQL Server
RULES
AND DEFAULTS
E.F.CODD RULES
ENHANCED FEATURES IN SQL SERVER
SUBSCRIBE YOUTUBE CHANNEL TO GET UPDATED VIDEOS
9440592994, 8885592994
040-40032994
www.akhilreddy.com
No comments:
Post a Comment