
This course includes our updated coding exercises so you can practice your skills as you learn.
See a demo
Install SQL Server Express from the Microsoft site, run a basic setup, and learn about instances, databases, and SQL Server Management Studio for local host connections.
Learn to create a bookstore database in SQL Server using SQL Server Management Studio, including connecting, writing a first query, and the master and dbo schema.
Discover how to filter and sort data with SQL keywords such as distinct, and, or, like, in, between, and not, and apply order by to shape result sets.
Whether you are a computer science student, an aspiring data analyst, data scientist, or a future data engineer, SQL is one of the essential skills to succeed in your Data career. SQL will enable you to store and retrieve exactly the Data you need by writing the right queries.
Learn SQL by doing this step-by-step course that covers all you need to start working with SQL.
I am a certified Data Engineer and have worked for multiple companies including Fortune 500 companies like IBM and SAP. I am using SQL in my day-to-day job for our customers' projects and I have gathered here all you need to start writing SQL queries.
This course is intended for people with little to no SQL experience.
At the end of this course, you will become confident in using SQL Server by writing the most used SQL queries
You will learn how to :
- Create a Database
- Create Tables
- Retrieve Data
- Write simple and complex SQL queries including queries with Group By clauses
- Use Joins to join data between multiple tables
and much more!
Today, SQL Server is one of the most used SQL Database Management System and is often used by many companies including Fortune 500 companies.
This will be your 1-on-1 course where you can ask all questions you have in the dedicated section. I will be glad to assist you in your learning journey.