Features
Premium video tutorials
Award-winning instructors
Personalized learning
Get certified
Learn at your own pace
Mobile (learn on-the-go)
Unlimited tests and quizzes
Regularly updated content
Overview
SQL is the world's most widely used programming language for database management, an essential skill for back-end web development and data analytics. Designed for beginners, this Introduction to SQL course will give you the foundation you need to get started with Structured Query Language in Microsoft SQL Server, through hands-on application and examples.
By the end of the course you will have a practical understanding of how to set up and connect to a server, create databases and tables, insert and update data, and create and filter queries to get the valuable insights you need.
In this course we are using Microsoft SQL Server's T-SQL, but you will be able to apply most of what you learn to many other databases such as MySQL, PostgreSQL, Oracle and more.
Highlights:
- 33 practical tutorials.
- Understand the structure of databases with RDBMS concepts.
- How to set up Microsoft SQL Server and SQL Management Studio.
- Create a new database and add data to tables.
- Back up and restore your database to protect your data.
- Use a SELECT statement to retrieve data.
- Filter records with WHERE, AND, OR clauses.
- Arrange results with ORDER BY and GROUP BY clauses.
- Search within aggregate groups with HAVING clause.
- Calculate data with Count, Average, and Sum functions.
- Update and remove data with UPDATE and DELETE statements.
- Combine and join tables with JOIN clauses.
- Other SQL concepts such as subqueries, indexing and primary key.
Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.
- 720p
- 540p
- 360p
- 0.50x
- 0.75x
- 1.00x
- 1.25x
- 1.50x
- 1.75x
- 2.00x
Summary
Skill level
Beginner
Certificate
Lessons
33
Pre-requisites
None
Video duration
2h 01m
Estimated study time
16h 30m for all materials
Instructor
Syllabus
Intro to Databases & SQL
What is a database?
We will discuss what a database is, the different types of databases and what they are used for
An Overview of SQL
We will discuss what SQL(Structured Query Language) is, what it is used for and some of the different systems that use SQLRDBMS Concepts
We will look at the core concepts and structure of a relational database such as tables, columns, rows, etcWorking With Data Types
We will discuss some of the important data types that may be used in a relational database, including Integer, varchar, text and much moreMicrosoft SQL 2016 Server & Management Studio Setup
Setting Up Microsoft SQL Server
We will install and setup Microsoft SQL Server 2016
Setting Up Microsoft SQL Server Management Studio
We will install and setup SQL Server Management Studio.
Connecting to a Server
We will connect to a server and look at the Object Explorer
System Databases
We will take a look at the master and model databases as well as the msdb and tempdb DatabasesCreating a New Database
We will create a new database within MS SQL Server 2016, and create a new table
Adding Data to a Table
We will add data to our Table
Backing Up & Restoring a Database
You will learn how to backup a database and how to restore a backup
Selecting & Filtering Data 1
Simple SELECT Statements
Here we will start to write SQL statements and queries, starting with basic SELECT statementsWHERE Clause
We can target specific columns using the WHERE clause along with a SELECT statementAND & OR Clause
We can select data based on multiple conditions using the AND & OR clauseORDER BY Clause
We will look at how we can sort returned data using the ORDER BY clause
GROUP BY Clause
We will look at how we can sort returned data using the GROUP_BY clause
Selecting & Filtering Data 2
HAVING Clause
The HAVING clause is similar to a WHERE clause but can use aggregationTOP Clause
The TOP clause is used to limit the number of records that will be returned from a SELECT statementSELECT DISTINCT
We can use DISTINCT to only return distinct or different values in a SELECT statementUNION
The UNION operator is used to combine the result-set of two or more SELECT statementsFunctions
We will look at some built in functions for performing calculations on dataInserting, Updating & Deleting Data
INSERT Statement
We will insert our own records into a database using INSERT INTOUPDATE Statement
The UPDATE statement can be used to change data that already exists in the SQL databaseDELETE Statement
We can use DELETE FROM to remove data from the SQL databaseALTER TABLE
With ALTER TABLE, we can add, remove or change columns, data types and just about anything elseCombining & Joining Multiple Tables
Aliases
Aliases can be used to temporary rename columns and tablesINNER JOIN
We will discuss and write inner joins to combine more than one table in a specific wayOUTER JOIN
We will discuss and write outer joins to combine more than one table in a specific wayLEFT JOIN
We will discuss and write left joins to combine more than one table in a specific wayRIGHT JOIN
We will discuss and write right joins to combine more than one table in a specific wayOther SQL Concepts
Subqueries
We will discuss combining queries together in a subqueryIndexing
We will talk about what indexing is and how to do it within MS SQL ServerPrimary Key
We will discuss the Primary Key and why it's so important