Learn SQL Query using MS Sql Server [Arabic]
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL Query using MS Sql Server [Arabic] to your Wishlist.

Add to Wishlist

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
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Created by Ahmed Sameer
Last updated 7/2017
Arabic
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
About the Instructor
Ahmed Sameer
0.0 Average rating
0 Reviews
5 Students
2 Courses
Development and Database Consultant

B.Sc. of Engineering 
Diploma of Information Systems at AAST
Master of Information Systems at AAST (not finished yet)
Microsoft Certified Trainer since 2007 
MCP, MCAD, MCSD 
MCTS,MCPD Enterprise
MCSD Sharepoint
MCSA(Office 365)
MCSE (SharePoint Admin)
MCSD(Web Applications)
MCDBA Database Administration
I Already worked Before as 
Trainer at Global Knowledge Cairo, KSA,UAE  & New Horizons Cairo,KSA
as Senior Developer at RAYA & ZAFA Limtied KSA Riyadh   
some of Companies already give them a training : Saudi Aramco ,NGHA , Taibah University ,Bank Saudi France and a lot
Founder of IB
Mob: +2 01117979965
Email: prog.ahmad@hotmail.com