Learn SQL with Microsoft SQL Server
Learn SQL with Microsoft SQL Server, available at $64.99, has an average rating of 4.75, with 39 lectures, based on 680 reviews, and has 4809 subscribers.
You will learn about Understand and Use Databases Understand and Use SQL with Databases Know How To Install and Use Microsoft SQL Server This course is ideal for individuals who are This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server or Anyone Who Wants To Learn SQL or Anyone Who Wants To Learn Databases It is particularly useful for This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server or Anyone Who Wants To Learn SQL or Anyone Who Wants To Learn Databases.
Enroll now: Learn SQL with Microsoft SQL Server
Summary
Title: Learn SQL with Microsoft SQL Server
Price: $64.99
Average Rating: 4.75
Number of Lectures: 39
Number of Published Lectures: 35
Number of Curriculum Items: 39
Number of Published Curriculum Objects: 35
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- Understand and Use Databases
- Understand and Use SQL with Databases
- Know How To Install and Use Microsoft SQL Server
Who Should Attend
- 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
Target Audiences
- 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
In this course I’ll teach you Structured Query Language – SQL for short – the fast and easy way.
We’ll download and use the free trial version of Microsoft SQL Server and I’ll teach you exactly how to use it like a pro.
Databases are incredibly important in our modern world, and they remain a mystery to most people. But they’re actually pretty easy to use if you know just a few things…and I’ll teach you those things in this course.
We’ll start out by learning fundamental database concepts, like… what is a database, what is a table, what are rows and columns, and what are data types.
After that I’ll show you how to set up and use Microsoft SQL Server.
Then we’ll dive right in to SQL itself. I’ll teach you basic concepts like
– Select Statements
– Where, And or Not
– How to Order and Group By
– And cool things like that.
Then we’ll move into slightly more difficult concepts like
– Having and Top Clauses
– Select Distinct
– Union
– And Functions
Then we’ll jump into more advanced concepts like
– Insert and Update Statements
– Deleting and Altering Tables
– Joining Tables
– Primary Keys
– Indexing
– And more!
When you get right down to it, using Databases with SQL is pretty easy, and actually a lot of fun.
Join me today and I’ll see you inside!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: First Things First: How To Get Support Fast!
Lecture 3: Database Concepts
Lecture 4: Data Types
Chapter 2: Installation and Setup
Lecture 1: Download and Install SQL Server
Lecture 2: SQL Server Download Update
Lecture 3: Download and Install SSMS
Lecture 4: Connect To Server
Lecture 5: System Databases
Lecture 6: Creating a Database and Table
Lecture 7: Adding Data To A Table
Chapter 3: Structured Query Language – SQL
Lecture 1: Intro To SQL
Lecture 2: Select Statements
Lecture 3: Where Clause
Lecture 4: And or Not
Lecture 5: Order By
Lecture 6: Group By
Lecture 7: The Having Clause
Lecture 8: The Top Clause
Lecture 9: Select Distinct
Lecture 10: Union
Lecture 11: Functions
Lecture 12: Insert Statement
Lecture 13: Update Statement
Lecture 14: Delete Statement
Lecture 15: Alter Table
Lecture 16: Null
Lecture 17: Creating A Table
Lecture 18: Drop Table
Lecture 19: Primary Key
Lecture 20: Intro To Joining Tables
Lecture 21: Inner Join
Lecture 22: Left, Right, and Outer Join
Lecture 23: Indexing
Lecture 24: Bonus Lecture
Instructors
-
John Elder
Founder of Codemy
Rating Distribution
- 1 stars: 11 votes
- 2 stars: 17 votes
- 3 stars: 68 votes
- 4 stars: 256 votes
- 5 stars: 328 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Emotional Intelligence Courses to Learn in December 2024
- Top 10 Time Management Courses to Learn in December 2024
- Top 10 Remote Work Strategies Courses to Learn in December 2024
- Top 10 Freelancing Courses to Learn in December 2024
- Top 10 E-commerce Strategies Courses to Learn in December 2024
- Top 10 Personal Branding Courses to Learn in December 2024
- Top 10 Stock Market Trading Courses to Learn in December 2024
- Top 10 Real Estate Investing Courses to Learn in December 2024
- Top 10 Financial Technology Courses to Learn in December 2024
- Top 10 Agile Methodologies Courses to Learn in December 2024
- Top 10 Project Management Courses to Learn in December 2024
- Top 10 Leadership Skills Courses to Learn in December 2024
- Top 10 Public Speaking Courses to Learn in December 2024
- Top 10 Affiliate Marketing Courses to Learn in December 2024
- Top 10 Email Marketing Courses to Learn in December 2024
- Top 10 Social Media Management Courses to Learn in December 2024
- Top 10 SEO Optimization Courses to Learn in December 2024
- Top 10 Content Creation Courses to Learn in December 2024
- Top 10 Game Development Courses to Learn in December 2024
- Top 10 Software Testing Courses to Learn in December 2024