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.
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.
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.