The Complete MS SQL Course
Free eCertificate | Limited time | SQL Masterclass | Tutor Support | Video Lessons
Frontier Education
Summary
- Reed courses certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
This is the Complete MS SQL course, includes a whole host of practical tips and advice, helping you to develop your MS SQL skills to become the Data Analyst or the professional you can be.
Packed with full of videos, PDFs and exercises, it'll equip you with what it takes to be a successful Data Analyst in today’s business landscape, covering a broad range of topics.
Curriculum
Course media
Description
With expert guidance and a combination of videos, PDFs, and worksheets, this course will enable you to develop your Database Design, become a Business Analyst and unlock your full potential.
This The Complete MS SQL Course course covers:
- What you need to know
- Tailoring your approach to maximise impact
- Mastering SQL Environment Setup
- SQL Statement Basics
- SQL Query Operators
You’ll also be able to access a number of exclusive bonus resources to help you along your The Complete MS SQL Course journey, including:
- Subqueries
- Data Definition Language (DDL) & Data Manipulation Language (DML)
Course Curriculum :
Course Introduction
- Introduction
- Course Curriculum overview
- Overview of Databases
SQL Environment Setup
- MSSQL Installation
- MSSQL Management Studio Installation
- Connecting to MS-SQL (Windows Authentication)
- Connecting to MS-SQL (SQL Server Authentication)
SQL Statement Basics
- Overview of Challenges
- SQL Statement Basic
- SELECT Statement
- SELECT DISTINCT
- Column AS Statement
- COUNT
Filtering Data Rows
- SELECT WHERE Clause – One
- SELECT WHERE Clause – Two
SQL Query Operators
- ORDER BY
- TOP in MSSQL
- BETWEEN
- IN
- LIKE
Overview of GROUP BY
- Aggregation Function – SUM()
- Aggregation Function – MIN()-MAX()
- GROUP BY – One(theory)
- GROUP BY – Two(practical)
- HAVING
JOINS
- Overview of JOINS
- Introduction to JOINS
- AS Statement
- INNER Join
- Full Outer Join
- Left Outer Join
- Right Outer Join
- Union
Advanced SQL Commands
- Basic of Advanced SQL Commands
- Timestamp
- Extract from Timestamp
- Mathematical Scalar Functions
- String Functions
- Sub Query
Creating Database and Tables
- Basic of Database and Tables
- Data Types
- Select Data type on SSMS
- Create Table on SSMS
- How to set Primary Key
- How to set Foreign Key
- Create Table using SQL Script
SQL CRUD Operations
- Insert
- Update
- Delete
- Alter Table
- Drop Table
- Check Constraint
- NOT NULL Constraint
- UNIQUE Constraint
Backup and Restore Functions
- Overview of Database and Tables
- Creating a Database backup using SSMS
- Restoring a Database from backup using SSMS
Top reasons to Study Online at Frontier Education
- Tailor made: Course adapted to market needs and interests
- Flexible programs: study and work at your own pace on easy-to-use web platforms
- Online education: progressive teaching methods with video or easy to understand medium
- Multicultural: connect with classmates from all corners of the globe
Who is this course for?
This Complete MS SQL Course is ideal for people looking to progress their career into a Data Analyst, for those who want to become Financial Analyst, as well as looking to further develop their skills and knowledge.
Requirements
-
Positive attitude and desire to learn
-
Passion to become SQL database administrator
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Reed courses certificate of completion
Digital certificate - Included
Will be downloadable when all lectures have been completed
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
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.