.png)
9 Reviews
14 Students
Course Highlights
Welcome to the Basic Microsoft SQL Server course! In this course, you will learn the fundamentals of SQL Server, one of the world’s most popular and widely used relational database management systems.
You will start by learning about the different components of SQL Server and how to install and configure them. Then, you will dive into the heart of SQL Server: the Transact-SQL (T-SQL) language. T-SQL is the language used to interact with SQL Server databases, and you will learn how to use it to create, read, update, and delete data.
As you progress through the course, you will learn more advanced SQL Server features, such as joins, subqueries, and functions. You will also learn how to use SQL Server Management Studio, a graphical tool for managing SQL Server databases.
Each step of the way, our course ensures that you’re not just passively absorbing information but actively engaging with the content, thereby solidifying your understanding and mastery of Microsoft SQL Server. So, if you’re ready to unlock a new realm of opportunities, this course is your golden key. The knowledge and skills you gain here will not only serve you in managing and querying databases with finesse but also open doors to many career paths, from database administration to data analysis and beyond. Join us and take the first step towards becoming the master of your data-driven destiny.
Learning outcome
- Understand the basic concepts and architecture of SQL Server.
- Install and navigate SQL Server Management Studio.
- Write simple SELECT queries to retrieve data.
- Use filters to extract relevant data from databases.
- Implement expressions and functions to manipulate data.
- Extract data from multiple tables.
- Summarize and group data to gain insights.
Course media
Why should I take this course?
- Gain a valuable skill in managing and querying databases.
- Learn from an easy-to-follow curriculum designed for beginners.
- Understand how to manipulate and retrieve data effectively.
- Boost your confidence in handling database management tasks.
- Enhance your career prospects in numerous industries.
Career Path
- Database Administrator
- SQL Developer
- Data Analyst
- Business Intelligence Developer
- Software Engineer
- IT Consultant
Requirements
- A computer with internet access
- No prior experience with SQL Server is required
- Basic computer skills are required
Curriculum
-
Course and Instructor Introduction
00:05:00
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Bonus_Section
00:01:00
Offer Ends in
All
Courses for £49-
Duration:3 hours, 50 minutes
-
Access:1 Year
-
Units:43
