This course is designed for those interested to understand and use SQL with Databases. Read more.
John Elder is a the founder and CEO of Codemy.com where he has taught over 150,000 people to code, as well as an Amazon #1 Best-Selling Author.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server
- Anyone who wants to learn SQL
- Anyone who wants to learn Databases
What you’ll learn:Â
- Select StatementsÂ
- Where, And or NotÂ
- How to Order and Group By
- Having and Top Clauses
- Select DistinctÂ
- Union
- And Functions
- Insert and Update Statements
- Deleting and Altering Tables
- Joining TablesÂ
- Primary Keys
- IndexingÂ
Requirements:Â
- No prior knowledge is required to take this course
Our Promise to You
By the end of this course, you will have learned how to use SQL on databases.Â
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about SQL.
Course Curriculum
| Section 1 - Introduction | |||
| Introduction | 00:00:00 | ||
| Database Concepts | 00:00:00 | ||
| Data Types | 00:00:00 | ||
| Download And Install SQL Server | 00:00:00 | ||
| Download And Install SSMS | 00:00:00 | ||
| Connect To Server | 00:00:00 | ||
| System Databases | 00:00:00 | ||
| Creating A Database And Table | 00:00:00 | ||
| Adding Data To A Table | 00:00:00 | ||
| Intro To SQL | 00:00:00 | ||
| Select Statements | 00:00:00 | ||
| Where Clause | 00:00:00 | ||
| And Or Not | 00:00:00 | ||
| Order By | 00:00:00 | ||
| Group By | 00:00:00 | ||
| The Having Clause | 00:00:00 | ||
| The Top Clause | 00:00:00 | ||
| Select Distinct | 00:00:00 | ||
| Union | 00:00:00 | ||
| Functions | 00:00:00 | ||
| Insert Statement | 00:00:00 | ||
| Update Statement | 00:00:00 | ||
| Delete Statement | 00:00:00 | ||
| Alter Table | 00:00:00 | ||
| Null | 00:00:00 | ||
| Creating A Table | 00:00:00 | ||
| Drop Table | 00:00:00 | ||
| Primary Key | 00:00:00 | ||
| Intro To Joining Tables | 00:00:00 | ||
| Inner Join | 00:00:00 | ||
| Left, Right, And Outer Join | 00:00:00 | ||
| Indexing | 00:00:00 | ||
About This Course
Who this course is for:
- This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server
- Anyone who wants to learn SQL
- Anyone who wants to learn Databases
What you’ll learn:Â
- Select StatementsÂ
- Where, And or NotÂ
- How to Order and Group By
- Having and Top Clauses
- Select DistinctÂ
- Union
- And Functions
- Insert and Update Statements
- Deleting and Altering Tables
- Joining TablesÂ
- Primary Keys
- IndexingÂ
Requirements:Â
- No prior knowledge is required to take this course
Our Promise to You
By the end of this course, you will have learned how to use SQL on databases.Â
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about SQL.
Course Curriculum
| Section 1 - Introduction | |||
| Introduction | 00:00:00 | ||
| Database Concepts | 00:00:00 | ||
| Data Types | 00:00:00 | ||
| Download And Install SQL Server | 00:00:00 | ||
| Download And Install SSMS | 00:00:00 | ||
| Connect To Server | 00:00:00 | ||
| System Databases | 00:00:00 | ||
| Creating A Database And Table | 00:00:00 | ||
| Adding Data To A Table | 00:00:00 | ||
| Intro To SQL | 00:00:00 | ||
| Select Statements | 00:00:00 | ||
| Where Clause | 00:00:00 | ||
| And Or Not | 00:00:00 | ||
| Order By | 00:00:00 | ||
| Group By | 00:00:00 | ||
| The Having Clause | 00:00:00 | ||
| The Top Clause | 00:00:00 | ||
| Select Distinct | 00:00:00 | ||
| Union | 00:00:00 | ||
| Functions | 00:00:00 | ||
| Insert Statement | 00:00:00 | ||
| Update Statement | 00:00:00 | ||
| Delete Statement | 00:00:00 | ||
| Alter Table | 00:00:00 | ||
| Null | 00:00:00 | ||
| Creating A Table | 00:00:00 | ||
| Drop Table | 00:00:00 | ||
| Primary Key | 00:00:00 | ||
| Intro To Joining Tables | 00:00:00 | ||
| Inner Join | 00:00:00 | ||
| Left, Right, And Outer Join | 00:00:00 | ||
| Indexing | 00:00:00 | ||
Course Review
4.8
6 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
Easy, conversational style
I found John’s instructional voice very conversational, easy to follow and understand. I tried to keep up with my own instance of SQL SM Studio but hit some snags. Decided to try to absorb the concepts versus get hung up. Good course.
Just Finished, Training was well organized.
Wow, very easy to understand. Loved how precise the videos were and how there wasn’t any wasted air time. I finished this entire course in a day and I understood everything presented. Thank you for posting.
Great Intro
Great intro to SQL!
Introduction to Databases With SQL
Great review for folks who are going back to using SQL. Great for beginners John was easy to understand and follow along.
Good Place to Start
This is a very good introductory course and is presented in an easy to follow manner. Any beginner should complete this if starting out with SQL and databases.