Udemybeginneren

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Learn Microsoft SQL Server! This beginner-friendly tutorial covers SQL basics, Management Studio, and T-SQL. Start your database journey today.

3.9(148)
597students
3h 50m
Certificate
Rashid Khan
Rashid KhanMicrosoft Certified-Business Intelligence Consultant

Course Content

SQL Server 101 : Microsoft SQL Server for Absolute Beginners is a beginner-level Udemy course taught by Rashid Khan. It runs 3h 50m, is taught in English, and includes a certificate of completion. Learners rate it 3.9 out of 5 from 148 reviews, with 597 students enrolled. It is a paid course, last updated October 2018.

Master SQL Server: A Comprehensive Guide for Beginners

This course provides a practical introduction to Microsoft SQL Server, equipping you with the essential skills to manage and query databases. You'll begin with a hands-on installation, setting up your own SQL Server environment using the Express edition.

What You'll Learn:

  • SQL Server Installation & Setup: Learn the requirements for installing Microsoft SQL Server and get it up and running quickly.
  • Relational Database Management Systems (RDBMS): Understand the core concepts of RDBMS and how SQL Server fits into the database landscape, with a comparison to platforms like Oracle and IBM.
  • SQL Server Management Studio (SSMS): Become proficient in navigating and utilizing SQL Server Management Studio for database administration and query execution.
  • System Databases: Explore the intricacies of SQL Server system databases and their role in database management.
  • SELECT Statements: Master constructing powerful SELECT statements, starting with basic literals and progressing to complex queries.
  • Filtering Data: Learn to refine your queries using the WHERE clause, BETWEEN / NOT BETWEEN operators, and IN / NOT IN operators.
  • Pattern Matching: Utilize the LIKE operator and wildcard characters for flexible data retrieval.
  • Working with NULL Values: Understand and handle NULL values effectively in your queries.
  • String & Date Functions: Leverage built-in string functions (including concatenation) and date functions to manipulate and format data.
  • SQL Server System Functions: Discover and apply a range of powerful SQL Server system functions.
  • JOIN Operations: Gain expertise in JOINs – including INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, and CROSS JOIN – to combine data from multiple tables.
  • UNION & UNION ALL: Learn to combine result sets using UNION and UNION ALL operators and understand their differences.
  • Subqueries: Explore the use of subqueries for more complex data retrieval.
  • Data Manipulation: Utilize DISTINCT and ALL predicates to handle duplicate rows.
  • Aggregate Functions: Employ aggregate functions (e.g., SUM, AVG, COUNT, MAX, MIN) to summarize data.
  • GROUP BY & HAVING Clauses: Master GROUP BY clause and HAVING clause for data aggregation and filtering.

By the end of this course, you will be able to:

  • Install and configure SQL Server to create a functional development environment.
  • Understand fundamental SQL Server concepts and RDBMS principles.
  • Effectively use SQL Server Management Studio for database management.
  • Write efficient SELECT statements to retrieve specific data.
  • Filter and sort data using WHERE and ORDER BY clauses.
  • Utilize essential string, date, and system functions.
  • Combine data from multiple tables using various JOIN types.
  • Combine result sets using UNION and UNION ALL.
  • Apply aggregate functions and GROUP BY/HAVING clauses for data summarization.
$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.