HRDF Approved Training Provider
+603-7623-1088
contact@rynet.com.my
Register Login

Connect with:

Login with Facebook Login with Google Login with Twitter Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with Twitter Login with LinkedIn

Lost your password?

Not a member yet? Register now

Rynet Malaysia | HRDF Approved Official PHP Training PartnerRynet Malaysia | HRDF Approved Official PHP Training Partner
  • About Us
    • Who Are We
    • Training Mode
    • Become a Training Partner
    • Blog
    • Zend Forum
    • Privacy Policy
    • Press
  • Services
    • Development
    • Training
  • All Courses
    • Official PHP Courses

      • Fast Track: Zend PHP Basics to Advanced
      • PHP I: Foundations
      • PHP for Experienced Programmers
      • PHP Test Prep
    • New Courses

      PCEP- Certified Entry Level Python Programmer

      PCEP- Certified Entry Level Python Programmer

      Free
      Read More
  • Certifications
    • PHP Certification
    • PYTHON Certification
    • CISCO Certification
  • Meet Our Trainers
    • Local Instructors
    • Virtual Instructors
  • Contact
    • About Us
      • Who Are We
      • Training Mode
      • Become a Training Partner
      • Blog
      • Zend Forum
      • Privacy Policy
      • Press
    • Services
      • Development
      • Training
    • All Courses
      • Official PHP Courses

        • Fast Track: Zend PHP Basics to Advanced
        • PHP I: Foundations
        • PHP for Experienced Programmers
        • PHP Test Prep
      • New Courses

        PCEP- Certified Entry Level Python Programmer

        PCEP- Certified Entry Level Python Programmer

        Free
        Read More
    • Certifications
      • PHP Certification
      • PYTHON Certification
      • CISCO Certification
    • Meet Our Trainers
      • Local Instructors
      • Virtual Instructors
    • Contact
    Register Login

    SQL Server

    • Home
    • All courses
    • SQL Server
    • SQL Server from Basics to Advanced

    SQL Server from Basics to Advanced

    Arun Rynet
    SQL Server
    (0 review)
    Free
    SQL Server from Basics to Advanced
    • Description
    • Curriculum
    • Instructors
    • Reviews (0)
    This Course is HRDF SBL Claimable for Employers Registered with HRDF.

    DESCRIPTION

    SQL Server is a relational database management system (RDBMS) developed by Microsoft.  In this two days course, candidates will learn how to execute the four main operations (CRUD) using SQL Server,create database objects such as views, indexes, stored procedures, triggers… and transactions in SQL.

    This course in quite practical with so many examples and activities and candidates will learn all the principles in a practical project means candidates will leave the class by a project in their hands on the first day of training.

    WHO IS THIS FOR

    • For the first day no knowledge about programming languages or databases is required.
    • For the second day basic knowledge of SQL Server is assumed.

    WHAT WILL I LEARN

    • RDBMS
    • Primary key, Surrogate key, Natural key, Composite key and Foreign key
    • What is SQL Server?
    • Install and connect to SQL Server
    • Install SQL Server Management Studio
    • CREATE DATABASE
    • DELETE DATABASE
    • DATA TYPES
    • CREATE TABLE
    • UPDATE TABLE
    • DELETE TABLE
    • INSERT
    • UPDATE
    • DELETE
    • SELECT
    • ORDER BY
    • GROUP BY
    • WHERE CLAUSE
    • OFFSET
    • LIKE
    • DISTINCT
    • AND, OR, BETWEEN, IN
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • FULL OUTER JOIN
    • CROSS JOIN
    • SELF JOIN
    • UNION
    • INTERSECT
    • EXCEPT
    • PIVOT
    • TEMPORARY TABLES
    • NORMALIZATION
    • VIEWS
    • INDEXES
    • STORED PROCEDURES
    • USER DEFINED FUNCTIONS
    • TRIGGERS
    • T-SQL

    COURSE BROCHURE




    Download Course Brochure here

    Course Fee: (per PAX)

    RM 1,800


    Buying for yourself?

    Write to us in the form below, we will contact you to discuss how best to fit your schedule.


    Buying for a Team?

    Write to us in the form below, we would be happy to talk to you about a group DISCOUNT.

    Send me more Information: For IndividualFor Business

    Share:


    Course Features

    • Lectures 0
    • Quizzes 0
    • Duration 2 Days
    • Skill level Beginner
    • Language English
    • Students 0
    • Certificate Yes
    • Assessments Self
    Curriculum is empty.
    Arun Rynet

    Reviews

    Average Rating

    0
    0 rating

    Detailed Rating

    5 stars
    0
    4 stars
    0
    3 stars
    0
    2 stars
    0
    1 star
    0
    • Description
    • Curriculum
    • Instructors
    • Reviews
    Free

    You May Like

    PCEP- Certified Entry Level Python Programmer Read More
    Arun Rynet

    PCEP- Certified Entry Level Python Programmer

    0
    0
    Free
    Laravel Masterclass Read More
    Arun Rynet

    Laravel Masterclass

    0
    0
    Free
    Certified Big Data Professional Read More
    Arun Rynet

    Certified Big Data Professional

    0
    0
    Free

    Course Categories

    • Angular
    • Artificial Intelligence
    • ASP.NET
    • Bootstrap
    • CISCO
    • Cloud Computing
    • Data Science
    • Express
    • Intro to Coding
    • JavaScript
    • Laravel
    • MongoDB
    • NOSQL
    • PHP
    • PHP Certification
    • PHP Official
    • Popular
    • Python
    • React
    • React Native
    • SQL Server
    • Vue.js
    • Web Security
    • WordPress

    Quick Links

    HOME
    ABOUT US
    WHY GET CERTIFIED?
    CERTIFICATION
    COURSES
    CONTACT

    Contact Us

    95-2, Block H
    The Suites, Jaya One
    72A, Jalan Universiti
    46200 Petaling Jaya
    Selangor, Malaysia

    +603-7623-1088

    +603-7660-9393

    contact@rynet.com.my

    Grants and Subsidies

    Human Resource Development Funds

    Follow Us on

    Rynet Malaysia© 2017 Rynet Malaysia Sdn Bhd [899837-K]

    • Privacy Policy
    • Terms of Use
    • Designed by Niche Studio