By Daniel AG, #1 Database Trainer in USA!!! (*****)
Our Microsoft SQL Server DBA and SQL Programing course help you learn both SQL Programing and Database Administration. The good thing is that there is no prerequisite for the course.
Key topics covered are Database Concepts, SQL Programming, SQL Server Installation & Configuration, Database Administration, High Availability, Disaster Recovery, Azure SQL, Performance Tuning, etc.
As part of this training, you will also receive the official course material issued by Microsoft for Querying Data with Transact-SQL and Administering Microsoft® SQL Server® Databases.
For course details and registration, please get in touch with Daniel at +1 267 718 1533 (Mobile & Whatsapp). We are based in Philadelphia, USA, and host affordable and comprehensive SQL Server/Azure/AWS/DevOps training programs for students around the globe.
Daniel has 16 years' extensive experience in SQL Server Administration, SQL Programming, Business Intelligence Development (SSAS, SSIS, SSRS), Data Visualization (Power BI) and Performance Tuning. Daniels's diverse experience has given him a wide understanding of how Data Design, Data Architecture, Data Management, Data Administration, Security, and System Architecture all come together forming enterprise solutions. He is currently working as a Data Architect in Health Care Industry near Philadelphia, USA.
Responsible for 24x7 technical support of 1300+ instances of 64/32 bit SQL Server 2019/2017/2016/2014/2012/2008/2005/ 2000 Enterprise/Standard infrastructure (Physical & Hyper-V) with Multi-Node Clusters (Active/ Passive), SQL Server Replication, Database Mirroring, Log Shipping, IBM SAN solutions, DPM backup, SCOM Monitoring.
Business intelligence development using SSRS, SSIS, SSAS & MDX - More than 600 SSRS reports in SharePoint 2010 integration mode - SSAS solution for data analysis - More than 100 SSIS data feeds between internal and client application databases.
Performance monitoring/tuning SQL Server, TSQL, ETL process, & SSRS. - Analysis Disk, CPU & Memory bottle neck using SCOM, SQL Profiler, Perfmon, Resmon, DMV, DMF & PAL. - Totally automated SQL Server index maintenance and statistics update process through SQL Agent.
You can reach Daniel directly @ 267 718 1533.
Daniel's Technical Blog: https://empiredatasystems.com/sql-server-training-blogs.html
We believe in letting our prospective students to watch recorded videos of our live training classes and decide for themselves. If you would still like to attend a one-on-one live demo session, please give call Daniel @ 267 718 1533 and he can schedule one for you at your convenience.
RDBMS Concept
|
SQL Server Architecture
|
Creating schemas
|
Selecting appropriate data types
|
Adding constraints
|
Implementing various types of joins
|
Joining a table to itself
|
Combining queries with set operators
|
Scalar and Aggregate Functions
|
Summarizing data with aggregate functions
|
Grouping data
|
Extending group queries
|
Building crosstab reports
|
Declaring variables and parameters
|
Calling built-in scalar functions
|
Performing Extensive Analysis with Analytic Functions
|
RANK Function
|
Extending the use of aggregates
|
Building Sub-queries
|
Correlated sub-queries
|
Common table expressions (CTE)
|
PIVOT/UNPIVOT
|
Derived Tables
|
Maintaining Data
|
Transaction
|
SQL Server locking fundamentals
|
Programming procedural statements
|
Handling errors
|
Producing server-side result sets
|
Views
|
Functions
|
Triggers
|
Stored Procedures
|
Temporary Tables
|
SQL Server Installation and Features
|
Storage Architecture & data redundancy
|
Essential tools
|
Creating and Managing Databases
|
Managing database space
|
Moving databases
|
Implementing Server and Database Security
|
Authorizing database access
|
Managing Permissions
|
Schemas
|
Catalog Information
|
Handling object-level permissions
|
Creating and managing indexes
|
Creating and managing Statistics
|
Transaction Log
|
System databases
|
Recovering from Disasters
|
Restoring databases
|
Export/Import data/database
|
Automating Tasks with Jobs and Alerts
|
Multistep jobs
|
Performing Database Maintenance
|
Ad hoc monitoring
|
Database Availably
|
SQL Server logs
|
Dead Locks
|
Latest Topics
|
Executing queries
|
Performance tuning tools
|
Memory Management
|
L-L-W Issues
|
Lock Mode
|
Isolotion Level
|
Lock Granularity and Hierarchies
|
Analyzing performance using
|
Design effective SQL statements
|
Partitioning strategies for tables
|
Indexes tuning
|
Statistics Tuning
|
Advanced DBA Topics
|
Years of Experience
Gratified Students
Training Batches
Training Hours