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
Course Curriculum
-
Course and Instructor Introduction00:05:00
-
Pre-requisites & Different Editions of SQL Server00:06:00
-
Downloading Express Edition & sample database00:03:00
-
Installing the downloads & Configuration00:19:00
-
The sa Login00: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 objects00:16:00
-
Different Files that got installed – MDF & LDF00:03:00
-
Wrap up – what we went over!00:01:00
-
Getting started with SSMS00:07:00
-
Getting around Object Explorer00:05:00
-
Query Window00:06:00
-
Pre-built DB – system database00:04:00
-
Wrap up – what we went over!00:01:00
-
Bare Minimum: SELECTING a literal00:05:00
-
Retrieving / querying data from a table – using FROM clause00:06:00
-
Playing with Column Names00:03:00
-
Rearranging columns to your liking00:01:00
-
Wrap up – what we went over!00:01:00
-
Narrowing down and ordering result set – WHERE and ORDER clause00:17:00
-
Narrowing down result set – BETWEEN / NOT BETWEEN00:09:00
-
Narrowing down result set – IN and NOT IN operator00:05:00
-
Narrowing down result set – Pattern Matching: LIKE and Wildcards00:11:00
-
Wrap up – what we went over!00:01:00
-
Dealing with nothing: NULL00:06:00
-
Working with strings: Concatenation and other string functions00:15:00
-
Working with dates: Date Functions00:07:00
-
Some System Functions00:05:00
-
Wrap up – what we went over!00:01:00
-
Joining multiple tables – INNER JOIN00:09:00
-
Join types – OUTER JOIN – LEFT / RIGHT / FULL00:08:00
-
Join types – CROSS JOIN00:02:00
-
Holy UNION!00:03:00
-
Subqueries00:04:00
-
Wrap up – what we went over!00:01:00
-
DISTINCT and ALL Predicates00:02:00
-
Aggregate Functions00:03:00
-
GROUP BY clause / HAVING clause00:04:00
-
WHERE and ORDER BY in aggregate queries00:04:00
-
Wrap up – what we went over!00:01:00
-
Bonus_Section00:01:00
14-Day Money-Back Guarantee
-
Duration:3 hours, 50 minutes
-
Access:1 Year
-
Units:43
Want to get everything for £149
Take Lifetime Pack