Introduction to SQL Databases (55315)
This three-day instructor-led 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 designs. This course updates and replaces course 10985C previously published under the same title.
Training at a glance
Level
Beginner
Duration
3 Days
Experience
General Computer Literacy
Average Salary
$65,000
Labs
Yes
Level
Beginner
Duration
3 Days
Experience
General Computer Literacy
Average Salary
$65,000
Labs
Yes
Training Details
- Describe key database concepts in the context of SQL Server
- Describe database languages used in SQL Server
- Describe data modeling techniques
- Describe normalization and denormalization techniques
- Describe relationship types and effects in database design
- Describe the effects of database design on performance
- Describe commonly used database objects
- Introduction to Relational Databases
- Other Databases and Storage
- Data Analysis
- SQL Server Database Languages
- Data Modelling
- Designing a Database
- Relationship Modeling
- Fundamentals of Normalization
- Normal Form
- Denormalization
- Introduction to Relationships
- Planning Referential Integrity
- Indexing
- Query Performance
- Concurrency
- Tables
- Views
- Stored Procedures, Triggers and Functions
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.
Basic end-user computer skills and some familiarity with database terminology and structure are required. Completion of one of the following courses or equivalent knowledge and skill is highly recommended:
- Using Microsoft® Windows® 10
- Microsoft® Windows® 10: Transition from Windows® 7
Course-specific Technical Requirements
Hardware:
Each computer will need the following minimum hardware configurations:
- 2 GHz or faster 64-bit (x64) processor
- 4 gigabytes (GB) RAM
- 40 GB available hard disk space
- CD-ROM drive (if installing any software from a CD-ROM)
- Keyboard and mouse (or other pointing device)
- 1024 x 768 (or higher) resolution monitor recommended
- Network cards and cabling for local network access
- Internet access (contact your local network administrator)
- Printer (optional) or an installed printer driver
- Projection system to display the instructor’s computer screen
Software:
To prepare a system for the class, install the following software according to the instructions provided. You will need the following:
- Microsoft® Windows® 10 64-bit with sufficient licenses.
Windows 10 requires activation unless you have volume-licensing agreements. There is a grace period for activation. If the duration of your class will exceed the activation grace period (for example, if you are teaching the class over the course of an academic semester), you should activate the installations at some point before the grace period expires. Otherwise, the operating system may stop working before the class ends.
- Microsoft® SQL Server® 2017 Express. (When this course was written, the installation file for this free software was available for download from https://www.microsoft.com/en-us/sql- server/sql-server-downloads.)
- Microsoft® SQL Server® Management Studio (SSMS). (When this course was written, the installation file for this free software was available for download from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio- ssms.)
Upcoming Classes
We offer more than just SQL Training
Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.
Strategic Planning & Project Management
From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.
IT & Cybersecurity
ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.
Leadership & Management
Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.