Latest Courses
Data Science in a Business ContextCheck course
Build a portfolio with React.JSCheck course
Java Programming - The Apprentice CourseCheck course
Node, Express, React and Mongo DB full stack developmentCheck course
Async/await in JavascriptCheck course
MERN stack complete Blog Application from scratch 2021Check course
Social Logins App - Flutter 2.5 & Firebase with Null SafetyCheck course
The Complete Dart Learning Guide [2021 Edition]Check course
Build a TODO app without a Javascript frameworkCheck course
PHP, HTML, CSS, Python and C++ Complete Bundle CourseCheck course
Data Science in a Business ContextCheck course
Build a portfolio with React.JSCheck course
Java Programming - The Apprentice CourseCheck course
Node, Express, React and Mongo DB full stack developmentCheck course
Async/await in JavascriptCheck course
- 40% Mastering SQL Scripting And SQL Queries

Mastering SQL Query With SQL Server

$14.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

11 reviews for Mastering SQL Query With SQL Server

4.4 out of 5
5
5
1
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Abhishek

    its a good experience

    Helpful(0) Unhelpful(0)You have already voted this
  2. Jeevan Kumar Reddy

    it really looks good, need some more real time examples

    Helpful(0) Unhelpful(0)You have already voted this
  3. Bharat Kumar Borra

    Helpful(0) Unhelpful(0)You have already voted this
  4. 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. Smriti s

    Good content

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

    Please call

    Helpful(0) Unhelpful(0)You have already voted this
  7. 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. Sriram N. Viswanathan

    It was helpful. Thanks.

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

    This course was interesting.

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

    The material is fine but the sound is not clear.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Andile

    So far this course is very informative and the outline is easy to understand and grasp

    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

    $14.99

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare