Mastering SQL Query With SQL Server


Mastering SQL Query With SQL ServerQuerying Microsoft SQL Server , Azure SQL DB & Cosmos DB

What you’ll learn

  • How To Create Tables In A Database Using SQL statements
  • How To Create Tables In A Database Using SQL SSMS
  • Why We Need To Create Multiple Tables
  • Building Globally Distributed Databases with Cosmos DB
  • How To Insert Data Into A tables
  • How To Updated Saved Data Using Update Statements
  • How To Remove unwanted Data from Table Using SQL
  • Different Ways To Retentive Data Saved In A Table
Cover Most Frequently Asked Interview Questions And Answers


  • This course is designed for everyone, no prior knowledge of SQL Server required.
  • You need a computer/Laptop
  • You need to install MS SQL Server 2012 or above version (Optional)
  • Internet Connection To Watch This videos


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;
      1. ALTER;
      2. DROP;
      3. ALTER COLUMN;
      4. CREATE

Create and modify constraints (simple statements)

    • Create constraints on tables; define constraints;
      1. unique Key constraints.
      2. Default constraints.
      3. Primary Key constraints.
      4. Foreign key constraints
      5. Not Null constraints.
      6. 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.

Who this course is for:

  • Any students Plan to Get Certified AS 70-461
  • Those Who Are Planing To Clear Exam 70-461 “Querying Microsoft SQL Server 2012/2014”

Created by Step2C Education
Last updated 10/2021

Size: 5.72 GB

Download Now

Leave A Reply

Your email address will not be published.