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
Job roles this course is suitable for:
Microsoft SQL Server Administrator , SQL Database Developer , SQL SupportCourse Location
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.
SQL Server Related Questions
Courses you can instantly connect with... Do an online course on SQL Server starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Querying Microsoft SQL Server 2012 Global EdulinkAED 516
AED 3,502Duration: Upto 16 Hours - Microsoft 70-762 - Developing SQL Databases Global EdulinkAED 374
AED 2,596Duration: Upto 29 Hours
