Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Mastering SQL Query With SQL Server

via Udemy

Overview

Querying 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
  • How To Use SELECT, FROM, WHERE, ORDER BY

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.


Taught by

Step2C Education

Reviews

Start your review of Mastering SQL Query With SQL Server

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.