- Duration: 5 Days
- Timings 10:00 AM- 6:00 PM
New Horizons is a Microsoft Gold Certified Partner for Learning Solutions, which ensures clients receive high quality training from a Microsoft approved, endorsed and accredited provider
Who is this course for?
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.
What will I learn (topics, modules, skills etc)?
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
This course helps people prepare for exam 70-461.
How will I benefit from taking this course/What career paths will be open to me?
After completing this course, students will be able to:
- Write SELECT queries
- Query multiple tables
- Use built-in functions
- Use subqueries
- Execute stored procedures
- Use set operators
- Implement error handling
- Implement transactions
- Use table expressions
- Sort and filter data
- Use window ranking, offset and aggregate functions
- Query SQL Server metadata
- Program with T-SQL
- Improve query performance
How will I be assessed?
Before attending this course, students must have:
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
About New Horizons Computer Learning Center-Abu Dhabi
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. For 30 years, New Horizons has provided more than 30 million students with industry-leading technical training that delivers the most relevant and intuitive computer courses and certifications. We’re now the world’s largest independent IT training company, and we continue to lead:
- 300 computer training centers in 70 countries (and counting)
- Largest Guaranteed-to-Run course schedule in the world
- Ranked in the top 5% of the industry for training quality and customer satisfaction
- Official training partner for technology leaders such as Microsoft, Cisco, CompTIA and VMware
- Microsoft’s largest training provider, delivering more than 40% of all authorized Microsoft training worldwide
- World’s largest Cisco-authorized training partner
New Horizons is an authorized partner to the top technology providers. For students that means training with the highest quality source materials and the latest products and technologies. For businesses it means getting the highest return on their training investment.
Invest in courses and certifications that advance careers:
The largest Guaranteed-to-Run course schedule in the world includes an extensive array of vendor-authorized IT training and all the in-demand Microsoft, Cisco, CompTIA and VMware certifications.
Learn in your own way:
All of New Horizons’ award-winning learning methods deliver the same comprehensive content—in online and traditional classroom settings, at your worksite, and self-paced with one-on-one support.
Continuously upgrade the people who drive your business:
We’ll create innovative training solutions that work for your business and we’ll account for the results—whether your company is small, mid-sized or a global enterprise. New Horizons training yields a 4:1 benefit-to-cost ratio, based on manager surveys of the improved performance and productivity immediately following our training.See all New Horizons Computer Learning Center-Abu Dhabi courses