Introduction
- Database Overview
- TUTORIAL: Install SQL Server Developer Edition
- TUTORIAL: Install the Adventureworks database
The SELECT Query
- SELECT Query Overview
- The FROM Clause
- The WHERE Clause
What you'll learn
- Students will get an introductory overview on databases and SQL queries.
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.
The University of Sheffield
Other Courses
How to Pass PMP® Exam in 10 Days
Learn to prepare and pass the Project Management Professional PMP® exam the first time effectively and cost efficiently
10 Steps to an AwesomeSauce You! (Step 6)
This section is about getting what you want NOW.
Hatching Hordes of Customers with Twitter in 1 Hour
Start using Twitter to promote your business: from first steps to automated systems to make it sustainable.
Time Management Accelerator: Turbocharge Your Productivity
Accelerate your journey to success with our time management masterclass, designed to turbocharge your productivity.
Ableton Certified Training: Getting Started with Live 12
A FREE introduction to Live 12 by Ableton Certified Trainer and University Professor J. Anthony Allen.
About the instructors
- 4.52 Calificación
- 11329 Estudiantes
- 3 Cursos
Jonathan Szeto
IT Professional
I am a professional IT developer specializing in programming and database development. I have been coding for over eleven years, primarily in the Microsoft suite of languages (.NET and SQL Server), but I have also made forays into PHP and MySQL.
I began coding after spending a decade in manufacturing and getting fed up with factory work. I believe that anyone can code if they really want to and are willing to put in the work to get good at it. It's my mission to help programmers be the best programmers they are capable of becoming.
Student feedback
4.55
Course Rating
Reviews
Jericho Zenarosa Obog
18-04-2024
I was expecting more hands-on example similar to DataCamp. I'm already familiar with most of the content. At least I learned some new details.
Abinaya
24-03-2024
good
Patrick Gonzalez
29-12-2023
Good content but missing more real live examples
Gerardo Campero
01-12-2023
Excelente
Sajan Limbu
19-06-2023
it gave me the broad overview of both the relational and no relational database..