![]()
Requirements:
Need MS Sql Server express of any version higher than 2005 installed on your system.
What am I going to get from this course?
Over 32 lectures and 3.5 hours of content you can download!
By the end of this course you will be in a position to do the following:-
-
Creating, Altering And Dropping DataBase Creating Tables
-
Primary Keys, Identity Columns and Unique Keys DataBase Diagram and Creating Relationships between tables
-
DataTypes In SQL Server
-
Insert Statement, Update Statement and Delete Statement
-
Select Statement with Top(), Order by, Where, in, not in, between, not between and Like Clauses, Aggregate Functions like Sum(), Avg(), Min(), Max(), Count() etc.,
-
DateTime Functions Like getDate(), Day(), Month(), Year(), DateDiff(), DateAdd(), etc.,
-
Group By and Having Clause with Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join. Implementing Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.
-
Creating Stored Procedures With No Input And Output Params Creating Stored Procedures With Input And No Output Params Creating Stored Procedures With Input And Output Params and Creating Functions
-
Working with control structures, sub queries, corelated quires, Views, Transactions and triggers, etc.,
What is the target audience?
-
Fresh Graduates
-
Developers
CURRICULUM
SECTION 1: Basic MS Sql Server Data Definition Language
Getting Started With Sql Server Management Studio 07:50
Create A Database 04:41
Create A Table 14:31
Data Types In SQL Server
SECTION 2: Data Manipulation Language - Insert,Update And Delete
Insert Statement 03:55
Update And Delete Statement 03:09
Delete Vs Truncate 07:45
OUTPUT clause 03:12
SECTION 3: Data Manipulation Language - Select
Select Statement 04:10
Various Clauses 11:19
SECTION 4: Data Manipulation Language - Built In Functions
Built In Functions 12:24
DateTime Functions 08:41
SECTION 5: Data Manipulation Language - Advance clauses and Joins
Group By and Having Clause 11:50
Understanding Joins 06:30
Implementing Joins 08:35
Self Join 05:32
SECTION 6: Data Manipulation Language - Stored Procedures And Functions
Creating Stored Procedures With No Input And Output Params 04:33
Creating Stored Procedures With Input And No Output Params 03:56
Creating Stored Procedures With Input And Output Params 05:07
Creating User Defined Functions 07:42
SECTION 7: Control Structures
IIF() 01:41
Case When 09:14
IF...ELSE 11:53
SECTION 8: Subqueries
Scalar SubQueries 05:56
Multivalued Subqueries 08:03
EXISTS and not EXISTS 03:25
Correlated Queries 13:23
SECTION 9: Advanced Operations
Views 07:58
Slowly Changing Dimensions 06:10
Scope Identity Function 07:48
Transactions 05:57
Triggers 06:08
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
