Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to SQL Server
Rating: 4.3 out of 5(113 ratings)
7,587 students

Introduction to SQL Server

An Introduction to SQL Database Programming with Microsoft SQL Server
Created byJonathan Szeto
Last updated 5/2021
English

What you'll learn

  • Students will get an introductory overview on databases and SQL queries.

Course content

2 sections • 6 lectures • 1h 51m total length

  • Database Overview33:43

    Let’s start with an overview of the fundamentals of databases and the SQL language. Even if you’re familiar with other programming languages like Java, Ruby, or one of the variants of C, databases work in a slightly different manner, and bringing Java thinking into SQL programming is going to result in poorly performing queries that run forever.

  • TUTORIAL: Install SQL Server Developer Edition15:47

    SQL Server Developer Edition is a free version of the SQL Server database system available from Microsoft. Installing this onto your own computer will give you opportunities to practice writing queries. In this tutorial, I'll show you how to download and install it onto your own computer.

  • TUTORIAL: Install the Adventureworks database13:08

    The AdventureWorks database is a sample SQL Server database published by Microsoft for practice and experimentation. It is free to use and can be downloaded from their site. In this tutorial, I'll show you how to download and install the database.

Requirements

  • None.

Description

"Introduction to SQL Server" is a free programming course introducing SQL and databases to new people. Using Microsoft SQL Server as an entry point into the database world, we will cover the concepts of relational databases and SQL (Structured Query Language), the language used to search, retrieve, and sort data from a database.

This course consists of two lesson sections:

  • Database Fundamentals: An overview on relational databases, tables, and SQL.

  • The SELECT Query: An overview of the foundational SQL command, SELECT. We will cover the four major parts of the SELECT query and best practices to follow.

Also included in this course are two tutorials on installing SQL Server on your own computer, so that you can practice writing queries on your own.

This is a beginner level course aimed at people who have had no prior computing experience before. It is well-suited for students who have never worked with computers before. If you have never taken any programming before, this course is suitable for you.

It is also suitable for new or beginner developers looking to improve their back-end development skills or strengthen their database querying skills. Instruction primarily revolves around the Microsoft SQL Server database system. However, the content is suitable for any SQL-based relational database system, such as MySQL, Postgres, or Oracle.

Who this course is for:

  • People curious about databases.

Report abuse