HOT
blank

A complete course in SQL with SQL server

Development

Rating4.5
Enroll Now

A complete course in SQL with SQL server, available at $69.99, has an average rating of 4.54, with 91 lectures, based on 185 reviews, and has 694 subscribers.

You will learn about 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. This course is ideal for individuals who are This course is for anyone who works with data. You may be a BI developer, data engineer, data analyst, data scientist, web developer, computer programmer, student, or work in a non-technical area such as finance but you need to extract and manipulate data from a database. The course will develop those with some or no knowledge into SQL experts. It is particularly useful for This course is for anyone who works with data. You may be a BI developer, data engineer, data analyst, data scientist, web developer, computer programmer, student, or work in a non-technical area such as finance but you need to extract and manipulate data from a database. The course will develop those with some or no knowledge into SQL experts.

Enroll now: A complete course in SQL with SQL server

Summary

Title: A complete course in SQL with SQL server

Price: $69.99

Average Rating: 4.54

Number of Lectures: 91

Number of Published Lectures: 91

Number of Curriculum Items: 91

Number of Published Curriculum Objects: 91

Original Price: £54.99

Quality Status: approved

Status: Live

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.

Who Should Attend

  • This course is for anyone who works with data. You may be a BI developer, data engineer, data analyst, data scientist, web developer, computer programmer, student, or work in a non-technical area such as finance but you need to extract and manipulate data from a database. The course will develop those with some or no knowledge into SQL experts.

Target Audiences

  • This course is for anyone who works with data. You may be a BI developer, data engineer, data analyst, data scientist, web developer, computer programmer, student, or work in a non-technical area such as finance but you need to extract and manipulate data from a database. The course will develop those with some or no knowledge into SQL experts.

The course will teach how to interact with relational databases by witting SQL within SQL server. Broader concepts are also covered such as data architecture and converting tables to JSON which is useful for many web applications and API’s. It starts at a novice level and then progresses through to an expert skill level. There is a fast-track route for those that need to get up to speed quickly. This enables students with time pressure, to learn SQL to a good standard and come back later when time allows to cover the full content.

Each topic taught is structured so that it covers the theory and then provides worked examples that you are encouraged to follow along with. In the later stages of the course, a mini project is created that enables the advanced features of SQL to be explored. Within this section, practical problems are demonstrated that you are likely to find in the real world.

Advanced topics such as indexes and transactions are covered in detail to help you understand areas useful in the real world such as query optimisation and complying with ACID principles. From my 15 years of experience in database development work and training colleagues, I have picked out all the topics that will enable you to become an expert SQL developer.

The course is structured to accommodate a variety of backgrounds from the complete novice with no programming experience to those who are experienced in other languages and already have some knowledge of SQL. Those with more experience will progress through the initial sections more quickly but still acquire new development knowledge. They will also appreciate the depth of the later sections. The complete novice will appreciate the clear instructions and no presumption of prior knowledge.

Course Curriculum

Chapter 1: Introduction to the course and set up

Lecture 1: Welcome to the course

Lecture 2: What you will learn

Lecture 3: How to learn the course

Lecture 4: SQL server versions

Lecture 5: Install SQL server

Lecture 6: How to set up SQL server in the cloud on Azure

Lecture 7: Install management studio

Lecture 8: Install adventure works

Lecture 9: How to use management studio

Lecture 10: Azure data studio

Chapter 2: Selecting, sorting and filtering data

Lecture 1: Introduction

Lecture 2: Select data from a table

Lecture 3: Sort selected data

Lecture 4: Data types

Lecture 5: WHERE clause with comparison operators

Lecture 6: Logical operators and NULL values

Lecture 7: Logical operators and NULL values – example

Lecture 8: BETWEEN and IN functions

Lecture 9: BETWEEN and IN function – examples

Lecture 10: LIKE function and wildcards

Lecture 11: LIKE function and wildcard – examples

Lecture 12: Order of precedence

Chapter 3: Calculations, data conversions, functions and logic

Lecture 1: Introduction

Lecture 2: Text concatenation and maths operators

Lecture 3: String functions

Lecture 4: String function – examples

Lecture 5: Date functions

Lecture 6: Trigonometric functions

Lecture 7: Trigonometric function – examples

Lecture 8: General maths functions

Lecture 9: General maths function – examples

Lecture 10: Converting data types

Lecture 11: Converting data type – examples

Lecture 12: Decision logic

Chapter 4: Grouping, aggregating and subqueries

Lecture 1: Introduction

Lecture 2: Aggregating and grouping data

Lecture 3: Aggregating and grouping data – examples

Lecture 4: Subqueries

Lecture 5: Subquery – examples

Lecture 6: Windows functions

Lecture 7: Windows function – examples

Chapter 5: Table joins and unions

Lecture 1: Introduction

Lecture 2: Primary and foreign keys

Lecture 3: Table relationships and cardinality

Lecture 4: Inner join

Lecture 5: Inner join – examples

Lecture 6: Left and right outer joins

Lecture 7: Left and right outer join – examples

Lecture 8: Full outer and cross joins

Lecture 9: Full outer and cross join – examples

Lecture 10: Union and union all

Chapter 6: Database architecture

Lecture 1: Introduction

Lecture 2: OLTP and normalisation

Lecture 3: OLAP and star and snowflake architecture

Chapter 7: DDL – databases, schemas, tables, indexes and CTE’s

Lecture 1: Indroduction

Lecture 2: Databases – create and drop

Lecture 3: Schemas – create and drop

Lecture 4: Tables – create and drop

Lecture 5: Columns – add, alter, and drop

Lecture 6: Column constraints – create

Lecture 7: Column constraints – alter

Lecture 8: Column constraints – drop

Lecture 9: Primary key constraints

Lecture 10: Foreign key constraints

Lecture 11: Indexes

Lecture 12: CTE’s (common table expressions)

Chapter 8: DML – insert, update and delete data

Lecture 1: Introduction

Lecture 2: Fast track route – restore backup file

Lecture 3: Insert data

Lecture 4: Update data

Lecture 5: Delete and truncate data

Chapter 9: Advanced database features

Lecture 1: Introduction

Lecture 2: Views

Lecture 3: Stored procedures and parameters

Lecture 4: Stored procedures with return values

Lecture 5: Functions – scalar

Lecture 6: Functions – table valued

Lecture 7: Locks, concurrency, ACID and transactions

Lecture 8: Transactions

Lecture 9: Cursors

Lecture 10: XML

Lecture 11: Trigger introduction and syntax

Lecture 12: Trigger DML example

Lecture 13: Trigger DDL example

Chapter 10: Working with JSON data

Lecture 1: Introduction

Lecture 2: JSON structure and JSON path

Lecture 3: JSON functions

Lecture 4: JSON function and path – examples

Lecture 5: Convert a table to JSON

Lecture 6: Convert JSON to a table

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 3 votes
  • 3 stars: 11 votes
  • 4 stars: 55 votes
  • 5 stars: 116 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Game Development Courses to Learn in December 2024

Top 10 Software Testing Courses to Learn in December 2024

Top 10 Internet Of Things Courses to Learn in December 2024