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 WORKINGWITHDATA!
Maybe you're an Excel user who has done a little bit of SQLcode, or maybe you have quite a bit of database experience. Either way, we've made this course to help you become skilled at with SQLcode and MSSQLServer 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 inExcel, either with the size of data or the complexity of your processes, then SQLServer is a logical next step.It allows great control, faster data processing and more reliable and repeatable results than working in spreadsheets. SQLis (thankfully)a straightforward programming language to learn. This course will teach you everything you to start working with databases today. The course includes:
Downloadable lesson code files
Challenge lessons to practice your skills
SQLKeyboard 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 SQLServer 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 popularExcel 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 SQLand Microsoft SQLServer. 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 SQLServer 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 SQLwith 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 SQLServer setup and configuration, downloading a sample database, covering how to write tidy code, and how to navigate the SQLServer interface. You'll know the main commands needed to run a basic query, and how to filter your results using the WHEREclause. 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:
SQLBasics
Working with the different types of objects and data inSQLServer
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
