Free Online Course : Mastering SQL Query With SQL Server

Mastering SQL Query With SQL Server 2020

Querying Microsoft SQL Server & Azure SQL DB

Free Online Course what You'll Learn 

• Why We Need To Create Multiple Tables
• How To Create Tables In A Database Using SQL statements
• How To Create Tables In A Database Using SQL SSMS
• 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

Free Online Course Content 

Requirement :

• 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

Description :

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.

Free Online Course Who this Course is for  

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

Free Online Course (Course Link Valid for 1 days)

Free Course : Master SQL Query With SQL Server