XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.
This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.
Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com
Phone: +27 10 020 2067
Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684
Head Office - South Africa 16 Monte Carlo Crescent Kyalami business Park Johannesburg South Africa 1684 Mail: info@icollege.co Phone: +27 10 020 2067
Developing Microsoft SQL Server 2012 Databases training prepares Database developers to build their skills in developing and implementing databases while ensuring a high level of data availability. This course is in preparation for the 70-464 Developing Microsoft SQL Server 2012 Databases exam. This course covers logical table design, indexing, and query plans, and focuses on the creation of database objects including views and stored procedures, along with parameters and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.
This training course on developing Microsoft SQL Server 2012 Databases prepares participants for the Microsoft Exam 70-464.
Module 1: SQL 2012 And The 464 Test
1.1 Introduction
1.2 Intro To SQL Server 2012 Part 1
1.3 Intro To SQL Server 2012 Part 2
1.4 Management Studio Demo Part 1
1.5 Management Studio Demo Part 2
1.6 Management Studio Demo Part 3
1.7 Other SQL Server Tools
Module 2: Working With Data Types
2.1 Working With Data Types Part 1
2.2 Working With Data Types Part 2
2.3 Working With Data Types Part 3
2.4 Other Data Types
Module 3: Tables
3.1 Tables
3.2 Creating Tables
Module 4: Data Constraints
4.1 Data Constraints Part 1
4.2 Data Constraints Part 2
Module 5: Planning In Indexing
5.1 Planning In Indexing Part 1
5.2 Planning In Indexing Part 2
5.3 Planning In Indexing Part 3
5.4 Planning In Indexing Part 4
Module 6: Table Structures
6.1 Table Structures
6.2 Working With Clustered Indexes
6.3 Clustered Indexes
6.4 Designing Effective Clustered Indexes
Module 7: Improving Performance with NonClustered Indexes
7.1 Improving Performance With NonClustered Indexes Part 1
7.2 Improving Performance With NonClustered Indexes Part 2
7.3 Improving Performance With NonClustered Indexes Part 3
Module 8: Using Indexes And Execution Plans
8.1 Using Indexes
8.2 Execution Plans Part 1
8.3 Execution Plans Demo
8.4 Execution Plans Part 2
Module 9: Working with Views
9.1 Working With Views Part 1
9.2 Working With Views Part 2
Module 10: Designing and Implementing Stored Procedures
10.1 Designing And Implementing Stored Procedures Part 1
10.2 Designing And Implementing Stored Procedures Part 2
10.3 Designing And Implementing Stored Procedures Part 3
Module 11: Merging Data and Passing Tables
11.1 Merging Data And Passing Tables Part 1
11.2 Merging Data And Passing Tables Part 2
11.3 Merging Data And Passing Tables Part 3
Module 12: Designing and Implementing User Functions
12.1 Designing And Implementing User Functions
Module 13: Creating Highly Concurrent SQL Server Applications
13.1 Creating Highly Concurrent SQL Server Applications Part 1
13.2 Creating Highly Concurrent SQL Server Applications Part 2
13.3 Creating Highly Concurrent SQL Server Applications Part 3
Module 14: Handling Errors in TSQL
14.1 Handling Error In TSQL Part 1
14.2 Handling Error In TSQL Part 2
Module 15: Triggers
15.1 Triggers
Module 16: Implementing Managed Code
16.1 Implementing Managed Code Part 1
16.2 Implementing Managed Code Part 2
16.3 Implementing Managed Code Part 3
Module 17: Storing XML in SQL
17.1 Storing XML In SQL Part 1
17.2 Storing XML In SQL Part 2
17.3 Storing XML In SQL Part 3
Module 18: Querying XML
18.1 Querying XML Part 1
18.2 Querying XML Part 2
18.3 Querying XML Part 3
Module 19: Working with the Spatial Data
19.1 Working With Spatial Data Part 1
19.2 Working With Spatial Data Part 2
19.3 Working With Spatial Data Part 3
Module 20: Working With FullText Indexes and Queries
20.1 Working With Full Text Indexes And Queries Part 1
20.2 Working With Full Text Indexes And Queries Part 2
20.3 Working With Full Text Indexes And Queries Part 3
20.4 Outro
| USD 195 | USD 95 | 51% OFF |
