Have a question?
Message sent Close
176 reviews

Mastering SQL Query With SQL Server

Querying Microsoft SQL Server & Azure SQL DB
10,356 Students enrolled
  • Description
  • Curriculum
  • FAQ
  • Reviews

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.

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

How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
176 reviews
Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
Course details
Lectures 12
Quizzes 3
Video 7 hours
Certificate of Completion
Full lifetime access
Access on mobile and TV

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW