4.36 out of 5
4.36
176 reviews on Udemy

Mastering SQL Query With SQL Server

Querying Microsoft SQL Server & Azure SQL DB
Instructor:
Step2c Education
10,356 students enrolled
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

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.

Introduction

1
Course Topics
2
How to use udemy

Basics Of DBMS

1
Introduction To This Module
2
What is Data ?
3
What is Database? & How To Design A Simple Database ?
4
Why We Need A DBMS Software ?
5
What Is The Use SQL Scripting Language ?
6
Summary Of This Module

How To Install SQL Server

1
Different SQL Server Installation Options (Cloud and On Premise)
2
Install SQL Server
3
Install SQL Server Management Studio
4
Connect To SQL Server by Using SQL Server management Studio
5
Create Free Azure Account
6
Create Azure SQL Server DB
7
Connect To Azure SQL Server DB From SSMS
8
Delete Azure SQL Data Base

Design Your First Database

1
Introduction To Designing A Database
2
Create A Databse
3
Create Tables Inside A Database
4
Insert Data Into A Tables
5
Insert Data Into A Tables Part 2
6
Retrieve Saved Data From A Database
7
Retrieve Saved Data From A Database Part 2
8
Update Records Saved in A Table
9
Remove Data From A Table
10
Remove Tables From A Database
11
Summary Of This Module

Task 1: Check Your Understanding

1
Task 1
2
Solution For Task 1: Part 1
3
Solution For Task 1: Part 2
4
Solution For Task 1: Part 3
5
Solution For Task 1: Part 4
6
Solution For Task 1: Part 5
7
Solution For Task 1: Part 6
8
Solution For Task 1: Part 7
9
Solution For Task 1: Part 8

Types OF SQL Statements

1
Interview Question: Different Types Of SQL Statements

Fundamentals Of DQL Statements

1
Basics Of SQL Select Statement & Derive New Data
2
Literal Select Statement
3
Select Distinct Data From A Table
4
Select Specific Data With Where Conditions
5
How To Use In Operate In SQL Where Condition
6
How To Use Between Operator In SQL Where Condition
7
How To Retrieve Null Values Using SQL Where Conditions
8
How To Select Values From A Table That Are Not Equal To Some Values
9
How To Use Like Operator In Where Clause

In this video, you will learn how to use Like operators in SQL where Clause. The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

There are two wildcards often used in conjunction with the LIKE operator:

  • % - The percent sign represents zero, one, or multiple characters.

  • _ - The underscore represents a single character

After this video, You will learn or master to use like operator in where conditions.  In this video, we will explain 20 sample queries by using like operators. So please watch full videos.

10
Sort Data By Using Order By
11
How To Use The SQL Server OFFSET FETCH Clauses To Limit The Number Of Rows ?

Introduction To SQL Constrains

1
What Is Constrain? How To Use It ? When We Need SQL Constrains ?
2
Use Of Not Null Constrains
3
How To Use Unique Constrains Part 1
4
How To Use Unique Constrains Part 2
5
How To Use Check Constraint In SQL Server?
6
How To Use Default Constrains In SQL Server
7
Use Of Primary Key In SQL Server
8
Use IDENTITY Keyword To Perform An Auto-Increment Feature With Primary Key
9
SQL FOREIGN KEY Constraint (Used To Link Two Tables Together)

Aggregate Function In SQL Server

1
Aggregate Functions Like Min, Max, Sum, Avg and Count in Select With Group By

Join In SQL

1
What Is SQL Join and Different Types Of Join
2
Inner Join
3
Outer Joins (Full / Left & Right Joins in SQL)

Union and Union All

1
How To Use Union to Combine Data from Multiple Tables

Introduction To Stored Procedure In SQL Server

1
Use Stored Procedure To Save Your Code And Reuse Old code
2
Use Single and Multiple Parameters With Stored Procedure

String Functions In SQL Server

1
SQL Server String Functions
2
Ascii Vs Char String Functions
3
Lower & Upper String Functions
4
Left & Right String Functions In SQL
5
Ltrim & Rtrim String Functions
6
Replace and Reverse String Functions
7
Substring & Charindex Functions

Interview Questions :: Short Answer

1
Question 1 and Answer
2
Question 2 and Answer
3
Question 3 and Answer

Common SQL Interview Questions And Answers

1
First Set of Questions And Answers
2
Question 1 and Answer
3
Question 2 and Answer
4
Question 3 and Answer
5
Question 4 and Answer
6
Question 5 and Answer
7
Question 6 and Answer
8
Question 7 and Answer
9
Question 8 and Answer
10
Question 9 and Answer
11
Question 10 and Answer
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.4
4.4 out of 5
176 Ratings

Detailed Rating

Stars 5
50
Stars 4
61
Stars 3
46
Stars 2
10
Stars 1
9
30b9153c780f5e6a6b1b9ec551162463
30-Day Money-Back Guarantee

Includes

7 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Don't Miss Any Course Join Our Telegram Channel Join Channel
+ +