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.
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 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
Don't just take our word for it
Amazing workshop.
Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.
Aarini Sinha
It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.
Varsha Sivamohan
I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.
Judith Taylor
The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable.
I am very grateful for the support
Charlie Anderson
Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it.
Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.
Parmjit Dosanjh
I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.
Shan
I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪
Sara Nana
$457.31Original price was: $457.31.$34.75Current price is: $34.75.
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.