Developing Microsoft SQL Server 2012 Online Course in South Africa
2KO South Africa offers online Developing SQL Databases courses in South Africa. We also offer full time Developing SQL Databases courses in Cape Town for groups of four or more delegates. 2KO South Africa's SQL course is offered to our international and local students. 2KO Africa conducts IT training and certification, as well as offering a large catalogue of online computer courses, to ensure students have access to the best Developing SQL training in South Africa.
2KO South Africa's Developing SQL Databases course in South Africa is intended specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around Developing Microsoft SQL Server 2012 Databases. 2KO South Africa also offers online courses to our international and local students. This course is designed for Database developers who build and implement databases across the organization, while ensuring high levels of data availability. They perform tasks including creating database files, create data types, tables, plan create and optimize indexes, implement data integrity, implement views, stored procedures and functions, manage transactions and locks.
Primary responsibilities may include:
Optimizing and tuning queries.
Creating and altering indexes and stored procedures.
Maintaining database integrity.
Optimizing indexing strategies.
Creating and altering tables.
Creating and modifying constraints.
The 2KO Africa course on developing Microsoft SQL Server 2012 Databases prepares participants for the Microsoft Exam 70-464.
This course will provide all the skills and knowledge for the following areas:
Creating and altering tables (complex statements)
Designing, implementing, and troubleshooting security
Designing the locking granularity level
Implementing data types
Creating and modifying constraints (complex statements)
Working with XML Data
Writing automation scripts
Designing and implementing stored procedures
Designing T-SQL table-valued and scalar functions
Creating, using, and altering user-defined functions (UDFs)
Creating and altering views (complex statements)
Designing for concurrency
Creating and altering indexes
Designing data integrity
Designing for implicit and explicit transactions
Optimizing and tuning queries
Troubleshooting and resolving performance problems
Optimizing indexing strategies
Capturing and analyzing execution plans
Collecting performance and system information
Developing Microsoft SQL Server 2012 Databases
Introduction to SQL Server 2012
SQL Server Tools
SQL Server Management Studio
SQL Data Tools
Utilizing SQL Server Tools
Introduction to Data Types and Tables
Converting Data Types
Introduction to Tables
Working with Tables
Primary and Foreign Keys
In Depth Look
SQL Server Indexing
Introduction to Indexing
Non Clustered Indexes
Creating and Altering Indexes
Reading Execution Plans
Execution Plan Operators
Common Language Runtime (CLR) Integration
Integrating the CLR within SQL Server
Transact-SQL (T-SQL) Error Handling
TRY CATCH Error Handling
TRY PARSE and TRY CONVERT
Error Handling in T-SQL
Views and Functions
Types of Views
Working with Views
Introduction to Functions
Working with Functions
Working with Views and Functions
Stored Procedures and Triggers
Working with Stored Procedures
Introduction to Triggers
Working with Triggers
Stored Procedures and Triggers Demo
Working with XML
Schemas and Schema Collections
FOR XML Clause
Working with XML in SQL Server
Working with Transactions and Locking within SQL