Course details
This instructor led 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. Many of the exercises in this course are SQL Azure enabled.
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
- mplementing Transactions
- Use Table Expressions
- Sort and Filter Data
- se Window Ranking, Offset and Aggregate Functions
- Query SQL Server Metadata
- Program with T-SQL
- Improve Query Performance
About NetAssist
Since its establishment in 1999, NetAssist has been continuously and vigorously committed to providing the highest quality of, and effective, training to IT professionals, both novice and experienced. We combine proven curriculum with practical hands-on learning and in-depth instruction to sharpen your technical skills. Our satisfied customers are our motivation and our best testimony.
See all NetAssist courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Developing Microsoft SQL Server 2012 Databases Global EdulinkLKR 31,029
LKR 211,366Duration: Upto 19 Hours - Administering Microsoft SQL Server 2012 Databases Global EdulinkLKR 31,029
LKR 211,366Duration: Upto 16 Hours