Learn SQL (Microsoft SQL) - Beginner's Course
What you'll learn
- What is Database, RDBMS and why do we need it?
- SQL fundamentals and Types of commands (DDL,DML,DCL and TCL)
- What are constraints and how to use these constraints (such as Primary key, Foreign Key along with some more)
- Various Datatypes and Operators
- Grouping of data using Group By and Order By
- What is Inner Query and Co-related query with an example
- Types of Joins with Example (Inner Join, Outer Join, Left, Right and Cross Join)
Requirements
- Microsoft SQL Express 2017 installed
- SQL Server Management Studio 2017 installed
- SQL Server management studio must be configured to connect to SQL Express instance.
Description
SQL (Structured Query Language) is a language which is used to interact with databases which stores data. Microsoft provides SQL Server to manage the data and the query language which enables to store and retrieve the data with ease. With the emergence of Big Data and Business Intelligence there is an extensive demand for the resources who has basic SQL skills.
This course will teach you how to use the SQL language with Microsoft SQL Server, one of the popular database server in the world.
In this course we will learn the following topics
Introduction to SQL
SQL Constraints
SQL Data types
DDL, DML, DCL & TCL
SQL Operators
Groups in SQL
Built-in Functions in SQL
Sub-Query, Inner Query, Co-related Query
Joins, Inner,Outer,Left and Cross Join
At the end of the course, you will gain a good knowledge and will be able to write SQL queries with ease.
Who this course is for:
- Anyone who knows Excel and want to learn databases
- Anyone working with databases, tables and lots of data
- Those who are joining as fresher who are joining an organization where Databases are used
- College students who works on their projects using databases
- Those who collects the data in Excel and would like to move their data to database
- Those who wants to potentially clear interviews and land into a job.
Course content
- Preview05:40
- Preview10:56
Instructor
![Rajkumar B](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 32 Reviews
- 3,146 Students
- 7 Courses
At some stage, i was also a beginner and i have worked on many technology and my courses will have beginners touch to it. I have vast experience and hopefully the students will benefit from my experience and mutual feedback. Please provide your valuable comment so that the future courses can be improved.