SQL Server Training
MCSA: SQL SERVER CERTIFICATION
Acquire essential skills to develop, run, and maintain the next wave of advanced database and information solutions.
TAKE THESE COURSES:
20761 Querying Data with Transact SQL
20762-1 Developing SQL Databases
TAKE THESE COURSES:
20764 Administering a SQL Database Infrastructure
20765 Provisioning SQL Databases
TAKE THESE COURSES:
TAKE THESE COURSES:
20461 Querying Microsoft SQL Server®
20462 Administering Microsoft® SQL Server® Databases
20463 Implementing a Data Warehouse with Microsoft® SQL Server®
MCSE: DATA PLATFORM
Acquire essential skills to develop, run, and maintain the next wave of advanced database and information solutions.
- MCSA: SQL Server Certification
Step 1
TAKE THESE COURSES
20464 Developing Microsoft® SQL Server® Databases
20465 Designing Solutions for Microsoft SQL Server 2014
Step 2
TAKE THESE EXAMS
70-464 Developing Microsoft SQL Server Databases
70-465 Designing Database Solutions for Microsoft SQL Server
Step 3
EARN THESE CERTIFICATIONS
MCSE: Data Platform
MCSE: DATA PLATFORM
Acquire essential skills to develop, run, and maintain the next wave of advanced database and information solutions.
- MCSA: SQL Server Certification
Step 1
TAKE THESE COURSES
20464 Developing Microsoft® SQL Server® Databases
20465 Designing Solutions for Microsoft SQL Server 2014
Step 2
TAKE THESE EXAMS
70-464 Developing Microsoft SQL Server Databases
70-465 Designing Database Solutions for Microsoft SQL Server
Step 3
EARN THESE CERTIFICATIONS
MCSE: Data Platform
SQL Server Courses
Microsoft SQL Server Certification Training Courses at National Business Training
Microsoft SQL Server delivers capabilities with in-memory performance and operational analytics built-in. Comprehensive security features help protect your data at rest and in motion. Whether you need Raleigh SQL Server training, Durham SQL Server training, Greensboro SQL Server training, Charlotte SQL Server training, or SQL classes anywhere in the country, National Business Training can help. Learning SQL is available live online or via private group training for your business.
When you learn SQL, organizations gain deeper insights into their data with capabilities that go beyond business intelligence to perform advanced analytics directly within their database and present rich visualizations for business insights on any device. You can learn SQL online with our 100% live, instructor-led training on a cloud-based platform.
You can also gain the benefits of hyper-scale cloud that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure in a secured way so your data is always at hand for queries, no matter the size. In addition, SQL Server delivers a complete database platform for hybrid cloud, enabling you to easily build, deploy and manage solutions that span on-premises and cloud.
Available via live online classes, at our facility in Raleigh-Durham, NC, and on-site training throughout North Carolina including Fayetteville, Wilmington, Charlotte, Greenville/New Bern, Greensboro, Jacksonville, and Winston-Salem.
Search for your Course
SQL Server Courses
10985 Introduction to SQL Databases
Course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database design
10986 Upgrading Your Skills to SQL Server 2016
This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
10987 Performance Tuning and Optimizing SQL Databases
This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
10988 Managing SQL Business Intelligence Operations
This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations.
10989 Analyzing Data with Power BI
This two-day course provides students with the knowledge and skills analyze data with Power BI.
10990 Analyzing Data with SQL Server Reporting Services
This three-day course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization.
20461 Querying Microsoft SQL Server
Students learn the technical skills to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
20462 Administering Microsoft SQL Server Databases
This five-day course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
20463 Implementing a Data Warehouse with Microsoft SQL Server
Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
20464 Developing Microsoft SQL Server Databases
In this course, students learn in detail the different standard & advanced availability check capabilities of the integrated SAP APO Global-Available to Promise component, embedded in corresponding business scenarios & along with the relevant settings.
20465 Designing Solutions for Microsoft SQL Server 2014
The focus of this course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies.
20466 Implementing Data Models and Reports with Microsoft SQL Server
This course describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services.
20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014
In this course, you will learn day-to-day management tasks including how to manage software client health, hardware and software inventory, applications. and integration with Windows Intune.
20761 Querying Data with Transact SQL
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
20762 Developing SQL Databases
This course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
20762-1 Developing SQL Databases
This course provides students with the skills to develop a Microsoft SQL Server 2016 database and focuses on teaching SQL Server 2016 features and tools.
20764 Administering a SQL Database Infrastructure
This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.
20765 Provisioning SQL Databases
This course provides students with the knowledge & skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on premise and in Azure, and covers installing from new and migrating from an existing install.
20767 Implementing a SQL Data Warehouse
The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
20768 Developing SQL Data Models
This course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models.
20778 Analyzing Data with Power BI
Gain a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
55005 Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014
The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images and gauges.
55069 PowerShell for SQL Server Administrators
Gain the knowledge and skills needed to use PowerShell for SQL Server administration. Learn how to manage day-to-day and scheduled maintenance tasks.
55123 Writing Reports with Report Builder and SSRS Level 1
In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS.
55128 Writing Reports with Report Builder and SSRS Level 2
In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.
55144 SQL Server Performance Tuning and Optimization
The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking.
6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube.
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
This course teaches students how to implement an Integration Services solution in an organization.
Oracle 12c SQL Fundamentals
This course takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, and more.
Oracle 12c: PL/SQL Fundamentals
In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c.
Oracle Database 11g – PL/SQL Fundamentals
Provides an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database.
Oracle Database 11g R2 – Advanced PL/SQL Programming and Tuning
This Oracle 11g course will give attention to three fundamental pillars of effective implementation of PL/SQL applications.
SQL Querying – Level 1 Fundamentals of Querying
This course, students will learn to use SQL as a tool to retrieve the information you need from databases.
SQL Querying – Level 2 Advanced Querying
In this course, students will learn how to identify and use advanced querying techniques. You may perform tasks such as modifying the structure of a table: inserting, updating, deleting data and indexing tables to optimize query performance.
SQL Server 2014 High Availability
Developed in-house by SolidQ, the high Availability course provides an in-depth review of SQL Server 2014 High Availability.
10977 Updating Your SQL Server Skills to Microsoft SQL Server 2014
This course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008.