Learning Database Development with SQL
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning Database Development with SQL to your Wishlist.

Add to Wishlist

Learning Database Development with SQL

Get a head start on your aspiration of becoming a SQL developer
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2 students enrolled
Created by Packt Publishing
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Fundamental information regarding SQL Server
  • Basic idea about SQL database design and how to create your very first database
  • Design databases, tables, complex views, queries, functions and stored procedures through hand coding, point-and-click, or a mix of both
  • 16 assessment questions specific to the course
  • Supporting text files for theoretical information
View Curriculum
Requirements
  • No prior knowledge of any other language is required.
  • You will require MySQL Workbench for taking this course.
Description

Get started with SQL if you haven't yet! And explore SQL queries using the ever popular Microsoft SQL Server.

While Database management is a complicated process, SQL is the cost-efficient database management system. With this powerful and easy-to-use query language, tackle large datasets efficiently.

It has gained popularity in the recent years because of its dynamic and rich analytical capabilities. With this course, get a solid foundation in SQL and design efficient flexible database. Learning Database Development with SQL will help web- and back-end developers create robust SQL relational databases from scratch. This is a useful skill to have when wanting to create web-based applications.

This course will introduce them to all the fundamental and essential concepts of SQL. From designing your database to creating a simple web-application that stores data in a SQL database, learn all the quintessentials with ease. All examples are created by using SQL Server, an open-source RDBMS that can run on many platforms. We start off with a brief introduction to databases and database designs. We will swiftly move on to the fundamentals of SQL server and SQL and help you in creating their own relational databases.

This is the ideal course you need, to get a started with most highly in-demand skills--SQL and database management! Take your first step towards becoming a database administrator or a data analyst today.


Objectives

  • Understanding the basics of SQL server
  • Setting up the working environment for SQL server
  • Configuring and establishing connections
  • Introduction to database designs
  • Monitoring tables and usage of database metadata


Who is the target audience?
  • This course is particularly for novice web-based developers and SQL developers. This can be taken by anyone from newbies to database aficionados.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
18 Lectures
01:29:49
+
Introduction to Databases
8 Lectures 37:39

This video gives an overview of the entire course.

Preview 03:50

Data is a collection of facts and statistics and database is a collection of data. This video helps you get a firm understanding of the components of SQL. Here is what is in store for you:

  • Fundamentals of data and database
  • Introduction to database management software and CRUD operations, that is, Create, Read, Update, and Delete
  • Introduction to database schema and how data is stored in a computer
DBMS, DDL, and DML – Oh CRUD!
06:03

Now that you have understood the background of SQL, let's learn some of the additional advantages of the same. Here is what is in store for you:

  • Get familiar with the differences in database engines
  • Explore the nature and uses of a database server
  • Discover the various ways you can use database software and how do all of the software differ from each other
Differences among Database Engines, Servers, and Software
03:47

In this video, you will understand how you can start working with database entities and software:

  • Explore different database entities such as tables, columns, and records
  • Understand what the database entities stand for and what they represent in DBMS
Tables, Attributes, and Records
04:01

Now that you have understood the representation of all the database entities, let's learn some of the granular concepts of the same:

  • Get familiar with the components of tables
  • Understand what are candidate keys and composite keys with regards to columns in a database table
  • Discover the various ways you can get familiar with unique set of records known as primary key and foreign key
Primary and Foreign Keys
04:38

Now that you have understood all the components of database tables, let's learn some of the additional concepts with regards to the data stored in a database:

  • Understand what is the concept of data integrity, data consistency, and data inconsistency
  • Exploring what transactions are and what is ACID model in data integrity
  • Discover the various rules that can be applied in keeping the data consistent
Data Integrity and Consistency
10:05

Now that you have understood the additional concepts of a database, let's learn how to actually play with data by carrying import and export operations over tables:

  • Get familiar with data importing techniques from .CSV and JSON files
  • Similarly learn how to explore data to .CSV and JSON files from the database
Import and Export Data
05:13

Support Files
00:02
+
Introduction to Database Design
3 Lectures 28:22

We attempt to build a database for the Atlas University, where the students can register for different courses provided by the university. In this video, we will:

  • Understand the different elements and their functionalities
  • Identify the entities for our database and their attributes based on the data
  • Learn about the different types of relationship and how we can apply these relationships in our database
Preview 06:19

Entity-relationship models and entity-relationship diagrams both represent data in our database. Often they are considered the same and misunderstood. In this video, we will:

  • Understand the difference between entity-relationship model and entity-relationship diagram, and how they are used to denote the different elements of the database
  • Understand what strong and weak entities are
  • Learn how to identify a relationship and denote them using the crow's feet notation
Entity-Relationship Model and Diagrams
08:46

Normalization is a very integral part of a good database design. In this video, we will:

  • Understand what database normalization means and why it is required
  • Study what functional dependency is, its properties, and see a few examples of functional keys
  • Learn about the different normal forms and how to convert our tables into normal forms
Database Normalizing and Normal Forms
13:17
+
Introduction to MS SQL Server
3 Lectures 08:13

To know more about SQL Server and its components, please refer the support files provided under the code download section. Learn the different types/ways to log into your SQL Server. Here is what is in store for you:

  • Know the different ways to log into the SQL Server database
  • Discover the vital types of logins in the SQL Server database and understand each kind of login
  • Get familiar with login mapped to a certificate or an asymmetric key
Preview 02:49

Now that you know how to log into your database, let's further move on the creation and selection of a database. With this video, we cover the following topics:

  • A crisp description on why database is used
  • Know the steps to successfully create a new database
  • Further, we understand how to select a specific database either through the Query window or through the command line
Create and Select Database
01:33

After getting a hang of creating and selecting a database, let's learn how to take a backup and restore the database:

  • Know why database backup and restoring is so crucial
  • Understand the procedure to take backup of the database and the types of backups
  • Grasp the process to successfully restore your database
Backup and Restore Database
03:51
+
Introduction to SQL
4 Lectures 15:34

SQL is a language that can be used to create, update, and delete data in a database table. This video will talk about the syntax and comments in the structured query language. Here is what is in store for you:

  • Fundamentals of SQL comments and syntax
  • Implementing the set of rules while writing SQL queries
  • Understanding the rules of writing comments and learning the syntax of the same
Preview 03:30

Now that you have understood the background of SQL syntax and comments, let's learn how to implement the same to create tables:

  • Get familiar with the create and select queries
  • Explore the types of queries in SQL
  • Discover ways you can enter records in the tables using the insert query
Add Tables and Records
02:15

In this video, you will understand how you can create and add constraints to the database to maintain the consistency:

  • Learning SQL constraints as the set of rules that needs to be implemented in order to achieve data integrity and consistency
  • Understanding what are the types of various SQL constraints and how they can be implemented
Add Consistency Constraints
07:00

Now that you have understood the consistency constraints and SQL queries, let's learn some more SQL queries such as update and delete. In this video, we will:

  • Get familiar with a way to modify database tables
  • Update or delete a single record or multiple records in the tables
  • Learn, practice, and implement a few commands on different tables
Update and Delete Records
02:49
About the Instructor
Packt Publishing
3.9 Average rating
7,282 Reviews
51,999 Students
616 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.