Complete beginners introduction to SQL
What you'll learn
- Download SQL Server
- Install SQL Server
- Download sample database
- Attach sample database to SQL Server
- Create a database table
- Create a view
- Update Records
- Delete records
- Retrieve and read data from database
- Use SSMS Tool
- Join tables
Requirements
- Basic knowledge of using a pc
Description
SQL -Structural Query language is the language used to interrogate and manipulate Microsoft SQL Server Databases.
SQL is one of the most in demand IT Skills and has been that way for quite a long time. Data growth is increasing and so also is the demand for professionals with SQL skills.
This course is a complete beginners course for those who have had no exposure to SQL.
It is a very basic and practical hands on course to introduce you to SQL.
We will be using SQL Server as our database engine for this course.
Microsoft SQL Server is robust relational database management system used by so many
organizations of various sizes including top fortune 100 companies.
In this course we will cover
Download and Install SQL Server
Database concepts
Download sample database
Attach sample database
Create a view
Create a table
Retrieve and reading data from a database using SELECT Statement
Updating existing data in the database
Deleting records from a database
Use Aliases
Use order by clause
Sort data by ascending order
Sort data by multiple columns
Add new records
Update existing records
Delete records
Joining Tables
Inner joins
Left outer joins
Right Outer joins
SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases.
Who this course is for:
- Basic knowledge of navigating the internet
Instructor
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.
At Bluelime Learning Solutions, our approach is simple: clear, direct, and engaging. We specialize in 100% video-based courses filled with hands-on examples that provide practical skills applicable in real-world scenarios. Our courses are designed to translate complex concepts into easy-to-understand lessons that anyone, regardless of their background, can grasp and apply.
Our extensive experience includes collaborating on projects with Fortune 500 companies, equipping us with the insights needed to understand the essential skills that today’s employers value most. At Bluelime, we’re not just about teaching; we’re about equipping you with the tools and knowledge to excel in your career and personal growth endeavors.
Join us on this journey to unlock your potential and master new skills in an easy, enjoyable, and efficient way with Bluelime Learning Solutions, where learning is made simple and effective.