A complete course in SQL with SQL server
This course will take you from novice to expert level in SQL development using SQL server
4.65 (231 reviews)
848
students
14.5 hours
content
Feb 2024
last update
$64.99
regular price
What you will learn
Setup SQL Server and use SQL Server management studio (SSMS) and azure data studio to write queries.
Setup an Azure cloud instance of SQL Server.
Select, sort and filter data with an understanding of the order of precedence.
Modify data with string, date, and maths functions.
Convert data types and apply decision logic.
Aggregate and group data both to the entire table and in line with windows functions.
Facilitate more complex requirements with sub-queries.
Structure of table relationships and cardinality.
Join tables together with the INNER, OUTER, FULL and CROSS joins.
Union multiple data sets together.
Understand OLTP and OLAP data architectures along with 3rd Normal Form and ACID transactions.
CREATE, ALTER, and DROP a database, table, and schema.
Add column, primary and foreign key constraints to a table.
Indexes for use in query optimisation.
Insert, update, and delete data into a table.
Advanced features including views, stored procedures, functions, locks, transactions, cursors, and triggers.
Import, export and alter JSON and XML data structures into and out of tables.
Screenshots
Related Topics
4236108
udemy ID
8/11/2021
course created date
12/4/2022
course indexed date
Bot
course submited by