Introduction to Microsoft SQL Server and SQL

Introduction to Microsoft SQL Server and SQL, available at $49.99, has an average rating of 4.75, with 14 lectures, based on 12 reviews, and has 31 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone interested to learn SQL in a short period of time. or Anyone interested to start working with the Microsoft SQL Server. It is particularly useful for Anyone interested to learn SQL in a short period of time. or Anyone interested to start working with the Microsoft SQL Server.

Enroll now: Introduction to Microsoft SQL Server and SQL

Summary

Title: Introduction to Microsoft SQL Server and SQL

Price: $49.99

Average Rating: 4.75

Number of Lectures: 14

Number of Published Lectures: 14

Number of Curriculum Items: 14

Number of Published Curriculum Objects: 14

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Anyone interested to learn SQL in a short period of time.
Anyone interested to start working with the Microsoft SQL Server.

Target Audiences

Anyone interested to learn SQL in a short period of time.
Anyone interested to start working with the Microsoft SQL Server.

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: About this course

Lecture 2: Installing the Microsoft SQL Server

Lecture 3: Getting started with the SQL Server Management Studio

Chapter 2: Creating and working with databases and tables

Lecture 1: Creating a Database

Lecture 2: Creating a Table

Lecture 3: View, Insert, Update and Delete records

Lecture 4: Primary Keys

Lecture 5: Auto-number with the Identity Specification

Chapter 3: Working with SQL

Lecture 1: Introduction to SQL

Lecture 2: Using the INSERT clause

Lecture 3: Using the UPDATE clause

Lecture 4: Using the DELETE clause

Lecture 5: Using the SELECT clause

Chapter 4: Conclusion

Lecture 1: Congratulations and Thank You

Instructors

London Academy of IT
Providing IT short courses

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 3 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu