The Complete SQL Server For Beginners
The ultimate practical guide to master SQL Server as a developer (Downloadable SQL Scripts Included).
4.42 (576 reviews)
2,503
students
9.5 hours
content
Aug 2024
last update
$84.99
regular price
What you will learn
Install SQL Server and Management Studio.
Understand basics of cloud databases.
Create SQL Server instances on Microsoft Azure.
Create SQL Server instances on AWS (Amazon Web Services).
Connect Management Studio to your cloud databases.
Create SQL databases and schemas.
Create and manage users in database.
Install AdventureWorks database.
Create tables using SQL script.
Create tables using Management Studio.
Learn about different data types available in SQL Server.
Applying different constraints.
Create primary keys, foreign keys and composite keys.
Design relational databases and create relationships between tables.
Generate Entity Relationship Diagram (ERD).
Import and Export Data using Management Studio.
Create tables using Import Wizard.
Work with select statement.
Filter data using where clause.
Work with and, or, not operators.
Use like operator and wildcards.
Enhance your data selection using (In and between)
How to select distinct column only.
How to work with union and intersect, except operators.
Work with case statement.
Enhancing your data selection with subqueries.
Applying aggregate functions (Min, Max, Avg, Sum, Count)
Group table records using group by keyword.
Filter grouped records using having keyword.
Integrating aggregate functions with group by and having keywords.
Understand what is DML and DDL.
Add new records using insert statement.
Delete records using delete statement.
Update records using update statement.
Generate SQL scripts using Management Studio.
Create inner joins, left outer joins and right outer joins.
How to create multiple joins in one SQL query.
Create views using SQL Script.
Create views using Management.
Create a small human resources databases.
Perform different SQL statements on the human resources database.
Understand what is T-SQL.
Working with Stored procedures.
How to create a stored procedures with parameters.
Setting default value for stored procedure parameters.
How to use built-in string functions (CharIndex, Replace, Substring, Concat, Upper, Lower and Reverse).
How to use built-in date functions (GetDate, DateAdd, DateDiff and DateName).
How to use built-in numeric functions (Round, Ceiling, Floor, Abs, Rand and Sign).
Screenshots
Related Topics
1512598
udemy ID
1/16/2018
course created date
11/21/2019
course indexed date
Bot
course submited by