Udemybeginnerpl

Serwer SQL dla początkujących (7 godzin praktyki)

Learn T-SQL basics with SQL Server 2019! 50 practical exercises to master your first queries. SQL tutorial for beginners.

4.2(8)
42students
7h 19m
Certificate
Olivier Thuillier Administracja, TSQL oraz wydajność serwera SQL.
Olivier Thuillier Administracja, TSQL oraz wydajność serwera SQL.Dołącz do kursu Masterclass SQL Server!

Course Content

Serwer SQL dla początkujących (7 godzin praktyki) is a beginner-level Udemy course taught by Olivier Thuillier Administracja, TSQL oraz wydajność serwera SQL.. It runs 7h 19m, is taught in Polish, and includes a certificate of completion. Learners rate it 4.2 out of 5 from 8 reviews, with 42 students enrolled. It is a paid course, last updated November 2022.

Learn SQL Server & Transact-SQL (T-SQL): A Beginner's Guide

Ready to unlock the power of data? This course is designed for complete beginners who want to learn SQL Server and Transact-SQL (T-SQL). Even if you have no prior experience with database servers, you'll be writing your first queries in no time!

Here's what you'll master in this comprehensive course:

  • SQL Server Setup: Learn to install SQL Server and SQL Server Management Studio (SSMS) on your workstation.
  • Database & Table Creation: Understand how to create and define databases and tables effectively.
  • Data Manipulation (CRUD): Master essential data operations: SELECT, INSERT, UPDATE, and DELETE.
  • Advanced SELECT Statements: Dive deep into SELECT statements, including:
    • Column Aliases: Improve readability and manageability.
    • LIKE Operator: Utilize wildcards for flexible pattern matching.
    • TOP Clause: Retrieve only the most relevant results.
    • DISTINCT Operator: Remove duplicate rows.
    • Comparison Operators: Understand =, !=, >, <, >=, <=.
    • SELECT INTO: Copy tables with a single command.
    • IN, NOT IN, IS, IS NOT: Filter data based on multiple values and existence.
    • ORDER BY: Sort your data for easy analysis.
  • Aggregate Functions: Discover powerful aggregate functions like MIN, MAX, AVG, COUNT, and SUM.
  • GROUP BY & HAVING: Group data and filter aggregated results.
  • JOIN Operations: Connect data from multiple tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
  • String Manipulation: Utilize functions like CHOOSE, IIF, CASE WHEN, SUBSTRING, and OFFSET FETCH NEXT ROWS for advanced data manipulation.
  • Common Functions: Explore useful functions like CHOOSE, TRIM, LTRIM, RTRIM, and COALESCE.
  • UNION & UNION ALL: Combine results from multiple queries.
  • CAST & CONVERT: Convert data types.
  • Stored Procedures: Learn to create and define stored procedures for reusable code.
  • Triggers: Understand how to create and define triggers to automate actions.
  • Functions: Create and define custom functions.

Course Details:

  • Content: 7 hours of demonstration, 30 minutes of theory. (Theory is presented in class, not within the course itself.)
  • Practice: Over 50 exercises to reinforce your learning!

Why Learn SQL?

SQL is a highly sought-after skill in today's job market. Proficiency in SQL Server administration and querying is a valuable asset. SQL Server's simplicity allows you to quickly gain expertise in critical data management topics. By the end of this course, you'll be much more comfortable working with SQL and managing data effectively.

We've kept the course concise and engaging, ensuring you don't get bogged down in unnecessary details. Get ready to confidently harness the power of SQL Server!

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

SQL w Praktyce!

by Łukasz Bartnicki

5.0(60)
2h 30m
all

SQL w Praktyce! - Zaawansowany

by Łukasz Bartnicki

5.0(63)
2h 3m
all
5.0(7)
4h 39m
beginner
5.0(15)
1h
beginner
5.0(25)
10h 2m
beginner