YoVDO

70-461 Sessions 1 and 2: Querying Microsoft SQL Server

Offered By: Udemy

Tags

Microsoft SQL Server Courses Data Manipulation Courses Database Management Courses T-SQL Courses SELECT Statements Courses Table Joins Courses

Course Description

Overview

SQL Database for beginners: Tables, data types + functions, and the SELECT statement. SQL Server 2012-2022, inc. 2019

What you'll learn:
  • create, alter and drop tables in a database.
  • create our first queries.
  • know what data type to use in various situations.
  • use functions to manipulate date, number and string data values.

Reviews:

"Best I've seen. Instead of just throwing information at me, I'm able to work along with the instructor. Thanks!!!" -- Charles Schweiger

"Lots of material covered in an easy-to-follow way. Not too slow, and not too face. Great job!" -- Anita Parks

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012/2014". Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL.

This course takes some of the basics and then goes in depth. The basics presented are: how to install SQL Server, and how to create and drop tables.

We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.

In session 2 (the second half of this course), we'll look at the 6 principal clauses of the SELECTstatement:SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. We'll look at how the FROMcan be expanded to JOIN 2 or 3 tables, and then we'll finish by inserting, updating and deleting data.

No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!

There are regular quizzes to help you remember the information.

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, and have an appreciation of how they can all be used in T-SQL.


Taught by

Phillip Burton

Related Courses

A Hands-On Look at Amazon Q Business Expert
Amazon Web Services via AWS Skill Builder
Amazon Aurora - Cloud SQL DB Essentials
A Cloud Guru
Amazon DynamoDB Data Modeling
A Cloud Guru
AWS Certified Database - Specialty (DBS-C01)
A Cloud Guru
Database Essentials
A Cloud Guru