31
- × Adobe Lightroom Classic CC & CC: Photo Editing Masterclass 3 × $29.50
- × PDF Certificate (Special Gift - 67% OFF) 13 × $7.07
- × Master Colour in Photoshop CC 2 × $29.50
- × Photoshop Portrait Editing: Dodge & Burn Technique 2 × $29.50
- × Vegan and Vegetarian Cooking 1 × $29.50
- × Nutritional Therapy 1 × $29.50
- × WordPress for Beginners: Designing a Blog with Zero Coding 1 × $29.50
- × PowerPoint 2016 Introduction 1 × $29.50
- × Practical Time Management 1 × $29.50
- × MySQL Database Development 2 × $29.50
- × SEO - Search Engine Optimisation Level 6 1 × $376.42
- × Excel 2016 Introduction 1 × $29.50
- × Short Story Writing Course 1 × $29.50
- × Complete Veterinary Program Prerequisites Bundle (all vet titles combined) 1 × $29.50
Subtotal: $969.81

View basket Checkout
LOGIN

Welcome to

Course Cloud

the best place for online learning!

Keep me logged in

Forgot Password?

Don’t have an account yet? Sign Up

Already have an account? Log In

By signing up, I accept Course Cloud’s Terms & Conditions

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

What Will I Learn? At the completion of the course, you will know how to install SQL Server and create …

★ ★ ★ ★ ★

( reviews)

6 enrolled on this course

What Will I Learn?

At the completion of the course, you will know how to install SQL Server and create a practice environment for yourself.

You will learn the ins and outs of SQL Server Management studio.

You will know how to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.

You will see how to get data out of multiple tables using JOIN ( INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOINS).

You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.

You will be familiarized with some of the core concepts of RDBMS / SQL Server.

You will start constructing your SELECT statement to retrieve data from SQL Server.

Course Overview

The comprehensive SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the SQL Server 101 : Microsoft SQL Server for Absolute Beginners today, and learn from the very best the industry has to offer!

This best selling SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth SQL Server 101 : Microsoft SQL Server for Absolute Beginners is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.

The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is CPD-accredited, so you can be confident you’re completing a quality training course which will boost your CV and enhance your career potential. The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.

After successfully completing the SQL Server 101 : Microsoft SQL Server for Absolute Beginners, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the SQL Server 101 : Microsoft SQL Server for Absolute Beginners will help you stand out from the crowd. You can also validate your certification on our website.

We know that you are busy and that time is precious, so we have designed the SQL Server 101 : Microsoft SQL Server for Absolute Beginners to be completed at your own pace, whether that’s part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.

Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Preview

Certification

After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

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:01: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:01: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	00:00:00

Course Cloud Endorsed

Benefits:

Accredited and Endorsed
Professional Credibility
Evidence of Achievement
Certification Validation
Skill Development

CPD QS Accredited

Benefits:

Recognised Internationally
Awarded CPD Hours & Points
Free Additional Transcript
Employer Recognised
Competitive Edge

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

$ 319

( 100% Off Limited Time )

TAKE THIS COURSE

Get Access to All Courses for £79

This Course Includes

44 Units
1 Year Access
3 hours, 50 minutes
Beginner
Accredited Certificate

Share this Course:

Frequently asked questions

Can’t find the anwser you’re looking for ? Reach out to customer support team.

Which courses will I be able to study?

As a Lifetime Prime Member, you will receive lifetime access to our entire course library and a student ID card. You will also receive a PDF certificate with every course you complete. Furthermore, you can get unlimited PDF transcripts and 5 hardcopy certificates.

Are there any restrictions?

What does the Prime Learning Membership include?

How do I become a Lifetime Prime Member?

Frequently Bought Together

Product Management

★ ★ ★ ★ ★

★ ★ ★ ★ ★

4.7(6 reviews)

Add to Cart See More

Lifeguard Training

★ ★ ★ ★ ★

★ ★ ★ ★ ★

4.7(6 reviews)

Add to Cart See More

Decision Making and Critical Thinking

★ ★ ★ ★ ★

★ ★ ★ ★ ★

4.7(6 reviews)

Add to Cart See More

Welcome to

Course Cloud

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

What Will I Learn?

At the completion of the course, you will know how to install SQL Server and create a practice environment for yourself.

You will learn the ins and outs of SQL Server Management studio.

You will know how to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.

You will see how to get data out of multiple tables using JOIN ( INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOINS).

You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.

You will be familiarized with some of the core concepts of RDBMS / SQL Server.

You will start constructing your SELECT statement to retrieve data from SQL Server.

Course Overview

Preview

Certification

Course Curriculum

Course Cloud Endorsed

Benefits:

CPD QS Accredited

Benefits:

This Course Includes

Share this Course:

Frequently asked questions

Frequently Bought Together

Important Links

Site Links

Certificate Validator

Important Links

Site Links