Skip to main content
SQL DBA School
Hands-On SQL Server Training
Labs • Portfolio • Interview Prep • Career Support
info@SQLdbaSchool.com
+1 (716) 464-0768
SQL
DBA
SQL DBA School
Learn SQL Server • Build Portfolio Proof • Become Interview-Ready
Student Login
Start Learning
Hire Candidates
Apply for Jobs
Home
Learning Paths
Choose Your Best Starting Point
Start From Zero
New to SQL or IT? Begin with the clean beginner roadmap.
Beginner Path
Become a SQL DBA
Build the job-ready SQL Server DBA skill path.
Career Path
Advance My Career
Move into tuning, cloud, automation, and higher-value roles.
Growth Path
Courses
Featured SQL Server Training
All Courses
Browse every SQL DBA learning path
Database Foundations
Best first step for newer learners
Complete SQL Server DBA Course
Core DBA training, labs, and portfolio work
Performance Tuning
Evidence-first troubleshooting and tuning
Career Center
From Skills to Opportunities
Apply Once
Join the candidate pool for matched roles
SQL Jobs
Explore remote and on-site opportunities
Employer Hiring Partners
Companies can request SQL DBA candidates
Remote DBA Roadmap
Skills, proof, and remote-readiness plan
SQL DBA Careers Guide
Skills, portfolio, pay, and job strategy
Resources
Tools, Guides, and Learning Support
SQL Downloads Hub
SQL Server, SSMS, tools, and setup help
Free SQL Training Guide
How to learn free and become job-ready
DBA Training Roadmap
Skills, proof, and certification strategy
Courses with Certificate
Certificate-ready learning paths
About
School, Trust, and Support
About SQL DBA School
Story, founder, training model, outcomes
Contact
Support, careers, and partner inquiries
Student Account
Login and course access
Become a Teacher
Teach with SQL DBA School
Hire Candidates
Contact
SQL DBA School mobile navigation
SQL Career School
Apply Now
SQL
DBA
SQL DBA School
Learn • Practice • Build Proof • Get Interview-Ready
Start Learning
Apply
Hire
Home
Paths
Learn
Jobs
Hire
SQL Server 2014 Essential Training
16 Sections
61 Lessons
100 Weeks
Expand all sections
Collapse all sections
INTRODUCTION
3
2.1
Welcome
2.2
What you should know before starting
2.3
Using the exercise files
OVERVIEW OF SQL SERVER 2104
3
3.1
Understanding the core concepts of SQL Server 2014
3.2
SQL Server principal editions
3.3
SQL Server additional editions
INSTALLING SQL SERVER 2014
3
4.1
Installation prerequisites
4.2
Basic installation
4.3
Advanced installation options
POST-INSTALL
3
5.1
Using SQL Server Configuration Manager
5.2
Basics of SQL Server Management Studio
5.3
More about SQL Server Management Studio
CREATING AND CONFIGURING DATABASES
3
6.1
Creating a database
6.2
Advanced options of database configuration
6.3
Installing sample database
CREATING TABLES IN A DATABASE
5
7.1
Creating a table using Managment Studio
7.2
Understanding data column options
7.3
Creating a table using T-SQL
7.4
Creating relationships between tables
7.5
In memory tables
WORKING WITH SQL
8
8.1
What is SQL?
8.2
Basic SELECT statement
8.3
Filtering results with a WHERE clause
8.4
Using wildcards in a WHERE clause
8.5
Sorting results with ORDER BY
8.6
INSERT statements
8.7
UPDATE statements
8.8
DELETE statements
CREATING VIEWS IN DATABASES
2
9.1
Creating a view
9.2
Understanding advanced options of views
UNDERSTANDING PROGRAMMABILITY
4
10.1
Stored procedures
10.2
Parameterized stored procedures
10.3
Built-in functions
10.4
Scalar functions
WORKING WITH XML
5
11.1
Intro to XML
11.2
Writing queries to return XML
11.3
Shredding XML
11.4
Working with XML schemas
11.5
Storing XML
BACKUP AND RESTORE
6
12.1
Overview of backups in SQL Server
12.2
Basic backups
12.3
Basic restore
12.4
Differential backup and restore
12.5
Creating maintenance plans to automate backups
12.6
Adding a cleanup task to a maintenance plan
MONITORING SQL SERVER
5
13.1
Review logs in SQL Server 2014
13.2
Auditing logins
13.3
Using Performance Monitor
13.4
Understanding dynamic management views
13.5
Using DBCC
SECURITY
4
14.1
Overview of authentication in SQL Server
14.2
Instance-level logins
14.3
Database-level users
14.4
Encrypting data
IMPORTING AND EXPORTING DATA
3
15.1
Exporting data
15.2
Importing data
15.3
Importing and exporting Unicode data
PERFORMANCE
3
16.1
Basics of indexes
16.2
Creating an index
16.3
Exploring execution plans
SUMMARY
1
17.1
Summing up and Next steps
This content is protected, please
login
and
enroll
in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content