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:
Basic concepts like:
- Select Statements
- Where, And or Not
- How to Order and Group By
More difficult concepts like:
- Having and Top Clauses
- Select Distinct
- Union
- And Functions
Advanced concepts like:
- 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.
30 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 Reviews
Related Courses
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.
Excellent Course
This Course is Amazing, The Instructor will teach you the Syntax Statement and in this Course you will use SQL SERVER 2016 Download and Installing SSMS and Later on you will able to move on from SQL Server 2016 basic to MCSA: SQL Server 2016 and MCSE! I George Mwavalla from Tanzania I will move on to MCSA: SQL Server 2008, 2012/2014, 2016, 2017 and 2019 I wanna be Professional and Expert in Microsoft SQL Server only and John Elder he is the best Instructor in this Course! Thank you SkillSuccess and John Elder God bless both of you guys! Guys You should take this Course immediately and Good Luck