Introduction To Databases With SQL
Skill Success
Summary
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
Certificates
Certificate of completion
Digital certificate - Included
Course media
Description
Who this course is for:
- This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server
- Anyone who wants to learn SQL
- Anyone who wants to learn Databases
What you'll learn:
Basic concepts like:
- Select Statements
- Where, And or Not
- How to Order and Group By
More difficult concepts like:
- Having and Top Clauses
- Select Distinct
- Union
- And Functions
Advanced concepts like:
- Insert and Update Statements
- Deleting and Altering Tables
- Joining Tables
- Primary Keys
- Indexing
Introduction To Databases With SQL will cover the following topics:
Section 1 - Introduction
- Introduction
- Database Concepts
- Data Types
- Download And Install SQL Server
- Download And Install SSMS
- Connect To Server
- System Databases
- Creating A Database And Table
- Adding Data To A Table
- Intro To SQL
- Select Statements
- Where Clause
- And Or Not
- Order By
- Group By
- The Having Clause
- The Top Clause
- Select Distinct
- Union
- Functions
- Insert Statement
- Update Statement
- Delete Statement
- Alter Table
- Null
- Creating A Table
- Drop Table
- Primary Key
- Intro To Joining Tables
- Inner Join
- Left, Right, And Outer Join
- Indexing
Who is this course for?
This course is designed for those interested to understand and use SQL with Databases.
Requirements
No prior knowledge is required to take this course.
Career path
None
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Sidebar navigation
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.