Please ensure Javascript is enabled for purposes of website accessibility
SQL Server Training Course
4.0( 1 REVIEWS )
241 STUDENTS
3h 36m

This course is designed for those interested to learn more about SQL Servers, to facilitate a robust solution in handling higher volume of data, and understand databases to better bridge between IT and the business.

Read more.
Course Skill Level
Intermediate
Time Estimate
3h 36m

Instructor

We are a collective of highly experienced professionals from the UK and North America who have packed decades of practical skills into top courses!

Access all courses in our library for only $9/month with All Access Pass

Get Started with All Access PassBuy Only This Course

About This Course

Who this course is for:

  • You’ve been working with Excel and your companies’ data volumes have grown to the point where you need a more robust solution to handle the higher volume of data
  • You’ve started working in a company or a new project that already has SQL server and you need to get up to scratch to start querying it to create analysis and reports. Perhaps you are a Data Analyst, Accountant or Reporting/Business Intelligence Analyst.
  • Finally, you are a project manager or business analyst who won’t be building or querying a database but you need to understand databases so you can be a better bridge between IT and the business.

What you’ll learn: 

  • How a SQL server database works and set one up
  • Tables: layouts, keys, data types and queries to interrogate a table
  • Database structure: the relational model, foreign keys, and cardinality
  • Joins: Essentially filter a database and make sure we get only the information we are interested in
  • Advanced SQL: Stored procedures, functions and exporting

Requirements: 

  • You will need access to SQL Server. This course is made with 2017, but other versions will work just fine.

There is far too much data in your company, and you have outgrown Excel, management is talking about bringing in a data expert but with our SQL Server course, it’s your time to shine as you take this challenge on.

Our Promise to You

By the end of this course, you will have learned database management with SQL server.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about SQL Server.

Course Curriculum

Section 1 - Introduction To SQL Server
Introduction To SQL Server 00:00:00
SQL Server Layout 00:00:00
Database Setup 00:00:00
Conclusion To Course Intro 00:00:00
Section 2 - Table Structure
Tables Introduction 00:00:00
Table Theory 00:00:00
Table Queries 00:00:00
Tables Conclusion 00:00:00
Section 3 - Databases
Introduction To Databases 00:00:00
Database Theory 00:00:00
Database Queries 00:00:00
Database Conclusion 00:00:00
Section 4 - Joins
Introduction To Joins 00:00:00
Joins Theory 00:00:00
Joins Queries 00:00:00
Joins Conclusion 00:00:00
Section 5 - SQL Server: Advanced Features
SQL Advanced Features 00:00:00

Course Review

4.0

4.0
1 Ratings
  1. Anonymous

    Just enough to be dangerous

    4.0

    A good review of SQL Server and the language, after being away from query writing for a few years. Very good examples of code and explanations of how/why it all works and order of operation.

4764597

Join our newsletter and get your first course free!

4764598

Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?