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

Start DateEnd DateDaysTimeCash Price
10-Jul-189-Aug-18T/T5:30pm – 8:30pm$3,500

 

Please note that all information given above is subject to change without prior notice.

  • 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

    • All classes are offered in Champs Fleurs.
    • Package price for all 3 modules is $9,765.
    • Payment Plans are available.

    Querying Microsoft SQL Server 2012 (70-461)

    Start DateEnd DateDaysTimeCash Price
    10-Jul-189-Aug-18T/T5:30pm - 8:30pm$3,500

     

    Administering Microsoft SQL Server 2012 Databases (70-462)

    Start DateEnd DateDaysTimeCash Price
    21-Aug-1820-Sep-18T/T5:30pm - 8:30pm$3,500

     

    Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)

    Start DateEnd DateDaysTimeCash Price
    2-Oct181-Nov-18T/T5:30pm - 8:30pm$3,500

    Please note that all information given above is subject to change without prior notice.