Course Brief

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. with two or more years of experience, who are seeking to prove their skills and knowledge in writing queries. Primary responsibilities may include but are not limited to:
  • Apply built-in scalar functions.
  • Apply ranking functions.
  • Combine datasets.
  • Create and alter DML triggers.
  • Create and alter indexes.
  • Create and alter stored procedures.
  • Create and alter tables.
  • Create and alter user-defined functions (UDFs).
  • Create and alter views.
  • Create and modify constraints.
  • Design T-SQL stored procedures.
  • Design views.
  • Implement aggregate queries.
  • Implement data types.
  • Implement error handling.
  • Implement subqueries.
  • Implement the sequence generator
  • Manage transactions.
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Modify data by using MERGE statements.
  • Optimize queries.
  • Query  and Manage XML data.
  • Query data by using SELECT statements.
  • Return data by using the OUTPUT clause.

 

Upon completion of this program students can move on to the Administering Microsoft SQL Server 2012 Databases (70-642) program.


  • This course is offered in 30 hours
This course is intended for SQL Server database administrators, implementers, system engineers, and developers. with two or more years of experience, who are seeking to prove their skills and knowledge in writing queries. Primary responsibilities may include but are not limited to:
  • Apply built-in scalar functions.
  • Apply ranking functions.
  • Combine datasets.
  • Create and alter DML triggers.
  • Create and alter indexes.
  • Create and alter stored procedures.
  • Create and alter tables.
  • Create and alter user-defined functions (UDFs).
  • Create and alter views.
  • Create and modify constraints.
  • Design T-SQL stored procedures.
  • Design views.
  • Implement aggregate queries.
  • Implement data types.
  • Implement error handling.
  • Implement subqueries.
  • Implement the sequence generator
  • Manage transactions.
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Modify data by using MERGE statements.
  • Optimize queries.
  • Query  and Manage XML data.
  • Query data by using SELECT statements.
  • Return data by using the OUTPUT clause.

 

Champs Fleurs

There are no classes scheduled in Champs Fleurs at this time.

  • Microsoft Certified Solutions Associate (MCSA): SQL Server 2012

    The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification demonstrates your essential skills and breakthrough insights in developing and maintaining the next wave of mission critical environments.

    This certification qualifies you for a position as a software or database developer or database analyst.It consists of the following modules and each module is covered in 30 contact hours.


    Why Study MCSA:SQL Server with SBCS?

    • Instructors are certified, highly skilled and experienced practitioners who bring their knowledge and work experience to the classroom.
    • Course is career oriented. The curriculum was developed to meet the needs of the current marketplace.
    • The course is practical. All sessions are held in a lab and each participant has access to a computer.
    • Modern, fully equipped labs. You learn using the same hardware and software that you will encounter in the field.
    • Convenient class schedules. Classes are offered part-time at one location. This allows working individuals to balance their work and educational needs.
    • Sufficient contact hours to cover the full syllabus and prepare participants for the Microsoft exams.
    • Microsoft exams can be written at your convenience at our Champs Fleurs campus through our testing center.

    SCHEDULE & FEES

    This programme is available for Corporate Training.  Please contact us for a quotation.