Price: USD 65
- Duration: 5 Days
Course details
Overview
This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features.
Who Should Attend
This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database. To be successful in this course, the student should have knowledge of basic relational database concepts and writing T-SQL queries
Outline
- Lesson 1: Introduction to SQL Server and its Toolset
- Lesson 2: Working with Data Types
- Lesson 3: Designing and Implementing Tables
- Lesson 4: Designing and Implementing Views
- Lesson 5: Planning for SQL Server Indexing
- Lesson 6: Implementing Table Structures in SQL Server
- Lesson 7: Reading SQL Server Execution Plans
- Lesson 8: Improving Performance through Nonclustered Indexes
- Lesson 9: Designing and Implementing Stored Procedures
- Lesson 10: Merging Data and Passing Tables
- Lesson 11: Creating Highly Concurrent SQL Server Applications
- Lesson 12: Handling Errors in T-SQL Code
- Lesson 13: Designing and Implementing User-Defined Functions
- Lesson 14: Ensuring Data Integrity through Constraints
- Lesson 15: Responding to Data Manipulation via Triggers
- Lesson 16: Implementing Managed Code in SQL Server
- Lesson 17: Storing XML Data in SQL Server
- Lesson 18: Querying XML Data in SQL Server
- Lesson 19: Working with SQL Server Spatial Data
- Lesson 20: Working with Full-Text Indexes and Queries
About IT & Business Consulting Group
Whether you need a one-day onsite training course, full-service consulting, or if you are not really sure which solution will work, we can help.
ITBCG is a leading and innovative learning provider with over twenty years’ experience of providing best in-class learning solutions. We work in partnership with our customers to deliver flexibility, value and service. We develop innovative programs to ensure that every aspect of the learning development, delivery and administration of courses work to our clients’ benefit.
We provide IT and business skills learning to both the private and public sector companies and organizations. Our core training is focused on Cisco, Microsoft, CompTIA Citrix, EC-Council, Oracle, and ISC2 and best practice. This includes ITIL® Service Management and ISO, and PMI which is tied into business process improvement, project management, and business analysis and leadership development.
See all IT & Business Consulting Group courses Are you from IT & Business Consulting Group ? Claim your course!
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
- Microsoft SQL Server for Beginners Alpha AcademyUSD 25
USD 240Duration: Upto 4 Hours - Python + JavaScript + Microsoft SQL Course LineUSD 24Duration: Upto 23 Hours
