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.
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 theLIKEoperator and learn about aliases for enhanced readability. TOPOperator: 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. COUNTandSUMFunctions: Learn to count rows and calculate totals.BETWEENOperator: Filter data within a specified range.GROUP BYClause: Aggregate data based on specific columns.HAVINGClause: Filter aggregated results.PRINTStatement: 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.
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.