99 queries to master SQL in less than 4 hours!
Learn Transact SQL basics in 4 hours! Quickly write your first database queries. Perfect for beginners.
Course Content
99 queries to master SQL in less than 4 hours! is a beginner-level Udemy course taught by ELOA FORMATION | SQL | Postgres | Powershell| MySQL | Python | TSQL Administration,TSQL, and SQL Server performance.. It runs 5h 4m, is taught in English, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 3 reviews, with 34 students enrolled. It is a paid course, last updated June 2024.
Looking to master SQL and TSQL? This course is perfect for SQL beginners who want to quickly learn how to write effective queries.
After setting up SQL Server on your computer, you'll follow a structured learning path:
- Table Creation & Definition: Learn how to design and build your own database tables.
- Data Manipulation: Master SELECT, UPDATE, and DELETE statements to manage your data. Also, discover how to efficiently INSERT new records.
- Data Filtering & Selection: Learn to retrieve specific data using TOP, DISTINCT (to remove duplicates), and powerful operators like BETWEEN, AND, OR, and HAVING.
- Advanced Operators & Functions: Explore PRINT statements, GROUP BY, and more.
- Combining Queries: Utilize UNION and UNION ALL to combine results from multiple queries.
- String Manipulation: Learn to use TRIM, LTRIM, RTRIM, UPPER, and LOWER for data cleaning and formatting.
- Table Copying & Comparison: Copy tables using SELECT INTO and understand comparison operators like = and !=.
- Aggregate Functions: Become proficient with MIN, MAX, and AVG to analyze your data.
- Mastering Joins: A comprehensive, 1 hour 30 minute deep dive into JOIN operations, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
This course is designed for rapid learning with videos under 10 minutes to keep you engaged.
Why Learn SQL?
SQL skills are in high demand! SQL Server administration and TSQL querying are essential skills for a full-time career. SQL Server's user-friendly nature allows you to quickly become proficient in specific areas. With an average rating of 4.4/5 from my other courses, you can be confident in the quality of this training. Start your journey to becoming a SQL expert today!
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.