Course Description
In this course students learn to use Management Studio and build basic and advanced Structured Query Language (SQL) statements to retrieve and update data in a database. Topics include how to use Management Studio, retrieving data from one or more tables, Joins, Subqueries, Insert, Update and Delete, Data Types, and SQL Server Functions. SQL DDL commands for creating databases, tables, indexes and views are also covered. Special emphasis is given to Functions, Joins, and Subqueries. Management Studio and its capabilities and tools are also explored.
Part of These Certificates
Terminology
What is SQL Server
How to use the Management Studio
SQL Basics, retrieving data from one tableBasic SELECT StatementsSELECT listFROM clauseWHERE clauseORDER BY clause
Basic SELECT Statements
SELECT list
FROM clause
WHERE clause
ORDER BY clause
Summary QueriesGROUP BY and HAVING clause
GROUP BY and HAVING clause
Joins, retrieving data from two or more tables
Subqueries
Manipulating DataInsertUpdateDelete
Insert
Update
Delete
SQL Data Types
Functions
DDL CommandsCreating TablesCREATE TABLEConstraintsIndexesALTER TABLECreating Views
Creating TablesCREATE TABLEConstraintsIndexesALTER TABLE
CREATE TABLE
Constraints
Indexes
ALTER TABLE
Creating Views
Night
$1,69500
Night
$1,69500
Night
$1,69500
Related Courses
Earning a SLU certificate allows you to enhance your career options by networking with peers and establishing valuable industry contacts.
No related courses found.
Our Testimonials
"We equip professionals with in-demand skills, strategically aligning our courses with industry needs and ensuring our curriculum reflects the latest technologies."
Our Training Partners
