Location:Main Road, Bangalore

courses@bangalore.com

Microsoft 70 464 Developing Microsoft Sql Server 2012 Da

Course

MICROSOFT 70 464 DEVELOPING MICROSOFT SQL SERVER 2012 DA

Category

SQL IT Institute

Eligibility

Lateral Entry Professionals and Freshers

Mode

Both Classroom and Online Classes

Batches

Week Days and Week Ends

Duration :

Daily 2 hrs during Weekdays

SQL Objectives

•How to create a SQL Project.
•Learn how to use and interpret SQL.
•Implement SQL in your apps and integrate it.
•Learn about each and every major SQL component.
•Write Compile and Run codes and apps using SQL.
•Will be able to write error free programs in SQL
•Learn A to Z of SQL from Basic to ADVANCE level.
•Build a strong knowledge base on SQL from Scratch to Advanced level
•Learn and understand the fundamentals of SQL and how to apply it to web development.

microsoft 70 464 developing microsoft sql server 2012 da Course Highlights

•Most comprehensive Industrry curriculum
•Get Training from Certified Professionals
•Software & others tools installation Guidance
•We Provide the Course Certificate of completion
•We hire Top Technical Trainers for Quality Sessions
•Project manager can be assigned to track candidates’ performance
•We also provide Normal Track, Fast Track and Weekend Batches also for Working Professionals
•Lifetime access to our 24×7 online support team who will resolve all your technical queries, through ticket based tracking system.

Who are eligible for SQL

•c++, React.js, Java Fullstack, Core Java Data Structure, Java Micro-services, Devops, Microsoft Azure, Cloud Computing, Machine Learning, Automation Testing
•Hyperion Developer, Hyperion Essbase, OBIEE, Oracle BI, Oracle Business Intelligence, Data Warehouse, Oracle Apps Funcitional, Oracle Apps HRMS Technical
•Java, Core Java, J2ee, Ui, Java Fullstack, Front End, Angularjs, Angular, React.js, Java Senior Developers, Java Developers, Java Lead, Ui Lead, Ui Developers
•OBIEE, OBIA, ODI, PHP, QA, Oracle Apps DBA, SQL Sever DBA, Dot Net Developer, Automation Testing, Informatica Developer, UI Designer, Agile PLM
•Sfdc, Software Development, Visualforce, Salesforce, Sale Cloud, Service Cloud, Marketing Cloud, Community Cloud, apex, Salesforce.com, customization, detail

MICROSOFT 70 464 DEVELOPING MICROSOFT SQL SERVER 2012 DA Topics

Developing Microsoft SQL Server 2012 Databases
•Module 1
•Introduction to SQL Server 2012
•SQL Instances
•SQL Editions
•SQL Server Tools
•SQL Server Management Studio
•SQL Data Tools
•SQL Command
•Utilizing SQL Server Tools
•Module 2
•Introduction to Data Types and Tables
•Collations
•Unicode Characters
•Null Values
•Converting Data Types
•Introduction to Tables
•Normalization
•Temporary Tables
•Working with Tables
•Schemas
•Primary and Foreign Keys
•UNIQUE Constraint/Index
•In Depth Look
•Module 3
•SQL Server Indexing
•Introduction to Indexing
•Clustered Indexes
•Non Clustered Indexes
•Maintaining Indexes
•Index Fragmentation
•Index Tuning
•Creating & Altering Indexes
•Module 4
•Query Performance
•Execution Plans
•Reading Execution Plans
•Execution Plan Operators
•Plan Reuse
•Module 5
•Common Language Runtime (CLR) Integration
•Assemblies
•Permissions
•CLR Objects
•Integrating the CLR within SQL Server
•Module 6
•Transact-SQL (T-SQL) Error Handling
•Error Severity
•TRY CATCH Error Handling
•TRY PARSE and TRY CONVERT
•@@ ERROR
•Alerts
•Error Handling in T-SQL
•Module 7
•Views and Functions
•Types of Views
•Working with Views
•Introduction to Functions
•Working with Functions
•Working with Views and Functions
•Module 8
•Stored Procedures and Triggers
•Working with Stored Procedures
•Introduction to Triggers
•Working with Triggers
•Stored Procedures & Triggers Demo
•Module 9
•Working with XML
•XML Concepts
•Schemas & Schema Collections
•FOR XML Clause
•FLOWR Queries
•Working with XML in SQL Server
•Module 10
•Transactions
•Implicit Transactions
•Explicit Transactions
•Locking
•Working with Transactions & Locking within SQL