- Other Location: Bukit Merah - Central
- Duration: 5 Days
Course details
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.
Course Location
About 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
See all New Horizons Singapore courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Big Data Hadoop: SQL & NoSQL Skill-UpSGD 18Duration: Upto 23 Hours
- Microsoft SQL Server Bootcamp 2022 Course LineSGD 32Duration: Upto 7 Hours
