- الموقع: Bukit Merah - Central
- مدة الدورة التدريبية: 5 Days
تفاصيل الدورة
This course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLRare also covered in this course.
Course Outline
- Lesson 1: Introduction to SQL Server 2012 and its Toolset
- Lesson 2: Working with Data Types
- Lesson 3: Designing and Implementing Tables
- Lesson 4: Ensuring Data Integrity through Constraints
- Lesson 5: Planning for SQL Server 2012 Indexing
- Lesson 6: Implementing Table Structures in SQL Server 2012
- Lesson 7: Reading SQL Server 2012 Execution Plans
- Lesson 8: Improving Performance through Nonclustered Indexes
- Lesson 9: Designing and Implementing Views
- Lesson 10: Designing and Implementing Stored Procedures
- Lesson 11: Merging Data and Passing Tables
- Lesson 12: Designing and Implementing UserDefined Functions
- Lesson 13: Creating Highly Concurrent SQL Server 2012 Applications
- Lesson 14: Handling Errors in T-SQL Code
- Lesson 15:Responding to Data Manipulation via Triggers
- Lesson 16: Implementing Managed Code in SQL Server 2012
- Lesson 17: Storing XML Data in SQL Server 2012
- Lesson 18: Querying XML Data in SQL Server
- Lesson 19: Working with SQL Server 2012 Spatial Data
- Lesson 20: Working with Full-Text Indexes and Queries
Prerequisites
- Knowledge of writing T-SQL queries.
- Knowledge of basic relational database concepts.
نبذة عن معهد New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
عرض الجميع دورات New Horizons SingaporeSQL Server أسئلة ذات صلة
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- SQL Database Administrator StudyHub49 درهم
955 درهممدة الدورة التدريبية: Upto 8 Hours - Oracle 12c OCP 120-061: SQL Fundamentals Study 365186 درهممدة الدورة التدريبية: Upto 16 Hours