The profile of Vinod and their contact details have been verified by our experts
Vinod
- Rate £8
- Response 5h
-
Students2
Number of students Vinod has accompanied since arriving at Superprof
Number of students Vinod has accompanied since arriving at Superprof
£8/hr
See PostgreSQL tutors
Unfortunately, this tutor is unavailable
- PostgreSQL
Microsoft SQL training. Learn from baisc to advanced. Each and every concept will be covered with demo.
- PostgreSQL
Lesson location
About Vinod
This will help in building your future.
Content
"Database, Create table,identity in SQL, top clause, drop table, Insert, and Update command
Different data types, Delete Truncate"
"SQL Joins, Group By, Aggregate functions,Having Clause
default keyword and check constraint
"
"Primary Key, Unique Key, Difference between
a) Where and having clause b) Primary key and unique key, c) Union and Union all"
"cross join example, what is DDL and DML, What is COALESCE in SQL Server?
How to check null value, Floor and sign functions, case when,Dynamic Queries, Debugging Queries"
exporting data to excel, and loading data from excel, Schema
"Stored Procedures, Advantages of stored procedures, excution plan , network traffic, code reusability, SQL Injection
Input and output parameters, What is CTE, Temporary Tables, Cursors, Merge
"
Inline Functions, Functions, Views
Pivot, Acid property, Normalization
Commit and rollback, Triggers, Magic Tables in SQL server
"Difference b/w clustered n non clustered index. , DBCC command, Heap
BCP, Collation, Indexes, Rank, row_number, Transactions, Explain indexes and filter Index, Convert varchar to date.
MINUS, INTERSECT, Partition, lead lag
"
See more
About the lesson
- All Levels
- English
All languages in which the lesson is available :
English
There is lot of Hands on in the classes.
Content
"Database, Create table,identity in SQL, top clause, drop table, Insert, and Update command
Different data types, Delete Truncate"
"SQL Joins, Group By, Aggregate functions,Having Clause
default keyword and check constraint
"
"Primary Key, Unique Key, Difference between
a) Where and having clause b) Primary key and unique key, c) Union and Union all"
"cross join example, what is DDL and DML, What is COALESCE in SQL Server?
How to check null value, Floor and sign functions, case when,Dynamic Queries, Debugging Queries"
exporting data to excel, and loading data from excel, Schema
"Stored Procedures, Advantages of stored procedures, excution plan , network traffic, code reusability, SQL Injection
Input and output parameters, What is CTE, Temporary Tables, Cursors, Merge
"
Inline Functions, Functions, Views
Pivot, Acid property, Normalization
Commit and rollback, Triggers, Magic Tables in SQL server
"Difference b/w clustered n non clustered index. , DBCC command, Heap
BCP, Collation, Indexes, Rank, row_number, Transactions, Explain indexes and filter Index, Convert varchar to date.
MINUS, INTERSECT, Partition, lead lag
"
See more
Rates
Rate
- £8
Pack prices
- 5h: £40
- 10h: £80
online
- £8/h
Similar PostgreSQL teachers in Thane
Dr Nick
London & Online
- £25/hr
Siddhant
Manchester & Online
- £33/hr
- 1st lesson free
Bishoy
London & Online
- £18/hr
- 1st lesson free
Carlos
& Online
- £150/hr
- 1st lesson free
Khalil
Gomshall & Online
- £40/hr
- 1st lesson free
Abhishek
London & Online
- £50/hr
- 1st lesson free
Alex
Wembley & Online
- £45/hr
- 1st lesson free
Agata
& Online
- £45/hr
- 1st lesson free
Ankit
Ilford & Online
- £50/hr
- 1st lesson free
Kristina
Leeds & Online
- £30/hr
- 1st lesson free
Pili
London & Online
- £70/hr
- 1st lesson free
Chinmay
Birmingham & Online
- £61/hr
- 1st lesson free
Yashika
Manchester & Online
- £25/hr
- 1st lesson free
Abhishek
London & Online
- £29/hr
- 1st lesson free
Abhishek
Glasgow & Online
- £21/hr
- 1st lesson free
Mayur
Northampton & Online
- £35/hr
- 1st lesson free
AAKASH
Huddersfield & Online
- £9/hr
- 1st lesson free
Darren
Bristol & Online
- £20/hr
- 1st lesson free
Dimitris
London & Online
- £35/hr
- 1st lesson free
Elena
London & Online
- £25/hr
- 1st lesson free
-
See PostgreSQL tutors
