title
SQL Server Tutorial For Beginners | Microsoft SQL Server Tutorial | SQL Server Training | Edureka

description
🔥 Edureka SQL Server Certification Training (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎"): https://www.edureka.co/microsoft-sql-server-certification-training This Edureka tutorial video on Microsoft SQL Server tutorial explains all the fundamentals of MS SQL Server with examples. The following are the topics covered in this Microsoft Server tutorial: 1:35 What is DBMS? 2:40 Types of DBMS 4:10 What is SQL? 5:25 What is SQL Server? 7:15 Features of SQL Server 10:30 SQL Server Installation 18:53 SQL Server Architecture 20:28 SQL Server Command Categories 21:18 SQL Server Data Types 22:53 DDL Commands 31:53 Keys in Database 33:13 Constraints in Database 40:00 DML Commands 1:15:47 Operators 1:28:07 Nested Queries 1:29:32 Joins 1:33:17 Stored Procedures 1:35:32 DCL Commands 1:37:52 TCL Commands 1:41:47 Exception Handling Subscribe to our Edureka YouTube channel and hit the bell icon to get video updates: https://goo.gl/6ohpTV -------------------------------------------------------------------------------------------------------- Edureka Community: https://bit.ly/EdurekaCommunity Instagram: https://www.instagram.com/edureka_learning/ Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka SlideShare: https://www.slideshare.net/EdurekaIN ------------------------------------------------------------------------------------------------------- #Edureka #EdurekaSQL #sqlservertutorial #sqlserver #microsoftsqlserver #sqlservertutorialforbeginners #sqltraining How does it work? 1. This is a 4 Week Instructor-led Online Course. 2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project 3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 4. You will get Lifetime Access to the recordings in the LMS. 5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate! - - - - - - - - - - - - - - About the Course MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data. - - - - - - - - - - - - - - Who should go for this course? This course can be beneficial for people having the below professional background: Database Developers Application Developers Database Designers Database Administrators - - - - - - - - - - - - - - Project In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :- • Employee list to be maintained having id, name, designation, experience • Salary details having employee id, current salary • Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee • Salary increment to be given by next year if any depending upon constraints • Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted. - - - - - - - - - - - - - - Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. Please write back to us at sales@edureka.in or call us at IND: 9606058406 / US: 18338555775 (toll-free) for more information.

detail
{'title': 'SQL Server Tutorial For Beginners | Microsoft SQL Server Tutorial | SQL Server Training | Edureka', 'heatmap': [{'end': 886.286, 'start': 819.912, 'weight': 0.708}, {'end': 1140.326, 'start': 1080.686, 'weight': 0.912}, {'end': 1459.642, 'start': 1325.467, 'weight': 0.817}, {'end': 1580.201, 'start': 1515.486, 'weight': 0.726}, {'end': 1967.049, 'start': 1830.588, 'weight': 0.748}], 'summary': 'Tutorial covers sql server essentials, including features, installation, architecture, ddl commands, keys, constraints, data manipulation techniques, data manipulation, and advanced sql concepts such as operators, functions, nested queries, and transaction control language, offering practical examples and emphasizing the importance of practice.', 'chapters': [{'end': 52.047, 'segs': [{'end': 52.047, 'src': 'embed', 'start': 11.573, 'weight': 0, 'content': [{'end': 15.496, 'text': "In today's market where humongous amount of data gets generated every day.", 'start': 11.573, 'duration': 3.923}, {'end': 23.582, 'text': "It's very important to understand how to handle data sequel server is an integrated environment developed by Microsoft to handle data.", 'start': 15.856, 'duration': 7.726}, {'end': 29.627, 'text': 'So hi all the society from edureka and I welcome you to this session on sequel server tutorial.', 'start': 24.023, 'duration': 5.604}, {'end': 33.832, 'text': 'In the session guys will be getting into depth of all the aspects related to sequel.', 'start': 30.007, 'duration': 3.825}, {'end': 37.796, 'text': "So without any further ado, let's take a look at the topics for today's session.", 'start': 34.232, 'duration': 3.564}, {'end': 45.665, 'text': 'But before we get started subscribe to Edureka YouTube channel and hit the bell icon to never miss an update from us on the top trending Technologies.', 'start': 38.116, 'duration': 7.549}, {'end': 52.047, 'text': "Also if you're looking for an online training certification in sequel check out the link in the description box below.", 'start': 46.205, 'duration': 5.842}], 'summary': 'Sequel server tutorial covers all aspects related to sequel for online training certification.', 'duration': 40.474, 'max_score': 11.573, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q11573.jpg'}], 'start': 11.573, 'title': 'Sequel server tutorial', 'summary': "Introduces the importance of handling data in today's market and provides an overview of the sequel server tutorial session on edureka, encouraging subscriptions and online training certification.", 'chapters': [{'end': 52.047, 'start': 11.573, 'title': 'Sequel server tutorial', 'summary': "Introduces the importance of handling data in today's market and provides an overview of the sequel server tutorial session on edureka, covering various aspects related to sequel server and encouraging subscriptions and online training certification.", 'duration': 40.474, 'highlights': ["The importance of handling data in today's market is highlighted, emphasizing the need to understand how to handle data due to the humongous amount of data generated every day.", 'The session on Edureka provides in-depth coverage of all aspects related to sequel server, offering comprehensive learning opportunities.', 'Encouragement is given to subscribe to the Edureka YouTube channel and explore online training certification in sequel.']}], 'duration': 40.474, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q11573.jpg', 'highlights': ["The importance of handling data in today's market is emphasized due to the humongous amount of data generated every day.", 'The session on Edureka provides in-depth coverage of all aspects related to sequel server, offering comprehensive learning opportunities.', 'Encouragement is given to subscribe to the Edureka YouTube channel and explore online training certification in sequel.']}, {'end': 600.05, 'segs': [{'end': 82.581, 'src': 'embed', 'start': 52.487, 'weight': 0, 'content': [{'end': 55.708, 'text': "So on that note, let's take a look at the topics for today's session.", 'start': 52.487, 'duration': 3.221}, {'end': 59.229, 'text': "So the topics for today's session are, as you can see on my screen,", 'start': 55.988, 'duration': 3.241}, {'end': 64.991, 'text': 'will start the session by understanding the types of DBMS and then we look into what is sequel after that.', 'start': 59.229, 'duration': 5.762}, {'end': 69.112, 'text': "We'll look into what a sequel server and then I'll talk about the features of sequel server.", 'start': 65.031, 'duration': 4.081}, {'end': 70.313, 'text': 'Once that is done.', 'start': 69.632, 'duration': 0.681}, {'end': 72.914, 'text': "We'll look into how to install and set up sequel server.", 'start': 70.353, 'duration': 2.561}, {'end': 78.478, 'text': "And finally, we'll look into the sequel command categories, where I'll talk about the DDL command, DML command,", 'start': 73.275, 'duration': 5.203}, {'end': 82.581, 'text': 'DCL command and TCL commands and also the various aspects related to it.', 'start': 78.478, 'duration': 4.103}], 'summary': "Today's session covers topics on dbms types, sequel, sequel server features, installation, and sequel command categories.", 'duration': 30.094, 'max_score': 52.487, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q52487.jpg'}, {'end': 182.229, 'src': 'embed', 'start': 159.827, 'weight': 2, 'content': [{'end': 167.735, 'text': 'Now, there are mainly four types of DBMS, that is, the hierarchical DBMS, the network DBMS, the relational DBMS and the object-oriented DBMS.', 'start': 159.827, 'duration': 7.908}, {'end': 170.678, 'text': 'talking about the hierarchical one, as the name suggests,', 'start': 167.735, 'duration': 2.943}, {'end': 175.702, 'text': 'this type of database management system showcases a style of predecessor and successor type of relationship.', 'start': 170.678, 'duration': 5.024}, {'end': 182.229, 'text': 'So you can consider it to be similar to a tree where in the nodes of the tree represent the records and the branches of the tree represent the fields.', 'start': 176.003, 'duration': 6.226}], 'summary': 'Four types of dbms: hierarchical, network, relational, and object-oriented.', 'duration': 22.402, 'max_score': 159.827, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q159827.jpg'}, {'end': 346.49, 'src': 'embed', 'start': 319.691, 'weight': 1, 'content': [{'end': 324.474, 'text': "but since this session is based on SQL Server, let's get into the main topic for today's session.", 'start': 319.691, 'duration': 4.783}, {'end': 327.136, 'text': 'That is what is SQL Server now.', 'start': 324.735, 'duration': 2.401}, {'end': 337.183, 'text': 'Microsoft SQL Server is basically a relational database management system which supports the structured query language and comes with its own implementation of the SQL language,', 'start': 327.136, 'duration': 10.047}, {'end': 339.905, 'text': 'which is known as the Transact SQL or the T-SQL.', 'start': 337.183, 'duration': 2.722}, {'end': 346.49, 'text': 'So it basically has an integrated environment to handle SQL databases, which is nothing but the SQL Server Management Studium.', 'start': 340.125, 'duration': 6.365}], 'summary': 'Microsoft sql server is a relational database management system supporting structured query language and transact sql.', 'duration': 26.799, 'max_score': 319.691, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q319691.jpg'}], 'start': 52.487, 'title': 'Sql server features and components', 'summary': 'Covers the agenda for the session, including understanding types of dbms, features of sql server, installation process, and command categories such as ddl, dml, dcl, and tcl. it also explains database management system (dbms), its types, and sql server, including features and components of sql server, as well as the benefits of using sql server such as user experience, availability, performance, analytics, security, and business intelligence.', 'chapters': [{'end': 87.524, 'start': 52.487, 'title': 'Understanding sql server: topics and agenda', 'summary': 'Covers the agenda for the session, including understanding types of dbms, features of sql server, installation process, and command categories such as ddl, dml, dcl, and tcl.', 'duration': 35.037, 'highlights': ['The session covers understanding types of DBMS, features of SQL Server, installation process, and command categories such as DDL, DML, DCL, and TCL.', 'Topics include understanding types of DBMS, what SQL is, features of SQL Server, installation and setup of SQL Server, and SQL command categories including DDL, DML, DCL, and TCL.']}, {'end': 600.05, 'start': 87.784, 'title': 'Dbms and sql server overview', 'summary': 'Explains database management system (dbms), its types, and sql server, including features and components of sql server. it also covers the benefits of using sql server, such as user experience, availability, performance, analytics, security, and business intelligence.', 'duration': 512.266, 'highlights': ['Microsoft SQL Server is a relational database management system which supports the structured query language and comes with its own implementation of the SQL language, known as Transact SQL or T-SQL. Microsoft SQL Server is highlighted as a relational database management system supporting SQL and Transact SQL or T-SQL.', "DBMS allows users to define, update, retrieve data, and administer users. There are four types of DBMS: hierarchical, network, relational, and object-oriented. DBMS capabilities and its four types are highlighted, showcasing the system's functionality and diversity.", 'SQL Server features include user experience, availability, performance, analytics, security, and business intelligence, providing benefits like cross-platform usability, high availability, scalable performance, built-in analytics, enhanced security, and business insights. The various features of SQL Server are highlighted, emphasizing the benefits they provide to users and businesses.']}], 'duration': 547.563, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q52487.jpg', 'highlights': ['The session covers understanding types of DBMS, features of SQL Server, installation process, and command categories such as DDL, DML, DCL, and TCL.', 'Microsoft SQL Server is highlighted as a relational database management system supporting SQL and Transact SQL or T-SQL.', "DBMS capabilities and its four types are highlighted, showcasing the system's functionality and diversity.", 'The various features of SQL Server are highlighted, emphasizing the benefits they provide to users and businesses.']}, {'end': 1116.452, 'segs': [{'end': 620.632, 'src': 'embed', 'start': 600.41, 'weight': 0, 'content': [{'end': 611.162, 'text': 'So sequel server provides you with this feature and allows you to build comprehensive Enterprise scale analytic solutions by benefiting from the fast performance of in-memory built into the tabular model.', 'start': 600.41, 'duration': 10.752}, {'end': 617.809, 'text': 'So basically what happens is that unit reduces the time to insights using direct querying against tabular and multidimensional models.', 'start': 611.482, 'duration': 6.327}, {'end': 620.632, 'text': 'So guys that were the features of sequel servers.', 'start': 618.309, 'duration': 2.323}], 'summary': 'Sql server enables building analytic solutions with fast in-memory performance, reducing time to insights.', 'duration': 20.222, 'max_score': 600.41, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q600410.jpg'}, {'end': 680.357, 'src': 'embed', 'start': 655.433, 'weight': 1, 'content': [{'end': 662.539, 'text': "then I'll connect to the SQL Server using SQL Server management studio and then I'll access the database engine now to install the SQL Server.", 'start': 655.433, 'duration': 7.106}, {'end': 668.584, 'text': 'What you have to do is you have to go to this official website of Microsoft SQL Server download.', 'start': 662.619, 'duration': 5.965}, {'end': 672.228, 'text': 'Right, so I just go to this particular page.', 'start': 670.266, 'duration': 1.962}, {'end': 680.357, 'text': 'And once you go to this page, you see this two options at a sequel server 2017 on-premises and on the cloud.', 'start': 674.435, 'duration': 5.922}], 'summary': 'Connecting to sql server using sql server management studio and accessing the database engine, then going to microsoft sql server download page to choose between on-premises and on the cloud options.', 'duration': 24.924, 'max_score': 655.433, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q655433.jpg'}, {'end': 742.014, 'src': 'embed', 'start': 718.482, 'weight': 2, 'content': [{'end': 725.005, 'text': 'once the application opens up, you see various types of installation types, that is, the basic type, the custom type and the download media.', 'start': 718.482, 'duration': 6.523}, {'end': 727.747, 'text': "So what I'll do is I'll just choose the basics type.", 'start': 725.486, 'duration': 2.261}, {'end': 729.248, 'text': 'So, when you choose the basic type,', 'start': 727.947, 'duration': 1.301}, {'end': 735.551, 'text': 'you can select the basic installation type to install the sequel server database engine feature with the default configuration.', 'start': 729.248, 'duration': 6.303}, {'end': 742.014, 'text': "just remember, guys, when you're choosing the basic type, you're installing sequel server with the default configuration Moving on to custom type.", 'start': 735.551, 'duration': 6.463}], 'summary': 'The application offers basic, custom, and download media installation types. choosing the basic type installs the sequel server database engine feature with default configuration.', 'duration': 23.532, 'max_score': 718.482, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q718482.jpg'}, {'end': 886.286, 'src': 'heatmap', 'start': 819.912, 'weight': 0.708, 'content': [{'end': 822.013, 'text': 'Now, once the installation has completed,', 'start': 819.912, 'duration': 2.101}, {'end': 828.097, 'text': 'what you next have to do is you have to go to this customize option pillow to basically configure your SQL Server database right?', 'start': 822.013, 'duration': 6.084}, {'end': 830.079, 'text': 'So I just click on this customize option.', 'start': 828.458, 'duration': 1.621}, {'end': 838.199, 'text': 'Now, once you click on the customize option, this is a screen that you will see so over here.', 'start': 834.016, 'duration': 4.183}, {'end': 842.181, 'text': 'what you just have to do is you just have to click on next, and once you click on next,', 'start': 838.199, 'duration': 3.982}, {'end': 844.543, 'text': "you'll basically see that the files are getting installed right?", 'start': 842.181, 'duration': 2.362}, {'end': 848.385, 'text': "So let's just wait for that to happen and then you keep clicking on next.", 'start': 844.863, 'duration': 3.522}, {'end': 850.387, 'text': "I'll tell you when you have to configure for something.", 'start': 848.385, 'duration': 2.002}, {'end': 852.328, 'text': "So let's just wait for that to happen.", 'start': 850.887, 'duration': 1.441}, {'end': 854.606, 'text': 'All right.', 'start': 854.346, 'duration': 0.26}, {'end': 859.748, 'text': 'Now once the installation rules are also done the next thing that you have to do is you have to choose the installation type.', 'start': 854.926, 'duration': 4.822}, {'end': 866.57, 'text': "So since we are performing a new installation, we'll just choose this option of perform a new installation of sequel server 2017.", 'start': 860.128, 'duration': 6.442}, {'end': 870.731, 'text': 'But yes, if you had any pre-installed sequel versions, then you will choose the second option, right?', 'start': 866.57, 'duration': 4.161}, {'end': 876.813, 'text': "So I'll just choose this option of perform a new installation of sequel server 2017 and then I'll click on next.", 'start': 870.991, 'duration': 5.822}, {'end': 884.746, 'text': 'Now, in the next visit that opens up, you have to choose basically the type of Edition that you had installed initially, that is,', 'start': 878.883, 'duration': 5.863}, {'end': 886.286, 'text': 'the developer Edition or the Enterprise.', 'start': 884.746, 'duration': 1.54}], 'summary': 'Instruction on installing sql server 2017, choosing edition and next steps.', 'duration': 66.374, 'max_score': 819.912, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q819912.jpg'}, {'end': 930.467, 'src': 'embed', 'start': 897.611, 'weight': 3, 'content': [{'end': 900.432, 'text': 'I accept the license terms and then click on next.', 'start': 897.611, 'duration': 2.821}, {'end': 904.434, 'text': 'now, in the next visit that opens up, you have to choose the features which you wish to install.', 'start': 900.432, 'duration': 4.002}, {'end': 908.256, 'text': 'Also, you can choose the instance root directory and then click on next.', 'start': 904.874, 'duration': 3.382}, {'end': 910.736, 'text': "So what I'll do is I'll just choose the features.", 'start': 908.815, 'duration': 1.921}, {'end': 916.199, 'text': "Let's say database engine, and then I'll let the root directory be the same and then I'll click on next.", 'start': 910.796, 'duration': 5.403}, {'end': 922.383, 'text': 'now, after that, what you have to do is you have to name your instance and then this will automatically return an instance ID right?', 'start': 916.199, 'duration': 6.184}, {'end': 923.663, 'text': "So I'll just name my instance.", 'start': 922.403, 'duration': 1.26}, {'end': 930.467, 'text': "Let's say edureka right and once I mentioned my instance name, you'll see that you know automatically my instance ID will be edureka.", 'start': 923.703, 'duration': 6.764}], 'summary': 'Installation process involves choosing features, setting directory, and naming instance with automatic instance id generation.', 'duration': 32.856, 'max_score': 897.611, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q897611.jpg'}], 'start': 600.41, 'title': 'Installing sql server 2017', 'summary': 'Discusses the features of sql server 2017, including enhanced analytics performance, and the installation process for sql server 2017 developer edition from the official website, focusing on downloading and installing. it also explains the process of installing sql server, including choosing installation types, specifying the directory, selecting features, and installing sql server management studio.', 'chapters': [{'end': 718.482, 'start': 600.41, 'title': 'Installing sql server 2017', 'summary': 'Discusses the features of sql server, including enhanced analytics performance and installation process, with a focus on downloading and installing sql server 2017 developer edition from the official website.', 'duration': 118.072, 'highlights': ['SQL Server provides comprehensive Enterprise scale analytic solutions with in-memory built into the tabular model, reducing time to insights using direct querying against tabular and multidimensional models.', 'To install SQL Server 2017, one needs to download the Developer Edition from the official website of Microsoft SQL Server and follow the installation steps.', 'SQL Server can be used locally on the system or on the cloud, offering options for on-premises and cloud deployment.', 'The process involves downloading the application from the official website and then opening the downloaded file to begin the installation.', 'Connecting to SQL Server using SQL Server Management Studio and accessing the database engine are subsequent steps in the installation process.']}, {'end': 1116.452, 'start': 718.482, 'title': 'Sql server installation and configuration', 'summary': 'Explains the process of installing sql server, including choosing between basic and custom installation types, specifying installation directory, selecting features, and installing sql server management studio.', 'duration': 397.97, 'highlights': ['Choosing between basic and custom installation types The speaker explains the difference between basic and custom installation types, recommending basic installation for local machine usage and custom installation for enterprise usage.', 'Specifying SQL Server installation directory and selecting features The transcript details the process of specifying the installation directory for SQL Server and selecting features like the database engine, along with naming the instance.', 'Installing SQL Server Management Studio The process of downloading and installing SQL Server Management Studio is explained, along with accessing the database engine using the Management Studio.']}], 'duration': 516.042, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q600410.jpg', 'highlights': ['SQL Server provides comprehensive Enterprise scale analytic solutions with in-memory built into the tabular model, reducing time to insights using direct querying against tabular and multidimensional models.', 'To install SQL Server 2017, one needs to download the Developer Edition from the official website of Microsoft SQL Server and follow the installation steps.', 'Choosing between basic and custom installation types The speaker explains the difference between basic and custom installation types, recommending basic installation for local machine usage and custom installation for enterprise usage.', 'Specifying SQL Server installation directory and selecting features The transcript details the process of specifying the installation directory for SQL Server and selecting features like the database engine, along with naming the instance.']}, {'end': 1888.852, 'segs': [{'end': 1163.043, 'src': 'embed', 'start': 1135.942, 'weight': 0, 'content': [{'end': 1140.326, 'text': 'So the sequel server architecture mainly has few components that you can see on my screen.', 'start': 1135.942, 'duration': 4.384}, {'end': 1141.807, 'text': 'So it has the server.', 'start': 1140.626, 'duration': 1.181}, {'end': 1149.313, 'text': 'it has the relational engine, the command parser, the optimizer, the query executor and the storage engine coming to the server first.', 'start': 1141.807, 'duration': 7.506}, {'end': 1154.917, 'text': 'This is where the sequel services are installed and the database resides moving on to relational engine.', 'start': 1149.593, 'duration': 5.324}, {'end': 1161.262, 'text': 'This contains the query parser optimizer and the executor and the execution happens in the relational engine.', 'start': 1155.197, 'duration': 6.065}, {'end': 1163.043, 'text': 'Moving on to command parcel.', 'start': 1161.682, 'duration': 1.361}], 'summary': 'Sequel server architecture includes server, relational engine, command parser, optimizer, and query executor.', 'duration': 27.101, 'max_score': 1135.942, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1135942.jpg'}, {'end': 1268.153, 'src': 'embed', 'start': 1238.628, 'weight': 1, 'content': [{'end': 1240.829, 'text': 'and the transaction control, language commands.', 'start': 1238.628, 'duration': 2.201}, {'end': 1242.631, 'text': 'coming to data definition, language commands.', 'start': 1240.829, 'duration': 1.802}, {'end': 1248.815, 'text': 'Well this consists of the commands that can be used to Define the database schema Moving on to data manipulation language commands.', 'start': 1242.711, 'duration': 6.104}, {'end': 1254.48, 'text': 'Well this deals with the manipulation of the data present in the database coming to data control language commands.', 'start': 1249.095, 'duration': 5.385}, {'end': 1258.744, 'text': 'Well, this deals with the rights and permissions and the controls of the database system.', 'start': 1254.54, 'duration': 4.204}, {'end': 1264.83, 'text': 'and finally, coming to transaction control, language commands, and this consists of the commands which deal with the transaction of the database.', 'start': 1258.744, 'duration': 6.086}, {'end': 1268.153, 'text': "So I hope that you've understood what are the sequel command categories.", 'start': 1265.35, 'duration': 2.803}], 'summary': 'The transcript covers sql command categories: data definition, manipulation, control, and transaction.', 'duration': 29.525, 'max_score': 1238.628, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1238628.jpg'}, {'end': 1311.5, 'src': 'embed', 'start': 1286.425, 'weight': 2, 'content': [{'end': 1292.069, 'text': 'the approximate numeric data types, the date and time values, the character strings, the Unicode character strings,', 'start': 1286.425, 'duration': 5.644}, {'end': 1294.171, 'text': 'the binary strings and many other data types.', 'start': 1292.069, 'duration': 2.102}, {'end': 1297.193, 'text': 'So talking about the exact numeric data type.', 'start': 1295.012, 'duration': 2.181}, {'end': 1300.795, 'text': 'Well, the exact numeric data type is used to basically store the numbers.', 'start': 1297.433, 'duration': 3.362}, {'end': 1308.259, 'text': 'So in this data type you have other data types like the numeric the tiny and small and big int and so on moving on to approximate numerics.', 'start': 1301.095, 'duration': 7.164}, {'end': 1311.5, 'text': 'Well approximate numerics are used to store decimal of float value.', 'start': 1308.279, 'duration': 3.221}], 'summary': 'Discusses various data types including exact and approximate numeric data types for storing numbers and decimal or float values.', 'duration': 25.075, 'max_score': 1286.425, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1286425.jpg'}, {'end': 1489.793, 'src': 'heatmap', 'start': 1325.467, 'weight': 3, 'content': [{'end': 1330.848, 'text': 'Well, this particular data type is used to store the character strings, like care, varchar, text and so on.', 'start': 1325.467, 'duration': 5.381}, {'end': 1337.03, 'text': 'the Unicode character strings are used to store the end care varchar and then text, after that coming to binary strings.', 'start': 1330.848, 'duration': 6.182}, {'end': 1340.431, 'text': 'binary strings, as the name suggests again, are used to store the binary values.', 'start': 1337.03, 'duration': 3.401}, {'end': 1345.972, 'text': 'So we have binary where binary and image values in this particular data type and in the other data type sections.', 'start': 1340.471, 'duration': 5.501}, {'end': 1351.014, 'text': 'We have data types like the cursor the row version hierarchy ID unique identifier and so on.', 'start': 1346.012, 'duration': 5.002}, {'end': 1356.898, 'text': 'Well, I would say, once you get a hands-on practice on how to write queries and how to manipulate data in your database,', 'start': 1351.454, 'duration': 5.444}, {'end': 1361.681, 'text': "you'll definitely understand which type of data type you need to use or you need to use to Define your columns.", 'start': 1356.898, 'duration': 4.783}, {'end': 1367.124, 'text': "So I hope that you have understood so on that note, let's start with the first language command category.", 'start': 1362.281, 'duration': 4.843}, {'end': 1369.366, 'text': 'That is the data definition language commands.', 'start': 1367.405, 'duration': 1.961}, {'end': 1372.668, 'text': 'So, to demonstrate the data definition language commands,', 'start': 1369.886, 'duration': 2.782}, {'end': 1376.831, 'text': "what I'm going to do is I'm going to write few queries and then I'm going to explain how you can use that.", 'start': 1372.668, 'duration': 4.163}, {'end': 1380.053, 'text': "So now what I'll do is I'll just add a query pane.", 'start': 1377.449, 'duration': 2.604}, {'end': 1386.202, 'text': "So to do that what I'll do is I'll just go to this new query option and then you'll see that you know automatically a query pane opens up.", 'start': 1380.073, 'duration': 6.129}, {'end': 1388.045, 'text': 'Let me just zoom in a little bit.', 'start': 1386.783, 'duration': 1.262}, {'end': 1391.442, 'text': "So now that I've zoomed in let's get started with the session.", 'start': 1388.9, 'duration': 2.542}, {'end': 1394.324, 'text': "So initially what I'll do is I'll just create a database.", 'start': 1391.762, 'duration': 2.562}, {'end': 1399.969, 'text': "So, to create a database, you'll type in a command, create database and then you'll mention the database name right?", 'start': 1394.364, 'duration': 5.605}, {'end': 1403.131, 'text': "So let's say I mentioned the database name to be students.", 'start': 1400.309, 'duration': 2.822}, {'end': 1406.574, 'text': 'now, after that, you just have to select this particular statement and click on execute.', 'start': 1403.131, 'duration': 3.443}, {'end': 1411.097, 'text': 'Now once you click on execute you clearly see that, you know, the commands have completed successfully.', 'start': 1407.014, 'duration': 4.083}, {'end': 1412.839, 'text': 'So our database has been created.', 'start': 1411.137, 'duration': 1.702}, {'end': 1420.314, 'text': "if I just refresh this particular section and then I go to databases, You see that you know we've got our students database right?", 'start': 1412.839, 'duration': 7.475}, {'end': 1424.857, 'text': 'So now, to perform any action in a database, you have to first use that database.', 'start': 1420.614, 'duration': 4.243}, {'end': 1429.7, 'text': "So for that you'll just type in use and then you'll mention the database name to be students right?", 'start': 1424.877, 'duration': 4.823}, {'end': 1433.162, 'text': "And then what you'll do is you'll just execute again, right?", 'start': 1430.28, 'duration': 2.882}, {'end': 1436.745, 'text': "And once you execute again, you'll see that you know the commands have been successful.", 'start': 1433.282, 'duration': 3.463}, {'end': 1441.067, 'text': "So that means whatever actions that you're going to perform is going to happen under this particular database.", 'start': 1437.045, 'duration': 4.022}, {'end': 1444.35, 'text': 'Now, after that, what you can simply do is you can just create a table, right?', 'start': 1441.328, 'duration': 3.022}, {'end': 1447.812, 'text': 'So to create a table again, you just have to use this command of create table.', 'start': 1444.59, 'duration': 3.222}, {'end': 1451.755, 'text': "Right, so I'll just mention create table and then you can mention the tables name.", 'start': 1448.352, 'duration': 3.403}, {'end': 1456.319, 'text': "So let's say we just mention it to be students info right and then in brackets.", 'start': 1451.775, 'duration': 4.544}, {'end': 1459.642, 'text': 'What you have to do is you have to mention your column names and its data types.', 'start': 1456.359, 'duration': 3.283}, {'end': 1462.965, 'text': 'So the column names could be like student ID.', 'start': 1459.982, 'duration': 2.983}, {'end': 1466.348, 'text': "Let's say to be of int right next.", 'start': 1463.325, 'duration': 3.023}, {'end': 1468.67, 'text': "Let's say student name.", 'start': 1466.408, 'duration': 2.262}, {'end': 1471.913, 'text': "Let's say varchar of 8000.", 'start': 1469.05, 'duration': 2.863}, {'end': 1475.576, 'text': 'Similarly, we can have parent name.', 'start': 1471.913, 'duration': 3.663}, {'end': 1479.511, 'text': 'again of varchar.', 'start': 1478.391, 'duration': 1.12}, {'end': 1484.752, 'text': "Let's say 8000 after that you can have phone number.", 'start': 1479.551, 'duration': 5.201}, {'end': 1489.793, 'text': "Let's say begin to, because it's going to have a large value.", 'start': 1486.372, 'duration': 3.421}], 'summary': 'The transcript discusses data types, data definition language commands, and provides a hands-on demonstration of creating a database and table in sql.', 'duration': 33.434, 'max_score': 1325.467, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1325467.jpg'}, {'end': 1580.201, 'src': 'heatmap', 'start': 1515.486, 'weight': 0.726, 'content': [{'end': 1520.049, 'text': 'So, after the statement is executed, what you can do is you can just refresh this particular section.', 'start': 1515.486, 'duration': 4.563}, {'end': 1523.731, 'text': "go to databases, go to students and in students you'll see that you know.", 'start': 1520.049, 'duration': 3.682}, {'end': 1527.014, 'text': 'if you go into the table section, we find a table of students info.', 'start': 1523.731, 'duration': 3.283}, {'end': 1533.998, 'text': "So that's how guys basically you can create a table also now, for example, let's say you want to drop a table now dropping a table is also similar.", 'start': 1527.434, 'duration': 6.564}, {'end': 1539.322, 'text': 'You just have to use the command drop table and then you mentioned the tables name so that it has students info right?', 'start': 1534.018, 'duration': 5.304}, {'end': 1547.449, 'text': "So I'll just mention students info right and then what I'll do is I'll just execute once I execute and then if I refresh,", 'start': 1539.902, 'duration': 7.547}, {'end': 1548.93, 'text': "you'll see that you know a table is gone.", 'start': 1547.449, 'duration': 1.481}, {'end': 1550.391, 'text': "So let's just wait for it to happen.", 'start': 1548.95, 'duration': 1.441}, {'end': 1555.235, 'text': 'If I go to table section you see that there is no table present.', 'start': 1552.373, 'duration': 2.862}, {'end': 1559.138, 'text': "So that's how basically you can create a table and drop a table now.", 'start': 1555.675, 'duration': 3.463}, {'end': 1561.661, 'text': 'Similarly, you can also drop a database also.', 'start': 1559.178, 'duration': 2.483}, {'end': 1566.665, 'text': 'So to drop a database what you have to simply do is you just mention drop database.', 'start': 1562.021, 'duration': 4.644}, {'end': 1569.699, 'text': 'and then you mentioned the database name, which was students.', 'start': 1567.458, 'duration': 2.241}, {'end': 1577.7, 'text': "So I'll just execute and then, once I execute, you see an error that you know we cannot drop the database because it's in current use right?", 'start': 1570.259, 'duration': 7.441}, {'end': 1580.201, 'text': 'So what you can do is you can just create another database.', 'start': 1577.961, 'duration': 2.24}], 'summary': 'Demonstrates creating and dropping tables and databases, with an example of table deletion, but unsuccessful database deletion due to current use.', 'duration': 64.715, 'max_score': 1515.486, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1515486.jpg'}, {'end': 1617.633, 'src': 'embed', 'start': 1587.623, 'weight': 4, 'content': [{'end': 1593.024, 'text': "So once you drop this database of students, you'll see that you know new database has been created, that is students one,", 'start': 1587.623, 'duration': 5.401}, {'end': 1594.964, 'text': 'and the students database has gone right.', 'start': 1593.024, 'duration': 1.94}, {'end': 1596.925, 'text': "So let's just wait for that to happen.", 'start': 1594.984, 'duration': 1.941}, {'end': 1601.002, 'text': 'So, as you can see, we just have one database, that is, students one, right?', 'start': 1597.773, 'duration': 3.229}, {'end': 1605.012, 'text': "So that's how, guys, basically you can drop and create the databases and tables.", 'start': 1601.302, 'duration': 3.71}, {'end': 1609.81, 'text': 'Now the next command that you need to know in the DDL commands is the alter command.', 'start': 1605.709, 'duration': 4.101}, {'end': 1617.633, 'text': "But before we start with the alter command, what I'll just do is I just use this particular database and then I'll just create back this table again,", 'start': 1610.03, 'duration': 7.603}], 'summary': 'Demonstrates dropping and creating databases and tables, including the use of alter command.', 'duration': 30.01, 'max_score': 1587.623, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1587623.jpg'}, {'end': 1737.332, 'src': 'embed', 'start': 1709.071, 'weight': 5, 'content': [{'end': 1712.713, 'text': 'So you want to do both you want to add a column and then you want to change the data type also.', 'start': 1709.071, 'duration': 3.642}, {'end': 1715.775, 'text': "So what you'll do is you'll just mention alter table,", 'start': 1713.133, 'duration': 2.642}, {'end': 1719.998, 'text': "will just copy paste this particular statement and then we'll mention all the table students info.", 'start': 1715.775, 'duration': 4.223}, {'end': 1721.559, 'text': 'that is basically a table name.', 'start': 1719.998, 'duration': 1.561}, {'end': 1723.96, 'text': "and then let's say we want to add a date of birth column, right?", 'start': 1721.559, 'duration': 2.401}, {'end': 1725.661, 'text': "So I'll just mention DOB over here.", 'start': 1723.98, 'duration': 1.681}, {'end': 1729.504, 'text': "Right and let's say our data type to be date.", 'start': 1726.962, 'duration': 2.542}, {'end': 1734.791, 'text': "Right and then I'll just execute once I execute you see that, you know, our column will be added.", 'start': 1730.129, 'duration': 4.662}, {'end': 1737.332, 'text': "Now, what I'll do is I want to change the data type right?", 'start': 1735.131, 'duration': 2.201}], 'summary': 'Add a column and change data type in sql table.', 'duration': 28.261, 'max_score': 1709.071, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1709071.jpg'}, {'end': 1863.775, 'src': 'embed', 'start': 1830.588, 'weight': 6, 'content': [{'end': 1836.587, 'text': "So you'll just mention truncate and then you'll mention the table name our table name is students info.", 'start': 1830.588, 'duration': 5.999}, {'end': 1841.069, 'text': 'So I just mentioned students info and then I click on execute.', 'start': 1837.209, 'duration': 3.86}, {'end': 1845.35, 'text': 'once I click on execute, we see that you know the commands have completed successfully, right.', 'start': 1841.069, 'duration': 4.281}, {'end': 1850.552, 'text': 'initially our columns have few values, but now our columns have no values over there right.', 'start': 1845.35, 'duration': 5.202}, {'end': 1857.573, 'text': 'apart from this, if you want to also rename a table or rename a database, you have to use the command of SP underscore rename.', 'start': 1850.552, 'duration': 7.021}, {'end': 1863.775, 'text': 'So this is something different from the other databases, as generally the rename command or the query is used,', 'start': 1858.014, 'duration': 5.761}], 'summary': 'Demonstrating truncating a table, executing commands, and renaming a table or database using sp_rename command.', 'duration': 33.187, 'max_score': 1830.588, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1830588.jpg'}], 'start': 1116.452, 'title': 'Sql server architecture and ddl commands', 'summary': 'Provides an overview of sql server architecture, covering its components such as server, relational engine, command parser, optimizer, query executor, and storage engine, along with an explanation of sql command categories and data types. it also covers the basics of data definition language (ddl) commands in sql, including creating and dropping databases and tables, adding and dropping columns, changing data types, truncating tables, and renaming tables and databases, with practical demonstrations and examples.', 'chapters': [{'end': 1351.014, 'start': 1116.452, 'title': 'Understanding sql server architecture', 'summary': 'Provides an overview of sql server architecture, covering its components such as server, relational engine, command parser, optimizer, query executor, and storage engine, along with an explanation of sql command categories and data types for numeric, date, time, character, unicode, and binary values.', 'duration': 234.562, 'highlights': ['The SQL Server architecture components include server, relational engine, command parser, optimizer, query executor, and storage engine, each with specific functions for query processing and data management.', 'The chapter explains SQL command categories, which encompass data definition language commands for defining database schema, data manipulation language commands for data manipulation, data control language commands for database rights and permissions, and transaction control language commands for managing database transactions.', 'Various SQL Server data types are discussed, including exact numeric, approximate numeric, date and time, character strings, Unicode character strings, and binary strings, each serving specific data storage and manipulation functions.']}, {'end': 1888.852, 'start': 1351.454, 'title': 'Sql ddl commands - basics and demonstrations', 'summary': 'Covers the basics of data definition language (ddl) commands in sql, including creating and dropping databases and tables, adding and dropping columns, changing data types, truncating tables, and renaming tables and databases, with practical demonstrations and examples.', 'duration': 537.398, 'highlights': ["Creating a database named 'students' and a table named 'students info' with specified columns and data types The demonstration includes creating a database named 'students' and a table named 'students info' with columns such as student ID, student name, parent name, phone number, address, city, and country, with specific data types like int and varchar.", "Dropping the 'students info' table and creating a new database named 'students one' The process of dropping the 'students info' table and creating a new database named 'students one' is demonstrated with practical execution and verification.", "Adding and dropping columns in the 'students info' table The procedure of adding a column for 'blood group' and subsequently dropping it, along with adding a 'date of birth' column and changing its data type to 'date time', is explained with execution and result verification.", "Truncating the 'students info' table to delete all its data The method of truncating the 'students info' table to delete all its data while retaining the table structure is demonstrated with the corresponding execution and outcome.", "Renaming a database and a table using the SP_RENAME command The usage of the SP_RENAME command to rename a database from 'Students one' to 'Info students' is explained, highlighting the specific syntax and execution process."]}], 'duration': 772.4, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1116452.jpg', 'highlights': ['The SQL Server architecture components include server, relational engine, command parser, optimizer, query executor, and storage engine, each with specific functions for query processing and data management.', 'The chapter explains SQL command categories, which encompass data definition language commands for defining database schema, data manipulation language commands for data manipulation, data control language commands for database rights and permissions, and transaction control language commands for managing database transactions.', 'Various SQL Server data types are discussed, including exact numeric, approximate numeric, date and time, character strings, Unicode character strings, and binary strings, each serving specific data storage and manipulation functions.', "Creating a database named 'students' and a table named 'students info' with specified columns and data types The demonstration includes creating a database named 'students' and a table named 'students info' with columns such as student ID, student name, parent name, phone number, address, city, and country, with specific data types like int and varchar.", "Dropping the 'students info' table and creating a new database named 'students one' The process of dropping the 'students info' table and creating a new database named 'students one' is demonstrated with practical execution and verification.", "Adding and dropping columns in the 'students info' table The procedure of adding a column for 'blood group' and subsequently dropping it, along with adding a 'date of birth' column and changing its data type to 'date time', is explained with execution and result verification.", "Truncating the 'students info' table to delete all its data The method of truncating the 'students info' table to delete all its data while retaining the table structure is demonstrated with the corresponding execution and outcome.", "Renaming a database and a table using the SP_RENAME command The usage of the SP_RENAME command to rename a database from 'Students one' to 'Info students' is explained, highlighting the specific syntax and execution process."]}, {'end': 2618.248, 'segs': [{'end': 1923.706, 'src': 'embed', 'start': 1889.608, 'weight': 0, 'content': [{'end': 1893.971, 'text': 'and execute and once I execute you can see that you know our table name has changed.', 'start': 1889.608, 'duration': 4.363}, {'end': 1898.033, 'text': "So what I'll do is I'll just refresh this left hand side and I'll go to students one.", 'start': 1894.151, 'duration': 3.882}, {'end': 1902.096, 'text': "I'll go to tables over here and then you can see that you know, it has changed to info students.", 'start': 1898.073, 'duration': 4.023}, {'end': 1904.658, 'text': "So I hope I'm clear with the DDL commands guys.", 'start': 1902.556, 'duration': 2.102}, {'end': 1910.821, 'text': 'Well, these are few basic commands that you need to know before you start handling and manipulating databases on that note.', 'start': 1904.718, 'duration': 6.103}, {'end': 1914.604, 'text': "Let's take a look at the next topic for today's session that is keys in the database.", 'start': 1910.862, 'duration': 3.742}, {'end': 1922.186, 'text': 'Now, the different types of keys used in the database are the candidate key, the super key, the primary key, the alternate key and the foreign key.', 'start': 1915.064, 'duration': 7.122}, {'end': 1923.706, 'text': 'now coming to candidate key.', 'start': 1922.186, 'duration': 1.52}], 'summary': 'Executing ddl commands changes table name to info students, covering basic commands and types of keys used in databases.', 'duration': 34.098, 'max_score': 1889.608, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1889608.jpg'}, {'end': 2059.681, 'src': 'embed', 'start': 1977.416, 'weight': 2, 'content': [{'end': 1982.48, 'text': 'that which key should be primary key and which keys together can uniquely identify your table, and so on.', 'start': 1977.416, 'duration': 5.064}, {'end': 1983.08, 'text': 'apart from this,', 'start': 1982.48, 'duration': 0.6}, {'end': 1986.363, 'text': 'We also have few constraints which are very popular in the database.', 'start': 1983.12, 'duration': 3.243}, {'end': 1990.926, 'text': "So next in the session, let's take a look at the popular constraints available in the database.", 'start': 1986.823, 'duration': 4.103}, {'end': 1996.17, 'text': 'So the constraints used in the database are not null unique check default and index.', 'start': 1991.206, 'duration': 4.964}, {'end': 1998.231, 'text': 'So talk about not null first.', 'start': 1996.73, 'duration': 1.501}, {'end': 2002.194, 'text': 'the not null constraint ensures that a column cannot have a null value right?', 'start': 1998.231, 'duration': 3.963}, {'end': 2003.395, 'text': 'So that is very simple.', 'start': 2002.234, 'duration': 1.161}, {'end': 2007.398, 'text': 'as the name suggests, it ensures that you know a column cannot have any null value.', 'start': 2003.395, 'duration': 4.003}, {'end': 2011.742, 'text': 'So if you just assign the constraint of not null to any particular column,', 'start': 2007.438, 'duration': 4.304}, {'end': 2017.166, 'text': 'then automatically you have to mention a value into that particular column to enter that particular tuple into the database.', 'start': 2011.742, 'duration': 5.424}, {'end': 2022.15, 'text': 'Coming to unique the unique Constrain make sure that you know, all the values in the column are different.', 'start': 2017.546, 'duration': 4.604}, {'end': 2025.814, 'text': 'So, basically, when you mention a constraint unique to a specific column,', 'start': 2022.451, 'duration': 3.363}, {'end': 2029.497, 'text': 'then automatically what happens is that all the values present in the column are unique.', 'start': 2025.814, 'duration': 3.683}, {'end': 2032.08, 'text': 'So two or more values cannot be the same.', 'start': 2029.818, 'duration': 2.262}, {'end': 2037.485, 'text': 'coming to check Constrain, this Constrain ensures that all the values in a column satisfy a specific condition.', 'start': 2032.08, 'duration': 5.405}, {'end': 2039.486, 'text': 'So whenever you mention the check constant,', 'start': 2037.985, 'duration': 1.501}, {'end': 2044.99, 'text': "you'll mention a condition and all the values which satisfy the condition can be present in that particular column.", 'start': 2039.486, 'duration': 5.504}, {'end': 2049.774, 'text': "any value which doesn't satisfy the condition cannot be present in that particular column, going on to default.", 'start': 2044.99, 'duration': 4.784}, {'end': 2054.897, 'text': 'Well, this constraint consists of set of default values of a column when no values is specified right?', 'start': 2050.054, 'duration': 4.843}, {'end': 2059.681, 'text': "For example, let's say, while entering values in a column, you forget to mention a few.", 'start': 2055.197, 'duration': 4.484}], 'summary': 'Explains popular database constraints: not null, unique, check, default, and index.', 'duration': 82.265, 'max_score': 1977.416, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1977416.jpg'}, {'end': 2101.948, 'src': 'embed', 'start': 2075.21, 'weight': 7, 'content': [{'end': 2079.274, 'text': 'This constant is used to create and retrieve data from the database very quickly, right?', 'start': 2075.21, 'duration': 4.064}, {'end': 2084.578, 'text': 'If you want to create and retrieve data from the database very quickly, then you have to use the index constraints.', 'start': 2079.654, 'duration': 4.924}, {'end': 2087.96, 'text': "So now that I've explained your keys and constraints in database.", 'start': 2084.998, 'duration': 2.962}, {'end': 2091.101, 'text': 'Let me just switch back to my SQL Server Management Studio.', 'start': 2088.239, 'duration': 2.862}, {'end': 2095.705, 'text': "And then what I'll do is I'll just execute few commands or queries based on this particular section.", 'start': 2091.462, 'duration': 4.243}, {'end': 2097.406, 'text': "So let's get started.", 'start': 2096.465, 'duration': 0.941}, {'end': 2101.948, 'text': "So what I do is I'll just copy this particular section from over here, right?", 'start': 2097.806, 'duration': 4.142}], 'summary': 'Using index constraints for quick database data retrieval', 'duration': 26.738, 'max_score': 2075.21, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q2075210.jpg'}], 'start': 1889.608, 'title': 'Keys and constraints in databases', 'summary': 'Covers the basics of ddl commands, types of keys and constraints in databases, including various keys such as candidate, super, primary, alternate, foreign, and popular constraints like not null, unique, check, default, and index. it also demonstrates the use of constraints in sql with practical examples and execution results, highlighting their importance in maintaining data integrity and consistency.', 'chapters': [{'end': 2091.101, 'start': 1889.608, 'title': 'Keys and constraints in databases', 'summary': 'Covers the basics of ddl commands, including table name changes, and then delves into the various types of keys and constraints in databases, including candidate keys, super keys, primary keys, alternate keys, foreign keys, as well as popular constraints like not null, unique, check, default, and index.', 'duration': 201.493, 'highlights': ['The chapter covers the basics of DDL commands, including table name changes. Basic DDL commands are demonstrated, including table name changes.', 'The different types of keys used in the database are the candidate key, the super key, the primary key, the alternate key, and the foreign key. Explanation of the different types of keys in a database, including candidate key, super key, primary key, alternate key, and foreign key.', 'The not null constraint ensures that a column cannot have a null value. Explanation of the not null constraint, which ensures that a column cannot have a null value.', 'The unique constraint ensures that all the values in the column are different. Explanation of the unique constraint, which ensures that all values in a column are different.', 'The check constraint ensures that all the values in a column satisfy a specific condition. Explanation of the check constraint, which ensures that all values in a column satisfy a specific condition.', 'The default constraint consists of a set of default values of a column when no values are specified. Explanation of the default constraint, which provides default values for a column when no values are specified.', 'The index constraint is used to create and retrieve data from the database very quickly. Explanation of the index constraint, which is used to create and retrieve data from the database quickly.']}, {'end': 2618.248, 'start': 2091.462, 'title': 'Using constraints in sql', 'summary': 'Demonstrates the use of not null, unique, check, and default constraints in sql, including practical examples and execution results, emphasizing the importance of constraints in maintaining data integrity and consistency.', 'duration': 526.786, 'highlights': ['The chapter demonstrates the use of not null, unique, check, and default constraints in SQL. Covers the main topic of the chapter, providing an overview of the constraints discussed.', 'Practical examples and execution results are provided for each type of constraint, emphasizing the importance of constraints in maintaining data integrity and consistency. Emphasizes the practical application and significance of constraints in SQL, highlighting the importance of data integrity and consistency.', 'Practical examples and execution results are provided for each type of constraint. Reiterates the emphasis on practical application and provides execution results for each type of constraint.']}], 'duration': 728.64, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q1889608.jpg', 'highlights': ['The chapter covers the basics of DDL commands, including table name changes.', 'Explanation of the different types of keys in a database, including candidate key, super key, primary key, alternate key, and foreign key.', 'Practical examples and execution results are provided for each type of constraint, emphasizing the importance of constraints in maintaining data integrity and consistency.', 'The not null constraint ensures that a column cannot have a null value.', 'The unique constraint ensures that all the values in the column are different.', 'The check constraint ensures that all the values in a column satisfy a specific condition.', 'The default constraint consists of a set of default values of a column when no values are specified.', 'The index constraint is used to create and retrieve data from the database very quickly.']}, {'end': 3346.958, 'segs': [{'end': 2648.975, 'src': 'embed', 'start': 2618.668, 'weight': 0, 'content': [{'end': 2624.493, 'text': "So I'll just execute this particular statement and then what you can just do is you can just check with the insert statement.", 'start': 2618.668, 'duration': 5.825}, {'end': 2629.002, 'text': 'So now, similarly, if you want to add the default constraint with the alter table,', 'start': 2625.06, 'duration': 3.942}, {'end': 2637.648, 'text': "you just have to again use all the table students info and then what you'll do is you'll just mention add constraint and let's say you give the constraint name to be,", 'start': 2629.002, 'duration': 8.646}, {'end': 2638.768, 'text': "let's say, default.", 'start': 2637.648, 'duration': 1.12}, {'end': 2648.975, 'text': "Let's say country right, and then you'll mention the condition that is default, which will be India, and then you'll mention the column name,", 'start': 2639.889, 'duration': 9.086}], 'summary': 'Executing statements to check and add default constraints for table students info.', 'duration': 30.307, 'max_score': 2618.668, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q2618668.jpg'}, {'end': 2712.087, 'src': 'embed', 'start': 2681.17, 'weight': 1, 'content': [{'end': 2685.031, 'text': "So once you click on OK, you'll automatically see that you know your default constraint has been dropped.", 'start': 2681.17, 'duration': 3.861}, {'end': 2689.034, 'text': 'Now one more way to drop the default constant is by using the alter table.', 'start': 2685.672, 'duration': 3.362}, {'end': 2695.237, 'text': "You just have to mention alter table students info and then mention drop constraint, and then you'll just execute this particular statement right?", 'start': 2689.314, 'duration': 5.923}, {'end': 2697.939, 'text': "So that's how, basically, you can drop the constraint, guys.", 'start': 2695.557, 'duration': 2.382}, {'end': 2701.761, 'text': "Now, let's move forward with the next constraint that is the index constraint.", 'start': 2698.279, 'duration': 3.482}, {'end': 2706.243, 'text': 'So the index constant as I said is used for the fast creation and retrieval of the database.', 'start': 2701.861, 'duration': 4.382}, {'end': 2712.087, 'text': "So for that you'll mention create index and then let's say we mentioned the index name to be, let's say,", 'start': 2706.564, 'duration': 5.523}], 'summary': 'Dropping default constraints and creating index constraints for fast database retrieval.', 'duration': 30.917, 'max_score': 2681.17, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q2681170.jpg'}, {'end': 2794.833, 'src': 'embed', 'start': 2767.084, 'weight': 2, 'content': [{'end': 2771.21, 'text': "right now let's move forward in the session and go to the next sequel, command category.", 'start': 2767.084, 'duration': 4.126}, {'end': 2773.113, 'text': 'That is the data manipulation language commands.', 'start': 2771.25, 'duration': 1.863}, {'end': 2780.721, 'text': 'So the data manipulation language commands are used to manipulate, or I would say retrieve the data in the databases based on your requirement,', 'start': 2774.016, 'duration': 6.705}, {'end': 2787.467, 'text': "right?. So to do that, what I'll do is I'll initially insert the values into the table and then what we can do is we can just manipulate the data.", 'start': 2780.721, 'duration': 6.746}, {'end': 2794.833, 'text': "So what I'm going to do is I'm going to show you the use command, the insert command, update command, delete, merge, the select commands, the cube,", 'start': 2787.887, 'duration': 6.946}], 'summary': 'Data manipulation language commands manipulate and retrieve data in databases.', 'duration': 27.749, 'max_score': 2767.084, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q2767084.jpg'}], 'start': 2618.668, 'title': 'Sql constraints and data manipulation', 'summary': 'Explains adding, dropping, and manipulating default and index constraints in sql with examples, and covers data manipulation commands like insert, update, delete, and merge operations with syntax examples and demonstrated execution using sample tables and quantifiable data.', 'chapters': [{'end': 2767.084, 'start': 2618.668, 'title': 'Manipulating keys and constraints', 'summary': 'Explains how to add, drop, and manipulate default and index constraints in sql, including examples of altering table data and creating index constraints for fast database retrieval.', 'duration': 148.416, 'highlights': ['You can add a default constraint with the alter table by specifying the table name, constraint name, condition, and column name, then executing the statement, for example default country as India and column name as country. default constraint creation process', 'Dropping a default constraint can be done by right-clicking, choosing delete, selecting the object name, and clicking OK, or by using the alter table to mention drop constraint and executing the statement. process to drop default constraint', 'Creating an index constraint involves using the create index statement with the index name, table name, and column name, and then refreshing the section to view the created index. index constraint creation process', 'Dropping an index constraint can be achieved by using the drop index statement with the index name and table name, then executing the statement to drop the index constraint. process to drop index constraint']}, {'end': 3346.958, 'start': 2767.084, 'title': 'Data manipulation language commands', 'summary': 'Covers data manipulation language commands including insert, update, delete, and merge operations, providing syntax examples and demonstrating their execution using sample tables and quantifiable data.', 'duration': 579.874, 'highlights': ['The chapter covers data manipulation language commands including insert, update, delete, and merge operations The session covers various data manipulation language commands such as insert, update, delete, and merge operations.', 'Provides syntax examples and demonstrating their execution using sample tables Syntax examples for data manipulation language commands are provided and demonstrated using sample tables.', 'The merge statement is used to perform insert, update, delete operations on a specific table where the source table is provided The merge statement allows performing insert, update, and delete operations on a specific table when the source table is provided.']}], 'duration': 728.29, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q2618668.jpg', 'highlights': ['Explains adding default and index constraints with alter table and create index statements', 'Demonstrates dropping default and index constraints using alter table and drop index statements', 'Covers data manipulation language commands like insert, update, delete, and merge operations with syntax examples', 'Provides demonstrated execution of data manipulation language commands using sample tables']}, {'end': 4547.812, 'segs': [{'end': 3419.592, 'src': 'embed', 'start': 3394.432, 'weight': 0, 'content': [{'end': 3400.996, 'text': "So you just mention select top three star and then you'll mention the table name.", 'start': 3394.432, 'duration': 6.564}, {'end': 3402.957, 'text': "So that will be let's say students info.", 'start': 3401.016, 'duration': 1.941}, {'end': 3409.347, 'text': 'And when I execute this particular statement, you see that you know we get the top three statements, that is, the values for the second student,', 'start': 3403.584, 'duration': 5.763}, {'end': 3410.807, 'text': 'third student and the fourth student.', 'start': 3409.347, 'duration': 1.46}, {'end': 3415.29, 'text': 'Now similarly, you can also find out the distinct values in a specific column.', 'start': 3411.248, 'duration': 4.042}, {'end': 3419.592, 'text': "Also, for example, let's say we want to find out the distinct cities present right?", 'start': 3415.41, 'duration': 4.182}], 'summary': "Query returns top 3 values from 'students info' table and identifies distinct cities.", 'duration': 25.16, 'max_score': 3394.432, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q3394432.jpg'}, {'end': 3518.949, 'src': 'embed', 'start': 3485.886, 'weight': 1, 'content': [{'end': 3488.188, 'text': "but that's how you can use the order by statement.", 'start': 3485.886, 'duration': 2.302}, {'end': 3489.83, 'text': 'Now This was just for one column.', 'start': 3488.468, 'duration': 1.362}, {'end': 3493.533, 'text': "Now let's say you want to sort the data present in the table with different columns, right?", 'start': 3490.17, 'duration': 3.363}, {'end': 3498.377, 'text': "So let's say we want to sort the students from the students info table by parent name and also the student name.", 'start': 3493.793, 'duration': 4.584}, {'end': 3503.762, 'text': "So we'll just mention student name and then what I'll do is I'll just execute.", 'start': 3498.737, 'duration': 5.025}, {'end': 3510.365, 'text': "And when I execute you can see that you know, since we haven't mentioned anything, whether it should be ascending or the descending order.", 'start': 3504.242, 'duration': 6.123}, {'end': 3512.886, 'text': 'automatically the parent name comes in the ascending order.', 'start': 3510.365, 'duration': 2.521}, {'end': 3518.949, 'text': 'So our fifth student comes first on the list and then the order follows similarly if you just replace this.', 'start': 3513.186, 'duration': 5.763}], 'summary': 'Demonstrating the use of order by statement for sorting data by multiple columns.', 'duration': 33.063, 'max_score': 3485.886, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q3485886.jpg'}, {'end': 3666.982, 'src': 'embed', 'start': 3639.212, 'weight': 2, 'content': [{'end': 3646.163, 'text': 'while grouping sets were introduced in SQL Server 2008 and we used to generate a result set that can be generated by Union,', 'start': 3639.212, 'duration': 6.951}, {'end': 3648.307, 'text': 'all of the multiple simple group by clauses.', 'start': 3646.163, 'duration': 2.144}, {'end': 3650.814, 'text': 'So the syntax is also very simple guys.', 'start': 3649.073, 'duration': 1.741}, {'end': 3654.736, 'text': 'You just have to mention select, and then you mentioned the column names from the table name,', 'start': 3650.834, 'duration': 3.902}, {'end': 3660.159, 'text': 'group by and then grouping set and in the brackets you mentioned all those column names which have to come under the grouping sets.', 'start': 3654.736, 'duration': 5.423}, {'end': 3666.982, 'text': "So for example, let's say I'll just modify this particular query, right? So I'll just mention select and then I'll remove the count function.", 'start': 3660.599, 'duration': 6.383}], 'summary': 'Sql server 2008 introduced grouping sets for generating result sets with multiple simple group by clauses using a simple syntax.', 'duration': 27.77, 'max_score': 3639.212, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q3639212.jpg'}, {'end': 4372.573, 'src': 'embed', 'start': 4345.172, 'weight': 3, 'content': [{'end': 4350.596, 'text': "So I'll just mention Pivot table right and then I'll just close.", 'start': 4345.172, 'duration': 5.424}, {'end': 4356.973, 'text': "So I've just mentioned select average cost of customer as customer according to the customers 1 1 2 2 3 3.", 'start': 4351.614, 'duration': 5.359}, {'end': 4358.715, 'text': 'So we have one row and three columns.', 'start': 4356.975, 'duration': 1.74}, {'end': 4364.956, 'text': "We want to select customer ID and cost from the supply table a source table and then continue right and so I'll just execute.", 'start': 4359.315, 'duration': 5.641}, {'end': 4367.117, 'text': 'So once I execute, you can see that you know.', 'start': 4365.356, 'duration': 1.761}, {'end': 4372.573, 'text': 'the average cost of customers has been named as customer according to the customers, and we have 1, 1, 2, 2, 3, 3..', 'start': 4367.117, 'duration': 5.456}], 'summary': 'Using a pivot table, the average cost of customers has been calculated with 3 unique customer ids.', 'duration': 27.401, 'max_score': 4345.172, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q4345172.jpg'}], 'start': 3346.978, 'title': 'Sql data manipulation techniques', 'summary': 'Covers sql select statements, order by, group by, having clauses, dml commands, pivot, unpivot commands, and includes examples for data manipulation, impacting sorting, and transforming data, with a focus on table merging, specific column selection, top record retrieval, distinct value finding, aggregate functions, grouping sets, backups creation, cube and roll-up commands, offset and fetch clauses, and pivot command for rotating rows to column values.', 'chapters': [{'end': 3437.901, 'start': 3346.978, 'title': 'Sql select statements', 'summary': 'Covers how to merge tables using sql, performing select statements, selecting specific columns or all columns, retrieving top records, and finding distinct values in a column.', 'duration': 90.923, 'highlights': ['The chapter covers how to merge tables using SQL, performing select statements, selecting specific columns or all columns, retrieving top records, and finding distinct values in a column.', "You can merge tables by using the 'merge' keyword and specifying the source table.", "Using the 'select' statement, you can retrieve specific columns or all columns from a table.", "The 'select top' statement can be used to retrieve the top records from a table with the specified number.", "To find distinct values in a specific column, the 'select distinct' statement can be used."]}, {'end': 3566.182, 'start': 3437.921, 'title': 'Using order by, group by, and having clauses in sql', 'summary': 'Explains how to use the order by clause in sql to sort data in ascending or descending order based on one or multiple columns, emphasizing the implementation of the order by clause and its impact on sorting the student data in the students info table.', 'duration': 128.261, 'highlights': ['The chapter explains how to use the order by clause in SQL to sort data in ascending or descending order based on one or multiple columns. Explanation of the functionality of the order by clause in SQL and its ability to sort data based on specified columns.', 'The demonstration of sorting student data in the students info table using the order by clause, showcasing examples of sorting by parent name and student name in both ascending and descending order. Practical examples of using the order by clause to sort student data in the students info table, including sorting by single and multiple columns in both ascending and descending order.', 'The chapter also highlights the capability to sort data in different columns using either ascending or descending order, allowing for versatile sorting options within the SQL query. Illustration of sorting data in different columns using either ascending or descending order, providing flexibility in arranging data within SQL queries.']}, {'end': 4186.738, 'start': 3566.603, 'title': 'Sql select statement and dml commands', 'summary': 'Covers the sql select statement, including the use of aggregate functions and grouping sets, along with the having clause, creating backups, using cube and roll-up commands, and demonstrating the offset and fetch clauses for retrieving specific ranges of records, concluding with the pivot command for rotating rows to column values and performing aggregations.', 'duration': 620.135, 'highlights': ['The chapter covers the SQL select statement, including the use of aggregate functions and grouping sets. It emphasizes the popularity of the select statement for manipulating data in databases and its ease of use in retrieving data, along with the use of aggregate functions such as sum, average, count, and range.', 'Demonstrating the use of cube and roll-up commands for generating subtotals and super aggregated rows. It explains how cube and roll-up commands extend the group by clause to produce subtotals for combinations of grouping columns and includes the demonstration of using these commands to generate subtotals and super aggregated rows.', 'Illustrating the offset and fetch clauses for retrieving specific ranges of records. It demonstrates the use of the offset clause with the order by statement to retrieve a range of records, as well as the fetch clause to return a set number of rows in conjunction with the offset clause.', 'Explaining the pivot command for rotating rows to column values and performing aggregations. It explains the syntax of pivot, which involves rotating rows to column values and running aggregations on the remaining column values.']}, {'end': 4547.812, 'start': 4187.178, 'title': 'Sequel pivot and unpivot', 'summary': 'Demonstrates the usage of sql pivot and unpivot commands to manipulate and transform data, including creating a pivot table with one row and three columns, and unpivoting a table to convert columns into rows, with examples and real-time execution results.', 'duration': 360.634, 'highlights': ['The chapter provides a step-by-step demonstration of creating a pivot table with one row and three columns, showcasing the average cost of customers for different customer IDs, such as 11, 22, and 33, with specific average cost values, and converting the previous rows into columns.', "The speaker further illustrates the process of unpivoting a table, transforming the existing four columns and three rows into a structure where each customer's products and values are displayed in separate rows, providing a clear understanding of the unpivoting process and its impact.", 'The transcript concludes with a reference to a blog link for a deeper understanding of sequel pivot and unpivot commands, offering additional resources for further learning and exploration.']}], 'duration': 1200.834, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q3346978.jpg', 'highlights': ['The chapter covers how to merge tables using SQL, performing select statements, selecting specific columns or all columns, retrieving top records, and finding distinct values in a column.', 'The chapter explains how to use the order by clause in SQL to sort data in ascending or descending order based on one or multiple columns.', 'The chapter covers the SQL select statement, including the use of aggregate functions and grouping sets.', 'The chapter provides a step-by-step demonstration of creating a pivot table with one row and three columns, showcasing the average cost of customers for different customer IDs.']}, {'end': 6288.095, 'segs': [{'end': 4587.01, 'src': 'embed', 'start': 4560.963, 'weight': 0, 'content': [{'end': 4567.445, 'text': 'So the different operators present in the sequel server are the arithmetic operators, the assignment operators, the bitwise operators,', 'start': 4560.963, 'duration': 6.482}, {'end': 4573.346, 'text': 'the comparison operators, the compound operators, the logical, the scope resolution operators to set operators,', 'start': 4567.445, 'duration': 5.901}, {'end': 4575.627, 'text': 'the string concat and the aggregate functions.', 'start': 4573.346, 'duration': 2.281}, {'end': 4581.428, 'text': 'So, talking about the arithmetic operators first will the arithmetic operators have the addition, subtraction, multiplication,', 'start': 4576.227, 'duration': 5.201}, {'end': 4583.349, 'text': 'division and the moduli sign right?', 'start': 4581.428, 'duration': 1.921}, {'end': 4587.01, 'text': 'So you can just add, subtract, multiply, divide or find the reminder.', 'start': 4583.369, 'duration': 3.641}], 'summary': 'Sequel server has various operators including arithmetic, assignment, bitwise, comparison, compound, logical, scope resolution, set, string concat, and aggregate functions.', 'duration': 26.047, 'max_score': 4560.963, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q4560963.jpg'}, {'end': 4652.445, 'src': 'embed', 'start': 4629.509, 'weight': 3, 'content': [{'end': 4638.074, 'text': 'So the different kinds of logical operators are as you can see on my screen like all and any between exists in like not or and some Right.', 'start': 4629.509, 'duration': 8.565}, {'end': 4640.296, 'text': "I'm not going to go into the depth of each one of them,", 'start': 4638.154, 'duration': 2.142}, {'end': 4645.1, 'text': "because you know it's completely based on your understanding of how which operator will benefit you better.", 'start': 4640.296, 'duration': 4.804}, {'end': 4649.303, 'text': 'but I would say, the more you practice, the more you will have an understanding about the different operators.', 'start': 4645.1, 'duration': 4.203}, {'end': 4652.445, 'text': 'moving on to the next type of operator, that is, the scope resolution operator,', 'start': 4649.303, 'duration': 3.142}], 'summary': 'Various logical operators are explained, emphasizing practice for better understanding.', 'duration': 22.936, 'max_score': 4629.509, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q4629509.jpg'}, {'end': 4775.985, 'src': 'embed', 'start': 4741.883, 'weight': 1, 'content': [{'end': 4746.024, 'text': 'Let me give you a few examples, but I would say, the more you practice, the more will you benefit, right?', 'start': 4741.883, 'duration': 4.141}, {'end': 4748.625, 'text': "For example, let's say you want to use the arithmetic operator.", 'start': 4746.244, 'duration': 2.381}, {'end': 4755.547, 'text': "additions can just mention select 40 plus, let's say 60, and then you can just execute.", 'start': 4748.625, 'duration': 6.922}, {'end': 4757.428, 'text': 'once you execute, you see the output as hundred.', 'start': 4755.547, 'duration': 1.881}, {'end': 4760.959, 'text': "Similarly, for example, let's say you want to use the comparison operators.", 'start': 4757.978, 'duration': 2.981}, {'end': 4762.4, 'text': "Let's say greater than equal to right.", 'start': 4760.979, 'duration': 1.421}, {'end': 4765.781, 'text': "So for that you'll mention select star from.", 'start': 4762.42, 'duration': 3.361}, {'end': 4775.985, 'text': "let's say, we choose a table, offset marks where marks is greater than or equal to, and then you mention, let's say, 62,", 'start': 4765.781, 'duration': 10.204}], 'summary': 'Practice leads to more benefit. examples: 40 + 60 = 100, marks >= 62.', 'duration': 34.102, 'max_score': 4741.883, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q4741883.jpg'}, {'end': 4939.888, 'src': 'embed', 'start': 4910.025, 'weight': 4, 'content': [{'end': 4911.627, 'text': 'We do not get that now.', 'start': 4910.025, 'duration': 1.602}, {'end': 4913.208, 'text': "Let's move forward with the next one.", 'start': 4911.667, 'duration': 1.541}, {'end': 4914.469, 'text': 'That is the like operator.', 'start': 4913.248, 'duration': 1.221}, {'end': 4918.493, 'text': 'So the like operator is one of the most popular question asked in your interviews.', 'start': 4914.87, 'duration': 3.623}, {'end': 4924.979, 'text': "Now, this is since people often get confused between how to use the like operators, right? So for that, I'll just show you a few example.", 'start': 4918.873, 'duration': 6.106}, {'end': 4928.164, 'text': "So let's say, you know, we want to find out all those students.", 'start': 4925.603, 'duration': 2.561}, {'end': 4929.944, 'text': "name starts with, let's say, s.", 'start': 4928.164, 'duration': 1.78}, {'end': 4939.888, 'text': "we'll just mention select staff from and then we'll use students info right where I mentioned student name like,", 'start': 4929.944, 'duration': 9.944}], 'summary': 'The like operator is a popular question in interviews since people often get confused by its usage.', 'duration': 29.863, 'max_score': 4910.025, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q4910025.jpg'}, {'end': 5046.073, 'src': 'embed', 'start': 5005.652, 'weight': 5, 'content': [{'end': 5007.794, 'text': 'and any number of letters can be present in between.', 'start': 5005.652, 'duration': 2.142}, {'end': 5010.115, 'text': 'Well, that was about this particular query guys.', 'start': 5008.294, 'duration': 1.821}, {'end': 5015.539, 'text': "Now, let's say you want to use the scope resolution operator to access the get root member of the hierarchy ID type.", 'start': 5010.435, 'duration': 5.104}, {'end': 5018.461, 'text': "Well to do that what I'll do is I just declare a variable.", 'start': 5015.899, 'duration': 2.562}, {'end': 5026.307, 'text': "So let's just declare at the rate example ID of hierarchy ID type.", 'start': 5018.661, 'duration': 7.646}, {'end': 5030.643, 'text': "And then what I'll do is I'll select this particular ID right?", 'start': 5027.12, 'duration': 3.523}, {'end': 5046.073, 'text': "So I'll just mention select at the rate example ID equal to hierarchy ID and then I'll mention the scope resolution operator and then I'll mention get root after that.", 'start': 5030.663, 'duration': 15.41}], 'summary': 'Using scope resolution operator to access get root member of hierarchy id type.', 'duration': 40.421, 'max_score': 5005.652, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q5005652.jpg'}, {'end': 5145.735, 'src': 'embed', 'start': 5113.025, 'weight': 6, 'content': [{'end': 5118.029, 'text': "you know we've got a name column which has the concatenated values of the student name and the parent name.", 'start': 5113.025, 'duration': 5.004}, {'end': 5123.653, 'text': 'So if you want to give a space, then you have to mention spaces over here right, and then you click on, execute again,', 'start': 5118.529, 'duration': 5.124}, {'end': 5126.015, 'text': 'and then you can clearly see that you know the space is visible.', 'start': 5123.653, 'duration': 2.362}, {'end': 5129.137, 'text': "So that's how you can use the string concatenation operators guys.", 'start': 5126.515, 'duration': 2.622}, {'end': 5134.107, 'text': "Now let's say you want to move forward with the aggregate functions, with aggregate functions were used before,", 'start': 5129.824, 'duration': 4.283}, {'end': 5138.07, 'text': 'also when we were doing the order by in the group by clauses, for your better understanding.', 'start': 5134.107, 'duration': 3.963}, {'end': 5145.735, 'text': "Let's say if you want to just calculate the average of all the marks, you'll just mention select, and then you'll choose average marks right?", 'start': 5138.09, 'duration': 7.645}], 'summary': 'Demonstrates string concatenation and using aggregate functions in sql queries.', 'duration': 32.71, 'max_score': 5113.025, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q5113025.jpg'}, {'end': 5257.885, 'src': 'embed', 'start': 5230.392, 'weight': 8, 'content': [{'end': 5234.774, 'text': 'once we execute, you can clearly see that you know all our table values have been inserted.', 'start': 5230.392, 'duration': 4.382}, {'end': 5238.9, 'text': 'So we had few values in at first table and a few values in a second table.', 'start': 5235.436, 'duration': 3.464}, {'end': 5244.346, 'text': 'So all the values got combined into a third table right now in similarly features to the intersect option.', 'start': 5238.92, 'duration': 5.426}, {'end': 5248.899, 'text': "So I'll just mention intersect and then we can see the common values in both the table.", 'start': 5244.446, 'duration': 4.453}, {'end': 5254.943, 'text': "So I'll just mention intersect and execute and we can see that you know the fourth and the fifth record are common in both the tables.", 'start': 5248.939, 'duration': 6.004}, {'end': 5257.885, 'text': 'when I type in students info except students details,', 'start': 5254.943, 'duration': 2.942}], 'summary': 'Merged table has 4th and 5th common records.', 'duration': 27.493, 'max_score': 5230.392, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q5230392.jpg'}, {'end': 5316.334, 'src': 'embed', 'start': 5284.85, 'weight': 9, 'content': [{'end': 5288.452, 'text': "Now let's move forward with the next part of the session, that is nested queries.", 'start': 5284.85, 'duration': 3.602}, {'end': 5292.555, 'text': 'now, nested queries are also one of the most popular concepts that you need to know.', 'start': 5288.452, 'duration': 4.103}, {'end': 5297.057, 'text': 'because you know, nested queries are sequel queries, which have an outer query and an inner sub query.', 'start': 5292.555, 'duration': 4.502}, {'end': 5302.901, 'text': 'So the sub query is a query nested within another query such as the select insert update and the delete statements.', 'start': 5297.457, 'duration': 5.444}, {'end': 5305.062, 'text': 'So this was about the nested query guys.', 'start': 5303.361, 'duration': 1.701}, {'end': 5309.868, 'text': 'So as you can see on my screen, we have an outer query and then we can have a sub query.', 'start': 5305.985, 'duration': 3.883}, {'end': 5316.334, 'text': 'So what will happen is that you know the first the sub query or the inner query will be executed and whatever output comes,', 'start': 5310.269, 'duration': 6.065}], 'summary': 'Nested queries involve an outer query and inner sub query, executed in sequence.', 'duration': 31.484, 'max_score': 5284.85, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q5284850.jpg'}, {'end': 5403.399, 'src': 'embed', 'start': 5380.051, 'weight': 10, 'content': [{'end': 5387.193, 'text': 'So they are predominantly used when a user is trying to extract data from the tables which have one too many or many too many relationships between them.', 'start': 5380.051, 'duration': 7.142}, {'end': 5390.133, 'text': 'Now, there are mainly four types of joints that you have to understand guys.', 'start': 5387.433, 'duration': 2.7}, {'end': 5393.034, 'text': 'That is the inner joint the left joint the right joint and the full joint.', 'start': 5390.153, 'duration': 2.881}, {'end': 5398.316, 'text': 'Now the inner joint returns, the records which have matching values in both the tables, the left joint returns,', 'start': 5393.494, 'duration': 4.822}, {'end': 5403.399, 'text': 'the records from the left table and also those records which satisfy the condition from the right table.', 'start': 5398.316, 'duration': 5.083}], 'summary': 'Predominantly used for data extraction, with 4 types of joints: inner, left, right, full.', 'duration': 23.348, 'max_score': 5380.051, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q5380051.jpg'}, {'end': 5665.738, 'src': 'embed', 'start': 5635.075, 'weight': 11, 'content': [{'end': 5642.041, 'text': "So let's say we create procedure, Let's say students City right,", 'start': 5635.075, 'duration': 6.966}, {'end': 5650.211, 'text': "and then we choose the parameter name to be a city and let's say to be of varchar type, a thousand right,", 'start': 5642.041, 'duration': 8.17}, {'end': 5656.458, 'text': 'and after that we choose as and then we select from students info.', 'start': 5650.211, 'duration': 6.247}, {'end': 5665.738, 'text': 'and then we can mention where city equal to add rate and then we mention it to add rate as a city.', 'start': 5658.05, 'duration': 7.688}], 'summary': 'Creating a procedure to select students by city parameter of varchar type.', 'duration': 30.663, 'max_score': 5635.075, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q5635075.jpg'}, {'end': 5754.26, 'src': 'embed', 'start': 5722.049, 'weight': 12, 'content': [{'end': 5726.751, 'text': 'You just write the code once and then you can keep using it again and again like any other programming languages.', 'start': 5722.049, 'duration': 4.702}, {'end': 5731.652, 'text': 'So guys that was about the stored procedures and with this we come to an end to the DML commands.', 'start': 5727.171, 'duration': 4.481}, {'end': 5735.654, 'text': "Now, let's move forward with the next section of commands that is the DCL commands.", 'start': 5732.053, 'duration': 3.601}, {'end': 5741.536, 'text': 'So as I mentioned before the DCL commands are used to grant or revoke privileges to a user.', 'start': 5736.454, 'duration': 5.082}, {'end': 5744.317, 'text': "So for example, let's say you want to create a user.", 'start': 5742.136, 'duration': 2.181}, {'end': 5754.26, 'text': 'So to create a user what you can do is you can just mention create login sample with we mentioned the password to be edureka.', 'start': 5745.04, 'duration': 9.22}], 'summary': 'Stored procedures allow for reuse of code. dml commands covered, moving to dcl commands for granting/reveoking privileges and creating users.', 'duration': 32.211, 'max_score': 5722.049, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q5722049.jpg'}, {'end': 5930.989, 'src': 'embed', 'start': 5894.832, 'weight': 13, 'content': [{'end': 5898.214, 'text': "So I'll just click on execute now, once these values are inserted.", 'start': 5894.832, 'duration': 3.382}, {'end': 5900.555, 'text': "now let's just start a transaction right?", 'start': 5898.214, 'duration': 2.341}, {'end': 5904.738, 'text': "So to start a transaction, what I'll do is I just mentioned begin right?", 'start': 5900.855, 'duration': 3.883}, {'end': 5907.4, 'text': "So that's a try catch block which I'll come to later in the session.", 'start': 5904.898, 'duration': 2.502}, {'end': 5908.801, 'text': "So don't worry after that.", 'start': 5907.44, 'duration': 1.361}, {'end': 5917.538, 'text': "I'll mention begin transaction right and then I'll mention insert into TCL sample, that's a table name.", 'start': 5908.841, 'duration': 8.697}, {'end': 5920.821, 'text': "and then I'll mention values and let's say we mentioned few values.", 'start': 5917.538, 'duration': 3.283}, {'end': 5930.989, 'text': "Let's say five and then I mentioned the name and let's say we've mentioned other values, right? So I'll just mention 56 this need not be in code.", 'start': 5920.841, 'duration': 10.148}], 'summary': 'Executing a transaction with 5 values in tcl sample table.', 'duration': 36.157, 'max_score': 5894.832, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q5894832.jpg'}, {'end': 6146.027, 'src': 'embed', 'start': 6114.628, 'weight': 14, 'content': [{'end': 6117.611, 'text': 'So talking about the pro block first, or I would say the pro clause.', 'start': 6114.628, 'duration': 2.983}, {'end': 6123.075, 'text': 'this clause is used to raise an exception and transfers the execution to a catch block of the try and catch construct.', 'start': 6117.611, 'duration': 5.464}, {'end': 6124.597, 'text': 'If you want to see the syntax.', 'start': 6123.476, 'duration': 1.121}, {'end': 6126.659, 'text': 'the syntax is as you can see on my screen.', 'start': 6124.597, 'duration': 2.062}, {'end': 6131.463, 'text': 'you mentioned throw and then you mentioned the error number, and then you can mention local variable message and so on.', 'start': 6126.659, 'duration': 4.804}, {'end': 6136.785, 'text': 'Coming to the try-catch block the try-catch block is used to implement exception handling in transact sequel.', 'start': 6132.003, 'duration': 4.782}, {'end': 6139.725, 'text': 'So a group of statements can be enclosed in a try block.', 'start': 6137.125, 'duration': 2.6}, {'end': 6146.027, 'text': 'So, in case an error occurs in the try block, the control is then passed to another group of statements that are enclosed in the catch block,', 'start': 6139.745, 'duration': 6.282}], 'summary': 'The pro clause raises exceptions and transfers execution to a catch block, while try-catch implements exception handling in t-sql.', 'duration': 31.399, 'max_score': 6114.628, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q6114628.jpg'}, {'end': 6288.095, 'src': 'embed', 'start': 6264, 'weight': 15, 'content': [{'end': 6271.124, 'text': 'So if you have any further queries related to the session or related to Microsoft SQL Server, please comment down in the comment section below.', 'start': 6264, 'duration': 7.124}, {'end': 6272.925, 'text': "until then, that's all from my side today.", 'start': 6271.124, 'duration': 1.801}, {'end': 6277.628, 'text': 'I hope you found the session informative and then you get good hands-on experience in the sequel server.', 'start': 6273.225, 'duration': 4.403}, {'end': 6283.972, 'text': 'Hopefully you will also crack your interviews for database administrators and start handling data in the database management systems.', 'start': 6278.008, 'duration': 5.964}, {'end': 6286.494, 'text': "On that note, that's all from my side today.", 'start': 6284.452, 'duration': 2.042}, {'end': 6288.095, 'text': 'Thank you and happy learning.', 'start': 6286.754, 'duration': 1.341}], 'summary': 'Session covered microsoft sql server, aiming to prepare for database administrator interviews and hands-on experience in sql server.', 'duration': 24.095, 'max_score': 6264, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q6264000.jpg'}], 'start': 4548.133, 'title': 'Sql operators, functions, nested queries, and transaction control language', 'summary': 'Discusses various sql operators, including arithmetic, assignment, bitwise, comparison, compound, logical, scope resolution, set, string concat, and aggregate functions, emphasizing the importance of practice. it also covers database operators and functions, nested queries, joins, and transaction control language commands with practical examples and outcomes.', 'chapters': [{'end': 5005.652, 'start': 4548.133, 'title': 'Sql operators and their functions', 'summary': 'Discusses the various operators in sql, including arithmetic, assignment, bitwise, comparison, compound, logical, scope resolution, set, string concat, and aggregate functions, with examples and their practical applications, emphasizing the importance of practice for better understanding.', 'duration': 457.519, 'highlights': ['The chapter covers various operators in SQL, including arithmetic, assignment, bitwise, comparison, compound, logical, scope resolution, set, string concat, and aggregate functions. Provides an overview of the different types of operators discussed in the session.', 'Emphasizes the importance of practice for better understanding of the different operators. Highlights the significance of practice in gaining a comprehensive understanding of SQL operators.', 'Provides practical examples of using arithmetic, comparison, and compound operators, demonstrating their application in SQL queries. Demonstrates the practical application of various operators through examples, strengthening the understanding of their usage.', 'Illustrates the application of logical operators with examples of SQL queries utilizing logical operators for data retrieval. Shows the practical use of logical operators in SQL queries and their role in data retrieval.', "Demonstrates the usage of the like operator with examples, explaining its application for pattern matching in SQL queries. Provides examples of the like operator's usage for pattern matching in SQL queries, enhancing understanding of this operator's functionality."]}, {'end': 5284.43, 'start': 5005.652, 'title': 'Database operators and functions', 'summary': 'Covers how to use scope resolution, string concatenation, aggregate functions, and set operators in sql, including examples and outcomes of using each operator.', 'duration': 278.778, 'highlights': ['Using scope resolution operator to access hierarchy ID type and converting it to string Demonstrates accessing a member of the hierarchy ID type using scope resolution operator and converting it to string.', 'Using string concatenation operator to combine columns and creating a new column with concatenated values Illustrates the usage of string concatenation operator to combine columns and create a new column with concatenated values from the original columns.', 'Demonstrating the usage of aggregate functions to calculate the average of all marks in a table Shows how to use aggregate functions to calculate the average of marks in a table.', 'Performing set operations (Union, Intersect, Except) on tables and displaying the outcomes Explains the execution and outcomes of performing set operations (Union, Intersect, Except) on tables, showcasing the combined, common, and distinct values between tables.']}, {'end': 5863.078, 'start': 5284.85, 'title': 'Sql nested queries and joins', 'summary': 'Covers the concepts of nested queries and joins in sql, explaining the process and usage of nested queries and the different types of joins such as inner, left, right, and full outer joins, along with the practical demonstration of creating and using stored procedures and dcl commands for granting and revoking privileges to a user.', 'duration': 578.228, 'highlights': ['Explanation of Nested Queries The transcript explains the concept of nested queries in SQL, emphasizing that a subquery is executed first and its output becomes the input for the outer query, with a practical example demonstrating the usage of nested queries with a select statement.', "Types of Joins in SQL The chapter delves into the four main types of joins in SQL: inner join, left join, right join, and full outer join, elucidating their purposes and practical application with an example of joining the 'students info' and 'subjects' tables.", "Creation and Usage of Stored Procedures The transcript demonstrates the creation of a stored procedure named 'students City' with a parameter 'city', followed by the execution of the procedure and showcasing its functionality by retrieving data based on the specified city value.", "Demonstration of DCL Commands The chapter illustrates the usage of DCL commands for creating a user, granting select privileges for a specific table to the user 'edureka', and subsequently revoking the granted privileges, providing a comprehensive understanding of user privileges management in SQL."]}, {'end': 6288.095, 'start': 5863.438, 'title': 'Transaction control language', 'summary': 'Covers the transaction control language commands used to handle transactions, with examples of begin, commit, and rollback operations, followed by an overview of exception handling using throw clause and try-catch block.', 'duration': 424.657, 'highlights': ["The chapter covers the Transaction Control Language commands used to handle transactions, with examples of begin, commit, and rollback operations. The speaker demonstrates the usage of TCL commands to manage transactions, including starting a transaction with 'begin', inserting values, updating records, committing the transaction, and handling errors with 'rollback'.", 'Overview of exception handling using throw clause and try-catch block is provided. The explanation includes the syntax and usage of the throw clause to raise exceptions, and the try-catch block for handling errors, with examples of error number and message, as well as a demonstration of handling exceptions using the catch block.', "The speaker encourages audience engagement and invites queries related to Microsoft SQL Server. The speaker encourages interaction by inviting queries related to the session or SQL Server, fostering engagement and learning, and concludes with best wishes for viewers' success in database administration and data management."]}], 'duration': 1739.962, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-EPMOaV7h_Q/pics/-EPMOaV7h_Q4548133.jpg', 'highlights': ['The chapter covers various operators in SQL, including arithmetic, assignment, bitwise, comparison, compound, logical, scope resolution, set, string concat, and aggregate functions. Provides an overview of the different types of operators discussed in the session.', 'Emphasizes the importance of practice for better understanding of the different operators. Highlights the significance of practice in gaining a comprehensive understanding of SQL operators.', 'Provides practical examples of using arithmetic, comparison, and compound operators, demonstrating their application in SQL queries. Demonstrates the practical application of various operators through examples, strengthening the understanding of their usage.', 'Illustrates the application of logical operators with examples of SQL queries utilizing logical operators for data retrieval. Shows the practical use of logical operators in SQL queries and their role in data retrieval.', "Demonstrates the usage of the like operator with examples, explaining its application for pattern matching in SQL queries. Provides examples of the like operator's usage for pattern matching in SQL queries, enhancing understanding of this operator's functionality.", 'Using scope resolution operator to access hierarchy ID type and converting it to string Demonstrates accessing a member of the hierarchy ID type using scope resolution operator and converting it to string.', 'Using string concatenation operator to combine columns and creating a new column with concatenated values Illustrates the usage of string concatenation operator to combine columns and create a new column with concatenated values from the original columns.', 'Demonstrating the usage of aggregate functions to calculate the average of all marks in a table Shows how to use aggregate functions to calculate the average of marks in a table.', 'Performing set operations (Union, Intersect, Except) on tables and displaying the outcomes Explains the execution and outcomes of performing set operations (Union, Intersect, Except) on tables, showcasing the combined, common, and distinct values between tables.', 'Explanation of Nested Queries The transcript explains the concept of nested queries in SQL, emphasizing that a subquery is executed first and its output becomes the input for the outer query, with a practical example demonstrating the usage of nested queries with a select statement.', "Types of Joins in SQL The chapter delves into the four main types of joins in SQL: inner join, left join, right join, and full outer join, elucidating their purposes and practical application with an example of joining the 'students info' and 'subjects' tables.", "Creation and Usage of Stored Procedures The transcript demonstrates the creation of a stored procedure named 'students City' with a parameter 'city', followed by the execution of the procedure and showcasing its functionality by retrieving data based on the specified city value.", "Demonstration of DCL Commands The chapter illustrates the usage of DCL commands for creating a user, granting select privileges for a specific table to the user 'edureka', and subsequently revoking the granted privileges, providing a comprehensive understanding of user privileges management in SQL.", "The chapter covers the Transaction Control Language commands used to handle transactions, with examples of begin, commit, and rollback operations. The speaker demonstrates the usage of TCL commands to manage transactions, including starting a transaction with 'begin', inserting values, updating records, committing the transaction, and handling errors with 'rollback'.", 'Overview of exception handling using throw clause and try-catch block is provided. The explanation includes the syntax and usage of the throw clause to raise exceptions, and the try-catch block for handling errors, with examples of error number and message, as well as a demonstration of handling exceptions using the catch block.', "The speaker encourages audience engagement and invites queries related to Microsoft SQL Server. The speaker encourages interaction by inviting queries related to the session or SQL Server, fostering engagement and learning, and concludes with best wishes for viewers' success in database administration and data management."]}], 'highlights': ['SQL Server provides comprehensive Enterprise scale analytic solutions with in-memory built into the tabular model, reducing time to insights using direct querying against tabular and multidimensional models.', 'The chapter covers various operators in SQL, including arithmetic, assignment, bitwise, comparison, compound, logical, scope resolution, set, string concat, and aggregate functions. Provides an overview of the different types of operators discussed in the session.', 'The chapter covers the basics of DDL commands, including table name changes.', 'The chapter explains how to use the order by clause in SQL to sort data in ascending or descending order based on one or multiple columns.', 'The chapter covers understanding types of DBMS, features of SQL Server, installation process, and command categories such as DDL, DML, DCL, and TCL.', 'The SQL Server architecture components include server, relational engine, command parser, optimizer, query executor, and storage engine, each with specific functions for query processing and data management.', 'The chapter covers how to merge tables using SQL, performing select statements, selecting specific columns or all columns, retrieving top records, and finding distinct values in a column.', 'The chapter explains the SQL select statement, including the use of aggregate functions and grouping sets.', 'The chapter covers the Transaction Control Language commands used to handle transactions, with examples of begin, commit, and rollback operations.', "The chapter illustrates the usage of DCL commands for creating a user, granting select privileges for a specific table to the user 'edureka', and subsequently revoking the granted privileges, providing a comprehensive understanding of user privileges management in SQL."]}