[vc_row][vc_column][vc_single_image image=”912″ img_size=”full”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

COURSE CONTENT :<\/strong><\/h5>\n

SQL Server & T-SQL installation, Architecture, DB[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Job Roles,\u00a0Installation :<\/strong><\/h5>\n

Introduction to Databases, DBMS
\nMicrosoft SQL Server : Advantages, Use
\nVersions and Editions of SQL Server
\nSQL DBA Job Roles, Responsibilities
\nRoutine Maintenance DBA Activities
\nEmergency SQL DBA Activities
\nSQL Server Prerequisites : S\/W, H\/W
\nSQL Server 2019\/2017\/2016 Installation
\nDefault Instance, Named Instances
\nPort Numbers, Instance Differences
\nService and Service Account Use
\nAuthentication Modes and Logins
\nFirewall Configuration in Real-time
\nSQLServr.exe and SQLBrowser.exe[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

SSMS Tool, SQL Basics :<\/strong><\/h5>\n

SSMS Tool Installation, Connections
\nSQL Server Management Studio
\nSingle Server, Multi Server Connections
\nSystem Databases: Master and Model
\nMSDB, TempDB, Resource Databases
\nSQL and T-SQL : Basic Differences
\nDDL, DML, SELECT Statements
\nUsing GUI and SQL Scripts in SSMS
\nCreating Databases : Files [MDF, LDF]
\nCreating Tables in SQL Server
\nData Storage in Tables : Inserts
\nSELECT : Data Retrieval Statement
\nTable Scans. LIVE QUERY STATISTICS
\nLimitations with SSMS GUI Options[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

SQL for DBAs :<\/strong><\/h5>\n

Creating Databases in SQL Server
\nDatabase Connections and Usage
\nCreating Tables and Data Storage
\nData Inserts and SELECT Statement
\nWHERE Conditions and Keywords
\nIN Operator and NOT IN Operator
\nBetween, Not Between Operators
\nLIKE and NOT LIKE Operators
\nUPDATE Statement & Conditions
\nDELETE & TRUNCATE Statements
\nLogged and Non-Logged Operations
\nTable Structure Modifications
\nADD, ALTER and DROP Columns
\nAliases and Batch Statements[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Schemas, Temporary Tables :<\/strong><\/h5>\n

Schemas : Group Tables in Database
\nSchemas : Security Management Object
\nCreating Schemas & Batch Concept
\nUsing Schemas for Table Creation
\nData Storage in Tables with Schemas
\nData Retrieval and Usage with Schemas
\nTable Migrations across Schemas
\nImport and Export Wizard in SSMS
\nData Imports with Excel File Data
\nPerforming Bulk Operations in SSMS
\nTemporary Tables : Real-time Use
\nLocal and Global Temporary Tables
\n# and ## Prefix, Scope of Usage
\nSession Level, Connection Level Use[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Constraints, Indexes :<\/strong><\/h5>\n

Constraints and Keys \u2013 Data Integrity
\nNULL, NOT NULL Property on Tables
\nUNIQUE KEY Constraints: Importance
\nPRIMARY KEY Constraint: Importance
\nFOREIGN KEY Constraint: Importance
\nREFERENCES, CHECK and DEFAULT
\nCandidate Keys and Identity Property
\nDatabase Diagrams and ER Models
\nRelationships Verification and Links
\nIndexes : Basic Types and Creation
\nIndex Sort Options, Search Advantages
\nClustered and Non Clustered Indexes
\nPrimary Key and Unique Key Indexes
\nNeed for Indexes \u2013 working with Keys[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Joins &Audits :<\/strong><\/h5>\n

JOINS \u2013 Table Comparisons Queries
\nINNER JOINS For Matching Data
\nOUTER JOINS For (non) Match Data
\nLeft Outer Joins with Example Queries
\nRight Outer Joins with Example Queries
\nFULL Outer Joins \u2013 Real Time Scenarios
\nJoin Queries with \u201cON\u201d Conditions
\nJoin Unrelated Tables in SQL Server
\nNULL, IS NULL Operators in Joins
\nCROSS JOIN and CROSS APPLY
\nCROSS JOIN Versus CROSS APPLY
\nOne-way &Two Way Data Comparisons
\nImportant Join Queries in T-SQL
\nJoin Options: Merge, Loop, Hash[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

View, Procedures, UDF Basics :<\/strong><\/h5>\n

Views : Types, Usage in Real-time
\nSystem Predefined Views and Audits
\nListing Databases, Tables, Schemas
\nFunctions : Types, Usage in Real-time
\nScalar, Inline and Multi-Line Functions
\nSystem Predefined Functions, Audits
\nDBId, DBName, ObjectID, ObjectName
\nDate and Time Functions : Getdate()
\nVariables & Parameters in SQL Server
\nProcedures : Types, Usage in Real-time
\nUser & System Predefined Procedures
\nParameters and Dynamic SQL Queries
\nSp_help, Sp_helpdb and sp_helptext
\nsp_pkeys, sp_rename and sp_help
\nsp_recompile, Performance Benefits
\nSystem Objects for Metadata Access[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Transactions, Linked Servers :<\/strong><\/h5>\n

Linked Servers and Real-time Usage
\nCreating Linked Servers in SQL Server
\nSecurity Options and Access Options
\nData Access, RPC and RPC Out Settings
\nAutomations with Triggers: DML,DDL
\nINSERTED, DELETED Memory Tables
\nTable Data Replication using Triggers
\nTransactions : Types, ACID Properties
\nTransaction Types and AutoCommit
\nEXPLICIT & IMPLICIT Transactions
\nCOMMIT and ROLLBACK Statements
\nSQL Server Configuration Manager Tool
\nServices : Start and Stop Options
\nNetwork Configurations and Protocols
\nSQL Server Instance: Ports, Aliases[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Server, DB Architecture :<\/strong><\/h5>\n

Server Architecture and Protocols
\nDatabase Engine and Query Processor
\nParser, Optimizer, SQL & DB Manager
\nStorage Engine Components, SQL OS
\nFile Manager and Database Files
\nTransaction Services, Buffer Manager
\nLock Manager, IO Manager, MDAC
\nCLR, WAL, Lazy Writer, Checkpoint
\nDatabase Architecture \u2013 Data Files
\nDatabase Architecture \u2013 Log Files
\nPrimary (mdf), Secondary Files (ndf)
\nFilegroups Usage, ReadOnly Filegroups
\nDatabase Files : Size and Location
\nPages, Extents. Uniform, Mixed Extents
\nTransaction Log File [LDF], LSN, VLF[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

SQL DBA \u2013 Backup-Restores, Jobs, Performance Tuning, Security :<\/strong><\/h4>\n

[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Backups \u2013 DB, Filegroup, File :<\/strong><\/h5>\n

Database Backups, Filegroup Backups
\nLog File Backups and Log Truncations
\nCOPY_ONLY Backups and Real-time Use
\nMirror Backups and Split Backups
\nPartial Backups \u2013 ReadOnly Filegroups
\nFormat, Compression and Checksum
\nBackup Verification, RetainDays, Stats
\nContinueOnError and Backup Scripts
\nGUI and Script Backups: Differences
\nBackup History Tables in MSDB \u2013 Joins
\nBackup Audits. HOT and COLD Backups
\nBackup Devices \u2013 Creation and Usage
\nUsing Backup Devices \u2013 Advantages
\nCommon Errors and Solutions[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Restores & DB Recovery :<\/strong><\/h5>\n

Restore Phases \u2013 COPY, REDO, UNDO
\nRECOVERY, NORECOVERY Options
\nSTANDBY and REPLACE in Restores
\nFile, File Group & Metadata Restores
\nBackup Verifications using GUI, Scripts
\nVERIFYONLY : Backup Verification
\nSTATS, UNLOAD, STOPAT and INIT
\nPARTIAL \/ PIECEMEAL Restores \u2013 Use
\nTail Log Backup Usage in Real-time
\nRestores using GUI and T-SQL Scripts
\nMOVE Options for File Level Restores
\nPoint-In-Time Restore, Checkpoint LSN
\nStandby Restores and Read-Only State
\nCommon Errors and Solutions[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Jobs, Maintenance Plans :<\/strong><\/h5>\n

SQL Server Agent Service & Agent XPs
\nSQL Agent Jobs \u2013 GUI, Script Creations
\nJob Steps \u2013 Creation, Edits and Parse
\nJob Executions, Disable\/Enable Options
\nJob History Purge. Job Activity Monitor
\nDatabase Maintenance \u2013 Backup Jobs
\nScheduling Database Maintenance Plans
\nAutomated Job Creations using DMPs
\nBackup Cleanup & History Cleanup Jobs
\nBackup Strategies For Minimal Data Loss
\nBackup Options: Block Size, Transfer Size
\nDB Mail Configurations and Alert System
\nDB Mail Profiles, SMTP Email Accounts
\nOperators : Creation, Job Notifications[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Security Management :<\/strong><\/h5>\n

Authentication Types & Modifications
\nWindows Logins & SQL Server Logins
\nLogins \u2013 Users Mapping, DB Access
\nServer Roles & Database Roles \u2013 Usage
\nObject, Column and Schema Security
\nGRANT, WITH GRANT, DENY, REVOKE
\nCONTROL, OWNERSHIP, Authorization
\nData Encryption: Keys and Certificates
\nData Encryption with Stored Procedures
\nJob Security : Credentials and Proxies
\nUsing Proxies for SSIS Jobs, Repl Jobs
\nSecurity Scripts and Documentation
\nDMVs for Security Audits, Orphan Users
\nLogin, User, Server Principal Audits[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Migrations & SLA-OLA :<\/strong><\/h5>\n

CDW : Copy Database Wizard @ SSMS
\nDatabase Detach and Attach Options
\nSMO Method and Database Scripting
\nCDW SSIS Packages, SSIS Proxies Use
\nScheduling Database Migration Jobs
\nDetecting and Resolving Orphan Users
\nContainment Databases Authentication
\nSLA and OLA Process, Ticketing Tools
\nImmediate, High, Normal Priorities
\nImpact, Urgency and SLA Metrics
\nLicensing and Pricing Options
\nCore Based Licenses. Device CALs
\nUser CALs and Multiplexing Concept
\nVersions, Editions Comparisons[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Tuning 1 \u2013 Audits, Indexes :<\/strong><\/h5>\n

Audit Long Running Queries : DMV, DMF
\nActivity Monitor Tool, Server Dashboards
\nLogical I\/O, Physical I\/O, Database I\/O
\nRecent Expensive Queries, Wait Time
\nActive Expensive Queries, Statistics
\nPlan Handle, Execution Time \u2013 Audits
\nCPU, IO, Memory Consumption Reports
\nIndexes: Architecture and Index Types
\nB Tree Structure, IAM Page [Root]
\nClustered &NonClustered Indexes
\nIncluded, Columnstore, Online
\nFiltered, Covering, Indexed Views
\nFill Factor and Pad Index Options
\nQuery Store \u2013 Settings and Advantages[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Tuning 2 \u2013 Index Management :<\/strong><\/h5>\n

PARTITIONS : Advantages, Performance
\nPartition Functions & Partition Schemes
\nPartitioning Un-partitioned Tables: GUI
\nPartition Compression : ROW and PAGE
\nAuditing Table Partitioned Structures
\nStatistics : Purpose, Auto Creation
\nStatistics : Audits and Updates
\nWorking with Indexes and Partitions
\nInternal and External Fragmentation
\nIndex Rebuilding Process and Audits
\nDatabase Maintenance Plans Jobs
\nLast Used, Page Count, Fragmentation
\nIndex Page Count and Index Condition
\nDegree Of Parallelism [DOP] Settings
\nResumable Indexes: ONLINE, RESUME
\nPAUSE & RESUME in Index Rebuilds[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Tuning 3 \u2013 Tuning Tools, Locks :<\/strong><\/h5>\n

Tuning Tools : Workload Files, Trace Files
\nProfiler Tuning Template, SP Events
\nDTA, Profiler Trace : Recommendations
\nPerfmon Tool Counters, Real-time Tracking
\nExecution Plan Analysis and Internals
\nQuery Costs : IO Cost and CPU Cost
\nQuery Costs: SubTree& Operator Cost
\nNUMA Nodes, Processor, IO Affinity
\nThread Count, Degree of Parallelism
\nLOCKS : Types and Isolation Levels
\nS, X, IX,U, MD, Sch-M and Sch-S
\nLock Audits : SP_WHO2 and SP_LOCK
\nsysprocesses and Lock Waits : Audits
\nDeadlock Audits and Deadlock Graphs
\nXDL Files and Deadlocks Prevention[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text]<\/p>\n

Health Checks, Issues, Solutions :<\/strong><\/h5>\n

Alerts : Creation and Notifications
\nDB Suspect Event Alerts (023)
\nImportant Perfmon Counters, Alerts
\nLog Space, Memory, Tempdb Alerts
\nScheduling Alerts & Notifications
\nDBCC CHECKDB : DB Health Checks
\nAllocation Errors, Consistency Errors
\nDBCC ShowContig, Extent Fragmentation
\nTrace Flags and EstimateOnly
\nDBCC Page: GAM, SGAM and PFS
\nConsistency Errors : Cause & Solutions
\nAllocation Errors : Cause and Solutions
\nLog Space Issues and Log Rebuilds
\nMemory &TempDB Issues, Solutions
\nDBCC ShrinkDB and Page Restores[\/vc_column_text][\/vc_column][vc_column width=”1\/2″][vc_column_text]<\/p>\n

SQL DBA PROJECT \u2013 Level 1 :<\/strong><\/h5>\n

Audit Login Failures : Server Logs
\nMonitoring Connectivity Issues
\nDatabase Refresh and MSDTC
\nAdhoc Memory Dump Files
\nPLE (Page Life Expectancy) Issues
\nObject Refresh and Recompilations
\nServer Registrations and Operations
\nLock Monitoring Operations
\nIndex Management Options
\nOpen Transactions, Blocking
\nMetadata Sync-up Issues
\nStored Procedure Recompilations
\nBackup and HA-DR Strategies
\nDb Restores and DB Repairs
\nHealth Checks, Issues, Solutions[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

[vc_row][vc_column][vc_single_image image=”912″ img_size=”full”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text] COURSE CONTENT : SQL Server & T-SQL installation, Architecture, DB[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_column_text] Job Roles,\u00a0Installation : Introduction to Databases, DBMS Microsoft SQL Server : Advantages, Use Versions and Editions of SQL Server SQL DBA Job Roles, Responsibilities Routine Maintenance DBA Activities Emergency SQL DBA Activities SQL Server Prerequisites : S\/W, H\/W SQL Server 2019\/2017\/2016 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-539","page","type-page","status-publish","hentry","no-post-thumbnail"],"_links":{"self":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/539","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/comments?post=539"}],"version-history":[{"count":7,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/539\/revisions"}],"predecessor-version":[{"id":918,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/539\/revisions\/918"}],"wp:attachment":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/media?parent=539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}