Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn SQL with Microsoft SQL Server
Rating: 4.6 out of 5(703 ratings)
4,859 students

Learn SQL with Microsoft SQL Server

Understanding Databases and SQL
Created byJohn Elder
Last updated 11/2023
English

What you'll learn

  • Understand and Use Databases
  • Understand and Use SQL with Databases
  • Know How To Install and Use Microsoft SQL Server

Course content

3 sections35 lectures1h 58m total length
  • Introduction2:10
  • First Things First: How To Get Support Fast!0:09

    Check out my student Facebook Group...

    It's a great place to get fast support for this course from me, to interact with other students, to post your projects and code, and to access course announcements and extras...

    Join Now!

    https://www.facebook.com/groups/codemycom/

  • Database Concepts4:33
  • Data Types4:47

Requirements

  • There are no programming skills necessary to take this course
  • There is no special software needed for this course, we'll download the trial version of Miscrosoft SQL Server

Description

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!


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