Duration

3.5 hours

Price

Level

Beginner

Certification

Available

Instructor

Ahmed Sameer

course provides students with the technical skills required to write basic Transact-SQL queries for MS SQL Server

Expected learning & outcomes

  • 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

    Skills you'll master / acquire / learn

    Business Intelligence, Database Administration, Development, Reporting, SQL, SQL Queries

    About this course

    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.

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

    احمد سمير