SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Home
Course
Hidden Course
SQL Server 101 : Microsoft SQL Server for Absolute Beginners

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Level: Intermediate
Modules: 44 Modules
Duration: 13 hours, 45 minutes
Students: 90

Overview

Learn about SQL Server 101 : Microsoft SQL Server for Absolute Beginners from industry experts and boost your professional skill. This SQL Server 101 : Microsoft SQL Server for Absolute Beginners course will enhance your skill and make you ready for the job market. You’ll get expert opinions about the best practices and problems of SQL Server 101 : Microsoft SQL Server for Absolute Beginners. You’ll also gain the skills of SQL Server 101 : Microsoft SQL Server for Absolute Beginners to excel in your job and tips to master professional skills in no time.

You’ll be connected with the community of SQL Server 101 : Microsoft SQL Server for Absolute Beginners professionals and gain first-hand experience of SQL Server 101 : Microsoft SQL Server for Absolute Beginners problem-solving. The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is self-paced. You can complete your course and submit the written assignment in your suitable schedule. After completing the SQL Server 101 : Microsoft SQL Server for Absolute Beginners, you’ll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.

This SQL Server 101 : Microsoft SQL Server for Absolute Beginners will provide you with the latest information and updates of SQL Server 101 : Microsoft SQL Server for Absolute Beginners. It will keep you one step ahead of others and increase your chances of growth.

Why buy this SQL Server 101 : Microsoft SQL Server for Absolute Beginners?

Unlimited access to the course for forever
Digital Certificate, Transcript, student ID all included in the price
Absolutely no hidden fees
Directly receive CPD accredited qualifications after course completion
Receive one to one assistance on every weekday from professionals
Immediately receive the PDF certificate after passing
Receive the original copies of your certificate and transcript on the next working day
Easily learn the skills and knowledge from the comfort of your home

Certification

After studying the course materials of the SQL Server 101 : Microsoft SQL Server for Absolute Beginners there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.

Who is this course for?

This SQL Server 101 : Microsoft SQL Server for Absolute Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning.

Prerequisites

This SQL Server 101 : Microsoft SQL Server for Absolute Beginners was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.

Career path

As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL Server 101 : Microsoft SQL Server for Absolute Beginners is a great way for you to gain multiple skills from the comfort of your home.

Course Curriculum

Unit 01: Course and Instructor Introduction
	Course and Instructor Introduction	00:05:00
Unit 02: Laying out the foundation - Overview & Installation
	Pre-requisites & Different Editions of SQL Server	00:06:00
	Downloading Express Edition & sample database	00:03:00
	Installing the downloads & Configuration	00:19:00
	The sa Login	00:04:00
	Wrap up – what we went over!	00:01:00
Unit 03: Core concepts - Taming the RDBMS beast!
	What is RDBMS?	00:12:00
	Where does SQL Server fit in?	00:02:00
	Basic database objects	00:16:00
	Different Files that got installed – MDF & LDF	00:03:00
	Wrap up – what we went over!	00:01:00
Unit 04: Tool of the trade - SQL Server Management Studio
	Getting started with SSMS	00:07:00
	Getting around Object Explorer	00:05:00
	Query Window	00:06:00
	Pre-built DB – system database	00:04:00
	Wrap up – what we went over!	00:01:00
Unit 05: Simple SELECT
	Bare Minimum: SELECTING a literal	00:05:00
	Retrieving / querying data from a table – using FROM clause	00:06:00
	Playing with Column Names	00:03:00
	Rearranging columns to your liking	00:01:00
	Wrap up – what we went over!	00:01:00
Unit 06: Filtering out unwanted data
	Narrowing down and ordering result set – WHERE and ORDER clause	00:17:00
	Narrowing down result set – BETWEEN / NOT BETWEEN	00:09:00
	Narrowing down result set – IN and NOT IN operator	00:05:00
	Narrowing down result set – Pattern Matching: LIKE and Wildcards	00:11:00
	Wrap up – what we went over!	00:01:00
Unit 07: Expressions and Functions
	Dealing with nothing: NULL	00:06:00
	Working with strings: Concatenation and other string functions	00:15:00
	Working with dates: Date Functions	00:07:00
	Some System Functions	00:05:00
	Wrap up – what we went over!	00:02:00
Unit 08: Getting data out of multiple tables
	Joining multiple tables – INNER JOIN	00:09:00
	Join types – OUTER JOIN – LEFT / RIGHT / FULL	00:08:00
	Join types – CROSS JOIN	00:02:00
	Holy UNION!	00:03:00
	Subqueries	00:04:00
	Wrap up – what we went over!	00:02:00
Unit 09: Summarizing and Grouping data
	DISTINCT and ALL Predicates	00:02:00
	Aggregate Functions	00:03:00
	GROUP BY clause / HAVING clause	00:04:00
	WHERE and ORDER BY in aggregate queries	00:04:00
	Wrap up – what we went over!	00:01:00
Unit 10: Bonus
	Bonus_Section	00:01:00
Assignment
	Assignment – SQL Server 101 : Microsoft SQL Server for Absolute Beginners	09:53:00