Introduction to SQL

Product type

Introduction to SQL

GoSkills
Logo GoSkills

Need more information? Get more details on the site of the provider.

Description

GoSkills helps you learn essential business skills to achieve your full potential.

GoSkills.com is an online learning company that helps anyone learn business skills to reach their personal and professional goals. With a GoSkills.com subscription, members have access to over 70+ courses consisting of bite-sized and interactive content.

SQL is the world's most widely used programming language for database management, an essential skill for back-end web development and data analytics. Designed for beginners, this Introduction to SQL course will give you the foundation you need to get started with Structured Query Language in Microsoft SQL Server, through hands-on application and examples.

By the end of the course you will have a practical understanding of how to set up and connect to a server, create databases and tables, insert and update data, and create and filter queries to get the valuable insights you need.

In this course we are using Microsoft SQL Server's T-SQL, but you will be able to apply most of what you learn …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, Database Management, PL/SQL, Programming (general), and IT Security.

GoSkills helps you learn essential business skills to achieve your full potential.

GoSkills.com is an online learning company that helps anyone learn business skills to reach their personal and professional goals. With a GoSkills.com subscription, members have access to over 70+ courses consisting of bite-sized and interactive content.

SQL is the world's most widely used programming language for database management, an essential skill for back-end web development and data analytics. Designed for beginners, this Introduction to SQL course will give you the foundation you need to get started with Structured Query Language in Microsoft SQL Server, through hands-on application and examples.

By the end of the course you will have a practical understanding of how to set up and connect to a server, create databases and tables, insert and update data, and create and filter queries to get the valuable insights you need.

In this course we are using Microsoft SQL Server's T-SQL, but you will be able to apply most of what you learn to many other databases such as MySQL, PostgreSQL, Oracle and more.

Highlights:

  • 33 practical tutorials.
  • Understand the structure of databases with RDBMS concepts.
  • How to set up Microsoft SQL Server and SQL Management Studio.
  • Create a new database and add data to tables.
  • Back up and restore your database to protect your data.
  • Use a SELECT statement to retrieve data.
  • Filter records with WHERE, AND, OR clauses.
  • Arrange results with ORDER BY and GROUP BY clauses.
  • Search within aggregate groups with HAVING clause.
  • Calculate data with Count, Average, and Sum functions.
  • Update and remove data with UPDATE and DELETE statements.
  • Combine and join tables with JOIN clauses.
  • Other SQL concepts such as subqueries, indexing and primary key.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.