Querying Microsoft SQL Server® 2014 (20461) part of MCSA SQL Server 2012 / 2014
Details
Outline
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
At Course Completion:
After completing this course, students will be able to:
- Describe the basic architecture and concepts of Microsoft SQL Server 2014.
- Understand the similarities and differences between Transact-SQL and other computer languages.
- 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
Speaker/s
Special Offer
- Courseware (please indicate if you would prefer a hard copy or e-book)
- Online labs for up to 180 days
- Full technical support for 3 months following delivery, for this course.
We are here to promote the core values of our vendors. We promote learning courses and courseware which has been approved by vendors to be accurate and the best material on the market to ensure that you learn the content with a view to certifying in the same area of study.
Our team of delivery specialists, training staff and proctoring team are guided by the principles, codes and requirements of our vendors. We can assure you that the training you will get will be correct and is as was intended by the vendor.
Our trainers are all experienced in their respective fields. Vendor requirements have been met.
In the case of Microsoft training, both public and private courses are provided using:
- active, current Microsoft Certified Trainers experienced in the area who have passed the relevant certification exam.
- official courseware and virtual lab materials only.
- Course management provided in association with a Certified Partner for Learning Solutions (CPLS) centre training provider (where it has not been possible for MBIT to manage the course directly ourselves). ...