Name: SQL Server: Basic Microsoft SQL Server
Price: 25 GBP

GET THIS COURSE AND 2500+ OTHERS FOR ONLY £49 FIND OUT MORE

Home
Curriculum

Overview:

Welcome to our comprehensive online course, “SQL Server: Basic Microsoft SQL Server,” designed to provide you with a solid foundation in utilizing Microsoft SQL Server for database management and querying. Throughout this course, you’ll learn essential SQL Server concepts and techniques, empowering you to effectively interact with databases, write SQL queries, and perform basic database administration tasks. Our interactive modules ensure an engaging learning experience, with practical exercises and real-world examples to reinforce your understanding of SQL Server fundamentals.

Interactive video lectures by industry experts
Instant e-certificate and hard copy dispatch by next working day
Fully online, interactive course with Professional voice-over
Developed by qualified first aid professionals
Self paced learning and laptop, tablet, smartphone friendly
24/7 Learning Assistance
Discounts on bulk purchases

Main Course Features:

Introduction to Microsoft SQL Server and its architecture
Understanding SQL Server databases, tables, and relationships
Writing SQL queries to retrieve and manipulate data
Basic database administration tasks such as backup and restore
Hands-on exercises and quizzes for practical application
Guidance on best practices for SQL Server development and administration

Who Should Take This Course:

Beginners with little to no experience in SQL Server
Database administrators seeking to expand their skills to SQL Server
IT professionals interested in database management and querying

Learning Outcomes:

Understand the architecture and components of Microsoft SQL Server
Create and manage databases, tables, and relationships
Write SQL queries to retrieve and manipulate data
Perform basic database administration tasks such as backup and restore
Apply best practices for SQL Server development and administration
Troubleshoot common SQL Server issues
Interpret and analyze SQL Server query execution plans
Develop foundational skills for advanced SQL Server topics

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

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