Introduction to SQL Databases - SQL for Beginners
- 8 hours on-demand video
- 6 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- SQL Database Development with MIcrosoft SQL Server
- Relational Database Management Systems (RDBMS)
- Structured Query Language (SQL)
- Microsoft SQL Server
- Database Queries
- Database Design using ERDs
In this lab, we create a table with a variety of columns with different data types and we explore how to populate data in these columns, along with reviewing NULL and Non-NULL columns, column default values, and some common errors we may encounter when working with columns in our database.
This lab examines how we can create a foreign key relationship between a table and itself, for example when creating a hierarchical structure within our database, and how the database will enforce these relationships the same way it does a foreign key between two different tables.
We review keywords that we should avoid using when we name our tables and columns in order to avoid potential issues or conflicts with special keywords in the database. We see how to research "reserved words" that have special meaning within the database.
- No prior knowledge or experience required
Structured Query Language (SQL or "Sequel") is the way we communicate with a relational database. It's an intuitive and powerful language and mastering it is rapidly becoming a prerequisite for career paths outside of software development.
SQL has been one of the most common skill sets required by employers for software developers for years, according to research published by Indeed. That fact is not likely to change any time soon, as businesses have woken up to the reality that the data they capture, generate, and store has tremendous business value to improve performance and efficiency and uncover new paths for growth.
If you're a software developer just getting started, a Business Analyst, a Test Engineer, Project Manager looking to augment your technical skill set, or a data or financial analyst who works primarily with spreadsheets, you'll benefit from taking this course to learn how you can power up your data skills. We start from the ground up to teach you what a relational database is, how to plan and build a database structure, how to get data into your database, and then how to work with it to retrieve meaningful insights using SQL.
In this course, you will learn:
What a Relational Database is
How to install Microsoft SQL Server and SQL Server Management Studio on your local computer
How to use SQL Server Management Studio to create, explore, and query a database
How to research SQL Server functionality using the online documentation
Database Design Techniques including how to diagram a database using an Entity Relationship Diagram (ERD)
The basic database structures: tables, columns, data types, primary keys, and foreign key relationships
Best practices for how to name your database elements (objects)
How to learn SQL by automatically generating queries and SQL statements with SQL Server Management Studio
Inserting data into tables using the INSERT statement
Retrieving and filtering data using SELECT statements and WHERE clauses
Extracting data from multiple tables with a single query using INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and CROSS JOIN statements
Sorting query results
Aggregating data with aggregate functions like SUM and COUNT and GROUP BY clauses (very important for building reports and summarizing data!)
Updating and deleting data with UPDATE and DELETE statements
This course is very hands on! It is structured as a series of lectures to help you understand what we'll do with labs, exercises, and quizzes along the way so that you're involved right from the start.
- Beginning Developers who need to use SQL in their applications
- Business Analysts, Project Managers, or Test Engineers/Analysts who want to extend their skill set and advance their careers
- Data and Financial Analysts who want to use SQL databases to level up their game
- Anyone interested in a career in data analytics, data science, or software development