Latest Courses
Reinforcement Learning with PytorchCheck course
Introduction to the MongoDBCheck course
Learn Javascript Step By StepCheck course
Dart Language Practice TestsCheck course
CSS: The Complete CSS Practice Test (+ LinkedIn Assessment)Check course
JQuery: Complete JQuery Practice Test (+LinkedIn Assessment)Check course
The Complete C# Practice Test (+ LinkedIn Assessment)Check course
The Complete Swift Practice Test (+ LinkedIn Assessment)Check course
The Complete Android Practice Test (+ LinkedIn Assessment)Check course
The Complete Python Practice Test (+ LinkedIn Assessment)Check course
Reinforcement Learning with PytorchCheck course
Introduction to the MongoDBCheck course
Learn Javascript Step By StepCheck course
Dart Language Practice TestsCheck course
CSS: The Complete CSS Practice Test (+ LinkedIn Assessment)Check course
- 48% Mastering SQL Query With SQL Server

Mastering SQL Query With SQL Server

$24.99 $12.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.6/10 (Our Score)
Product is rated as #35 in category SQL

This Course cover first two modules of 70–461 (Querying Microsoft SQL Server 2012/2014).

Topics we covered:

Create and alter tables using T–SQL syntax (simple statements):

Create tables without using the built in tools;

ALTER;

DROP;

ALTER COLUMN;

CREATE

Create and modify constraints (simple statements)

Create constraints on tables; define constraints;

unique Key constraints.

Default constraints.

Primary Key constraints.

Foreign key constraints

Not Null constraints.

Check constraints.

Query data by using SELECT statements:

Use the ranking function to select top(n) rows;

Restrict data using where conditions

IN Operators.

Between Operators.

Like Operators.

Conditional Operators.

Combine multiple conditions using AND / OR / NOT.

Sort Data using Order By clause:

Sort Data ascending and descending order.

Restrict Sorted Data Using Offset Fetch.

Modify data by using INSERT, UPDATE, and DELETE statements:

Insert data into a table using insert statement.

Insert data using SQL server management studio.

Remove data using Delete statements.

Remove data using SQL server management Studio.

Remove data using Truncate statement.

Update data using Update statements.

Update data using SQL server management studio.

This course provide 30–day money back guarantee. So if you don’t like the course, you could ask for refund.

Instructor Details

My Name is Shebina k: I'm basically from Kerala. Right now I'm working in Bangalore for Step2c. Me and my team is part of a online educational firm called Step2c which is started in 2011 and we are committed provide high quality IT video tutorials in Malayalam and English language. We have team which include web developer , data base developer , data base architecture , data scientist , data visualisation expert. software engineers, python developers. We are here to help you. Sarafudheen PM is our current instructor team head

Specification: Mastering SQL Query With SQL Server

Duration 8.5 hours
Year 2020
Level Beginner
Certificate Yes
Quizzes Yes

10 reviews for Mastering SQL Query With SQL Server

4.3 out of 5
4
5
1
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Abhishek

    its a good experience

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Jeevan Kumar Reddy

    it really looks good, need some more real time examples

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Bharat Kumar Borra

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Sajid Nehal

    It was awesome to learn or recover but again i want to say that please add more content and example to more understand new things.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Smriti s

    Good content

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Stacey Arnold

    Please call

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Abdulla

    Question answer and practice test are really good. IAM and EC2 video need to be improved.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Sriram N. Viswanathan

    It was helpful. Thanks.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Jerimiah Penny

    This course was interesting.

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Emila

    The material is fine but the sound is not clear.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Mastering SQL Query With SQL Server

    $24.99 $12.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare