Basic Microsoft SQL Server
Harness the power of Microsoft SQL Server, the world’s leading relational database management system, and gain valuable skills that are in high demand by employers.
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 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
1 Year Access 
14 Students 
3 hours, 50 minutes 
