Note: Udemy FREE coupon codes are valid for maximum 1000 redemption only and might get redeemed in few hours. Look for "GET THIS DEAL" green button at the end of Description.
This post may have affiliate link & we may get small commission if you make a purchase.
![[Few Hours Left] Udemy Sitewide $9.99 – List of 1300 Popular Courses (By Ratings, Hours of Videos, Categories, Authors )](https://media.freebiesglobal.com/2020/12/Udemy9.99.png)
Mastering SQL Query With SQL Server
Querying Microsoft SQL Server & Azure SQL DB
Requirements
- 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 tables without using the built in tools;
- 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.
- Create constraints on tables; define 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.
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”
