Latest Courses
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
Python Programming Skills Test With ExplanationCheck course
Beginners Eclipse Java IDE Training CourseCheck course
Xamarin Android - A Master Guide to App Development in C#Check course
Python for beginnersCheck course
Salesforce Integration With External SystemsCheck course
Game Audio 101 & 201: Beginner to Advanced Game Sound DesignCheck course
Xamarin on Steroids: Xamarin Forms Shell and MVVMCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
Python Programming Skills Test With ExplanationCheck course
Beginners Eclipse Java IDE Training CourseCheck course
- 35% Mastering SQL Query With SQL Server

Mastering SQL Query With SQL Server

$19.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 #42 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.

Soon will upload more videos to explain module three and four for 70–641.

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 7 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

    $19.99 $12.99

    Price tracking

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