The Complete Microsoft SQL Bootcamp :Learn SQL For Beginners
4.5 (51 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,804 students enrolled

The Complete Microsoft SQL Bootcamp :Learn SQL For Beginners

Learn to become an SQL Expert : SQL For Beginners
4.5 (51 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,804 students enrolled
Created by Gary Cowan
Last updated 7/2020
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 8 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will learn how to write SQL statements in a SQL Server Database
  • Get employed as a SQL Expert in a SQL Server Database
  • Being a SQL Expert , you will be able to insert information into a SQL Server Database
  • Being a SQL Expert , you will be able to update information into a SQL Server Database
  • Being a SQL Expert , you will be able to delete information into a SQL Server Database
  • Being a SQL Expert , you will be able to search information into a SQL Server Database
  • Being a SQL Expert , you will be able to join tables within a SQL Server Database
  • Being a SQL Expert , you will be able to use SQL Server Management Studio
Requirements
  • No experience needed
  • Internet Access
  • Windows 10 (or better) Operating System
  • Willing to learn SQL
Description

Learn to become an SQL Expert in SQL Server Database.

This course is for anybody who wants to become a SQL Expert in a SQL Server Database but doesn't know what skills or steps to take.

Nearly every company uses SQL and usually, they need a SQL Expert. To become good at SQL, you need technical, communication and problem-solving skills.

In this course 'The Complete Microsoft SQL Bootcamp :Learn SQL For Beginners' I will cover how to use SQL and you will learn the same skills no matter which version of SQL Server you use.

This step by step approach will be as follows

  • Learn how to write SQL in a SQL Server Database

  • You will understand what SQL is and how to update, delete and insert information in tables



Who this course is for:
  • Students who want to become a SQL Expert in a SQL Server Database
Course content
Expand all 33 lectures 01:28:00
+ Introduction
2 lectures 02:03
Leave a review and win FREE access to courses
00:44
+ Using SQL Server Management Studio
2 lectures 05:07

This is how you download the file for this SQL course

Open up the downloaded file from lecture 2
00:06

SQL For Beginners : Microsoft : Beginner To Expert : This will teach you how to use SQL Server Management Studio

Using SQL Server Management Studio
05:01
+ How to create a database and table a SQL Server Database
3 lectures 04:32

SQL For Beginners : Microsoft : Beginner To Expert : The lecture will teach you what a database is.

What is a database
01:31

SQL For Beginners : Microsoft : Beginner To Expert : This lecture will teach you what a table is.

What is a table
01:52

SQL For Beginners : Microsoft : Beginner To Expert: This lecture shows you how to setip and create test data within a SQL Server database.

Setup and creating test data
01:09
+ Getting information from tables using SELECT Statements
6 lectures 15:23

This lecture show you how to use the USE command within TSQL

USE Command - Switching Between Databases
01:26

This lecture will show you how to use the SELECT statement within a SQL Server database.

SELECT
04:04

This lecture will show you how to use the UNION statement within a SQL Server database.

UNION
01:28

This lecture will show you how to use the DATE statement within a SQL Server database.

DATE Functions
05:09

This lecture will show you how to use the CASE statement within a SQL Server database.

CASE Statements
03:10
Further Reading
00:06

This will test you on basic knowledge of SQL

TSQL
2 questions
Practice, Practice, Practice! What I want you to do is practice what you have learn't by creating your own queries. Do not look at your notes and write some TSQL that pulls data from the tables you have been using.
Learn TSQL
1 question
+ Joining tables using JOIN Statements
4 lectures 16:47
JOINS : INNER, LEFT AND RIGHT JOINS - PART 1
00:10

This lecture will show you how to use the INNER, LEFT and RIGHT JOINS statement within a SQL Server database.

JOINS : INNER, LEFT AND RIGHT JOINS - PART 2
11:36

This lecture will show you how to use the JOIN statement within a SQL Server database.

Which JOIN is better? PART 1
04:20

This lecture will show you how to use the JOIN statement within a SQL Server database.

Which JOIN is better? PART 2
00:41
+ Aggregation Functions
3 lectures 09:31

This lecture will show you how to use the COUNT statement within a SQL Server database.

COUNT Statement
03:23

This lecture will show you how to use the SUM statement within a SQL Server database.

SUM Statement
02:39

This lecture will show you how to use the AVG statement within a SQL Server database.

AVG (Average) Statement
03:29
+ Filter GROUP BY Statement using HAVING Statements
1 lecture 04:27

This lecture will show you how to use the GROUP BY statement within a SQL Server database.

Filter GROUP BY Statement using HAVING Statements
04:27
+ Insert Statements
2 lectures 03:00

This lecture will show you how to use the INSERT statement within a SQL Server database.

Insert Statements
02:57
Further Reading
00:03
+ Update Statements
2 lectures 02:55

This lecture will show you how to use the UPDATE statement within a SQL Server database.

Update Statements
02:52
Further Reading
00:03