Library

Course: Teach yourself SQL Step by Step

Teach yourself SQL Step by Step

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

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.

Basic knowledge
  • No prior computer knowledge required, all you need is a computer with SQL server installed
What you will learn
  • 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
Curriculum
Number of Lectures: 24
Total Duration: 02:48:45
Introduction
  • SQL Server Introduction  
  • Database Concepts  
Installation Connection and Disconnection
  • 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  
Admin Login and Northwind Database
  • Difference between Admin Login and User Login  
  • Download the Database Northwind as a resource for our training  
SQL commands for : Creating, Displaying and Deleting Databases
  • Create Database  
  • Show Database  
  • Delete Database  
Sql commands for creating tables, inserting records and deleting tables
  • Creating Tables  
  • Inserting Records  
  • Deleting Tables  
SQL Commands for Exploring Tables
  • Exploring the Northwind Database - SELECT command  
  • Selecting Specific columns  
Organizing Data
  • Sorting by a Single Column  
  • Sorting by Multiple Columns  
  • Sorting by Column Position  
  • Ascending and Descending Sorts  
SQL Commands for displaying data from multiple tables
  • Understanding Joins  
  • Inner Join  
  • Left Join  
  • Right Join  
Reviews (0)