Learn SQL from scratch with our comprehensive beginner's course, covering tables, data types, functions, and the SELECT statement, using SQL Server 2012-2022.
This beginner-friendly SQL course walks you through the essentials of SQL Server, focusing on data types, functions, and the SELECT statement. You’ll learn how to manipulate data while having fun and soaking up real-world skills along the way.
SQL Database for beginners: Tables, data types + functions, and the SELECT statement. SQL Server 2012-2022, inc. 2019
Reviews:
"Best I've seen. Instead of just throwing information at me, I'm able to work along with the instructor. Thanks!!!" -- Charles Schweiger
"Lots of material covered in an easy-to-follow way. Not too slow, and not too face. Great job!" -- Anita Parks
This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012/2014". Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL.
This course takes some of the basics and then goes in depth. The basics presented are: how to install SQL Server, and how to create and drop tables.
We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.
In session 2 (the second half of this course), we'll look at the 6 principal clauses of the SELECTÂ statement:Â SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. We'll look at how the FROMÂ can be expanded to JOIN 2 or 3 tables, and then we'll finish by inserting, updating and deleting data.
No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!
There are regular quizzes to help you remember the information.
Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, and have an appreciation of how they can all be used in T-SQL.
create, alter and drop tables in a database.
create our first queries.
know what data type to use in various situations.
11 Lectures
6 Lectures
7 Lectures
11 Lectures
8 Lectures
7 Lectures
3 Lectures
4 Lectures
4 Lectures
8 Lectures
1 Lectures
Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 800,000 students and more than 40 video courses, including over a dozen Bestseller courses.My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more....
I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.Our courses are available on Udemy at any time, so...
ć—
nice
.
good
Good Course
Excellent
Too long of an introduction, I want to just start learning
Good
nice
Your email address will not be published. Required fields are marked *
Natalia F.
Great course. One of the best about SQL and one of the best on Udemy that I've taken. Suitable both for beginners and for refreshing your knowledge.