SQL Server per i manichini (7 ore di pratica)

Learn SQL Server with Italian Subtitles: A Beginner's Guide

Ready to dive into the world of SQL Server? This course is perfect for complete beginners who want to learn Transact SQL and gain valuable database skills. Even though the instruction is in English, you'll have access to Italian subtitles to ensure you understand every step.

Here's what you'll master:

• SQL Server Setup & Management: Learn to install and manage SQL Server on your own computer.
• Database & Table Creation: Understand how to create and define databases and tables.
• Data Manipulation (CRUD): Master essential operations like SELECT, INSERT, UPDATE, and DELETE to manage your data effectively.
• Advanced SELECT Statements: Explore the power of aliases, the nuances of LIKE (including wildcards!), and the usefulness of TOP.
• Data Cleaning & Deduplication: Learn to remove duplicate data using DISTINCT and understand comparison operators like =, !=, and more.
• Table Copying: Efficiently copy tables using SELECT INTO.
• Logical Operators: Utilize IN, NOT IN, IS, and IS NOT for complex queries.
• Data Ordering: Sort your data with ORDER BY.
• Aggregate Functions: Discover the power of MIN, MAX, AVG, and the logical operators AND and OR.
• COUNT & SUM: Learn to use COUNT and SUM for data analysis, and filter data with BETWEEN.
• GROUP BY & HAVING: Aggregate and filter data using GROUP BY and HAVING.
• Joins: Master different types of joins including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN to combine data from multiple tables.
• Transact SQL Functions: Explore advanced T-SQL functions like CHOOSE, IIF, CASE WHEN, SUBSTRING, and OFFSET FETCH NEXT ROWS.
• String Manipulation: Learn to use CHOOSE, TRIM, LTRIM, RTRIM, and COALESCE.
• UNION & LEFT/RIGHT: Understand UNION, UNION ALL, and the LEFT and RIGHT functions.
• Data Type Conversion: Utilize CAST and CONVERT, as well as TRY_CAST and TRY_CONVERT.
• Views & Stored Procedures: Create and define database views and stored procedures for efficient data management.

Course Details:

• Duration: 7 hours of demonstrations + 30 minutes of theory. (Theory is delivered in class, not within this course).
• Practice: Includes over 30 exercises to reinforce your learning.

Why Learn SQL?

SQL is a highly sought-after skill in today's job market. SQL Server administration and T-SQL querying are in high demand. SQL Server's relative simplicity allows you to quickly become proficient in specific database areas. By the end of this course, you'll feel confident and comfortable using SQL!

We've kept the video length under 10 minutes to maintain engagement and prevent information overload. Start your SQL Server journey today!