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. 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.
We guarantee that all our online courses will meet or exceed your
expectations. If you are not fully satisfied with a course - for
any reason at all - simply request a full refund. We guarantee no
hassles. That's our promise to you.
Go ahead and order with confidence!
Easy to Access
Let's Navigate Together
Course Curriculum
| Unit 01: Course and Instructor Introduction | |||
| Course and Instructor Introduction | |||
| Unit 02: Laying out the foundation - Overview & Installation | |||
| Pre-requisites & Different Editions of SQL Server | |||
| Downloading Express Edition & sample database | |||
| Installing the downloads & Configuration | |||
| The sa Login | |||
| Wrap up – what we went over! | |||
| Unit 03: Core concepts - Taming the RDBMS beast! | |||
| What is RDBMS? | |||
| Where does SQL Server fit in? | |||
| Basic database objects | |||
| Different Files that got installed – MDF & LDF | |||
| Wrap up – what we went over! | |||
| Unit 04: Tool of the trade - SQL Server Management Studio | |||
| Getting started with SSMS | |||
| Getting around Object Explorer | |||
| Query Window | |||
| Pre-built DB – system database | |||
| Wrap up – what we went over! | |||
| Unit 05: Simple SELECT | |||
| Bare Minimum: SELECTING a literal | |||
| Retrieving / querying data from a table – using FROM clause | |||
| Playing with Column Names | |||
| Rearranging columns to your liking | |||
| Wrap up – what we went over! | |||
| Unit 06: Filtering out unwanted data | |||
| Narrowing down and ordering result set – WHERE and ORDER clause | |||
| Narrowing down result set – BETWEEN / NOT BETWEEN | |||
| Narrowing down result set – IN and NOT IN operator | |||
| Narrowing down result set – Pattern Matching: LIKE and Wildcards | |||
| Wrap up – what we went over! | |||
| Unit 07: Expressions and Functions | |||
| Dealing with nothing: NULL | |||
| Working with strings: Concatenation and other string functions | |||
| Working with dates: Date Functions | |||
| Some System Functions | |||
| Wrap up – what we went over! | |||
| Unit 08: Getting data out of multiple tables | |||
| Joining multiple tables – INNER JOIN | |||
| Join types – OUTER JOIN – LEFT / RIGHT / FULL | |||
| Join types – CROSS JOIN | |||
| Holy UNION! | |||
| Subqueries | |||
| Wrap up – what we went over! | |||
| Unit 09: Summarizing and Grouping data | |||
| DISTINCT and ALL Predicates | |||
| Aggregate Functions | |||
| GROUP BY clause / HAVING clause | |||
| WHERE and ORDER BY in aggregate queries | |||
| Wrap up – what we went over! | |||
| Unit 10: Bonus | |||
| Bonus_Section | |||