The Complete SQL Server For Beginners

The ultimate practical guide to master SQL Server as a developer (Downloadable SQL Scripts Included).

Created by: Ahmad Mohey
Software Developer & DevOps Engineer

What Will I 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).

Requirements

• SQL Server Developer Edition (Free)
• Management Studio (Free)

Target audience

• Complete beginners, no prior experience is required.
• Anyone looking for a course to refresh and incredibly increase their SQL knowledge.
• People who are looking for a career change.
• Anyone want to learn relational databases and SQL Server and be familiar with SQL syntax.
• Developers looking for a huge boost in CV.