Learn SQL Query using MS Sql Server [Arabic]
4.6 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
21 students enrolled

Learn SQL Query using MS Sql Server [Arabic]

course provides students with the technical skills required to write basic Transact-SQL queries for MS SQL Server
4.6 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
21 students enrolled
Created by Ahmed Sameer
Last updated 7/2017
Arabic
Current price: $20.99 Original price: $29.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Write SELECT Queries
  • Sort and Filter Data
  • Query Multiple Tables
  • Use Subqueries
  • Use Built-In Functions
  • Create Views
  • Creating Stored Procedure
  • Creating User Define Function
  • Creating Trigger
  • Implementing Transactions
  • Improving Query Performance
  • Creating Report Example using SSRS
Course content
Expand all 22 lectures 03:16:49
+ Write SELECT Queries - Sort and Filter Data
4 lectures 46:58
Select (Formula ,Sort,Alias ,null ,In operator )
17:25
Aggregate Functions and Group By
12:29
Group By - Having
02:51
+ Query Multiple Tables
6 lectures 39:18
Outer Join
10:08
Cross Join
03:06
Self Join
04:02
Sub Query
10:54
+ T-SQL Programming Objects
6 lectures 56:27
Create Views
06:23
Creating Stored Procedure
11:13
Stored Procedure - Output Parameter
07:12
Creating User Define Function
04:45
Creating Trigger
15:57
Implementing Transactions
10:57
+ Enhance the Performance
3 lectures 19:13
Improving Query Performance
07:42
Creating Report Example using SSRS
11:03
Conclusion
00:28
Requirements
  • Basic knowledge of the Microsoft Windows® operating system and its core functionality.
  • Basic knowledge of relational databases
Description

This Course provides students with the technical skills required to write basic
Transact-SQL queries for Microsoft® SQL Server. Course will help the Database Administration, Database Development and Business Intelligence.

فعلا الكورس مفيد جدااا لمبتدئين والمتوسطين لانشاء تقارير مفيده من خلال لغة 

SQL .

The main purpose of the course is to prepare people for the exam "70-461".

The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

وبالتوفيق لكم تحياتي

احمد سمير

Who this course is for:
  • Database Developers
  • Database Administrators
  • Business Intelligence Developers
  • SQL power users
  • plan on taking all most of database exams
  • report writers
  • business analysts
  • client application developers.