Udemybeginnerit

Impara le basi di transact SQL (5 ore di lezione)

Learn Transact SQL Server 2019! Write queries with 30 exercises in this 4-hour course. Get hands-on SQL skills now.

4.0(3)
15students
5h 5m
Certificate
Olivier Thuillier Amministrazione, TSQL e prestazioni del server SQL.
Olivier Thuillier Amministrazione, TSQL e prestazioni del server SQL.Join the masterclass SQL Server course !

Course Content

Impara le basi di transact SQL (5 ore di lezione) is a beginner-level Udemy course taught by Olivier Thuillier Amministrazione, TSQL e prestazioni del server SQL.. It runs 5h 5m, is taught in Italian, and includes a certificate of completion. Learners rate it 4.0 out of 5 from 3 reviews, with 15 students enrolled. It is a paid course, last updated June 2022.

Struggling to get started with SQL Server? This course is perfect for absolute beginners eager to learn Transact SQL!

Here's what you'll master:

  • SQL Server Installation & Management: Learn to install and manage SQL Server on your own machine. Get hands-on experience setting up your development environment.
  • Database & Table Creation: Understand how to create and define databases and tables – the foundation of any SQL project.
  • Data Manipulation (CRUD Operations): Become proficient in essential data operations:
    • SELECT: Retrieve data from your tables.
    • INSERT: Add new data.
    • UPDATE: Modify existing data.
    • DELETE: Remove data.
  • String Manipulation with LIKE: Discover the power of wildcard searches using the LIKE operator and learn about aliases for enhanced readability.
  • TOP Operator: Learn how to limit the number of rows returned by your queries.
  • Removing Duplicates with DISTINCT: Eliminate redundant data from your results.
  • Comparison Operators: Utilize operators like =, != (not equal to) for precise filtering.
  • Copying Tables with SELECT INTO: Quickly create copies of tables using a single command.
  • Logical Operators (IN, NOT IN, IS, IS NOT): Master conditional filtering with these powerful operators.
  • Data Ordering with ORDER BY: Present your data in a meaningful sequence.
  • Aggregate Functions (MIN, MAX, AVG): Calculate summary statistics from your data.
  • Logical Operators (AND, OR): Combine conditions for complex queries.
  • COUNT and SUM Functions: Learn to count rows and calculate totals.
  • BETWEEN Operator: Filter data within a specified range.
  • GROUP BY Clause: Aggregate data based on specific columns.
  • HAVING Clause: Filter aggregated results.
  • PRINT Statement: Display output within your queries.
  • Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN: Combine data from multiple tables.

Why Learn SQL Server?

SQL is a highly sought-after skill in today's job market. Managing SQL Server and writing T-SQL queries are in-demand skills. SQL Server's relative simplicity allows you to quickly become proficient in specific areas.

This course features concise video lessons (under 10 minutes each) to keep you engaged and learning effectively! You'll gain confidence and comfort with the SQL language.

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

5.0(63)
44m
all
5.0(23)
55m
beginner
5.0(7)
3h 29m
beginner
5.0(10)
5h 2m
intermediate
5.0(1)
1h 46m
beginner