A complete course in SQL with SQL server

Focused View

Robert Meldrum

14:42:59

125 View

1. Introduction to the course and set up

1. Welcome to the course.mp4

03:20

2. What you will learn.mp4

02:37

3. How to learn the course.mp4

03:17

4. SQL server versions.mp4

05:54

5. Install SQL server.mp4

12:47

6. How to set up SQL server in the cloud on Azure.mp4

15:45

7. Install management studio.mp4

03:59

8. Install adventure works.mp4

04:49

9. How to use management studio.mp4

18:32

10. Azure data studio.mp4

04:20

2. Selecting, sorting and filtering data

1.1 selectingsyntaxandexamples.zip

1. Introduction.mp4

03:11

2. Select data from a table.mp4

11:01

3. Sort selected data.mp4

12:04

4. Data types.mp4

11:25

5. WHERE clause with comparison operators.mp4

11:17

6. Logical operators and NULL values.mp4

08:02

7. Logical operators and NULL values example.mp4

06:06

8. BETWEEN and IN functions.mp4

05:05

9. BETWEEN and IN function examples.mp4

08:52

10. LIKE function and wildcards.mp4

08:08

11. LIKE function and wildcard examples.mp4

06:33

12. Order of precedence.mp4

08:52

3. Calculations, data conversions, functions and logic

1.1 calculationssyntaxandexamples.zip

1. Introduction.mp4

03:02

2. Text concatenation and maths operators.mp4

09:37

3. String functions.mp4

08:03

4. String function examples.mp4

16:05

5. Date functions.mp4

14:51

6. Trigonometric functions.mp4

06:49

7. Trigonometric function examples.mp4

07:51

8. General maths functions.mp4

05:46

9. General maths function examples.mp4

09:34

10. Converting data types.mp4

03:02

11. Converting data type - examples.mp4

18:00

12. Decision logic.mp4

11:49

4. Grouping, aggregating and subqueries

1.1 groupingsyntaxandexamples.zip

1. Introduction.mp4

01:50

2. Aggregating and grouping data.mp4

06:52

3. Aggregating and grouping data examples.mp4

07:53

4. Subqueries.mp4

05:51

5. Subquery examples.mp4

09:31

6. Windows functions.mp4

08:09

7. Windows function examples.mp4

16:34

5. Table joins and unions

1.1 joinunionsyntaxandexample.zip

1. Introduction.mp4

01:38

2. Primary and foreign keys.mp4

05:58

3. Table relationships and cardinality.mp4

12:02

4. Inner join.mp4

06:54

5. Inner join - examples.mp4

07:02

6. Left and right outer joins.mp4

06:43

7. Left and right outer join - examples.mp4

04:17

8. Full outer and cross joins.mp4

06:16

9. Full outer and cross join - examples.mp4

06:12

10. Union and union all.mp4

12:12

6. Database architecture

1. Introduction.mp4

01:17

2. OLTP and normalisation.mp4

15:51

3. OLAP and star and snowflake architecture.mp4

09:26

7. DDL - databases, schemas, tables, indexes and CTEs

1.1 ddlsyntaxandexamples.zip

1. Indroduction.mp4

03:44

2. Databases - create and drop.mp4

12:34

3. Schemas - create and drop.mp4

10:40

4. Tables - create and drop.mp4

16:18

5. Columns - add, alter, and drop.mp4

16:05

6. Column constraints create.mp4

15:56

7. Column constraints alter.mp4

10:37

8. Column constraints drop.mp4

03:22

9. Primary key constraints.mp4

17:40

10. Foreign key constraints.mp4

16:49

11. Indexes.mp4

24:21

12. CTEs (common table expressions).mp4

16:53

8. DML - insert, update and delete data

1.1 dmlsyntaxandexamples.zip

1. Introduction.mp4

00:50

2.1 sql_course.zip

2. Fast track route - restore backup file.mp4

04:10

3.1 Covid_Variant.csv

3.2 insertlists.zip

3. Insert data.mp4

17:34

4. Update data.mp4

12:44

5. Delete and truncate data.mp4

09:12

9. Advanced database features

1.1 advancefeaturessyntaxandexamples.zip

1. Introduction.mp4

02:58

2. Views.mp4

09:05

3. Stored procedures and parameters.mp4

14:46

4. Stored procedures with return values.mp4

24:26

5. Functions scalar.mp4

11:02

6. Functions - table valued.mp4

17:26

7. Locks, concurrency, ACID and transactions.mp4

08:31

8. Transactions.mp4

12:21

9. Cursors.mp4

16:20

10. XML.mp4

13:14

11. Trigger introduction and syntax.mp4

08:52

12. Trigger DML example.mp4

13:27

13. Trigger DDL example.mp4

14:08

10. Working with JSON data

1.1 jsonsyntaxandexamples.zip

1. Introduction.mp4

01:29

2. JSON structure and JSON path.mp4

12:00

3. JSON functions.mp4

05:56

4.1 jsondata.zip

4. JSON function and path - examples.mp4

14:21

5. Convert a table to JSON.mp4

16:05

6. Convert JSON to a table.mp4

09:48

11. Course review

1. Course review and what is next.mp4

04:22

Description

This course will take you from novice to expert level in SQL development using SQL server

What You'll 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 is this 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.

More details

Description
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.
Who this course is 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.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Robert Meldrum

Instructor's Courses

Robert is a consultant that provides expertise in computational physics, data engineering and data science. He has a bachelor’s degree in computing, a second bachelor’s degree in physics and MSc in physics. He has worked with data for the past 15 years and within physics environments for the last three years. Robert’s work has been used within the nuclear, and space sectors and he has led many commercial projects in industries including finance, private equity, insurance, and large-scale infrastructure projects.He has managed several teams consisting of data engineers, computer programmers and physicists. Robert has extensive knowledge and experience in many programming languages including C#, C++, Fortran, SQL, JavaScript and Python. He is an expert within the platforms: SQL server, Cosmos, Synapse, Mongo DB and Databricks. He also has substantial knowledge of software design and data architecture.On the physics side, he has specialist knowledge of Bose-Einstein condensate quantum simulators and quantum dot photovoltaics. He also has interests in applied mathematics and laser-driven X-ray sources.Robert loves teaching students, colleagues, and anyone who desires to learn.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.