[Udemy] Learn MS SQL Server From Scratch
What am I going to get from this course?
Скрытое содержимое.
What am I going to get from this course?
- Over 36 lectures and 3.5 hours of content!
- 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
Скрытое содержимое.