Querying Microsoft SQL Server® 2014 New Horizons Computer Learning Center
Price: AED 6,300
  • Duration: Upto 5 Days
  • Timings: Part Time, Flexible

    Course details

    Students learn the technical skills to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

    Course Objectives
    After completing this course, students will be able to: •Write SELECT queries •Query multiple tables •Sort and filter data •Describe the use of data types in SQL Server •Modify data using Transact-SQL •Use built-in functions •Group and aggregate data •Use subqueries •Use table expressions •Use set operators •Use window ranking, offset and aggregate functions •• Implement pivoting and grouping sets •Execute stored procedures •Program with T-SQL •Implement error handling •Implement transactions Updated on 24 October, 2017

    About New Horizons Computer Learning Center

    New Horizons is the world’s largest training provider with a global footprint of more than 300 locations in over 70 countries.They have more combined global training experience than any other training provider in the world as an industry leading training provider.   The institute has been awarded more times
    by major vendors than any other training organisation in the world.Their customers have a dedicated account manager who provides advice and guidance regarding training solutions and manages the relationship end-to-end.
            

    See all New Horizons Computer Learning Center courses
    Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or