How to install the Microsoft SQL Server and the SQL Server Management Studio (SSMS)
How to create a databases and tables with the graphical interfaces in SSMS
Viewing, inserting, updating and deleting records in SSMS
Viewing, inserting, updating and deleting records with SQL
4 sections • 14 lectures • 1h 19m total length
Installing the Microsoft SQL Server
Creating a Table
View, Insert, Update and Delete records
Auto-number with the Identity Specification
Introduction to SQL
Using the INSERT clause
Using the UPDATE clause
Using the SELECT clause
Congratulations and Thank You
No prior knowledge or experience in database or SQL is required.
Students should have a computer or a Virtual Machine with a Windows operating system.
This course is for absolute beginners who have no previous knowledge or experience in Database or SQL and want to learn it within a short space of time. This course is also useful if you already have some familiarities and experience with other database systems like Oracle, MySQL, Access etc.
You need to have a windows computer to follow the lectures in this course. You’ll install the developer edition of the Microsoft SQL Server and the Management studio. In this course, I have used the latest release of the Microsoft SQL Server which is 2019. However, this course should be fine with the older as well as upcoming releases because we don’t see dramatic changes with this software.
Downloadable files with the SQL statements of the SQL lessons have been provided for your convenience.
Who this course is for:
Anyone interested to learn SQL in a short period of time.
Anyone interested to start working with the Microsoft SQL Server.
The London Academy of IT has been delivering practical oriented IT courses since 2012. Our courses emphasise on both practical work and exercises as we strongly believe the best approach to learn is by having interactive sessions. The Academy focuses on delivering high-quality training courses to help build your knowledge as well as giving you a competitive edge that employers love.