Back

Enroll on provider's site
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 will 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.

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

    احمد سمير

    LORE ADVANTAGE

    Lore delivers value at the intersection of learning, interests and skills.

    Learn from Domain Experts

    Access learning options recommended by industry experts, professionals and thought leaders.

    Search & Compare

    Quickly search, select and add learning options to your learning list.

    Personalize your feed

    Tell us more about yourself to access the latest learning options, curated just for you.