Introduction to DBMS 3
- File Management System and Its DrawbacksLecture1.1
- Database Management System (DBMS) and Data ModelsLecture1.2
- Conceptual Data ModelsLecture1.3
Introduction to SQL Server 4
- Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2Lecture2.1
- Connecting To ServerLecture2.2
- Authentication ModelsLecture2.3
- SQL Server Management Studio and Tools in Management StudioLecture2.4
Introduction To SQL 16
- History and Features of TSQLLecture3.1
- Types of TSQL CommandsLecture3.2
- Data Definition Language (DDL)Lecture3.3
- Data Manipulation Language (DML)Lecture3.4
- Data Query Language (DQL)Lecture3.5
- Data Control Language (DCL)Lecture3.6
- Transaction Control Language (TCL)Lecture3.7
- Creating DatabaseLecture3.8
- Altering DatabaseLecture3.9
- Deleting DatabaseLecture3.10
- ConstraintsLecture3.11
- Procedural Integrity ConstraintsLecture3.12
- Declarative Integrity ConstraintsLecture3.13
- Creating TableLecture3.14
- Altering TableLecture3.15
- Deleting TableLecture3.16
Data Manipulation Language 3
Data Query Language (DQL) 10
- Scalar FunctionsLecture5.1
- Numeric FUnctionsLecture5.2
- Character FunctionsLecture5.3
- Conversion FunctionsLecture5.4
- Date FunctionsLecture5.5
- Aggregate FunctionsLecture5.6
- Conventional Aggregate FunctionsLecture5.7
- Super AggregatesLecture5.8
- Over(partition by …) clauseLecture5.9
- Ranking FunctionsLecture5.10
Top n Clause 0
No items in this sectionSet Operations 3
Joins 9
- Inner JoinsLecture8.1
- Equi JoinLecture8.2
- Natural JoinLecture8.3
- Self JoinLecture8.4
- Outer JoinLecture8.5
- Left Outer joinLecture8.6
- Right Outer joinLecture8.7
- Full Outer JoinLecture8.8
- Cross JoinLecture8.9
Sub Queries 4
- Single Row Sub QueriesLecture9.1
- Multi Row Sub QueriesLecture9.2
- Nested Sub QueriesLecture9.3
- Co-Related sub QueriesLecture9.4
Indexes 4
- Clustered IndexLecture10.1
- NonClustered IndexLecture10.2
- Create, Alter and Drop IndexesLecture10.3
- Using IndexesLecture10.4
Security 6
- SQL Server Authentication LoginLecture11.1
- Windows Authentication LoginLecture11.2
- User CreationLecture11.3
- Granted PermissionsLecture11.4
- Revoking PermissionsLecture11.5
- RolesLecture11.6
Views 4
- Purpose of viewsLecture12.1
- Creating, Altering and Dropping IndexesLecture12.2
- Simple and COmplex ViewsLecture12.3
- Encryption and Schema Binding options in creating viewsLecture12.4
Transaction Management 7
- IntroductionLecture13.1
- Begin TransactionLecture13.2
- Commit TransactionLecture13.3
- Rollback TransactionLecture13.4
- Save TransactiojnLecture13.5
- Role of Log File in Transaction ManagementLecture13.6
- Implicit TransactionsLecture13.7
TSQL Programming 5
- Drawbacks of TSQL that Leads to TSQL programmingLecture14.1
- Introduction to TSQL programmingLecture14.2
- Conditional Control StatementsLecture14.3
- IF, Case, Looping control StatementsLecture14.4
- WhileLecture14.5
Cursors 4
- Working with CursorsLecture15.1
- Types of CursorsLecture15.2
- Forward only and Scroll CursorsLecture15.3
- Local and GLobal CursorsLecture15.4
Stored Sub Programs 24
- Advantages of stored sub programs compared to independent SQL StatementsLecture16.1
- Stored ProceduresLecture16.2
- Creating, Altering and DroppingLecture16.3
- Optional ParametersLecture16.4
- Input and Output ParametersLecture16.5
- Permissions on Stored ProceduresLecture16.6
- User Defined FunctionsLecture16.7
- Creating, Altering and Dropping FunctionsLecture16.8
- Types of user Defined FunctionsLecture16.9
- Scalar FunctionsLecture16.10
- Table Valued FunctionsLecture16.11
- Inline Table Valued FunctionsLecture16.12
- Multi Statement Table Valued FunctionsLecture16.13
- Permissions on User Defined FunctionsLecture16.14
- TriggersLecture16.15
- Purpose of TriggersLecture16.16
- Difference between stored procedures and user defined functions and TriggersLecture16.17
- Creating, Altering and Dropping TriggersLecture16.18
- Magic TablesLecture16.19
- Instead of TriggersLecture16.20
- Exception HandlingLecture16.21
- Implementing Exception HandlingLecture16.22
- Adding and removing user defind Error messaged to and from SQL Server Error Messages ListLecture16.23
- Raising Exceptions ManualLecture16.24
CLR Integration 2
- What is CLR integration and the steps for implementing itLecture17.1
- A simple Example with CLR IntegrationLecture17.2
This content is protected, please login and enroll course to view this content!
Next NonClustered Index
3 Comments
I have completed SQL server course at Eminent IT, Best place to learn and providing job assistance after course
Best Environment to learn SQL server, Here trainers are very experienced. Best Training institute in Marathahalli Bangalore for SQL Server training.
if you want to learn SQL server from Basics. Eminent IT is best place in marathahalli,Bangalore.