SQL Queries 101

SQL Queries 101, available at $34.99, has an average rating of 4.05, with 31 lectures, based on 90 reviews, and has 684 subscribers.

You will learn about To get proficient at SQL code for writing queries, manipulating data, basic Security, and common workplace tips. This course is ideal for individuals who are Beginners wanting to know the core coding concepts of SQL Server 2012 and 2014. It is particularly useful for Beginners wanting to know the core coding concepts of SQL Server 2012 and 2014.

Enroll now: SQL Queries 101

Summary

Title: SQL Queries 101

Price: $34.99

Average Rating: 4.05

Number of Lectures: 31

Number of Published Lectures: 31

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

To get proficient at SQL code for writing queries, manipulating data, basic Security, and common workplace tips.

Who Should Attend

Beginners wanting to know the core coding concepts of SQL Server 2012 and 2014.

Target Audiences

Beginners wanting to know the core coding concepts of SQL Server 2012 and 2014.

This short course helps a beginner to understand how to write basic SQL queries and other code statement to develop and administer SQL Server. There will be downloadable labs to follow with the lessons so you gain confidence with your new skill. When you do the steps along with the lessons you can expect this course to take between 20 and 40 hours.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Course Intro

Lecture 2: Setting up Your Labs

Chapter 2: SQL Queries

Lecture 1: Single Table Queries

Lecture 2: Using Criteria

Lecture 3: Finding Patterns in Data

Lecture 4: Joining Table

Lecture 5: Outer Joins

Lecture 6: Table Aliases

Lecture 7: Unmatched Records Queries

Lecture 8: Cross Joins

Chapter 3: Design Definitions

Lecture 1: LabTips

Lecture 2: CreatingDatabases

Lecture 3: CreatingTables

Chapter 4: Data Manipulation (DML)

Lecture 1: Inserting Data

Lecture 2: Updating Data

Lecture 3: Deleting Data

Lecture 4: Using Scripts

Lecture 5: Altering Tables

Lecture 6: Using BCP

Lecture 7: Stored Procedures

Lecture 8: Using Variables

Lecture 9: Stored Procedure Parameters

Chapter 5: Transactions

Lecture 1: Explicit Transactions

Lecture 2: Table Hints

Chapter 6: Security

Lecture 1: SQL Logins

Lecture 2: Granting Permissions

Lecture 3: Revoking & Denying Permissions

Chapter 7: Workplace Tips

Lecture 1: Code Comments

Lecture 2: Automatic Script Generation

Lecture 3: Import Export Wizard

Chapter 8: Conclusion

Lecture 1: Conclusion

Instructors

A. Morelan
Joes 2 Pros

Rating Distribution

1 stars: 3 votes

2 stars: 0 votes

3 stars: 10 votes

4 stars: 24 votes

5 stars: 53 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!