Microsoft SQL - Getting Started With The T SQL Basics

Microsoft SQL - Getting Started With The T SQL Basics

Do you want to level up your data analytics skills?

Do you want to learn the world’s most popular database software, used by corporations and businesses all over the world?

If so, you’re in the right place - and we’re happy to have you here!

It's great to have you here. WE LOVE WORKING WITH DATA!

Maybe you're an Excel user who has done a little bit of SQL code, or maybe you have quite a bit of database experience. Either way, we've made this course to help you become skilled at with SQL code and MS SQL Server databases.

Start building databases, manipulating data and building data analytics capabilities in your job today!

If you've started to hit the limits of what is possible in Excel, either with the size of data or the complexity of your processes, then SQL Server is a logical next step. It allows great control, faster data processing and more reliable and repeatable results than working in spreadsheets. SQL is (thankfully) a straightforward programming language to learn. This course will teach you everything you to start working with databases today. The course includes:

1. Downloadable lesson code files

2. Challenge lessons to practice your skills

3. SQL Keyboard Shortcuts Cheat Sheet to download for quick reference

What makes me qualified to teach you?

I'm Martyn Blythin, and I've been using T SQL (Microsoft SQL) and SQL Server for over a decade. I'm a data scientist and have worked for many global financial services corporations, building data analytics, KPI dashboards and databases.

Plus, I run some of Udemy's most popular Excel courses, with over 30,000 students and thousands of 5-star reviews like these ones:

The instructor does a good job of starting simple and building up to more complex ideas using practical examples.

— Jerrett M

Martyn's course is simple and coherent. It is well taught and I do feel that I’ve gained important, practical information.

— Shoma B

Thoroughly enjoyed the course as it was very well paced. Bite sized yet providing clear concise detailed instructions that I could follow the activities in a separate file and learn by doing. Good clarity in speech and good examples help. The instructor also reverts back quickly if you have a question or suggestion.

— Cathy B

MY PROMISE TO YOU

I'll be here for you every step of the way. If you have any questions about the course content or anything related to this topic, you can always post a question in the course or send me a direct message.

We want to make this the best course on learning T SQL and Microsoft SQL Server. So if there is any way we can improve this course, just tell us and we'll make it happen.

WHAT'S THIS COURSE ALL ABOUT?

Whether you're using Microsoft SQL for the first time or are brushing up on your skills this course will teach you how to use Microsoft SQL Server Express and Microsoft Transact SQL to its fullest potential.

When you are done with this course you'll be able to work with data in SQL with ease. You'll be able to manipulate data tables, create new ones and query your existing data to answer specific data questions with confidence.

You'll also be able to add to and edit existing data tables and spend less time working in Excel. You'll be able to export your query results to Excel where needed to turn data into reports.

We’ll do this by covering SQL Server setup and configuration, downloading a sample database, covering how to write tidy code, and how to navigate the SQL Server interface. You'll know the main commands needed to run a basic query, and how to filter your results using the WHERE clause. You'll be able to sort and group your query results and how to insert, amend and delete data from tables, and much more.

Make your database skills count with this great course!

Each lesson is available for download, so you can take it with you wherever you go.

KEY TOPICS:

• SQL Basics

• Working with the different types of objects and data in SQL Server

• How to Navigate a SQL database for beginners

• Selecting data using simple queries

• Using Where clauses to query specific data in tables

• Aggregate queries - learn to sum, count and average numeric fields

• Sorting your query results

• Joining tables together

• Update data in tables

• Insert new rows into tables

• Create new tables

• Delete and clear table contents

With our 30-day 100% money back guarantee, there is nothing holding you back from jumping in right now and trying the course out.

Go ahead and click the enroll button, and I'll see you in lesson 1!

Cheers,

Martyn

A complete guide to Microsoft T-SQL for Beginners, Microsoft SQL Server Express & SQL For Data Analysis / SQL Server DBA

Url: View Details

What you will learn

• Learn to use and navigate the SQL server interface
• Learn about the different object and data types in SQL Server
• Select specific data from tables and views

Rating: 4.3

Level: Beginner Level

Duration: 3 hours

Instructor: Martyn Blythin