Teach yourself SQL Step by Step

Simpliv

Course

Online

£ 10 VAT inc.

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Structured Query Language (SQL) is a special purpose language for interacting with relational databases. In this course, Teach yourself SQL Step by Step, you will learn the basics of Structured Query Language. First, you will learn how to query data and shape results. Next, you will focus on creating and modifying data in your tables. Finally, you will touch on how to set relations with tables and extract matching data. By the end of this course, you'll understand the basics of how to create and use a relational database.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Understanding Database Concepts
Installation of SQL server
Connection and Disconnection
Difference between Admin Login and User Login
SQL commands for creating
displaying and deleting database
SQL commands for creating
displaying and deleting tables
Commands for exploring tables
Organizing data
Setting relations and understanding joins

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Installation
  • Database training
  • SQL
  • Database
  • Server

Course programme

Introduction 2 lectures 11:18 SQL Server Introduction Database Concepts Introduction 2 lectures 11:18 SQL Server Introduction Database Concepts SQL Server Introduction SQL Server Introduction SQL Server Introduction SQL Server Introduction Database Concepts Database Concepts Database Concepts Database Concepts Installation Connection and Disconnection 4 lectures 01:26:58 Installation of SQL server How to Connect to SQL Server How to troubleshoot unable to connect to SQL server How to disconnect from SQL server and exit SSMS Installation Connection and Disconnection 4 lectures 01:26:58 Installation of SQL server How to Connect to SQL Server How to troubleshoot unable to connect to SQL server How to disconnect from SQL server and exit SSMS Installation of SQL server Installation of SQL server Installation of SQL server Installation of SQL server How to Connect to SQL Server How to Connect to SQL Server How to Connect to SQL Server How to Connect to SQL Server How to troubleshoot unable to connect to SQL server How to troubleshoot unable to connect to SQL server How to troubleshoot unable to connect to SQL server How to troubleshoot unable to connect to SQL server How to disconnect from SQL server and exit SSMS How to disconnect from SQL server and exit SSMS How to disconnect from SQL server and exit SSMS How to disconnect from SQL server and exit SSMS Admin Login and Northwind Database 2 lectures 13:11 Difference between Admin Login and User Login Download the Database Northwind as a resource for our training Admin Login and Northwind Database 2 lectures 13:11 Difference between Admin Login and User Login Download the Database Northwind as a resource for our training Difference between Admin Login and User Login Difference between Admin Login and User Login Difference between Admin Login and User Login Difference between Admin Login and User Login Download the Database Northwind as a resource for our training Download the Database Northwind as a resource for our training Download the Database Northwind as a resource for our training Download the Database Northwind as a resource for our training SQL commands for : Creating, Displaying and Deleting Databases 3 lectures 05:09 Create Database Show Database Delete Database SQL commands for : Creating, Displaying and Deleting Databases 3 lectures 05:09 Create Database Show Database Delete Database Create Database Create Database Create Database Create Database Show Database Show Database Show Database Show Database Delete Database Delete Database Delete Database Delete Database Sql commands for creating tables, inserting records and deleting tables 3 lectures 10:11 Creating Tables Inserting Records Deleting Tables Sql commands for creating tables, inserting records and deleting tables 3 lectures 10:11 Creating Tables Inserting Records Deleting Tables Creating Tables Creating Tables Creating Tables Creating Tables Inserting Records Inserting Records Inserting Records Inserting Records Deleting Tables Deleting Tables Deleting Tables Deleting Tables SQL Commands for Exploring Tables 2 lectures 15:35 Exploring the Northwind Database - SELECT command Selecting Specific columns SQL Commands for Exploring Tables 2 lectures 15:35 Exploring the Northwind Database - SELECT command Selecting Specific columns Exploring the Northwind Database - SELECT command Exploring the Northwind Database - SELECT command Exploring the Northwind Database - SELECT command Exploring the Northwind Database - SELECT command Selecting Specific columns Selecting Specific columns Selecting Specific columns Selecting Specific columns Organizing Data 4 lectures 08:37 Sorting by a Single Column Sorting by Multiple Columns Sorting by Column Position Ascending and Descending Sorts Organizing Data 4 lectures 08:37 Sorting by a Single Column Sorting by Multiple Columns Sorting by Column Position Ascending and Descending Sorts Sorting by a Single Column Sorting by a Single Column Sorting by a Single Column Sorting by a Single Column Sorting by Multiple Columns Sorting by Multiple Columns Sorting by Multiple Columns Sorting by Multiple Columns Sorting by Column Position Sorting by Column Position Sorting by Column Position Sorting by Column Position Ascending and Descending Sorts Ascending and Descending Sorts Ascending and Descending Sorts Ascending and Descending Sorts SQL Commands for displaying data from multiple tables 4 lectures 17:42 Understanding Joins Inner Join Left Join Right Join SQL Commands for displaying data from multiple tables

Additional information

No prior computer knowledge required, all you need is a computer with SQL server installed

See related categories

Teach yourself SQL Step by Step

£ 10 VAT inc.

The best Other Education courses

See all

See all