Transcription
A Unit of Sequelgate Innovative Technologies Pvt. Ltd. ISO Certified Training Institute Microsoft Certified PartnerSQL SERVER & T-SQL COURSEComplete Practical & Real-time TrainingMode:Duration:Type:Instructor Led – Inhouse Classroom Training in Hyderabad, IndiaThree Weeks, Weekly 6 days100% Practical. Theory Material provided in AdvanceTraining Highlights Complete Practical and Real-time ScenariosStudy Material and Practice LabsSession wise notes & Doubts ClarificationsCertification Material & Resume PreparationVideos for Missing Sessions & Doubts Clarifications24x7 LIVE Server Access with TWO DatabasesInterview Preparation and GuidanceTechnical Support and Placements Assistance One Real-time Case Study and FAQs with Answers Mock Interview and Course Completion CertificateAll Training Sessions are Completely Practical & Real-time.SQL School (SequelGate Innovative Technologies Pvt. Ltd.), #108/2RT, Road No: 1, Beside Bus Stop, SR Nagar,Hyderabad - 38, India. CREDITS: ISO Certified Learning Center. Microsoft Certified Learning Partner.www.sqlschool.com
SQL SERVER & T-SQL (DEV) TrainingAll Our Training Sessions are COMPLETELY PRACTICAL & REALTIME with Hands-On Lab.Course includes: Study Material, Practice Material, 24x7 LIVE Server Access and a Real-time ProjectChapter 1: SQL Server Introduction & Installation SQL Server 2012 & 2014 Installation Services, Service Accounts and Usage Authentication Modes, Security, Logins Instance Configuration Options & Rules SQL Server Components and Features Configuration Tools, Services and Use Naming Conventions & Collation Settings Using Management Studio (SSMS) Tool Post Installation Procedures and WMI Firewall Settings, Remote ConfigurationChapter 10: Triggers and Memory Limitations Triggers - Architecture, Types & Usage DML Triggers and Performance Impact INSERTED and DELETED Memory Tables Data Validations with Triggers & Cloning Triggers for Audit Operations (Memory) Triggers for Data Sampling & Table Cloning Database Triggers and Usage Options Server Triggers (DDL) and Usage Options Triggers for Bulk Operations (SELECT.INTO) Triggers for Data Audits and MSDTCChapter 2: SQL Server 2012/2014 Database DesignChapter 11: Cursors, Stored Procedures, CTE Cursor Declaration and Fetch Options STATIC and DYNAMIC Cursor Types SCROLL and FORWARD ONLY Cursors LOCAL and GLOBAL Cursors - Scope KEYSET Cursors and Temp Objects Embedding Cursors in SPs and Functions Temp Tables and Procedures with Cursors Common Table Expressions (CTE) and Queries Stored Procedures with CTE : Tuning Options SQL Server Database ArchitectureSQL Server Database Creation using GUIDatabase Creation using T-SQL ScriptsDB Design using Files and File GroupsFilegroups For Capacity Planning (Storage)File Locations and File Size ParametersDatabase Log Files, Growth and PlacementDB Structure Modifications and OwnershipUI Limitations and ALTER Command OptionsChapter 3: SQL Server Tables and T-SQL Queries Table creation using T-SQL Scripts SQL Server Tables and Filegroup Routing DML Operations: INSERT, UPDATE, DELETE Single Row and Multi-Row Insert Statements Table Aliases, Column Aliases & Usage Table creation with Schemas & Filegroups DELETE Versus TRUNCATE Statements SELECT Queries, Variants and Sub Queries Schemas and Nested Queries with Aliases Temporary Tables & Usage, PerformanceChapter 4: Constraints, Keys and Data Validation Data Integrity and Normal Forms (BCNF)Chapter 12: Understanding Real-time Databases Real-time Project Implementation Requirement Analysis & OLTP Modelling Identifying Entities and DB Objects ER (Entity Relation) Models for OLTP Database Diagrams and Scripting Data Sheets and DB Documentation Normal Forms and Types in DB Design Advantages of BCNF Normal Form Technical Specifications and DB Design Relations, Coding Notations, Process Data Type Checks and Column Integrity Schema and Filegroup Implementation Synonyms and Object Level AccessSQL School (SequelGate Innovative Technologies Pvt. Ltd.), #108/2RT, Road No: 1, Beside Bus Stop, SR Nagar,Hyderabad - 38, India. CREDITS: ISO Certified Learning Center. Microsoft Certified Learning Partner.www.sqlschool.com
Tables with Keys & Constraints (BCNF)NULL and IDENTITY Properties - UsageUNIQUE KEY Constraint and NOT NULLPRIMARY KEY Constraint & ImportanceFOREIGN KEY and REFERENCE AttributesCHECK and DEFAULT Constraints, UsageDuplicating Identity, Disabling ConstraintsChapter 5: Joins, Sub Queries and Nested Queries SELECT Statements - IIF, SWITCH, CHOOSE ORDER BY, GROUP BY, GROUPING, HAVING Sub Queries, Nested Queries and EXISTS DELETE from SELECT, UPDATE from SELECT INSERT INTO . SELECT & Data Copy Inner Joins - Purpose and Performance Outer Joins - Types, Advantages and Usage Cross Joins - Advantages and Limitations Self Joins, Merge Joins and Sub QueriesChapter 6: Joins, Views and Nested Queries Benefits of Views - End User AccessDefining Views on Tables and ViewsCHECK OPTION Usage & View level CascadesSCHEMABINDING and ENCRYPTION OptionsALTER TABLE Issues and Solutions with ViewsSystem Views & Management Views : AuditsOrphan Objects, Table SynchronizationsJoins and Nested Sub Queries in Views System Objects and Metadata AccessMERGE, PIVOT, Clone OperationsChapter 13: Data Access in Multi Server Environment Linked Servers and Data Distribution Configuring Linked Servers (Remote) sp addlinkedserver & sp addsrvlogin SQL Server & Non-SQL Server Products Using MSDTC for Remote Queries Using OPENROWSET for Remote Queries Multi User and Multi Database Access Real-world Query Blockings & Solutions Self Joins and CTEs - Query Tuning Using CTE and Temp Tables in SProcsChapter 14: Transactions in Procedures , Functions Understanding Transactions Concepts ACID Properties, Transaction Types EXPLICIT Transactions and Usage IMPLICIT Transaction Types, Options AUTOCOMMIT Transaction Advantages Transactions Nesting - Rules & Usage SAVEPOINT, Query Blocking Scenarios Lock Hints and Remote CTE QueriesChapter 7: User Defined Functions and Joins Functions - Syntax, Usage and Importance Scalar Valued Functions and Examples Table Valued Functions and Examples SCHEMABINDING and ENCRYPTION Options System Functions and Joins - CROSSAPPLY Date, Time and Conversion Functions String Functions and Meta-data Functions ROWCOUNT, GROUPING, ROLLUP Functions Joining Functions and Tables / ViewsChapter 15: XML Data and Full Text Search XML Formats and Query Options Sub Queries in T-SQL with XML Related Sub Queries with XML XML PATH and Custom ROOT Options Indexing XML Data for Performance XML Operations on Views, Synonyms Nested Queries & XML Limitations KEYSET Cursors with XML Options Full Text Search Service Options Full Text Catalog and FT Indexes Storing BLOB / CLOB Data (Docs, Pdf) BULK.INSERT Commands - Options OPENROWSET and Bulk Data LoadsChapter 8: Indexes and Query Tuning Need for Indexes, Index Types & Usage Indexing Table and View Columns Index SCAN, SEEK and LOOP Operations Composite Indexed Columns & Keys Materializing Views (Indexed Views) RIDs, KEYs and Column ConstraintsChapter 16: SQL Server Architecture Gearing for 70-461 Certification Client Server Architecture - Detailed TCP/IP, Named Pipes, Shared Memory TDS Packets and Network Options Storage Architecture, Transaction, IO Query Parse, Optimizer, Mini LSNSQL School (SequelGate Innovative Technologies Pvt. Ltd.), #108/2RT, Road No: 1, Beside Bus Stop, SR Nagar,Hyderabad - 38, India. CREDITS: ISO Certified Learning Center. Microsoft Certified Learning Partner.www.sqlschool.com
PRIMARY KEYS and Non Clustered IndexesINCLUDED Column Indexes & TuningTuning Joined Data Sets: Tables/ViewsChapter 9: Stored Procedures and Benefits Need for Stored Procedures & Syntax Use of Variables and Query Parameters Stored Procedures with Loops & IF . ELSE SCHEMABINDING and ENCRYPTION Options INPUT, OUTPUT & RESULTSET Parameters System Stored Procedures and Nesting Dynamic SQL Queries and Parameters Stored Procedures , Data Validation Options OUTPUT Parameters and Resultset OptionsWrite Ahead Log, Lazy Writer ThreadsSQL Engine and SQL Manager @ QuerySQLOS and Thread, Log SchedulersCourse Highlights:Normal Forms, Joins, Views, StoredProcedures, CTEs, Indexed Views, ExecutionPlans, Triggers, Linked Servers, QueryBlocking, Remote Queries and Sub Queries,Nested Queries, Tuning Recursive Queries,Query Hints, FTS, Architecture and lot more.!Pre-requisites for this Course:This is a starter course, no pre-requisites required. We provide free orientation classes for starters!Course includes Study Material, Interview & Certification guidance along with one Real-time Case Study.About Trainer:Mr. Sai Phanindra Tholeti is a Database Consultant working for his own company - SequelGateInnovative Technologies Pvt. Ltd. With more than 9 years of expertise and passion for SQL Server,Administration (SQL DBA) and Business Intelligence (MSBI) - Mr. Sai provides Data Hosting, BusinessConsulting and Technical Support Services for Corporate Clients. All his training sessions arecompletely practical, real-time and highly interactive.Complete profile of the trainer available @ http://www.linkedin.com/in/saiphanindraJoining Procedure:Participant needs to attend for a free demo. Registrations accepted after attending the demo session.For Free Demo / Further Clarifications, please reach us.SQL SchoolSequelGate (I) Technologies Pvt. Ltd.#108/2RT, Road No: 1, Beside Bus Stop,SR Nagar, Hyderabad - 38 (India). [email protected] 91-9666440801 (INDIA)Skype: SQL School 91-9542916779 (INDIA) 91-(0)40 64577244 (INDIA) 1-510-400-4845 (USA/Canada)SQL School (SequelGate Innovative Technologies Pvt. Ltd.), #108/2RT, Road No: 1, Beside Bus Stop, SR Nagar,Hyderabad - 38, India. CREDITS: ISO Certified Learning Center. Microsoft Certified Learning Partner.www.sqlschool.com
Why Choose Us? Complete Practical and Real-time SessionsStudy Material and Practice LabsCertification Material & Resume PreparationInterview Questions, Preparation and GuidanceOne Mock Interview per CourseTechnical Support and Placements AssistanceVideos for Missing Classes24x7 LIVE Server Access with TWO DatabasesISO Certified Training OrganizationAuthorized Microsoft Partner (ID# 4338151)For Course Fee and Free Demo schedules, you may also refer to http://sqlschool.com/Register.htmlWe ASSURE you on complete practical, real-time training services.Thank You!SQL School (SequelGate Innovative Technologies Pvt. Ltd.), #108/2RT, Road No: 1, Beside Bus Stop, SR Nagar,Hyderabad - 38, India. CREDITS: ISO Certified Learning Center. Microsoft Certified Learning Partner.www.sqlschool.com
SQL Server Components and Features Configuration Tools, Services and Use Naming Conventions & Collation Settings Using Management Studio (SSMS) Tool Post Installation Procedures and WMI Firewall Settings, Remote Configuration Chapter 2: SQL Server 2012/2014 Database Design SQL Server Database Architecture SQL Server Database Creation using GUI
