Showing all 10 results
-
Sale!
Quick ViewExploring SQL Server 2016: Fundamentals (CA152)
₹249.00 Add to cart -
Sale!
Quick ViewExploring SQL Server 2016: Intermediate (CA153)
₹249.00 Add to cart -
Sale!
Quick ViewFundamentals of MySQL (SR052)
₹249.00 Add to cart -
Sale!
Quick ViewMySql: Become a Certified Database Engineer (FC007)
₹249.00 Add to cart -
Sale!
Quick ViewMySQLi For Beginners (SR061)
₹249.00 Add to cart -
Sale!
Quick View
SQL Database for Beginners (ML021)
₹249.00 Add to cart -
Sale!
Quick ViewSQL Server 2014: Management Studio (CA169)
₹249.00 Add to cart -
Sale!
Quick View
SQL Server 2014: Security Fundamentals (CA170)
₹249.00 Add to cart -
Sale!
Quick View
SQL Server 2014: T-SQL Fundamentals (CA172)
₹249.00 Add to cart -
Sale!
Quick ViewSQL Server Core 2016 (CA144)
₹249.00 Add to cart
Exploring SQL Server 2016: Fundamentals (CA152)
The Exploring SQL Server 2016: Fundamentals course helps the experienced database professionals to update their SQL Server skills to the new features introduced in the SQL Server 2016. The new features covered in this course are for performance, security, availability, scalability, reporting and data access. This course also covers the introduction to Transact-SQL (T-SQL) which a key new feature of SQL Server 2016.
This SQL Server 2016 course introduces the students to the latest SQL Server 2016’s new capabilities and feature set. The students are also introduced to T-SQL and the enhancements in manageability, memory tables and column store indexes. The course is very helpful for the students planning to undertake the SQL Server 2016 certification exam.
Exploring SQL Server 2016: Intermediate (CA153)
The Exploring SQL Server 2016: Intermediate course is the second course in the two course series on Microsoft SQL Server 2016. The course builds on the topics covered in the Exploring SQL Server 2016: Fundamentals course and explores the topics of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). The course also touches the security and encryption aspect in SQL Server programming.
This SQL Server 2016: Intermediate course covers the more advanced topics of integration, analysis and reporting related to the SQL Server 2016. It also explores the advanced integration in R language, security and encryption features in MS SQL Server 2016. The course when combined with the SQL Server 2016: Fundamentals course is a comprehensive package to master Microsoft SQL Server 2016 and pass any certification exam related to it.
Fundamentals of MySQL (SR052)
If you’re new to web development, MySQL is the most popular database technology out there. This free technology is used to create the majority of database dependent websites (which most are).
This course will start at the very beginning, with lessons on what MySQL is and how it works, to installing MySQL, then moving on to all the basic skills you’ll need to use MySQL in the real world. You will also learn the popular new MySQLi framework. MySQLi is the next generation of MySQL, and if you know this now you will be ahead of the competition for a long time to come.
Projects
This course also includes two real life projects. After you’ve gained an understanding of how MySQL works, you’ll learn how this technology is used on real websites.
MySql: Become a Certified Database Engineer (FC007)
MySQL is one of the most famous systems whose primary role is managing databases.The main goal of this course is the acquaintance with the basic concepts of databases.The acquired knowledge will enable you to practically use MySQL servers. Through the lessons, you’ll get a general picture regarding SQL language syntaxes as well as the advanced functionalities of servers. This is an open code system which means it’s available to everyone that wishes to use it and modify it according to their own specific needs. Apart from the fact this system enables you to manage your daily tasks quickly and efficiently, gaining skills and experience in MySQL will also provide you with a chance at building a successful and lucratively rewarding IT career. This course also prepares you for ORACLE certification, which can only further improve your chance at landing a great job.
What are the requirements?
No prior experience required
Knowing a some programming language would be helpful
What am I going to get from this course?
Apply for jobs as MySQL developers
After this course, students will be ready for ORACLE exam: Oracle Certified Professional, MySQL 5.6 Database Administrator
MySQLi For Beginners (SR061)
The course teaches MySQLi, a way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.
Benefits of MySQLi
An object-oriented interface
Support for prepared statements
Support for multiple statements
Support for transactions
Enhanced debugging support
Embedded server support
A knowledge of PHP and MySQL is recommended for this course.
SQL Server 2014: Management Studio (CA169)
This course will introduce students to SQL Server 2014 Management Studio, as well as teach them about queries, projects, DB design, constraints, indexes, diagrams, integrity, design, and types.
There is no required prerequisite for this course however, the candidates are exoected to have a basic knowledge of SQL databases and Microsoft Windows.
SQL Server 2014: Security Fundamentals (CA170)
This course will introduce students to SQL Server 2014 security fundamentals, as well as teach them about authentication, contained databases, authorization, permissions, schemas, metadata, and encryption.
There is no required prerequisite for this course however, the candidates are expected to have a basic knowledge of SQL databases and Microsoft Windows.
SQL Server 2014: T-SQL Fundamentals (CA172)
This course will introduce students to SQL Server 2014 T-SQL fundamentals, as well as teach them about functions, flow, results, select, where, clauses, tables, and working with data
SQL Server Core 2016 (CA144)
This course will introduce students to SQL Server Core 2016, as well as teach them about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.
This SQL Server Core 2016 course introduces the students to the SSMS and Data Tools ,Server Configuration ,Using Management Studio, Writing and Executing Queries.